Oracle 1Z0-007 試験概要:

Oracle 1Z0-007 試験シラバストピック:

Oracle Introduction to Oracle9i: SQL 認定 1Z0-007 試験問題：

問題 #1
Which two are attributes of iSQL*Plus? (Choose two)

A. /SQL*Plus commands cannot be abbreviated.
B. /SQL*Plus commands manipulate table definitions in the database.
C. /SQL*Plus commands are used to manipulate data in tables.
D. /SQL*Plus commands are accessed from a browser.
E. /SQL*Plus is the Oracle proprietary interface for executing SQL statements.

問題 #2
You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others.
Which statement accomplishes this?

A. GRANT select, insert, update ON student_grades TO manager;
B. GRANT select, insert, update ON student_grades TO ROLE manager WITH GRANT OPTION;
C. GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;
D. GRANT select, insert, modify ON student_grades TO ROLE manager WITH GRANT OPTION;
E. GRANT select, insert, update ON student_grades TO ROLE manager;
F. GRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;

問題 #3
Evaluate the SQL statement:
SELECT ROUND(45.953, -1), TRUNC(45.936, 2)
FROM dual;
Which values are displayed?

A. 50 and 45.9
B. 46 and 45
C. 45.95 and 45.93
D. 50 and 45.93
E. 45 and 45.93
F. 46 and 45.93

問題 #4
Which three are true regarding the use of outer joins? (Choose three.)

A. You cannot link a condition that is involved in an outerjoin to another condition by using the OR operator.
B. You use (*) on both sides of the WHERE condition to perform an outerjoin.
C. In the WHERE condition, you use (+) following the name of the column in the table without matching rows, to perform an outerjoin.
D. You cannot use IN operator in a condition that involves an outerjoin.
E. You use (+) on both sides of the WHERE condition to perform an outerjoin.
F. You use an outerjoin to see only the rows that do not meet the join condition.

問題 #5
Which two are character manipulation functions? (Choose two.)

A. TRIM
B. CASE
C. MOD
D. TRUNC
E. REPLACE
F. TO_DATE

解説：