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

Q. Which option prints output in table-format when MySQL is run interactively?

View solution

Q. The clause that enables mapping a short command to a long command is __________

View solution

Q. 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.

View solution

Q. In UNIX, the name of the option file is __________

View solution

Q. Which statement upgrades the database directory name encoding?

View solution

Q. The statement that alters an existing event to have the given definition is _____________

View solution

Q. What sets up an association between one or more MyISAM tables and the named key cache?

View solution

Q. Which statement can produce the same output as ‘SHOW COLUMNS’?

View solution