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

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 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 : The -- ssl level was not specified.

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

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

D : The mysqld binary was not compiled with SSL support.

E : The server’s SSL certificate was invalid.

Answer: D

Question 3

Examine this command and output:

Which statement is true?

A : Firewall_cached_entries is the number of statements found in the query cache for users in DETECTING mode.

B : Firewall_access_denied is the number of connection attempts from prohibited hosts that are denied.

C : Firewall_access_suspicious is the number of statements logged as suspicious for users in DETECTING mode.

D : Firewall_access_granted is the number of connections granted from whitelisted hosts.

Answer: C

Question 4

Examine this MySQL client command to connect to a remote database:

mysql -h remote.example.org -u root -p --protocol=TCP --ssl-mode=

Which two --ssl-mode values will ensure that an X.509-compliant certificate will be used to establish the

SSL/TLS connection to MySQL?

A : REQUIRED

B : VERIFY_CA

C : VERIFY_IDENTITY

D : PREFERRED

E : DISABLED

Answer: A

Question 5

Which query would you use to find connections that are in the same state for longer than 100 seconds?

A : SHOW FULL PROCESSLIST WHEER Time > 100;

B : SELECT * FROM INFORMATION_SCHEMA.EVENTS SHERE STARTS < (DATE_SUB (NOW ( ), INTERVAL 100 SECOND) );

C : SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE TIME > 100;

Answer: C

Page: 1 / 79

Total 392 Questions | Updated On: Apr 15, 2026

Add To Cart