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

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

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

Which three statements are true about MySQL replication? (Choose three.)

Options:
A.

Replication can use only TCP/IP connections.

B.

Any instance can have multiple slaves, but it can have only one master.

C.

Each instance in a replication topology must have a unique server ID.

D.

Binary logs contain only transactions originating from a single MySQL instance.

E.

Each slave must have its own MySQL user for replication.

F.

Binary logging must be enabled on the master in order to replicate to other instances.

G.

A replication user must have the SELECT privilege for all tables that need to be replicated.

Questions # 12:

Examine the modified output:

Question # 12

Seconds_Behind_ Master value is steadily growing. What are two possible causes? (Choose two.)

Options:
A.

The master is most probably too busy to transmit data and the slave needs to wait for more data.

B.

One or more large tables do not have primary keys.

C.

This value shows only I/O latency and is not indicative of the size of the transaction queue.

D.

The master is producing a large volume of events in parallel but the slave is processing them serially.

E.

The parallel slave threads are experiencing lock contention.

Questions # 13:

Examine this statement, which executes successfully:

Question # 13

Now examine this query:

Question # 13

Which two statements can do this? (Choose two.)

Options:
A.

ALTER TABLE employees -

ADD INDEX (birth_date DESC);

B.

ALTER TABLE employees -

ADD INDEX ((MONTH(birth_date)));

C.

ALTER TABLE employees -

ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (MONTH(birth_date)) VIRTUAL NOT NULL,

ADD INDEX (birth_month);

D.

ALTER TABLE employees -

ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (birth_date->>'$.month') VIRTUAL NOT NULL,

ADD INDEX (birth_month);

E.

ALTER TABLE employees -

ADD INDEX ((CAST(birth_date->>'$.month' AS unsigned)));

F.

ALTER TABLE employees -

ADD INDEX (birth_date);

Questions # 14:

Examine this list of MySQL data directory binary logs:

binlog.000001 binlog.000002

.....

binlog.000289

binlog.000300

binlog.000301

binlog.index

Now examine this command, which executes successfully:

mysqldump --delete-master-logs --all-databases > /backup/db_backup.sql

Which two are true? (Choose two.)

Options:
A.

All databases are backed up to the output file.

B.

All non-active binary logs are removed from the master.

C.

All binary logs are deleted from the master.

D.

All binary logs are backed up and then deleted.

E.

All databases, excluding master metadata, are backed up to the output file.

F.

All details regarding deleted logs and master metadata are captured in the output file.

Questions # 15:

Binary log events for the ‘mydb1’ schema must be copied to a different schema name ‘mydb2’.

Which command will do this?

Options:
A.

mysqlbinlog --rewrite-db=’mydb1->mydb2’ | mysql

B.

mysqlbinlog --datebase=mydb1 --database=mydb2 | mysql

C.

mysqlbinlog --rewrite-db=’mydb1’ --rewrite-db=’mydb2’ | mysql

D.

mysqlbinlog --read-from-remote-server --raw | sed ‘s/mydb1/mydb2/g’ | mysql

Questions # 16:

Which three are requirements for a secure MySQL Server environment? (Choose three.)

Options:
A.

Restrict the number of OS users that have access at the OS level.

B.

Ensure appropriate file system privileges for OS users and groups.

C.

Minimize the number of non-MySQL Server-related processes running on the server host.

D.

Encrypt the file system to avoid needing exact file-system permissions.

E.

Keep the entire software stack on one OS host.

F.

Run MySQL server as the root user to prevent incorrect sudo settings.

Questions # 17:

You are using mysqlcheck for server maintenance.

Which two statements are true? (Choose two.)

Options:
A.

The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks.

B.

The mysqlcheck --optimize --all-databases command reclaims free space from table files.

C.

The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.

D.

The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.

E.

The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual table corruptions.

Questions # 18:

Which two statements are true about raw binary backups? (Choose two.)

Options:
A.

They are converted to a highly compressible binary format.

B.

The data format is identical to how MySQL stores the data on disk.

C.

They are required to obtain FIPS security compliance.

D.

The resulting files are easily human readable.

E.

They are faster than logical backups because the process is a simple file or file system copy.

Questions # 19:

You execute this command:

shell> mysqlpump --exclude-databases=% --users

Which statement is true?

Options:
A.

It creates a logical backup of all MySQL user accounts.

B.

It creates a logical backup of all metadata, but contains no table data.

C.

It returns an error because the mysqldump command should have been used.

D.

It creates a logical backup of only the users database.

Questions # 20:

Which two statements are true about using backups of the binary log? (Choose two.)

Options:
A.

Multiple binary logs can be used to restore data.

B.

Multiple binary logs can be applied in parallel for faster data restoration.

C.

Binary logs are relatively small, and therefore, excellent for long-term storage and disaster recovery.

D.

Binary logs can always be used to unapply unwanted schema changes.

E.

They allow for point-in-time recovery of the data.

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