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

Question 86

What three are correct statements about MySQL backups? (Choose three.)

A.They are used to set up the initial binary log files.

B.They are used to prevent data corruption.

C.They are used to prevent data theft.

D.They are used to set up a replication slave.

E.They are used to recover data.

F.They are used to set up a test system.

Question 87

A MySQL replication slave is set up as follows:
* Uses all InnoDB tables
* Receives ROW-based binary logs
* Has the read-only option
The replication slave has been found in an error state.
You check the MySQL error log file and find these entries:

What are two possible causes for this error to occur? (Choose two.)

A.The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite.

B.The applications have the SUPERprivilege, which allows them to update rows.

C.For tables with UNIQUE keys, statement-based replication must be used to maintain integrity.

D.The slave was created with mysqldump -u root -p --skip-lock-tables -all-databases > / data/data.sql

E.The slave user does not have INSERT, UPDATE, or DELETEpermission and cannot execute the Write_rowsfunction.

Question 88

Which two capabilities are granted with the SUPER privilege? (Choose two.)

A.allowing a client to shut down the server

B.allowing client accounts to take over the account of another user

C.allowing change of the server runtime configuration

D.allowing a client to kill other client connections

Question 89

You have just created a replication slave from a backup of the master made with mysqldump:

You try to log in to the slave with the application user, but fail as follows:

The login works on the master.
Which two changes to the process can fix the issue?

A.Add a second dump for the 'mysql' database; --all-databases does not include it.

B.Use the --flush-privileges with mysqldump.

C.After the restore, log in to the database and execute FLUSH PRIVILEGES.

D.Use the --grants option to include GRANT statements in the dump.

Question 90

The following grants were executed:
GRANT CREATE ROUTING ON sales.* TO 'webadmin'@'%';
GRANT ALTER ON PROCEDURE sales.myproc TO 'webadmin'@'%';
A user successfully connects to the database as webadmin and created a stored procedure named get_reports.
The next day, the user logs in again as webadmin and wants to delete the stored procedure named get_reports, and therefore, issues the following statement:
USE sales;
DROP PROCEDURE IF EXISTS get_reports;
What is the result of executing the statement?

A.The user will get an error because he or she did not put the database name in front of the stored procedure name.

B.The user will get an error because he or she did not use the ALTER statement to drop the stored procedure.

C.The stored procedure named get_reports will be dropped.

D.The user will get an error because he or she does not have the permission to drop stored procedures.

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 86

Question 87

Question 88

Question 89

Question 90

Download PDF File