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 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 2

How can we start MySQL when it was installed using RPM in Oracle Enterprise Linux 7?

A : mysqld_safe --user=mysql &

B : systemctl start mysqld

C : service start mysql

D : mysqladmin -u root start

Answer: B

Question 3

Why should you be selective when granting the PROCESS privilege to an account?

A : It allows a client to process scripts.

B : It allows the use of stored routines.

C : It allows a client to see another user-s queries with the SHOW PROCESSLIST command.

D : It allows a client to control running processes on a server.

Answer: C

Question 4

You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server.

Which two changes would ensure that the temporary table does not propagate to the slave? (Choose two.)

A : Set binlog_format=MIXED with the –replicate-ignore-temp-table option.

B : Use the –replicate-do-db, –replicate-do-table, or –replicate-wild-do-table option with the value equal to OLD_INVENTORY.

C : Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table.

D : Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table.

E : Use the –replicate-ignore-table option with the value equal to OLD_INVENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table.

Answer: A,C

Question 5

Which two are valid uses for binary logs on a MySQL instance? (Choose two.)

A : recording the order in which queries are issued

B : audit of all queries

C : point-in-time recovery

D : replication

E : logging the duration and locks for all queries

Answer: A,C

Page: 1 / 79

Total 392 Questions | Updated On: Mar 01, 2021

Add To Cart