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: Oct 28, 2025

Add To Cart

Question 1

You adjust a default configuration to the following /etc/my.cnf on a Linux installation:

[mysqld]

Loq-bin

Binrylog_format=ROW

You do not notice the spelling error in binrylog_format and restart your production server.

How does the MySQL server behave with incorrectly spelled options?

A : Mysqld uses internal configuration versioning and reverts to the previous configuration.

B : When using mysql_config_editor for configuration adjustments, it detects incorrect syntax and typing mistakes.

C : The mysqld_safe script skips the unknown variable and starts using the remaining configuration changes.

D : Mysqld prints to the error log about an unknown variable, and then exits.

Answer: D

Question 2

When the backup is taken, there are no errors.

Why are triggers missing from the backup?

A : The FILE privilege is required to back up the TRG files stored in the database directory.

B : The PROCESS privilege will allow the user access to process items such as triggers and functions.

C : The ALL privilege is required to back up triggers because triggers have a wide variety of abilities.

D : The TRIGGER privilege Is required to create, execute, and show triggers in a database.

Answer: D

Question 3

Which three statements are true about memory buffer allocation by a MySQL Server? (Choose three.)

A : Global buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freed.

B : Thread buffers are allocated when a client connects, and are freed when the client disconnects.

C : Buffers that are needed for certain operation are allocated when the operation starts, and freed when it ends.

D : User buffers are allocated at server startup and freed when the user is dropped.

E : All dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally, and are never freed.

Answer: A,C

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

Your MySQL server was upgraded from an earlier major version.

The sales database contains three tables, one of which is the transactions table, which has 4 million rows.

You are running low on disk space on the datadir partition and begin to investigate.

Examine these commands and output:

Other-Image-5400dea42-15fa-4b95-aaab-09ec510a61e4

Which two statements are true? (Choose two.)

A : Executing SET GLOBAL innodb_row_format=COMPRESSED and then ALTER TABLE transactionswill free up disk space.

B : Executing ALTER TABLE transactions will enable you to free up disk space.

C : Truncating the sales and leads table will free up disk space.

D : Truncating the transactions table will free up the most disk space.

E : The transactions table was created with innodb_file_per_table=OFF.

Answer: A

Page: 1 / 79

Total 392 Questions | Updated On: Oct 28, 2025

Add To Cart