Oracle 1z0-882 Exam Practice Questions (P. 4)

In MYSQL 5.6 you have the table t1:
CREATE TABLE t1 (
id int unsigned NOT NULL PRIMARY key) ENGINE = InnoDB;
There are two connections to the server. They execute in this order:
Connection 1> SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
Connection 1> START TRANSACTION;
Connection 1> SELECT * FROM t1 WHERE id =1;
Connection 2> TRUNCATE TABLE t1;
What happens to the TRUNCATE TABLE command in connection 2?

Your application is running slow.
Which two features provide information that help to identify problems?

Cormcctor/Net supports a decoupled database connection mode, where a database Connection is established only when needed.
'
Choose the three parts that are involved when working with decoupled data.

You have two test tables:
✑ Code_innodb as InnoDB engine
✑ Code_ myisam as MYISAM engine
The tables have the same structure:

The tables have one row of data:

You execute an INSERT statement on both code_myisam tables and receive duplicate key errors: mysql> INSERT INTO code_innodb VALUES (1, Alpha), (2, Beta), (3, charlie,),(4, Delta);
ERROR 1062 (23000): Duplicate entry 3 for key PRIMARY
Mysql> INSERT INTO code_myisam VALUES (1, Alpha), (2, Beta), (3, charlie),
(4, Delta);
ERROR 1062 (23000); Duplicate entry 3 for key PRIMARY
What is the expected output of the SELECT statements?

Which two code samples demonstrate valid methods for working with loops?