Free Practice Mock Questions Set 41-45 () for Oracle 1Z0-888 Exam, according to official Oracle MySQL 5.7 Database Administrator exam syllabus topic # 7
Which two methods will provide the total number of partitions on a table? (Choose two.)
Answer : A, B
On a master server that is using statement-based replication, a table of log data has become very large. You decide to delete 100.000 rows.
Which two methods can be independently invoked to ensure that the delete is properly propagated to the slave? (Choose two.)
Answer : A, D
Exhibit:
What does the possible_keys column in this output denote?
Answer : A
Which two options describe how MySQL Server allocates memory?
Which three are key advantages of standard MySQL replication?
Answer : B, E, F