1Z0-908 by Oracle Valid Free Exam Practice Test

Question 1

An existing asynchronous replication setup is running MySQL 8.
Which two steps are a part of implementing GTID replication? (Choose two.)

A. Restart MySQL (master and slave) with these options enabled:
--gtid_mode=ON
--log-bin
--log-slave-updates
--enforce-gtid-consistency B. Execute this on the slave to enable GTID:
START SLAVE IO_THREAD WITH GTID; C. On the slave, alter the MySQL master connection setting with:
ALTER channel CHANGE MASTER TO MASTER_AUTO_POSITION = 1; D. Execute this on the slave to enable GTID:
RESET SLAVE; START SLAVE GTID_NEXT=AUTOMATIC; E. On the slave, alter the MySQL master connection setting with:
CHANGE MASTER TO MASTER_AUTO_POSITION = 1; F. Enable GTID by executing this on the master and the slave:
SET GLOBAL GTID_ENABLED=on;

Correct Answer: A,E

Question 2

What is the correct syntax for using transparent data encryption with an existing InnoDB table?

A. ALTER TABLE t1 WITH ENCRYPTION USING MASTER KEY; B. ALTER TABLE t1 ENCRYPTION='Y'; C. ALTER TABLE t1 ADD ENCRYPTED_TABLESPACE = 'Y'; D. ALTER TABLE t1 SET TDE = 'ON';

Correct Answer: C

Question 3

Examine this statement, which executes successfully:

You want to improve the performance of this query:

Which change enables the query to succeed while accessing fewer rows?

A. ALTER TABLE world.city ADD FULLTEXT INDEX (Name); B. ALTER TABLE world.city ADD INDEX (Name); C. ALTER TABLE world.city ADD SPATIAL INDEX (Population); D. ALTER TABLE world.city ADD FULLTEXT INDEX (Population); E. ALTER TABLE world.city ADD INDEX (Population); F. ALTER TABLE world.city ADD SPATIAL INDEX (Name);

Correct Answer: E

Question 4

Examine this query:

What information does this query provide?

A. total memory used by connection number 10 B. total memory used by the first 10 threads C. total memory used across all connections associated with the user on connection number 10 D. total memory used across all connections associated with the user on thread number 10 E. total memory used by thread number 10 F. total memory used by the first 10 connections

Correct Answer: A

Question 5

Examine this command, which executes successfully:
$ mysqlrouter --bootstrap user@hostname:port --directory=directory_path Which activity is performed?

A. MySQL Router is restarted. B. MySQL Router configures itself based on the information retrieved from the InnoDB cluster metadata server. C. MySQL Router configures all the cluster nodes based on the information retrieved from the InnoDB cluster metadata server. D. MySQL Router is configured based on the information in files in directory_path.

Correct Answer: B

Question 6

Examine this statement:
mysql> DROP ROLE r_role1, r_role2;
Which two are true? (Choose two.)

A. It fails if any of the roles is specified in the mandatory_roles variable. B. It fails if at least one of the roles does not exist. C. You must revoke r_role1 and r_role2 from all users and other roles before dropping the roles. D. Existing connections can continue to use the roles' privileges until they reconnect. E. It fails if you do not have the ADMIN OPTION of the roles r_role1 and r_role2. F. You must revoke all privileges from r_role1 and r_role2 before dropping the roles.

Correct Answer: D,E

Question 7

You plan to take daily full backups, which include the ndbinfo and sys (internal) databases.
Which command will back up the databases in parallel?

A. mysqlpump --all-databases > full-backup-$(date +%Y%m%d).sql B. mysqlpump --include-databases=% > full-backup-$(date +%Y%m$d).sql C. mysqldump --all-databases > full_backup-$(date +%Y%m%d).sql D. mysqldump --single-transaction > full-backup-$(date +%Y%m%d).sql

Correct Answer: B

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

Question 8

You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnf parameters to suit your installation.
Examine the output:

What statement is true about the start attempt?

A. MySQL server continued to start up even though another process existed. B. systemd waited for 30 seconds before timing out and start up failed. C. systemd attempted to start mysqld, found another systemd mysqld process running, and shut it down. D. MySQL server was not started due to a problem while executing process 2732. E. systemd found the mysqld service disabled and failed to start it.

Correct Answer: C

Question 9

Which statement is true about cold backups?

A. They are backups taken from OS copy commands. B. They are good to use when many users are online accessing the database. C. They are good to use if only data structures must be backed up but not log files. D. They are backups taken from snapshots of a running database.

Correct Answer: D

Question 10

You are using mysqlcheck for server maintenance.
Which two statements are true? (Choose two.)

A. The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks. B. The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default. C. The mysqlcheck --optimize --all-databases command reclaims free space from table files. D. The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table. E. The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual table corruptions.

Correct Answer: B,E

Oracle MySQL 8.0 Database Administrator - 1Z0-908 Exam Practice Test