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: Apr 20, 2026

Add To Cart

Question 1

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 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 : ALTER TABLE world.city ADD SPATIAL INDEX (Name);

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

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

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

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

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

Answer: B

Question 3

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 4

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 5

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

Page: 1 / 79

Total 392 Questions | Updated On: Apr 20, 2026

Add To Cart