Q. For which of these is the startup option best suited?

View solution

Q. Before relocation of database, the server should be stopped if running.

View solution

Q. When relocating an individual table, the table to be relocated should be ______________

View solution

Q. What is the special database that always exists after setting up MySQL on a computer?

View solution

Q. In which file are the statements entered in ‘mysql’ saved?

View solution

Q. Mysql cannot be used to execute script files.

View solution

Q. Which command is used to make a script file ‘run_me.sh’ executable?

View solution

Q. The superuser account of the grant tables in the mysql database is called ______________

View solution

Q. Which script initializes the data directory during installation?

View solution

Q. Anonymous accounts have user name ______________

View solution

Q. For REVOKE statements, the server automatically rereads the grant tables.

View solution

Q. What does the default case sensitivity of database and table names depend on?

View solution

Q. The case sensitive among these is ______________

View solution

Q. The variable used to set table alias names as non case sensitive is ______________

View solution

Q. The clause that can be used to sort string values according to a specific collation is ______________

View solution

Q. The statement used to find out which character sets are available is ______________

View solution

Q. The error log file has a suffix ______________

View solution

Q. The option which finds the startup options supported by the server through mysqld is ______________

View solution

Q. Server startup can also be done by the ______________

View solution

Q. It is required to have an access privilege for a database before selecting it with ‘USE’.

View solution