Free Oracle 1Z1-920 Exam Dumps Questions & Answers

Consider this SQL statement which is using the innoDB storage engine and with global AUTOCOMMIT = 1:

What is the result after issuing the rollback command?

• A.  Both the tables, t1 and t2, are created.
• B.  Only the t2 table is created.
• C.  Both the tables, t1 and t2, are not created because there is an explicit ROLLBACK.
• D.  Only the t1 table is created.

You get a maintenance-notification about your MySQL Enterprise Edition in Oracle Cloud Infrastructure (OCI) Compute instance. What is re the implication?

• A.  Depending on the planned outage, you may not be affected by it. You need to read the maintenance details in the support notice.
• B.  You can expect an outage of your MySQL OCI instance during the planned time..
• C.  You need to agree to the maintenance windows. If not, you are not affected by the outage.
• D.  There are no maintenance operations planned. You need to do them manually.

The user 'fwuser'@'localhost% was registered with the MySQL Enterprise Firewall and was granted privileges for the SAKILA database. You executed the commands:

You want to clear the account whitelist for the * fwuser" @* localhost* user. Which statement should you run to accomplish this?
A)

B)

C)

D)

• A.  Option B
• B.  Option C
• C.  Option A
• D.  Option D

Which query will find rows in a table that have no counterpart in another table?

• A.  SELECT left_tbl.*FROM left_tbl LEFT JOIN right_tbl ON left_tbl.id=right_tbl.idWHERE right_tbl.id IS NULL;
• B.  SELECT *FROM table1 INNER JOIN table2 ON table1.id=table2.id WHERE table1.id=! table2.id;
• C.  SELECT t1.name, t2.name2FROM employee t1 INNER JOIN info t2 WHERE t1.name=t2.name;
• D.  SELECT t1.name, t2.name2FROM employee AS t1 INNER JOIN info AS t2 ON t1.name= t2.name2;

You want to create an encrypted table. So, you enter this command:
CREATE TABLE 'test_encryption2% (
'id' int(10) unsigned NOT NULL AUTO_INCREMENT,
'server_name' varchar(15) NOT NULL,
PRIMARY KEY ('id') ) ENGINE=MYISAM AUTO_INCREMENT=l DEFAULT CHARSET=latin1 ENCRYPTION = 'Y1; You receive the following error:
ERROR 1031 (HY000): Table storage engine for 'test_encryption2' doesn't have this option Which statement correctly explains the reason for this error?

• A.  You cannot use the AUTO_INCREMENT option to create an encrypted table. This is what is causing the error.
• B.  The encryption feature only works with InnoDB tables. You are creating a MylSAM table, and it is causing the error.
• C.  The test_encryption2 already exist. You are not using the correct option to recreate it and it is causing the error.
• D.  The term "server_name" is a reserved MySQL term. You cannot use it for the new table. This is what is causing the error.