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: Dec 05, 2025

Add To Cart

Question 1

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

A : innodb_ram_size=50GB

B : innodb_buffer_pool_size=50GB

C : innodb_buffer_pool=50G

Answer: B

Question 2

You adjust a default configuration to the following /etc/my.cnf on a Linux installation:

[mysqld]

Loq-bin

Binrylog_format=ROW

You do not notice the spelling error in binrylog_format and restart your production server.

How does the MySQL server behave with incorrectly spelled options?

A : Mysqld uses internal configuration versioning and reverts to the previous configuration.

B : When using mysql_config_editor for configuration adjustments, it detects incorrect syntax and typing mistakes.

C : The mysqld_safe script skips the unknown variable and starts using the remaining configuration changes.

D : Mysqld prints to the error log about an unknown variable, and then exits.

Answer: D

Question 3

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 4

You enable binary logging on MySQL Server with the configuration: binlog-format=STATEMENT log-bin

Which database updates are logged on the master server to the binary log by default?

A : all updates except to the TEMPDB database

B : all updates except to the PERFORMANCE_SCHEMA database

C : all updates not involving temporary tables

D : all updates to the default database, except temporary tables

E : all updates to all databases

Answer: A

Question 5

Which three statements are true about memory buffer allocation by a MySQL Server? (Choose three.)

A : Global buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freed.

B : Thread buffers are allocated when a client connects, and are freed when the client disconnects.

C : Buffers that are needed for certain operation are allocated when the operation starts, and freed when it ends.

D : User buffers are allocated at server startup and freed when the user is dropped.

E : All dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally, and are never freed.

Answer: A,C

Page: 1 / 79

Total 392 Questions | Updated On: Dec 05, 2025

Add To Cart