Q. The MySQL server used in its client/server architecture is _______________

View solution

Q. In MySQL databases, the structure representing the organizational views of the entire databases is ____________

View solution

Q. Which of the following clauses is used to display information that match a given pattern?

View solution

Q. The special database that always exists after setting up MySQL in a computer is __________

View solution

Q. Which operator is used to perform integer divisions in MySQL?

View solution

Q. The NULL value also means ___________

View solution

Q. What does comparing a known value with NULL result into?

View solution

Q. Which clause is used to sort query elements?

View solution

Q. MySQL client runs on the machine containing the databases and servers connect to the client over a network.

View solution

Q. Which of the following options tells mysql to ask for entering the password?

View solution

Q. The query ‘SELECT NOW()’ shows the current _____________

View solution

Q. Suppose you want to select a database named ‘sampledb’ as the default database. Which of the following commands do you use?

View solution

Q. To see the table structure, which of the following SQL commands is issued?

View solution

Q. SHOW DATABASES lists the databases in the server to which you are connected.

View solution

Q. The command to move the cursor to the beginning of line in MySQL input editor is?

View solution

Q. What does Control-_ do in MySQL input editor?

View solution

Q. On UNIX, statements entered in ‘MySQL’ are saved in which file?

View solution

Q. MySQL can be used to execute script files.

View solution

Q. Suppose run_me.sh is a script file. Which command is used to make it executable?

View solution

Q. To execute the contents of a query file ‘exec.sql’ by feeding it to mysql, which command is used?

View solution