Question No. 1

Examine these entries from the general query log:

All UPDATE statements reference existing rows.

Which describes the outcome of the sequence of statements?

AConnection 24 experiences a lock wait timeout.

BConnection 25 experiences a lock wait timeout.

CA deadlock occurs immediately.

DAll statements execute without error.

EA deadlock occurs after innodb_lock_wait_timeout seconds.

Show Answer

Correct Answer: E

Question No. 2

A valid raw backup of the shop.customers MyISAM table was taken.

You must restore the table. You begin with these steps:

1. Confirm that secure_file_priv='/var/tmp'

2. mysql> DROP TABLE shop.customers;

3. shell> cp /backup/customers.MY* /var/lib/mysql/shop/

Which two actions are required to complete the restore? (Choose two.)

Ashell> cp /backup/customers.sdi /var/tmp

Bshell> cp /backup/customers.sdi /var/lib/mysql/shop/

Cmysql> SOURCE '/var/tmp/customers.sdi'

Dmysql> IMPORT TABLE FROM /var/tmp/customers.sdi

Eshell> cp /backup/customers.frm /var/lib/mysql/shop/

Fmysql> IMPORT TABLE FROM /var/lib/mysql/shop/customers.sdi

Gmysql> ALTER TABLE shop.customers IMPORT TABLESPACE

Hmysql> ALTER TABLE shop.customers DISCARD TABLESPACE

Show Answer

Correct Answer: D, G

Question No. 3

User account baduser@hostname on your MySQL instance has been compromised.

Which two commands stop any new connections using the compromised account? (Choose two.)

AALTER USER baduser@hostname PASSWORD DISABLED;

BALTER USER baduser@hostname MAX_USER_CONNECTIONS 0;

CALTER USER baduser@hostname ACCOUNT LOCK;

DALTER USER baduser@hostname IDENTIFIED WITH mysql_no_login;

EALTER USER baduser@hostname DEFAULT ROLE NONE;

Show Answer

Correct Answer: C, D

Question No. 4

Examine this SQL statement:

Which set of privileges will allow Tom to execute this SQL statement?

AGRANT ALL PRIVILEGES ON 'world'.'city' TO 'tom'@'%';
GRANT SELECT ('code') ON 'world'.'country' TO 'tom'@'%';

BGRANT UPDATE ON 'world'.* TO 'tom'@'%';
GRANT ALL PRIVILEGES ON 'world'.'country' TO 'tom'@'%';

CGRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.* TO 'tom'@'%';

DGRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.'country' TO 'tom'@'%';

Show Answer

Correct Answer: D

Question No. 5

Which two are true about binary logs used in asynchronous replication? (Choose two.)

AThey are pushed from the master to the slave.

BThey contain events that describe database changes on the master.

CThey contain events that describe all queries run on the master.

DThey contain events that describe only administrative commands run on the master.

EThey are pulled from the master to the slave.

Show Answer

Correct Answer: A, B

Free Oracle 1Z0-908 Exam Actual Questions

The questions for 1Z0-908 were last updated On Jan 17, 2025