1Z0-909 試験問題を無料オンラインアクセス

You must write a statement that combines the first_name and last_name columns from the employees table as "last_name, first_name." Which two statements will do this?

• A.SELECT GROUP_CONCAT(last_name, first_name) FROM employees;
• B.SELECT last_name, ' , ',first_name FROM employees;
• C.SELECT CONCAT(last name,', ',first_name) FROM employees;
• D.SELECT CONCAT_WS(', ',last_name,first_name) FROM employees;
• E.SELECT last_name + ', ' + first_name FROM employees;

Examine the statement which executes successfully:
SET sql_mode=' NO_ENGINE_SUBSTITTJTION' ;
You try to create a table with a storage engine that is not available. What will happen?

• A.The server will create the table but it will be unusable until the specified storage engine is available.
• B.The server will create the table but report an error when the first attempt to insert a row is performed.
• C.The server will create the table using the default storage engine.
• D.An error occurs and the create table statement fails.

Which two statements are true about AUTO_INCREMENT?

• A.The decimal data type supports AUTO_INCREMENT.
• B.An AUTO_INCREMENT column must be indexed.
• C.A server restart always resets the AUTO_INCREMENT value to largest value in the AUTO_INCREMENT column plus 1.
• D.AUTO_INCREMENT values allocated to a transaction that is rolled back are not reused.
• E.A table can have multiple AUTO_INCREMENT columns.

Examine this event's metadata:

Now examine this command:
DROP USER 'userl'e'localhost';
Which effect will the command have on the event?

• A.The event is scheduled but will no longer execute. The system will log an error.
• B.The event will be dropped without an error or warning.
• C.The event is not scheduled and will no longer execute. The system will log an error.
• D.The event is scheduled and executed but fails. The system will log an error.

Examine these statements:
SET collation_connection=utf8mb4_0900_as_cs;
SELECT STRCMPCAlice', UCASE ('Alice* )) ;
What is displayed?

• A.0
• B.-1
• C.NULL
• D.1
• E.ERROR: 1267 (HYOOO): Illegal mix of collations