Oracle 1Z0-908 Exam Real Questions

Prepare and pass your MySQL 8.0 Database Administrator with free 1Z0-908 exam questions.

Page: 1 / 79

Total 392 Questions | Updated On: Oct 09, 2024

Add To Cart

Question 1

You have an InnoDB Cluster configured with three servers.

Examine this command, which executes successfully:

mysqldump -uroot -p -d mydatabase > mydatabase_backup.sql

Due to data loss, the cluster is initialized and a restore is attempted resulting in this error:

ERROR 13176 (HY000) at line 23: Cannot update GTID_PURGED with the Group Replication plugin running

Which two actions, either one of which, can fix this error and allow a successful restore of the cluster? (Choose two.)

A : op all instances except the primary read/write master instance and run the restore.

B : move the @@GLOBAL.gtid_purged statement from the dump file.

C : eate the backup by using the --set-gtid-purged=OFF option.

D : move the group replication plugin from each instance before restoring.

E : move the @@GLOBAL.gtid_executed statement from the dump file.

F : tore using the --set-gtid-purged=OFF option.

Answer: B,C

Question 2

You are attempting to secure a MySQL server by using SSL encryption.

On starting MySQL, you get this error:

[ERROR] mysqld: unknown option ‘--ssl’

What is the cause of the error?

A : -- ssl level was not specified.

B : server was not started with the --enable–ssl-plugin option.

C : --ssl is not a valid server option.

D : mysqld binary was not compiled with SSL support.

E : server’s SSL certificate was invalid.

Answer: D

Question 3

When using MySQL Group Replication you can use the following storage engines:

A : InnoDB and MyISAM

B : noDB

C : ISAM

D : l the engines included with MySQL

Answer: B

Question 4

Which two methods will provide the total number of partitions on a table? (Choose two.)

A : ery the INFORMATION_SCHEMA.PARTITIONS table

B : the command: SHOW TABLE STATUS

C : ery the performance_schema.objects_summary_global_by_type table

D : ery the INFORMATION_SCHEMA.TABLES table for the partition_count

E : the command: SHOW CREATE TABLE

Answer: A

Question 5

Force Majeure is a catastrophic failure on a major level of the database operation. Regular backups are key to helping avoid data loss in such situations.

Which two other steps can help avoid data loss in a major catastrophe? (Choose two.)

A : plement a failover strategy to another geographic location.

B : eate a master-master pair for each service.

C : ve a second data centre in a different region or country.

D : ep software updated to the latest version.

E : RAID 10 storage for data.

F : on-site network-attached storage to separate service from data.

Answer: A,C

Page: 1 / 79

Total 392 Questions | Updated On: Oct 09, 2024

Add To Cart