1z1-908 by Oracle Valid Free Exam Practice Test

Question 1

The mysqld instance has the connection control plugin enabled with these settings:
connection_control_min_connection_delay=1000 connection_control_max_connection_delay=2000 The minimum and maximum delays need to be increased to 3000 and 5000, respectively.
A command is executed:
mysql> SET GLOBAL connection_control_min_connection_delay=3000;
What is the result?

A. An error is returned. B. The minimum connection value is changed to 2000. C. The minimum value increases to 3000 and the maximum value increases to 4000. D. Only the minimum connection value is increased to 3000.

Correct Answer: D

Question 2

You have upgraded the MySQL binaries from 5.7.28 to 8.0.18 by using an in-place upgrade.
Examine the message sequence generated during the first start of MySQL 8.0.18:

Which step or set of steps will resolve the errors?

A. Start mysqld again using the --upgrade=FORCE option. B. Go to the <datadir>/mysql directory and execute: myisamchk --update-state columns_priv event proc proxies_priv tables_priv. C. Execute: mysqlcheck --repair mysql columns_priv event proc proxies_priv tables_priv. D. Remove the redo logs. Replace the MySQL binaries with the 5.7.28 binaries. Prepare the tables for upgrade. Upgrade to 8.0.18 again. E. Execute: mysqlcheck --check-upgrade mysql columns_priv event proc proxies_priv tables_priv.

Correct Answer: A

Question 3

Which two are use cases of MySQL asynchronous replication? (Choose two.)

A. You can scale writes by creating a replicated mesh. B. MySQL Enterprise Backup will automatically back up from an available slave. C. It guarantees near real-time replication between a master and a slave. D. You can scale reads by adding multiple slaves. E. It allows backup to be done on the slave without impacting the master.

Correct Answer: D,E

Question 4

You want to log only the changes made to the database objects and data on the MySQL system.
Which log will do this by default?

A. audit log B. slow query log C. error log D. binary log E. general query log

Correct Answer: D

Question 5

You plan to take daily full backups, which include the ndbinfo and sys (internal) databases.
Which command will back up the databases in parallel?

A. mysqlpump --all-databases > full-backup-$(date +%Y%m%d).sql B. mysqlpump --include-databases=% > full-backup-$(date +%Y%m$d).sql C. mysqldump --all-databases > full_backup-$(date +%Y%m%d).sql D. mysqldump --single-transaction > full-backup-$(date +%Y%m%d).sql

Correct Answer: B

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 6

Which two queries are examples of successful SQL injection attacks? (Choose two.)

A. SELECT email,passwd FROM members
WHERE email = 'INSERT INTO members('email','passwd') VALUES ('[email protected]',
'secret');--'; B. SELECT user, phone FROM customers WHERE name = '\; DROP TABLE users; --'; C. SELECT id, name FROM user WHERE user.id=(SELECT members.id FROM members); D. SELECT id, name FROM user WHERE id=23 OR id=32 OR 1=1; E. SELECT id, name FROM user WHERE id=23 OR id=32 AND 1=1; F. SELECT user,passwd FROM members
WHERE user = '?';INSERT INTO members('user','passwd') VALUES
('[email protected]','secret');--';

Correct Answer: A,E

Oracle MySQL 8.0 Database Administrator - 1z1-908 Exam Practice Test