Q. Each database has a data directory located under database directory.

View solution

Q. In the database directory of the database each view and trigger object is associated with how many files?

View solution

Q. What is the maximum number of characters allowed for a database name to have?

View solution

Q. The data directory subdirectory that corresponds to the nbdinfo database is ______________

View solution

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

View solution

Q. What is the synonym for CHARACTER SET?

View solution

Q. What is the statement used to select a default database?

View solution

Q. Symlink is an applicable relocation method for ______________

View solution

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