Free Online Oracle 1Z0-908 Practice Test

Prepare Your Oracle 1Z0-908 Exam Questions with Free online 1Z0-908 Practice Test. Get Brilliant MySQL 8.0 Database Administrator Exam Results with Valid 1Z0 908 Exam Dumps.

Page: 1 / 79

Total 392 Questions | Updated On: Apr 22, 2024

Question 1

You are considering using file-system snapshots to back up MySQL.

Which three statements are true? (Choose three.)

A : They take roughly twice as long as logical backups.

B : They allow direct copying of table rows with operating system copy commands.

C : They work best for transaction storage engines that can perform their own recovery when restored.

D : The backup window is almost zero from the perspective of the application.

E : They do not back up views, stored procedures, or configuration files.

F : There is a slight performance cost while the snapshot is active.

G : They do not use additional disk space.

Answer: A,C

Question 2

In a test database, you issue the SELECT … INTO OUTFLLE statement to create a file with your t1 table data.

You then TRUNCATE this table to empty it.

mysql> SELECT * INTO OUTFILE ‘/tmp/t1.sql’ from t1;

mysql> TRUNCATE t1;

Which two methods will restore data to the t1 table? (Choose two.)

A : mysql> LOAD DATA INFILE ‘/tmp/t1.sql’ INTO TABLE t1;

B :

$ mysqladmin -u root -p -h locathost test –restore /tmp/t1.sql

C : $ mysql -u root -p -h localhost test < /tmp/t1.sql

D : $ mysqlimport -u root -p -h localhost test /tmp/t1.sgl

E : mysql> INSERT INTO t1 VALUES FRON ‘tmp/t1.sql’;

Answer: A,D

Question 3

Which two are valid uses for binary logs on a MySQL instance? (Choose two.)

A : recording the order in which queries are issued

B : audit of all queries

C : point-in-time recovery

D : replication

E : logging the duration and locks for all queries

Answer: A,C

Question 4

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

A :

InnoDB and MyISAM

B : InnoDB

C : MyISAM

D : All the engines included with MySQL

Answer: B

Question 5

Which three methods will show the storage engine for the Country table? (Choose three.)

A : SHOW CREATE TABLE Country;

B : SHOW ENGINE Country STATUS;

C : SHOW TABLE STATUS LIKE ‘Country’;

D : SELECT ENGINE FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME= ‘Country’;

E : SELECT ENGINE FROM INFORMATION_SCHEMA.ENGINES WHERE TABLE_NAME= ‘Country’;

Answer: A,C,D

Page: 1 / 79

Total 392 Questions | Updated On: Apr 22, 2024