Oracle 1Z0-909 問題集

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

質問 2：
Examine this bar graph based on columns from the players table:

Which two statements would generate this bar graph?
A. SELECT Name, Gender, Sport, LENGTH (GPA*10, '# ') AS GPA_Graph FROM players ORDER BY GPA DESC;
B. SELECT Name, Gender, Sport, REPEAT('# 'Y GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;
C. SELECT Name, Gender, Sport, RPAD ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;
D. SELECT Name, Gender, Sport, CHAR_LENGTH ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;
E. SELECT Name, Gender, Sport, CONCAT ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;
正解：B,C

質問 3：
Examine these my.cnf settings:

Examine this entry from /data/slow.log

Which option is also set in my.cnf?
A. log_throttle_queries_not_using_indexes=100
B. log__slow_admin_statements=1
C. log_queries_not_using_indexes
D. log_queries_not_using_indexes=ON
正解：B

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

質問 5：
The continent column in the country table contains no null values.
Examine this output:

A)

B)

C)

D)

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

質問 6：
The employee table includes these columns:
e_id INT, e_name VARCHAR (45), dept_id INT salart INT
You must create a stored function, getMaxSalary(), which returns the maximum salary paid for a given department id.
Which statement will create the function?
A.

B.

C.

D.

正解：D