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 need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns.

Which two conditions must be true? (Choose two.)

A : Each extra column in the copy with more columns must not have a default value.

B : Columns that are common to both versions of the table must be defined in the same order on the master and the slave.

C : The slave database cannot have more columns than the master. Only the master database can have more columns.

D : Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server.

E : The master database cannot have more columns than the slave. Only the slave deatbase can have more columns.

Answer: B,D

Question 2

You have forgotten the root user account password. You decide to reset the password and execute:

2020-03-14-14-37-11-4ec4153145d3e66368ed58ed6f5922f5

Which additional argument makes this operation safer?

A : --old-passwords, to start MySQL to use the old password format while running without the grant tables.

B : --reset-grant-tables, to start the server with only the mysql database accessible.

C : --read-only, to set all data to read-only except for super users

D : --skip-networking, to prohibit access from remote locations

Answer: D

Question 3

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 4

You have a MySQL replication setup and you intentionally stop the SQL thread on the slave.

mysql> SHOW SLAVE STATUS\G

... Slave_IO_Running: YesSlave_SQL_Running: No

What are two reasons that you may stop the SQL thread on the slave while keeping the I/O thread running? (Choose two.)

A : to allow the remaining events to be processed on the slave while not receiving new events from the master

B : to allow a backup to be created under reduced load

C : to allow for point-in-time recovery on the slave

D : to prevent schema changes from propagating to the slave before they are validated

E : to prevent any transaction experiencing a deadlock

Answer: B,C

Question 5

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

Page: 1 / 79

Total 392 Questions | Updated On: Mar 01, 2021

Add To Cart