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 have just created a replication slave from a backup of the master made with mysqldump:

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

You try to log in to the slave with the application user, but fail as follows:

The login works on the master.

Which two changes to the process can fix the issue?

A : ter the restore, log in to the database and execute FLUSH PRIVILEGES.

B : the --flush-privileges with mysqldump.

C : a second dump for the 'mysql' database; --all-databases does not include it.

D : the --grants option to include GRANT statements in the dump.

Answer: B

Question 2

When using MySQL Group Replication you can use the following storage engines:

A : InnoDB and MyISAM

B : noDB

C : ISAM

D : l the engines included with MySQL

Answer: B

Question 3

In a test database, you issue the SELECT … INTO OUTFLLE statement to create a file with your t1 table data.

You then TRUNCATE this table to empty it.

mysql> SELECT * INTO OUTFILE ‘/tmp/t1.sql’ from t1;

mysql> TRUNCATE t1;

Which two methods will restore data to the t1 table? (Choose two.)

A : ql> LOAD DATA INFILE ‘/tmp/t1.sql’ INTO TABLE t1;

B : $ mysqladmin -u root -p -h locathost test –restore /tmp/t1.sql

C : $ mysql -u root -p -h localhost test < /tmp/t1.sql

D : $ mysqlimport -u root -p -h localhost test /tmp/t1.sgl

E : ql> INSERT INTO t1 VALUES FRON ‘tmp/t1.sql’;

Answer: A,D

Question 4

On examination, your MySQL installation datadir has become recursively world read/write/executable.

What are two major concerns of running an installation with incorrect file privileges? (Choose two.)

A : ers could overwrite configuration files.

B : ta files could be deleted.

C : L injections could be used to insert bad data into the database.

D : QL binaries could be damaged, deleted, or altered.

E : tra startup time would be required for the MySQL server to reset the privileges.

Answer: A,B

Question 5

Examine this command and output:

Which statement is true?

A : rewall_cached_entries is the number of statements found in the query cache for users in DETECTING mode.

B : rewall_access_denied is the number of connection attempts from prohibited hosts that are denied.

C : rewall_access_suspicious is the number of statements logged as suspicious for users in DETECTING mode.

D : rewall_access_granted is the number of connections granted from whitelisted hosts.

Answer: C

Page: 1 / 79

Total 392 Questions | Updated On: Mar 01, 2021

Add To Cart