Free Access Oracle.1Z0-888.v2022-08-02.q167 Practice Test (Page 12)

Question 51

Examine the mysqldumpslow output:

Which two options could explain the slow query? (Choose two.)

A.A full table scan is being used.

B.No index has been defined on the filtered column.

C.There is network congestion between client and server.

D.There are 108 queries still being executed.

E.A table lock is causing delays.

Question 52

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

B.Edit the .indexfile 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 LOGSand specify a binary log file name or a date and time to remove unused files.

Question 53

These details are shown when logged in to an account:

Which set of statements would match the accounts shown?

A.mysql> CREATE_USER ''@'' IDENTIFIED WITH authentication_pam ACCOUNT LOCK; mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets'; mysql> GRANT PROXY ON 'employee'@'localhost' TO ''@'';

B.mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets'; mysql> GRANT PROXY ON 'employee'@'localhost' TO 'robert'@'localhost';

C.mysql> CREATE USER 'robert'@'localhost' IDENTIFIED BY 'secret_password'; mysql>CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets';

D.mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets'; mysql> CREATE USER ''@'' IDENTIFIED BY 'valid_password' WITH PROXY
'employee'@'localhost';

Question 54

Consider that local disk files are accessible via MySQL with commands such as:
mysql> LOAD DATA LOCAL INFILE '/etc/passwd' INTO TABLE mypasswords;
What change could be made to stop any breach via this insecurity?

A.executing REVOKE FILE ON *.* FROM ' ' @'%'

B.executing REVOKE LOAD FROM *.*

C.setting the --local-service=0 option when starting mysqld

D.executing REVOKE FILE FROM *.*

E.setting the --open-files-limit=0 option when starting mysqld

F.setting the --local-infile=0 option when starting mysqld

Question 55

Which two statements describe how InnoDB recovery works? (Choose two.)

A.There will in general be lost committed transactions after a crash using the default settings.

B.It is recommended to set innodb_force_recovery = 1as part of normal operations.

C.InnoDB blocks some operations when innodb_force_recoveryis set to greater than 0.

D.It is always required to enable innodb_force_recoveryto perform a crash recovery.

E.It is required to enable binlog_gtid_simple_recoveryto perform a crash recovery.

F.InnoDB handles most crash recoveries automatically.

Other Version: 1657Oracle.1Z0-888.v2022-11-15.q104; 2650Oracle.1Z0-888.v2022-04-28.q136; 102Oracle.Trainingdump.1Z0-888.v2022-02-05.by.chad.108q.pdf

Latest Upload: 104OCEG.GRCP.v2025-09-11.q211; 103HP.HPE0-V27.v2025-09-11.q78; 118Oracle.1Z0-1057-23.v2025-09-10.q47; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 164TheSecOpsGroup.CNSP.v2025-09-08.q20; 223CFAInstitute.ESG-Investing.v2025-09-08.q173; 158PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 147Salesforce.Data-Architect.v2025-09-05.q216; 142Adobe.AD0-E605.v2025-09-05.q50

Question 51

Question 52

Question 53

Question 54

Question 55

Download PDF File