Free Access Oracle.1Z1-888.v2022-04-27.q131 Practice Test (Page 23)

Question 106

Which two statements are true regarding MySQL security? (Choose two.)

A.The mysqld process should be run as root or administrator.

B.The mysqld process owner should own all files and directories to which the server writes.

C.The mysqld process should not be run as root or administrator.

D.The root or administrator users should own all files and directories to which the server writes.

E.The mysql user needs to have sudo privileges.

Question 107

You are using replication and the binary log files on your master server consume a lot of disk space. Which two steps should you perform to safely remove some of the older binary log files? (Choose two.)

A.Execute the PURGE BINARY LOGS NOT USED command.

B.Edit the .index file to remove the files you want to delete.

C.Ensure that none of the attached slaves are using any of the binary logs you want to delete.

D.Remove all of the binary log files that have a modification date earlier than today.

E.Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files.

Question 108

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 back.

Question 109

The /myfolder/my.cnf file has option set:
[mysqld]
skip-log-bin
/myfolder2/my.cnf has this option set:
[mysqld]
log-bin = /valid/path/to/mysqlbinlog
All mentioned paths are accessible to the account that you are currently using. Assume that any other options mentioned in either file are valid and legal option definitions.
You start an instance by using this command line:
mysqld --defaults-file=/myfolder/my.cnf --defaults-extra-file=/myfolder2/my.cnf What is the outcome?

A.MySQL fails to start due to conflicting options on the command line.

B.MySQL starts and Binary Logging is enabled.

C.MySQL starts but Binary Logging is disabled.

D.MySQL fails to start due to the conflicting options in the configuration files.

Question 110

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

A.query cache

B.thread cache

C.read buffer

D.internal temporary table

E.sort buffer

F.InnoDB buffer pool instance

Other Version: 2098Oracle.1Z1-888.v2022-09-10.q127; 1835Oracle.1Z1-888.v2022-07-14.q104

Latest Upload: 108WGU.Secure-Software-Design.v2025-10-07.q44; 142Fortinet.FCP_FAZ_AD-7.4.v2025-10-06.q79; 289NAHQ.CPHQ.v2025-10-06.q485; 121EMC.D-VXR-DS-00.v2025-10-06.q30; 138GitHub.GitHub-Actions.v2025-10-04.q24; 236Cisco.350-701.v2025-10-04.q562; 205Microsoft.AZ-120.v2025-10-03.q125; 234Huawei.H12-811_V1.0.v2025-10-02.q205; 219PMI.PfMP.v2025-10-02.q265; 141EMC.D-NWR-DY-01.v2025-10-02.q145

Question 106

Question 107

Question 108

Question 109

Question 110

Download PDF File