To see the table structure which command is issued?(a) VIEW tbl_name;(b) SELECT TABLE tbl_name;(c) SELECT tbl_name;(d) DESCRIBE tbl_name;The question was posed to me in an online interview.I need to ask this question from Using Multiple-Statement Execution in chapter MySQL Programs Using C of MySQL

To see the table structure which command is issued?(a) VIEW tbl_name;(

1.	To see the table structure which command is issued?(a) VIEW tbl_name;(b) SELECT TABLE tbl_name;(c) SELECT tbl_name;(d) DESCRIBE tbl_name;The question was posed to me in an online interview.I need to ask this question from Using Multiple-Statement Execution in chapter MySQL Programs Using C of MySQL
Answer» RIGHT answer is (d) DESCRIBE tbl_name; To elaborate: The ‘DESCRIBE’ command is ISSUED to see the structure of the table ‘tbl_name’. It shows the structure in the format: Field-Type-Null-Key-Default-Extra. The ‘VIEW’ and ‘SELECT’ commands are USED to see the contents of the table.

Discussion

No Comment Found

Related InterviewSolutions

What is the general term for information about databases and the objects in MySQL?(a) datum(b) info(c) record(d) metadataI had been asked this question in a national level competition.I need to ask this question from Using Server-Side Prepared Statements in division MySQL Programs Using C of MySQL
The statement used to change the table name is __________(a) RENAME(b) CHANGE(c) CHANGENAME(d) CHANGENMThis question was posed to me by my school teacher while I was bunking the class.Enquiry is from Using Server-Side Prepared Statements in division MySQL Programs Using C of MySQL
The statement used to remove indexes on tables is ______________(a) DROP INDEX(b) DELETE INDEX(c) REMOVE INDEX(d) FLUSH INDEXI have been asked this question during an interview.This is a very interesting question from Using Server-Side Prepared Statements topic in division MySQL Programs Using C of MySQL
The statement that makes changes to the global attributes of the database is ______________(a) CHANGE(b) ALTER(c) ALTERNATE(d) UPDATEThis question was addressed to me in a national level competition.Question is from Using Server-Side Prepared Statements in portion MySQL Programs Using C of MySQL
The statement used to select a default database is ______________(a) USE(b) CREATE(c) DROP(d) SCHEMAThis question was addressed to me in an international level competition.Question is taken from Using Server-Side Prepared Statements in portion MySQL Programs Using C of MySQL
A synonym for CHARACTER SET is ______________(a) CSET(b) CHSET(c) CHARSET(d) CHCSETI got this question in a national level competition.The question is from Using Server-Side Prepared Statements topic in chapter MySQL Programs Using C of MySQL
The maximum collations a character set can have is ______________(a) 0(b) 1(c) 2(d) more than 1This question was posed to me in an interview for internship.Query is from Using Server-Side Prepared Statements topic in division MySQL Programs Using C of MySQL
The binary protocol is more difficult to use.(a) True(b) FalseThe question was posed to me in an online quiz.This intriguing question comes from Using Server-Side Prepared Statements topic in division MySQL Programs Using C of MySQL
The binary protocol does not support all statements.(a) True(b) FalseThis question was posed to me in examination.I'd like to ask this question from Using Server-Side Prepared Statements in chapter MySQL Programs Using C of MySQL
The default case sensitivity of the database and table names depends on ___________(a) Server SQL mode(b) Operating system of machine(c) Does not depend on anything(d) SQL serverThis question was posed to me in final exam.My doubt stems from Using Multiple-Statement Execution topic in section MySQL Programs Using C of MySQL

To see the table structure which command is issued?(a) VIEW tbl_name;(b) SELECT TABLE tbl_name;(c) SELECT tbl_name;(d) DESCRIBE tbl_name;The question was posed to me in an online interview.I need to ask this question from Using Multiple-Statement Execution in chapter MySQL Programs Using C of MySQL

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment