61.
Will the following SELECT query list all of the tables in the INFORMATION_SCHEMA database?
If not, why? SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'INFORMATION_SCHEMA' ORDER BY TABLE_NAME
If not, why? SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'INFORMATION_SCHEMA' ORDER BY TABLE_NAME
- A.Yes.
- B.No; the INFORMATION_SCHEMA database does not contain information on itself.
- C.No; the WHERE clause is incorrect. The correct field name is TABLE_SCHEMATA.
- D.No; there is no table in the INFORMATION_SCHEMA database called TABLES.
- Answer
- Report
Answer : [A]
62.
Which of the following are some general capabilities of the mysql client program?
- A.Create and Drop databases
- B.Ping the server
- C.Create, Drop, and modify tables and indexes.
- D.Shutdown the server.
- E.Create users.
- E.Display replication server status.
- Answer
- Report
Answer : [A, C, E, F]
63.
Suppose you have a server that has been started with the --myisam-recover option. When does
the server perform the check on the MyISAM tables?
- A.Each time the server is started.
- B.Each time it encounters an error.
- C.Each time it opens theMyISAM table files.
- D.Each time the CHECK TABLE command is issued.
- Answer
- Report
Answer : [C]
64.
Consider the following query: DELETE FROM INFORMATION_SCHEMA.TABLES
WHERE table_schema = 'world' AND table_name = 'Country' What would be the result of executing this query?
- A.An error would be issued
- B.A warning would be issued
- C.The row would be deleted from the INFORMATION_SCHEMA.TABLES table, and the table Country would be dropped from the world database
- D.The row would be deleted from the INFORMATION_SCHEMA, but the table Country in the world database would be unaffected.
- Answer
- Report
Answer : [A]
65.
Which mysqld command line option disables incoming TCP/IP connections?
- A.--Shared-memory
- B.--Memlock
- C.--No-networking
- D.--Skip-networking
- Answer
- Report
Answer : [D]
|
|
||||||||||||||||||||||||||||
