Oracle 1Z0-909 問題集

質問 1：
The meeting table stores meeting schedules with participants from five continents. The participants' details are stored in another table.

You need to adjust the start_time and duration columns for optimal storage. What datatype changes would achieve this?
A. start_time DATETIME duration DATETIME
B. start__time DATETIME duration TIME
C. start_time TIME duration TIME
D. start_time TIMESTAMP duration TIME
E. start_time TIMESTAMP duration TIMESTAMP
正解：A

質問 2：
Examine this statement which executes successfully:
SET @ir := 2;
Which query updates the value of @r to 0?
A. SELECT 'Car' REGEXP('Ca?') >= 0 INTO @r;
B. SELECT 'Car' LIKE 'Ca?' INTO @r;
C. SELECT STRCMP('Car'/Ca?') >= 0 INTO @r;
D. SELECT 'Car' RLIKE 'Ca?' INTO @r;
正解：D

質問 3：
Examine the contents of these tables:

Now examine the expected results for a user with privileges to access the table:

Which query returns the expected results?
A)

B)

C)

D)

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

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

質問 5：
Examine this statement and output:

Now, examine these desired output values:

Which statement updates the table data as require
A. UPDATE exam_result SET score=CEIL(TRUNCATE(sco
B. UPDATE exam_result SET score=TRUNCATE(score,1);
C. UPDATE exam_result SET score=CEIL(ROUND(score,1));
D. UPDATE examresult SET score=ROUND(CEIL(score
E. UPDATE exam_result SET score=TRUNCATE
F. UPDATE exam_result SET score=ROUND(score,1);
正解：F

質問 6：
Examine the output:

Which explain command will obtain the output?
A. EXPLAIN PORMAT^TRADITIONAL
B. EXPLAIN FORMAT=TREE
C. EXPLAIN ANALYZE
D. EXPLAIN PORMAT=JSON
E. EXPLAIN PARTITIONS
正解：D