Suppose you want to select a database named ‘sampledb’ as the default database. Which of the following commands do you use?(a) SELECT DATABASE()(b) SELECT DATABASE sampledb(c) USE DATABASE sampledb(d) USE sampledbThis question was posed to me in exam.Asked question is from MySQL Setup topic in portion General MySQL Use of MySQL

Suppose you want to select a database named ‘sampledb’ as the defa

1.	Suppose you want to select a database named ‘sampledb’ as the default database. Which of the following commands do you use?(a) SELECT DATABASE()(b) SELECT DATABASE sampledb(c) USE DATABASE sampledb(d) USE sampledbThis question was posed to me in exam.Asked question is from MySQL Setup topic in portion General MySQL Use of MySQL
Answer» RIGHT choice is (d) USE sampledb Easiest explanation: ‘USE sampledb’ selects sampledb as the DEFAULT database. Initially, ‘SELECT DATABASE();’ command displays ‘NULL’, SINCE no database is selected by default. The other TWO are not valid commands.

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