Oracle-MySQL 5.6 Developer Set 1

Which three are valid identifiers for the user table in the mysq1 database?

You have a transaction that queries a table at the beginning of the transaction and performs the same query later. Which two transaction isolation levels guarantee that you get the same results both times?

Which three database objects have non-case-sensitive names on all operating system?

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?

A table (t1) contains 1000 random integer values in the first column (col1).The random values are in the range of 0-1000. Examine this query: SELECT col1 FROM t1 WHERE col1 <=100 UNION SELECT col1 FROM t1 WHERE col1 >=900 ORDER BY col1 DESC What is the expected output?

A SELECT statement without an ORDER BY clause return some rows. Which statement is always true about the order of the returned results?

A complex query consists of eight populated tables that are all connected via INNER JOIN operands as shown: You modify the query and replace the SELECT operand with SELECT STRAIGHT JOIN. What is the effect of adding STRAIGHT JOINs to the query?

Which two can be used to obtain information stored in the Diagnostics Area?