What is the name of the format file for a table named my_tbl?(a) my_tbl.fmt(b) my_tbl.frm(c) my_tbl.fmr(d) my_tbl.ftmThe question was posed to me in my homework.The above asked question is from Creating, Dropping, Indexing and Altering Tables in portion Using SQL to Manage Data of MySQL

What is the name of the format file for a table named my_tbl?(a) my_tb

1.	What is the name of the format file for a table named my_tbl?(a) my_tbl.fmt(b) my_tbl.frm(c) my_tbl.fmr(d) my_tbl.ftmThe question was posed to me in my homework.The above asked question is from Creating, Dropping, Indexing and Altering Tables in portion Using SQL to Manage Data of MySQL
Answer» Correct answer is (b) my_tbl.frm To elaborate: Every TIME a table is CREATED in MySQL, it creates a DISK file containing the format of the table. It has two components, namely, BASE name (here, ‘my_tbl’) and an extension (here, ‘frm’).

Discussion

No Comment Found

Related InterviewSolutions

Which of the following functions are not performed by “ALTER” clause?(a) Change the name of the table(b) Change the name of the column(c) Drop a column(d) All of the mentionedI have been asked this question in unit test.My question is from Populating & Modifying Tables topic in chapter Using SQL to Manage Data of MySQL
Which of the following functions are not performed by “ALTER” clause?(a) Change the name of the table(b) Change the name of the column(c) Drop a column(d) All of the mentionedThe question was posed to me in examination.My query is from Populating & Modifying Tables topic in section Using SQL to Manage Data of MySQL
Which clause is used to rename the existing table?(a) RENAME(b) MODIFY(c) ALTER(d) None of the mentionedThe question was posed to me in an internship interview.I would like to ask this question from Populating & Modifying Tables topic in section Using SQL to Manage Data of MySQL
“INSERT” is same as “UPDATE”?(a) NO(b) YES(c) May be(d) None of the mentionedI got this question in an interview for job.This key question is from Populating & Modifying Tables in division Using SQL to Manage Data of MySQL
Which statement is used to delete an existing row from the table?(a) DELETE(b) WHERE(c) MODIFY(d) None of the mentionedI had been asked this question during an interview.Query is from Populating & Modifying Tables in division Using SQL to Manage Data of MySQL
Which statement is used for updating existing information in the table?(a) UPDATE(b) WHERE(c) MODIFY(d) ALTERThis question was addressed to me in a national level competition.Asked question is from Populating & Modifying Tables in portion Using SQL to Manage Data of MySQL
Which among the following is the correct syntax for showing all tables in the database?(a) SHOWS TABLES(b) SHOW TABLE(c) SHOW(d) SHOWS TABLES;This question was posed to me in unit test.My doubt stems from Populating & Modifying Tables in portion Using SQL to Manage Data of MySQL
Which command is used to show all tables that are stored in a database?(a) SHOWS(b) SHOW(c) SHOWES(d) None of the mentionedI have been asked this question in class test.I need to ask this question from Populating & Modifying Tables topic in section Using SQL to Manage Data of MySQL
Which Clause is used to select a particular table in Mysql?(a) WHERE(b) SELECT(c) FROM(d) ALTERThe question was posed to me in a national level competition.My question comes from Populating & Modifying Tables in portion Using SQL to Manage Data of MySQL
Which Clause is used to sort the stored data in alphabetical order?(a) ORDER by CLAUSE(b) MODIFY(c) ALTER(d) UPDATEI got this question in my homework.I'd like to ask this question from Populating & Modifying Tables topic in section Using SQL to Manage Data of MySQL

What is the name of the format file for a table named my_tbl?(a) my_tbl.fmt(b) my_tbl.frm(c) my_tbl.fmr(d) my_tbl.ftmThe question was posed to me in my homework.The above asked question is from Creating, Dropping, Indexing and Altering Tables in portion Using SQL to Manage Data of MySQL

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment