Oracle 1Z0-909 問題集

質問 1：
Examine these statements:
SET collation_connection=utf8mb4_0900_as_cs;
SELECT STRCMPCAlice', UCASE ('Alice* )) ;
What is displayed?
A. 0
B. NULL
C. ERROR: 1267 (HYOOO): Illegal mix of collations
D. 1
E. -1
正解：E

質問 2：
You must reclaim memory used by a prepared statement named prep. Which two achieve this?
A. DROP PREPARE prep;
B. DEALLOCATE PREPARE prep?
C. DROP PROCEDURE prep;
D. SET @a = ''; EXECUTE prep USING @a;
E. PREPARE prep FROM '';
F. SET @prep = NULL;
正解：C,F

質問 3：
Examine this statement:
DECLARE not_found CONDITION FOR SQLSTATE '02000';
In which two statements can not found be used?
A. in a leave statement to exit a loop
B. in an if statement
C. in a handler declaration
D. in a while loop
E. in a signal statement
正解：D,E

質問 4：
Examine the structure of the emp table:

Examine the structure of the emp_vu1 view based on the emp table:

Now, examine this statement:
mysq1> INSERT INTO emp_vul VALUES ('Alice',20000) ;
What is true about executing the statement?
A. It inserts a row in the emp table.
B. It inserts a row in the view only.
C. It returns an error because an insert operation is not allowed on views.
D. It returns an error because the PRIMARY ACCOUNT column is not selected for the view definition.
正解：A

質問 5：
Your session has sqi_mode set to default.
Examine this statement which executes successfully:

Now examine this statement:

Which two changes are required to the insert statement so that it inserts the correct data?
* std_id = 10301
* firstname = Mary
* lastname = O'Hagen
* birthdate = November 26, 1997
* reg_date = the current date
A. Change date () to CURRENT_TIMESTAMP () .
B. Change "O'Hagen" to "O\'Hagen".
C. Change " NULL " to ' NULL ' .
D. Change " NULL " to NULL.
E. Change DATE () to DAY ().
F. Change "O'Hagen" to 'o\'Hagen'.
正解：D,E

質問 6：
Examine these statements and output:

Now, examine this command:
Mysql> ROLLBACK;
What is true about the effect of the command?
A. It returns an error because there is no active transaction.
B. It has no effect.
C. It undoes the insert command.
D. It undoes the update command.
E. It undoes both insert and update commands.
正解：C