You are using the InnoDB engine and the innodb_file_per_table option is set. You delete a significant number of a large table named INVENTORY. What command will reorganize the physical storage of table data and associated index data for the INVENTORY table, in order to reduce storage space and improve I/O efficiency?
A. ANALYZE TABLE INVENTORY;
B. mysqlcheck INVENTORY
C. mysqldump INVENTORY
D. OPTIMIZE TABLE INVENTORY;
Answer: D
You execute the following statement SELECT NULL_NULL;
What is the result?
A. 0
B. 1
C. TRUE
D. FALSE
E. NULL
Answer: D
No comments:
Post a Comment
Note: only a member of this blog may post a comment.