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

Question 111

Consider the key buffer in a MySQL server. Which two statements are true about this feature? (Choose two.)

A.It caches index blocks for MyISAM tables only.

B.It caches index blocks for all storage engine tables.

C.It is a global buffer.

D.It is set on a per-connection basis.

E.It caches index blocks for InnoDB tables only.

Question 112

A MySQL server was initialized with separate UNDO tablespaces. Users complain that when they roll back large transactions, the time to process the request takes too long. The DBA would like to move the MySQL InnoDB UNDO tablespace to a solid-state drive (SSD) for better performance. Is this possible and how?

A.Yes. Shut down the mysqldprocess, enable the transportable_tablespaceoption, and move the UNDO directory to the SSD.

B.No. The UNDO tablespaces must remain on the same file system as the system tablespaces.

C.No. The sequential write pattern of the UNDO tablespaces is not supported on modern SSD block devices.

D.Yes. Shut down, copy the UNDO tablespaces to the new location, and change the innodb_undo_directoryvalue in your my.cnf.

Question 113

These details are shown when logged in to an account:

Which set of statements would match the accounts shown?
mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets';

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

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

C.mysql>CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets';
mysql> CREATE_USER ''@'' IDENTIFIED WITH authentication_pam ACCOUNT LOCK;

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

Question 114

You created a backup of the worlddatabase with this command:
shell> mysqldump --opt world > dump.sql
Which two will import the data from dump.sql? (Choose two.)

A.shell> mysqladmin recover test dump.sql

B.shell> mysql test < dump.sql

C.shell> mysqlimport test dump.sql

D.mysql> USE test; mysql> LOAD DATA INFILE 'dump.sql';

E.mysql>USE test; mysql>SOURCE dump.sql;

Question 115

Which two statements are true regarding the creating of new MySQL physical and logical backups? (Choose two.)

A.Logical backups are human-readable whereas physical backups are not.

B.Physical backups are usually slower than text backups.

C.Physical backups are usually faster than text backups.

D.Physical backups can be used to recover from data corruption.

E.Logical backups are always larger than physical backups.

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; 290NAHQ.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 111

Question 112

Question 113

Question 114

Question 115

Download PDF File