Free Access Oracle.1Z0-888.v2022-11-15.q104 Practice Test (Page 15)

Question 66

Which three allocate memory per thread in MySQL?

A.query cache

B.thread cache

C.read buffer

D.internal temporary table

E.sort buffer

F.InnoDB buffer pool instance

Question 67

When you examine a new MySQL installation with default configuration, you find a file called ibdata1 in the database directory. Which two statements are true about this file? (Choose two.)

A.it contains a general tablespace.

B.it contains the undo log.

C.it contains the binary log.

D.it contains the system tablespace.

E.it is the default location for all new tables that you create.

F.it contains the redo log.

Question 68

What is the order of tables shown in an EXPLAINoutput?

A.It lists tables from the smallest to the largest.

B.It lists tables in the order in which their data will be read.

C.It lists tables from the most optimized to the least optimized.

D.It lists tables in the order in which they are specified in the statement that is being explained.

Question 69

An admin attempts to enforce stronger security by using these commands:

The admin then leaves the system running with the specified changes. What are two remaining security concerns?

A.The validate_passwordplug-in has not been loaded.

B.validate_password_policycannot be set without restarting the MySQL instance.

C.validate_password_dictionary_filecannot be set without restarting the MySQL instance.

D.The dictionary file word list is too short.

E.The name of the dictionary file is too obvious.

F.The dictionary file is an insecure location.

Question 70

Which three allocate memory per thread in MySQL? (Choose three.)