1. Home
  2. Oracle
  3. MySQL Database Administration
  4. 1z0-888
  5. MySQL 5.7 Database Administrator Questions and Answers

Pass the Oracle MySQL Database Administration 1z0-888 Questions and answers with CertsForce

 Oracle Exams      Go to Exam Detail      Get Premium Access
Viewing page 2 out of 4 pages
Viewing questions 11-20 out of questions
Questions # 11:

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

Options:
A.

Change the replication mode to MIXED before issuing any delete statements when the LIMIT clause is used.

B.

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

C.

Use the LIMIT clause to limit the deletion to 100,000 rows.

D.

Use the LIMIT clause in conjunction with the ORDER BY clause.

Questions # 12:

You want to dump only data from the userdata table.

Which mysqldump command argument is required to accomplish this?

Options:
A.

- -no-create-info to skip writing CREATE TABLE statements

B.

- -single-transaction as this obtains a consistent view of data only

C.

- -data-only as this specifies that only data is to be dumped

D.

- -table=userdata in order to dump only the data from the userdata table

Questions # 13:

Why should you be selective when granting the PROCESS privilege to an account?

Options:
A.

It allows a client to process scripts.

B.

It allows the use of stored routines.

C.

It allows a client to see another user’s queries with the SHOW PROCESSLIST command.

D.

It allows a client to control running processes on a server.

Questions # 14:

You are setting up a new installation of MySQL Server 5.7 (a GA release.) You have used a ZIP or TAR package to ensure that the mysqld binary, along with its support files, such as plug-ins and error messages, now exist on the host. Assume that the default datadir exists on the host. You installed the binary in the default location (the default --basedir value) for your operating system.

Which step should you perform before defining your own databases and database tables?

Options:
A.

Execute a command with a minimal form of: mysql --initialize

B.

Register mysqld as a service that will start automatically on this host machine.

C.

Create a configuration file containing default-storage-engine=InnoDB.

D.

Set an exception in the host machine’s firewall to allow external users to talk to mysqld.

E.

Create additional login accounts (so that everyone does not need to log in as root) and assign them appropriate privileges.

Questions # 15:

Multiversion Concurrency Control (MVCC) enables what type of backup?

Options:
A.

Hot

B.

Binary

C.

Logical

D.

Incremental

Questions # 16:

You have just executed a manual backup by using this command:

mysqlbackup –u root –p –-socket=/tmp/my.sock –-backup-dir=/my/backup/ backup

The operation completed without error.

What is the state of this backup and operation required before it is ready to be restored?

Options:
A.

Backup State = Compressed Backup

Operation = copy-back

B.

Backup State = Raw Backup

Operation = apply-log

C.

Backup State = Prepared Backup

Operation = validate

D.

Backup State = Prepared Backup

Operation = apply-log

E.

Backup State = Raw Backup

Operation = backupdir-to-image

Questions # 17:

Which statement best describes the purpose of the InnoDB buffer pool?

Options:
A.

It is amount of buffers available during a transaction.

B.

It caches only the indexes for InnoDB tables.

C.

It caches data and indexes for InnoDB tables.

D.

It holds changes made during a transaction before they are written to the log.

E.

It is a pool of memory for SQL query sort operations from within the InnoDB engine.

Questions # 18:

An employee cannot access the company database. You check the connection variables:

Question # 18

A look at the user privileges shows:

Question # 18

What is a valid explanation for why one of the users is unable to connect to the database?

Options:
A.

Bob has max_user_connections set to zero, which blocks all his connections.

B.

All users are blocked because max_user_connections is accumulated over the host account information.

C.

connect_timeout is too small to allow a connection to occur.

D.

Joe has exceeded the max_user_connections global limit.

E.

Kay is already connected elsewhere and attempting to log in again.

Questions # 19:

Which statement is correct about how InnoDB storage engine uses disk space?

Options:
A.

It stores data in .MYD files and its index and undo information in the common tablespace.

B.

It stores data in .MYD files, index information in .MYI files, and undo information the common tablespace.

C.

It stores its data in tablespace file(s). Index and data dictionary details are stored in .FRM files.

D.

It stores its data, index and undo information in .MYD and .MYI files.

E.

It stores data, index and undo information in tablespace file(s).

Questions # 20:

While attempting to set up a new replication slave on host ‘192.168.0.25’ with the user ‘replication’, you encounter this error:

Question # 20

What should you do to resolve this error?

Options:
A.

Add the user replication@192.168.0.25 with the correct password to the master.

B.

Edit the DNS table on the master to include the domain name for the IP address of 192.168.0.25.

C.

Edit the my.ini file on the slave so that the master-host variable is equal to the IP address of the master, and restart the slave.

D.

Add the user replication@192.168.0.25 with the correct password to the slave.

Viewing page 2 out of 4 pages
Viewing questions 11-20 out of questions