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 01, 2021

Add To Cart

Question 1

You are considering using file-system snapshots to back up MySQL.

Which three statements are true? (Choose three.)

A : ey take roughly twice as long as logical backups.

B : ey allow direct copying of table rows with operating system copy commands.

C : ey work best for transaction storage engines that can perform their own recovery when restored.

D : backup window is almost zero from the perspective of the application.

E : ey do not back up views, stored procedures, or configuration files.

F : ere is a slight performance cost while the snapshot is active.

G : ey do not use additional disk space.

Answer: A,C

Question 2

You are setting up a new server and you want to reserve 50GB of RAM for InnoDB use. What option would you set

A : nodb_ram_size=50GB

B : nodb_buffer_pool_size=50GB

C : nodb_buffer_pool=50G

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

User bob@% has the following roles granted: app_read and app_write.

How would you show the privileges for bob@% when it uses app_write? (Choose one).

A : OW GRANTS FOR bob@'%';

B : OW GRANTS FOR bob@'%' USING 'app_write';

Answer: B

Question 5

Which two statements are true about using MySQL Enterprise Monitor Query Analyzer? (Choose two.)

A : single query QRTi pie chart in the Query Analyzer view is based on the average execution of all statements.

B : is possible to retrieve a normalized statement, but never the exact statement that was executed.

C : is possible to configure the Query Analysis built-in advisor to get notified about slow query execution.

D : is possible to list and analyze statements in an arbitrary graph range selection from timeseries graphs.

E : is possible to import data into the Query Analyzer from heterogeneous sources, such as CSV.

Answer: C,D

Page: 1 / 79

Total 392 Questions | Updated On: Mar 01, 2021

Add To Cart