The collection of databases is referred to as
A. tree.
B. cluster.
C. data hierarchy.
D. Group.
The collection of databases is referred to as Read More »
A. tree.
B. cluster.
C. data hierarchy.
D. Group.
The collection of databases is referred to as Read More »
A. Quit.
B. exit.
C. Ctrl+D.
D. quit, exit or ctrl+D.
Which of the following should be used to quit the mysql client. Read More »
a. column-names.
B. compress.
C. extended-status.
D. pager.
Which of the following is a command of mysqladmin utility. Read More »
A. flush-logs.
B. flush-threads.
C. flush-status.
D. flush-privileges.
Which command is used to close and reopen all logging files. Read More »
6 letter value by writing.
A. LIKE
(that’s six underscore characters).
B. LIKE (6)
C. LIKE…… (that’s six dots).
D. LIKE ?????.
In a LIKE clause, you can ask for any 6 letter value by writing. Read More »
A. nothing.
B. all the records from a table, or information about all the records.
C. all the records from a table that match the previous WHERE clause.
D. SELECT is invalid without a WHERE clause.
A SELECT command without a WHERE clause returns Read More »
A. nchar binary.
B. blob.
C. char.
D. binary text.
Which of these field types would be best to hold a .jpg image. Read More »
A. only to the “mysql” user.
B. to the “mysql” user, and also to the “webserver user.
C. only to the “root” user.
D. to the “mysql” user, and also to people who are installing applications that use MySQL.
A. Only DESCRIBE can take a LIKE clause.
B. Only SHOW FIELDS FROM can take a LIKE clause.
C. Nothing they’re the same thing.
D. SHOW FIELDS cannot take LIKE clause.
What’s the difference between the DESCRIBE and SHOW FIELDS FROM commands. Read More »