Free Oracle 1Z1-888 Practice Test & Real Exam Questions, Page 1

Question #1

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 USAGE, X509, .......ON *.* TO user@remotehost IDENTIFIED BY `secret_password'

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

Discussion 0

Correct Answer: D Vote an answer

Question #2

You have installed MySQL Server for the first time on your system. However, the data directory along with the tables in the mysql system database are missing. Which step do you perform to create the contents of the data directory?

A. Invoke mysql with the --initialize option.

B. Run the create_system_tables.sql file

C. Run the mysql_unpack.sql file

D. Invoke mysqld with the --initialize option.

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #3

On a master server that is using statement-based replication, a table of log data has become very large.
You decide to delete 100.000 rows.
Which two methods can be independently invoked to ensure that the delete is properly propagated to the slave? (Choose two.)

A. Use the limit clause to limit the deletion to 100.000 rows.

B. If the data modification is non-deterministic, the query optimizer will resolve any potential issues.

C. Change the replication mode to mixed before issuing any delete statements when the limit clause is used.

D. Use the limit clause in conjunction with the order 3Y clause.

Discussion 0

Correct Answer: C,D Vote an answer

Question #4

Which two statements are true about InnoDB auto-increment locking?

A. InnoDB never uses table_level locks.

B. InnoDB does not use locks to enforce auto-increment uniqueness.

C. Some settings for innodb_autoinc_lock_mode can help reduce locking.

D. The auto-increment lock can be a table-level lock.

E. InnoDB always protects auto-increment updates with a table-level lock

Discussion 0

Correct Answer: C,D Vote an answer

Question #5

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

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

B. It caches index blocks for InnoDB tables only.

C. It is a global buffer.

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

E. It caches index blocks for MyISAM tables only.

Discussion 0

Correct Answer: D,E Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #6

The InnoDB tablespace is corrupted and you start the server with option --innodb_force_recover=4.
Which backup method would you use to reload the corrupted InnoDB tables?

A. A text backup. InnoDB does not allow you to make binary backups while the server is running.

B. a binary backup that uses transportable tablespaces and allows you to reload a corrupted table

C. A text backup. A binary backup will still contain the corrupted segments.

D. a binary backup taken with MySQL Enterprise Backup that can back up even corrupted tables

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #7

An admin attempts to enforce stronger security by using these commands:

The admin then leaves the system running with the specified changes. What are two remaining security concerns?

A. The validate_password plug-in has not been loaded.

B. validate_password_policy cannot be set without restarting the MySQL instance.

C. The name of the dictionary file is too obvious.

D. validate_password_dictionary_file cannot be set without restarting the MySQL instance.

E. The dictionary file word list is too short.

F. The dictionary file is an insecure location.

Discussion 0

Correct Answer: C,F Vote an answer

Question #8

You are using the Performance Schema to investigate replication on a slave which has a single master.
The option slave-parallel-type is set to DATABASE.

Assume that all instruments and consumers are enabled and all threads are instrumented. Which two facts can be concluded from the given output?

A. THREAD_ID 21 has stopped running.

B. The server needs more cores to use all slave threads.

C. The slave cannot process the relay log fast enough to use all threads.

D. The salve has two intermediate relay slaves connected to it.

E. The slave is configured with slave_parallel_workers = 4

F. At most, two schemas are being updates concurrently.

Discussion 0

Correct Answer: C,E Vote an answer

Question #9

Which two methods accurately monitor the size of your total database size over time?

A. monitoring datadir size in the operating system

B. monitoring the innodb_redo_log_size variable

C. monitoring cumulative Innodb_page_size increase

D. monitoring the performance_schema_hosts_size variable

E. monitoring the information_schemA.TABLES table

F. monitoring the Innodb_rows_inserted status variable

Discussion 0

Correct Answer: A,E Vote an answer

Question #10

The MySQL user `adam' currently has USAGE permissions to the database.
The football database is transactional and has non-stop updates from application users. The `adam' user needs to be able to take consistent backups of the football database by using the -single-option.
transaction
Which extra GRANT permissions are required for adam to take mysqldump backups?

A. The `adam' user must also have SELECT on the football database for backups to work.

B. The `adam' user must also have SINGLE TRANSACTION global grant to take a consistent backup.

C. The `adam' user must have the SUPER privilege in order to take data backups.

D. The `adam' user needs the PROCESS privilege to be able to take a consistent backup while other users are connected.

Discussion 0

Correct Answer: C Vote an answer

Question #11

Consider a replication setup where a snapshot of the replication status shows:

Which statement is true?

A. The melbourne channel is keeping up with the received events.

B. The replication slave uses multisource replication with eight sources.

C. The melbourne channel is resolving a GTID conflict.

D. The last event received from the sydney channel was at 2018-05-08 14:55:01.

E. The sydney channel is keeping up with the received events.

Discussion 0

Correct Answer: B Vote an answer

Question #12

Consider:

Which statement best describes the meaning of the values in the ref columns?

A. world.City.CountryCodeis used as the primary key for the Country table.

B. No indexed columns are used to select rows from the Countrytable. The world.City.CountryCodecolumn is used to select rows in the City table.

C. No indexed columns are used to select rows from the City table. The world.City.CountryCode column is used to select rows in the Country table.

D. world.City.CountryCode is used to sort the rows in the Citytable.

Discussion 0

Correct Answer: C Vote an answer

Question #13

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

A. They are used to prevent data corruption.

B. They are used to prevent data theft.

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

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.

Discussion 0

Correct Answer: C,D,E Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Free Oracle 1Z1-888 Practice Test & Real Exam Questions

Download Free Oracle 1Z1-888 Demo