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
質問と回答：
| 質問 # 1 正解： C、E | 質問 # 2 正解： C | 質問 # 3 正解： D | 質問 # 4 正解： A、C、F | 質問 # 5 正解： A、E |
1088 お客様のコメント
品質保証JPexamはIT認定試験のシラバスに従って、試験問題の範囲を正確に絞って、的中率が99％の最新問題集を捧げます。
1年間の無料更新サービスJPexamは1年以内に問題集の無料更新サービスを提供し、お客様がいつでも最新版の問題集を持つことを保証いたします。もし試験の内容が変更されたら、弊社は直ちにお客様にお知らせします。それに、弊社の問題集が更新されたら、早速メールで最新バージョンを送付いたします。
全額返金JPexamの問題集を利用すると、短時間で勉強しても試験に合格できるのを保証いたします。試験に不合格になってしまった場合、弊社は全額返金いたします。(
ご購入前のお試しJPexamは問題集のサンプルを無料で提供いたします。ご購入前にサンプルを試用して製品の品質を確認することができます。ご遠慮なく利用してください。
