Oracle 1Z0-909 問題集

質問 1：
Examine the employee table structure:

Which set of statements immediately returns empname for a given emp_id by using a parameterized prepare statement?
A)



D)

A. Option A
B. Option C
C. Option D
D. Option B
正解：C

質問 2：
Examine these commands and output:


Which is true about the execution of the insert statement?
A. It inserts a new row in the base table only.
B. It returns an error.
C. It inserts a new row in the view only.
D. It inserts a row in the view and base table.
正解：C

質問 3：
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

質問 4：
Examine this statement and output:

Which is true?
A. Column Name in myview can be indexed if the is_updatable attribute is true.
B. The underlying table's index on the Name column is not chosen because of low selectivity.
C. myview was defined with the temptable processing algorithm.
D. myview cannot be automatically indexed.
正解：C

質問 5：
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

質問 6：
Which two are true about indexes?
A. Indexing all of a table's columns improves performance.
B. Secondary index access will always be faster than a table scan.
C. Indexes are used to enforce unique constraints.
D. Indexes contain rows sorted by key values.
E. Indexes reduce disk space used.
正解：A,E