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

Q. Converting a client/server application to embedded server is difficult.

View solution

Q. The option that executes all SQL statements in a SQL script irrespective of the number of errors is _______________

View solution

Q. The clause that is used to display information that matches a given pattern is _____________

View solution

Q. The header that should be included first is ________________

View solution

Q. What does mysql_init() return?

View solution

Q. The statement that constructs a branching flow-control construct is _____________

View solution

Q. Which statement terminates the execution of a function?

View solution

Q. Association between one or more MyISAM tables and the named key cache is set by _____________

View solution

Q. Which statement exits a labeled flow-control construct?

View solution

Q. What is the exec_stmt_ssl written in?

View solution

Q. What does ‘mysql_query()’ return on failure?

View solution

Q. When linking to a static MySQL C client library, the client library and the client application can use different compiler options.

View solution