Free Access Oracle.1Z1-888.v2022-09-10.q127 Practice Test (Page 18)

Question 81

A particular government's security policy is to have very strict data encryption and safety settings. This is done by restricting access based on their own CA authority and limiting access to particular users within a department. Which method could be used to restrict access as required?

A.using GRANT USAGE, SSL, .....ON *.* TO user@remotehost IDENTIFIED BY 'secret_password'

B.using GRANT ... REQUIRE SSL for a secure connection

C.using GRANT ... REQUIRE X509 AND REQUIRE ISSUER '/C=.....' AND REQUIRE SUBJECT
'/C=.....'

D.using GRANT USAGE, X509, .......ON *.* TO user@remotehost IDENTIFIED BY 'secret_password'

Question 82

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

A.shell> mysqladmin recover test dump.sql

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

C.shell> mysql test < dump.sql

D.shell> mysqlimport test dump.sql

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

Question 83

Which two statements are true about MySQL when it has been started using the --skip-grant-tables option? (Choose two.)

A.All users have unrestricted access.

B.MySQL becomes read-only except for setting passwords.

C.All connections succeed regardless of the username and password.

D.Only the password for active account can be changed.

E.User authentication is based on the operating system username.

Question 84

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

A.It caches index blocks for MyISAM tables only.

B.It is a global buffer.

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

D.It caches index blocks for InnoDB tables only.

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

Question 85

The MySQL error log shows:
InnoDB: Warning: a long semaphore wait:
The relevant parts of the InnoDB monitor output shows:

Which two options would help avoid the long wait in the future?

A.Change the table to use HASH indexes instead of BTREE indexes.

B.Increase the value of the innodb_read_io_threads option.

C.Deactivate the query cache.

D.Increase the size of the InnoDB buffer pool.

E.Increase the value of the innodb_lock_wait_timeout option.

F.Set the value of innodb_adaptive_hash_index to zero.

Other Version: 2469Oracle.1Z1-888.v2022-07-14.q104; 3112Oracle.1Z1-888.v2022-04-27.q131

Latest Upload: 201BCS.PC-BA-FBA-20.v2026-10-27.q111; 195Salesforce.Plat-Dev-210.v2026-10-27.q75; 145Salesforce.Strategy-Designer.v2026-10-26.q75; 244Veeam.VMCE_v12.v2026-10-24.q119; 228API.API-510.v2026-10-24.q84; 191AIChE.CCPSC.v2026-10-24.q41; 230CIPS.L4M5.v2026-10-24.q263; 163InsuranceLicensing.InsNV_Health02.v2026-10-23.q44; 304Juniper.JN0-452.v2026-10-23.q141; 340EC-COUNCIL.312-38.v2026-10-22.q321

Question 81

Question 82

Question 83

Question 84

Question 85

Download PDF File