Oracle MySQL 5.7 Database Administrator - 1Z1-888 Exam Practice Test
Which statement is correct about how InnoDB storage engine uses disk space?
Correct Answer: D
Vote an answer
Which two are considered good security practices when using passwords? (Choose two.)
Correct Answer: C,D
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
A crucial database, `db_prod', just disappeared from your production MySQL instance. In reviewing the available MySQL logs (General, Audit, or Slow) and your own application-level logs, you identified this command from a customer facing application:
SELECT id FROM users WHERE login='payback!';DROP DATABASE db_prod;' Which three methods could have been used to prevent this SQL injection attack from happening?
SELECT id FROM users WHERE login='payback!';DROP DATABASE db_prod;' Which three methods could have been used to prevent this SQL injection attack from happening?
Correct Answer: A,C,E
Vote an answer
Examine the mydata table and SELECT statements:
You issue:
mysql> begin;
mysql> update mydata set a=0 where b=3;
How many rows are now protected by locks with the default InnoDB configuration?
You issue:
mysql> begin;
mysql> update mydata set a=0 where b=3;
How many rows are now protected by locks with the default InnoDB configuration?
Correct Answer: C
Vote an answer
In which order does MySQL process an incoming INSERT statement?
Correct Answer: A
Vote an answer
You need to dump the data from the master server and import it into a new slave server.
Which mysqldump option can be used when dumping data from the master server in order to include the master server's binary log information?
Which mysqldump option can be used when dumping data from the master server in order to include the master server's binary log information?
Correct Answer: C
Vote an answer
A single InnoDB table has been dropped by accident. You are unable to use an additional intermediate MySQL instance to restore the table. Which two backup methods can be used to restore the single table without stopping the MySQL instance?
Correct Answer: B,E
Vote an answer
Consider:
Which statement best describes the meaning of the value for the key_len column?
Which statement best describes the meaning of the value for the key_len column?
Correct Answer: A
Vote an answer
You are investigating the performance of the server and see this information:
* events_waits_summary_global_by_event_namein the Performance Schema shows that the wait/synch/mutex/sql/LOCK_table_cacheevent is dominating other wait events.
* The Table_open_cache_overflowsstatus variable is 0.
Which action should be taken to remove the performance bottleneck described here?
* events_waits_summary_global_by_event_namein the Performance Schema shows that the wait/synch/mutex/sql/LOCK_table_cacheevent is dominating other wait events.
* The Table_open_cache_overflowsstatus variable is 0.
Which action should be taken to remove the performance bottleneck described here?
Correct Answer: E
Vote an answer