Oracle Database MySQL 5.6 Developer Free Practice Exam Questions

24 real Oracle Database MySQL 5.6 Developer exam questions with answers and AI explanations. Oracle certification prep — page 2 of 3.

1. Question 17: What is true about the contents of the INFORMATION_SCHEMATA table?
2. Question 19: Which two queries return a value of NULL?
3. Question 20: 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 exec…
4. Question 21: You attempt to create two new tables: CREATE TABLE warehouse ( id int (11) NOT NULL AUTO_INCREMENT, name varchar (20) NOT NULL, phone varchar (20) NOT NULL, PR…
5. Question 23: Which two statements provide the definition for a view named view1 in the test database?
6. Question 24: A SELECT statement without an ORDER BY clause return some rows. Which statement is always true about the order of the returned results?
7. Question 28: Using the MYSQL command –line client you have received the error "Lost connection to MYSQL server query" Which three are possible causes of the error?
8. Question 30: Consider the statement: CREATE TABLE t1 (a INT) PARTITION BY KEY /*150611 ALGORITHM = 1*/ What does this statement do?
9. Question 31: You have a database dev that contains 15 tables, all of which use the CHARACTER SET utfs and the COLLATION utfs_general_ci. You perform the command: ALTER DATA…
10. Question 32: You have been tasked to create a database that will store a list of all managers and the employees who report directly to them. The following is stipulated: ✑…