1z1-882 무료 덤프문제 온라인 액세스

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

What is true about the contents of the INFORMATION_SCHEMATA table?

• A.It contains information about the table structure for all databases.
• B.It contains information including tables, trigger, stored routines, and views for all databases
• C.It contains information such as name, character set, and collation for all the databases on the server.
• D.It contains information about all the tables, triggers, and views for all databases.

In the office table, the city column is structured as shown:
Mysql> show columns from office like 'city'\G
---------------------------------------------------1. row ---------------------__________________
Field: city
Type: enum('paris'.'Amsterdam'.'New York'.'Tokyo')
Null: Yes
Key:
Default:NULL
Extra:
Consider the output of the SELECT query executed on the office table:
Mysql> SELECT DISTINCT city FROM office ORDER BY city:

If the query is written as:
SELECT DISTINCT city FROM office ORDER BY CAST(city AS CHAR)
In what order are the rows returned?

• A.Tokyo, Paris, New York, Amsterdam
• B.Tokyo, New York, Amsterdam, Paris
• C.Amsterdam, New York, Paris, Tokyo
• D.Paris, Amsterdam. New York, Tokyo

Which three connector/J connection strings can be used to connect to the MYSQL server?

• A.Jdbc :mysql:replication://master,slave1.slave2. /test?user=xxx&password=xxx
• B.Jdbc :mysql:loadbalance://master.slave1,slave2/test?user=xxx&password=xxx
• C.Jdbc:mysq1://localhost/test?user =xxx&password=xxx
• D.Jdbc:mysql:proxy://localhost/test?user=xxx&password=xxx
• E.Jdbc :mysqli://localhost/test?user=xxx&password=xxx

The people table contains the data as shown:

Which two statements return two rows each?

• A.SELECT DISTINCT last_name, first_name FROM people
• B.SELECT 1,2 FROM people GROUP BY last_name
• C.SELECT first_name, last _name FROM people WHERE age LIKE '2'
• D.SELECT 1, 2 FROM people WHERE last _name ='smith'
• E.SELECT first _name, last_name FROM people LIMIT 1, 2