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: Jan 08, 2025

Add To Cart

Question 1

Which query would you use to find connections that are in the same state for longer than 100 seconds?

A : OW FULL PROCESSLIST WHEER Time > 100;

B : LECT * FROM INFORMATION_SCHEMA.EVENTS SHERE STARTS < (DATE_SUB (NOW ( ), INTERVAL 100 SECOND) );

C : LECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE TIME > 100;

Answer: C

Question 2

Your MySQL environment has asynchronous position based-replication with one master and one slave.

The slave instance had a disk I/O problem, so it was stopped.

You determined that the slave relay log files were corrupted and unusable, but no other files are damaged.

You restart MySQL Server.

How can replication be restored?

A : slave relay logs should be deleted; then execute START SLAVE;

B : relay logs from the master should be used to replace the corrupted relay logs.

C : slave relay logs should be deleted; execute CHANGE MASTER to adjust the replication relay log file name, then issue start SLAVE;

D : slave needs to be restored from backup.

Answer: B

Question 3

You are attempting to secure a MySQL server by using SSL encryption.

On starting MySQL, you get this error:

[ERROR] mysqld: unknown option ‘--ssl’

What is the cause of the error?

A : -- ssl level was not specified.

B : server was not started with the --enable–ssl-plugin option.

C : --ssl is not a valid server option.

D : mysqld binary was not compiled with SSL support.

E : server’s SSL certificate was invalid.

Answer: D

Question 4

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 5

Consider the three binary log files bin.00010, bin.00011, and bin.00012 from which you want to restore data.

Which method would use mysqlbinlog for greater consistency?

A : ell> mysqlbinlog bin.00010 | mysql shell> mysqlbinlog bin.00011 | mysql shell> mysqlbinlog bin.00012 | mysql

B : ell> mysqlbinlog bin.00010 bin.00011 bin.00012 | mysql

C : ell> mysqlbinlog – restore bin.00010 bin.00011 bin.00012

D : ell> mysqlbinlog – include-gtide=ALL bin.00010 bin.00011 bin.00012 | mysql

Answer: B

Page: 1 / 79

Total 392 Questions | Updated On: Jan 08, 2025

Add To Cart