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: Apr 15, 2026

Add To Cart

Question 1

A MySQL replication master is set up by using global reansaction identifiers(GTIDs). You execute this statement:

mysql> CREATE TABLE datatarget SELECT * FROM datasource;

ERROR 1786 (HY000): CREATE TABLE ... SELECT is forbidden when @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1.

Why is this statment forbiden?

A : GTIDs have detected thar a slave is inconsistent and therefore, disallow upadtes until the problem is resolved.

B : The datasource table is using an older InnoDB tablespace format, which is not compatible with GTIDs.

C : The datasource table is using the MyISAM engine, which is not compatible with GTIDs.

D : The statement cannot be logged in a transactionally safe manner.

Answer: D

Question 2

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

Examine the output:

Other-Image-30e9b1e03-8bbc-4275-a4c0-1ac8f11994b9

What statement is true about the start attempt?

A : MySQL server was not started due to a problem while executing process 2732.

B : MySQL server continued to start up even though another process existed.

C : systemd found the mysqld service disabled and failed to start it.

D : systemd waited for 30 seconds before timing out and start up failed.

E : systemd attempted to start mysqld, found another systemd mysqld process running, and shut it down.

Answer: A

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

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 5

On examination, your MySQL installation datadir has become recursively world read/write/executable.

What are two major concerns of running an installation with incorrect file privileges? (Choose two.)

A : Users could overwrite configuration files.

B : Data files could be deleted.

C : SQL injections could be used to insert bad data into the database.

D : MySQL binaries could be damaged, deleted, or altered.

E : Extra startup time would be required for the MySQL server to reset the privileges.

Answer: A,B

Page: 1 / 79

Total 392 Questions | Updated On: Apr 15, 2026

Add To Cart