1z0-888 Oracle Exam Questions and Free Practice Test

Question 7

How does the InnoDB storage engine handle deadlocks when they are detected?

A. Both the affected transactions will be rolled back.

B. The affected transactions wait for innodb_lock_wait_timeout seconds, and then roll back.

C. One of the affected transactions will be rolled back, the other is allowed to proceed.

D. The transaction isolation level determines which transaction is rolled back.

E. The innodb_locks_unsafe_for_binlog setting determines which transaction is rolled bac

Correct Answer:C

Question 8

The MySQL error log shows:
InnoDB: Warning: a long semaphore wait:
The relevant parts of the InnoDB monitor output shows:
1Z0-888 dumps exhibit
Which two options would help avoid the long wait in the future?

A. Increase the value of the innodb_lock_wait_timeout option.

B. Increase the value of the innodb_read_io_threads option.

C. Change the table to use HASH indexes instead of BTREE indexes.

D. Set the value of innodb_adaptive_hash_index to zero.

E. Deactivate the query cache.

F. Increase the size of the InnoDB buffer poo

Correct Answer:BF

Question 9

Which three statements correctly describe MySQL InnoDBCluster?

A. The cluster can be operated in multimaster mode with conflict detection for DML statements.

B. All MySQL client programs and connectors can be used for executing queries.

C. It provides fully synchronous replication between the nodes.

D. There is support for automatic failover when one node fails.

E. The data is automatically shared between the nodes.

F. Each query will be executed in parallel across the node

Correct Answer:BDF

Question 10

A particular government’s security policy is to have very strict data encryption and safety settings. This is done by restricting access based on their own CA authority and limiting access to particular users within a department. Which method could be used to restrict access as required?

A. using GRANT … REQUIRE X509 AND REQUIRE ISSUER ‘/C=…..’ AND REQUIRE SUBJECT ‘/C=…..’

B. using GRANT USAGE, X509, …….ON *.* TO user@remotehost IDENTIFIED BY ‘secret_password’

C. using GRANT … REQUIRE SSL for a secure connection

D. using GRANT USAGE, SSL, …..ON *.* TO user@remotehost IDENTIFIED BY ‘secret_password’

Correct Answer:A

Question 11

What are three methods to reduce MySQL server exposure to remote connections? (Choose three.)

A. using SSL when transporting data over remote networks

B. using the sql_mode=STRlCT_SECURE after connections are established for encrypted communications

C. setting —skip-networking when remote connections are not required

D. setting specific grant privileges to limit remote authentication

E. setting —mysql_secure_configuration to enable paranoid mode

Correct Answer:ACD

Question 12

Which two statements are true about InnoDB auto-increment locking?

A. InnoDB never uses table_level locks.

B. InnoDB always protects auto-increment updates with a table-level lock

C. InnoDB does not use locks to enforce auto-increment uniqueness.

D. The auto-increment lock can be a table-level lock.

E. Some settings for innodb_autoinc_lock_mode can help reduce lockin

Correct Answer:DE

START 1z0-888 EXAM