Oracle 1z0-882 Exam : Oracle Certified Professional, MySQL 5.6 Developer

Assume the user has just connected to the MySQL server.
What is the result of the query SELECT @ a?

• A. An error that @ a is undefined
• B. A single NULL
• C. The value of GLOBAL variable @ a
• D. An empty string

You are connected to a MySQL server and using a prepared statement. You accidentally exit your session.
What will happen if you log back in to use your prepared statement?

• A. The statement no longer exists.
• B. The statement exists, but will need to be deallocated and re-created.
• C. The statement exists, but the user variables need to be redefined.
• D. The statement can be used, if the MySQL server hasn't been restarted.

Consider the table structure shown by this output:
Mysql> desc city:

5 rows in set (0.00 sec)
You execute this statement:
SELECT -,-, city. * FROM city LIMIT 1
What is returned?

• A. One row with 10 columns
• B. One row with 5 columns
• C. An error message
• D. One row with 15 columns

Which two statements provide the definition for a view named view1 in the test database?

• A. SHOW DEFINITION FOR test.view
• B. SHOW CREATE VIEW view1 FROM test
• C. SHOW CREATE VIEW test-view1
• D. SELECT DEFINITION
  FROM INFORMATION_SCHEMA.VIEWS
  WHERE NAME = "test"
• E. SELECT VIEW_DEFINITION_SCHEMA.VIEWS
  FROM INFORMATION _SCHEMA.VIEWS
  WHERE TABLE_NAME="view1"
  AND TABLE_SCHEMA = "test"

Consider the statements:
Mysql> drop function foo;
ERROR 1305 (420000): FUNCTION test, foo does not exist
Mysql > show warnings;

Mysql> get diagnostics condition 2 @msg=MESSAGE_TEXT;
What is the result of the final statement?

• A. A warning message is generated that adds error 1758 (invalid condition number) to the diagnostics area.
• B. An error is generated as only one condition can exist in the diagnostics area.
• C. An empty result is returned.@msg is set to message of the warning.
• D. A line will be an output to the error log that contains the warning message details from the failed command.