In the database directory of the database each view and trigger object is associated with how many files?(a) 0(b) 1(c) 2(d) 3This question was posed to me at a job interview.My question comes from Structure of the Data Directory topic in chapter MySQL Data Directory of MySQL

In the database directory of the database each view and trigger object

1.	In the database directory of the database each view and trigger object is associated with how many files?(a) 0(b) 1(c) 2(d) 3This question was posed to me at a job interview.My question comes from Structure of the Data Directory topic in chapter MySQL Data Directory of MySQL
Answer» Right option is (b) 1 Easy explanation: Each view and trigger object is ASSOCIATED with one FILE in the DATABASE directory of the database containing that object. A view consists of a .FRM file that contains the view DEFINITION.

Discussion

No Comment Found

Related InterviewSolutions

Which command is used to make a script file ‘run_me.sh’ executable?(a) chmod +e run_me.sh(b) chmod +a run_me.sh(c) chmod +y run_me.sh(d) chmod +x run_me.shThe question was posed to me during an interview for a job.This intriguing question comes from Relocating Data Directory Contents in section MySQL Data Directory of MySQL
Mysql cannot be used to execute script files.(a) True(b) FalseThe question was posed to me in an interview for internship.The question is from Relocating Data Directory Contents topic in section MySQL Data Directory of MySQL
In which file are the statements entered in ‘mysql’ saved?(a) .mysql_queries(b) .queries(c) .mysql_history(d) .historyI had been asked this question in an internship interview.I want to ask this question from Relocating Data Directory Contents in section MySQL Data Directory of MySQL
What is the special database that always exists after setting up MySQL on a computer?(a) sampdb(b) mysql(c) information_schema(d) readme_dbI have been asked this question during an interview for a job.The question is from Relocating Data Directory Contents in division MySQL Data Directory of MySQL
When relocating an individual table, the table to be relocated should be ______________(a) MyISAM(b) InnoDB(c) TRANSACTION(d) ENGINEThis question was addressed to me during an interview.My enquiry is from Relocating Data Directory Contents in division MySQL Data Directory of MySQL
Before relocation of database, the server should be stopped if running.(a) True(b) FalseI have been asked this question during an online interview.My enquiry is from Relocating Data Directory Contents in division MySQL Data Directory of MySQL
For which of these is the startup option best suited?(a) entire data directory(b) individual database tables(c) server PID file(d) individual database directoriesI have been asked this question in an online quiz.I'd like to ask this question from Relocating Data Directory Contents in portion MySQL Data Directory of MySQL
Symlink is an applicable relocation method for ______________(a) entire data directory(b) individual database tables(c) server PID file(d) log filesI had been asked this question in my homework.Enquiry is from Relocating Data Directory Contents topic in portion MySQL Data Directory of MySQL
What is the statement used to select a default database?(a) USE(b) CREATE(c) DROP(d) SCHEMAThis question was posed to me in semester exam.My question comes from Structure of the Data Directory in portion MySQL Data Directory of MySQL
What is the synonym for CHARACTER SET?(a) CSET(b) CHSET(c) CHARSET(d) CHCSETI got this question in class test.This interesting question is from Structure of the Data Directory in section MySQL Data Directory of MySQL

In the database directory of the database each view and trigger object is associated with how many files?(a) 0(b) 1(c) 2(d) 3This question was posed to me at a job interview.My question comes from Structure of the Data Directory topic in chapter MySQL Data Directory of MySQL

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment