Free Oracle 1Z0-908 Exam Questions

Become Oracle Certified with updated 1Z0-908 exam questions and correct answers

Page: 1 / 79

Total 392 Questions | Updated On: Feb 10, 2026

Add To Cart

Question 1

You enable binary logging on MySQL Server with the configuration: binlog-format=STATEMENT log-bin

Which database updates are logged on the master server to the binary log by default?

A : all updates except to the TEMPDB database

B : all updates except to the PERFORMANCE_SCHEMA database

C : all updates not involving temporary tables

D : all updates to the default database, except temporary tables

E : all updates to all databases

Answer: A

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

You have forgotten the root user account password. You decide to reset the password and execute:

2020-03-14-14-37-11-4ec4153145d3e66368ed58ed6f5922f5

Which additional argument makes this operation safer?

A : --old-passwords, to start MySQL to use the old password format while running without the grant tables.

B : --reset-grant-tables, to start the server with only the mysql database accessible.

C : --read-only, to set all data to read-only except for super users

D : --skip-networking, to prohibit access from remote locations

Answer: D

Question 4

You execute mysqladmin shutdown on a MySQL server that is decribed as follows:

- It is running with both active and idle client connections.

- It has open transactions against InnoDB.

- It has active multi-row inserts into MyISAM engine tables.

- Innodb_fast_shitdown is set to 1.

What are three effects of shutting down the server by using a mysqladmin shutdown command?

A : Connections that have an open transaction are rolled back.

B : Connections with statements running against MyISAM tables wait for completion.

C : New client connections are not accepted after shutdown is initiated.

D : Connections are accepted during the shutdown process because a graceful shutdown can take large amounts of time.

E : Partial updates may occur for non-transactional tables.

Answer: A,C

Question 5

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

Page: 1 / 79

Total 392 Questions | Updated On: Feb 10, 2026

Add To Cart