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: Mar 26, 2025

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 : l updates except to the TEMPDB database

B : l updates except to the PERFORMANCE_SCHEMA database

C : l updates not involving temporary tables

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

E : l updates to all databases

Answer: A

Question 2

Examine this statement, which executes successfully:

Other-Image-2d087695c-370a-4149-9dae-43fdb2993133

You want to improve the performance of this query:

Other-Image-4d087695c-370a-4149-9dae-43fdb2993133

Which change enables the query to succeed while accessing fewer rows?

A : TER TABLE world.city ADD SPATIAL INDEX (Name);

B : TER TABLE world.city ADD SPATIAL INDEX (Population);

C : TER TABLE world.city ADD INDEX (Population);

D : TER TABLE world.city ADD INDEX (Name);

E : TER TABLE world.city ADD FULLTEXT INDEX (Name);

F : TER TABLE world.city ADD FULLTEXT INDEX (Population);

Answer: B

Question 3

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 : ql> 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 : ql> INSERT INTO t1 VALUES FRON ‘tmp/t1.sql’;

Answer: A,D

Question 4

Which statement is true about FLUSH LOGS command?

A : requires the RELOAD, FILE, and DROP privileges.

B : closes and reopens all log files.

C : closes and sends binary log files to slave servers.

D : flushes dirty pages in the buffer pool to the REDO logs.

Answer: B

Question 5

Which three are properties of the MyISAM storage engine? (Choose three.)

A : ansaction support

B : LLTEXT indexing for text matching

C : ble and page level locking support

D : reign key support

E : ospatial indexing

F : H index support

G : ble level locking only

Answer: A,B

Page: 1 / 79

Total 392 Questions | Updated On: Mar 26, 2025

Add To Cart