To see the table structure, which of the following SQL commands is issued?(a) DESCRIBE tbl_name(b) VIEW tbl_name(c) SELECT TABLE tbl_name(d) SELECT tbl_nameI got this question by my college professor while I was bunking the class.Origin of the question is MySQL Setup topic in chapter General MySQL Use of MySQL

To see the table structure, which of the following SQL commands is iss

1.	To see the table structure, which of the following SQL commands is issued?(a) DESCRIBE tbl_name(b) VIEW tbl_name(c) SELECT TABLE tbl_name(d) SELECT tbl_nameI got this question by my college professor while I was bunking the class.Origin of the question is MySQL Setup topic in chapter General MySQL Use of MySQL
Answer» Right OPTION is (a) 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

In UNIX, the name of the option file is __________(a) .my.cnf(b) .my.ini(c) .my.opt(d) .my.opcThis question was posed to me in semester exam.This intriguing question comes from Interacting with MySQL topic in portion General MySQL Use of MySQL
The connection parameters for setting up MySQL can be stored in an option file to save typing the names every time a connection is established.(a) True(b) FalseI had been asked this question in examination.I'd like to ask this question from Interacting with MySQL in chapter General MySQL Use of MySQL
Which option prints output in table-format when MySQL is run interactively?(a) -t(b) -tf(c) -p(d) -pfThis question was posed to me in semester exam.I want to ask this question from Interacting with MySQL topic in section General MySQL Use of MySQL
To execute the contents of a query file ‘exec.sql’ by feeding it to mysql, which command is used?(a) mysql exec.sql > sampdb(b) mysql sampdb < exec.sql(c) mysql exec.sql(d) mysql execThis question was addressed to me by my school principal while I was bunking the class.I'm obligated to ask this question of Interacting with MySQL in portion General MySQL Use of MySQL
Suppose run_me.sh is a script file. Which command is used to make it executable?(a) chmod +e run_me.sh(b) chmod +a run_me.sh(c) chmod +y run_me.sh(d) chmod +x run_me.shI got this question in an internship interview.This intriguing question comes from Interacting with MySQL topic in chapter General MySQL Use of MySQL
MySQL can be used to execute script files.(a) True(b) FalseI have been asked this question in final exam.This key question is from Interacting with MySQL topic in chapter General MySQL Use of MySQL
On UNIX, statements entered in ‘MySQL’ are saved in which file?(a) .mysql_queries(b) .queries(c) .mysql_history(d) .historyThis question was addressed to me in final exam.This interesting question is from Interacting with MySQL topic in chapter General MySQL Use of MySQL
What does Control-_ do in MySQL input editor?(a) copies to clipboard(b) pastes from clipboard(c) undoes last change(d) deletes the current lineI had been asked this question in a job interview.The question is from Interacting with MySQL topic in chapter General MySQL Use of MySQL
The command to move the cursor to the beginning of line in MySQL input editor is?(a) Ctrl-A(b) Ctrl-E(c) Ctrl-D(d) Esc-aThis question was posed to me by my college director while I was bunking the class.This interesting question is from Interacting with MySQL topic in portion General MySQL Use of MySQL
SHOW DATABASES lists the databases in the server to which you are connected.(a) True(b) FalseThis question was addressed to me during an online interview.My question is from MySQL Setup topic in section General MySQL Use of MySQL

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment