The query ‘SELECT NOW()’ shows the current _____________(a) table(b) time only(c) date only(d) date and timeThis question was addressed to me during an interview.I'm obligated to ask this question of MySQL Setup in division General MySQL Use of MySQL

The query ‘SELECT NOW()’ shows the current _____________(a) table(

1.	The query ‘SELECT NOW()’ shows the current _____________(a) table(b) time only(c) date only(d) date and timeThis question was addressed to me during an interview.I'm obligated to ask this question of MySQL Setup in division General MySQL Use of MySQL
Answer» Correct choice is (d) date and time The BEST explanation: SELECT NOW() is an SQL query. It SHOWS both the current date and the current time. It is generally DISPLAYED in the format ‘yyyy-mm-dd hh-mm-ss’. For EXAMPLE, 2009-04-21 11-51-36.

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

The query ‘SELECT NOW()’ shows the current _____________(a) table(b) time only(c) date only(d) date and timeThis question was addressed to me during an interview.I'm obligated to ask this question of MySQL Setup in division General MySQL Use of MySQL

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment