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

Add To Cart

Question 1

Force Majeure is a catastrophic failure on a major level of the database operation. Regular backups are key to helping avoid data loss in such situations.

Which two other steps can help avoid data loss in a major catastrophe? (Choose two.)

A : Implement a failover strategy to another geographic location.

B : Create a master-master pair for each service.

C : Have a second data centre in a different region or country.

D : Keep software updated to the latest version.

E : Use RAID 10 storage for data.

F : Use on-site network-attached storage to separate service from data.

Answer: A,C

Question 2

You execute this command:

shell> mysqlpump --exclude-databases=% --users

Which statement is true?

A : It creates a logical backup of all MySQL user accounts.

B : It creates a logical backup of all metadata, but contains no table data.

C : It returns an error because the mysqldump command should have been used.

D : It creates a logical backup of only the users database.

Answer: B

Question 3

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

A : Transaction support

B : FULLTEXT indexing for text matching

C : Table and page level locking support

D : Foreign key support

E : Geospatial indexing

F : HASH index support

G : Table level locking only

Answer: A,B

Question 4

On a master server that is using Statement-based replication a table of log data has become very large. You decide to delete 100,000 rows.

Which two methods can be independently invoked to ensure that the delete is properly propagated to the slave? (Choose two.)

A : Use the LIMIT clause to limit the deletion to 100,000 rows.

B : Change the replication mode to MIXED before issuing any delete statements when the LIMIT clause is used.

C : Use the LIMIT clause in conjunction with the ORDER BY clause.

D : Use the data modification is non-deterministic, the query optimizer will resolve any potential issues.

Answer: B,C

Question 5

Your MySQL server was upgraded from an earlier major version.

The sales database contains three tables, one of which is the transactions table, which has 4 million rows.

You are running low on disk space on the datadir partition and begin to investigate.

Examine these commands and output:

Other-Image-5400dea42-15fa-4b95-aaab-09ec510a61e4

Which two statements are true? (Choose two.)

A : Executing SET GLOBAL innodb_row_format=COMPRESSED and then ALTER TABLE transactionswill free up disk space.

B : Executing ALTER TABLE transactions will enable you to free up disk space.

C : Truncating the sales and leads table will free up disk space.

D : Truncating the transactions table will free up the most disk space.

E : The transactions table was created with innodb_file_per_table=OFF.

Answer: A

Page: 1 / 79

Total 392 Questions | Updated On: Nov 26, 2025

Add To Cart