9i DBA 1z0-007考試題庫由KillTest認證題庫網資深IT認證講師和9i DBA產品專家結合PROMETRIC或VUE的真實1z0-007考試環境最新原題傾心打造。題庫覆蓋了當前最新的真實考題，並且全部附有正確答案，我們承諾題庫對9i DBA 1z0-007(Introduction to Oracle9i: SQL)考試原題完整覆蓋。1z0-007題庫助您輕鬆通過認證考試，一次不過全額退款。

9i DBA 1z0-007(Introduction to Oracle9i: SQL)考題由我們的資深IT認證講師和9i DBA產品專家精心打造，包括了當前最新的真實1z0-007考題，全部附有正確答案。所有購買KillTest 1z0-007 題庫的客戶都將得到60天的免費升級服務，保證了客戶的一次通過率。KillTest IT認證題庫網助您一次通過9i DBA 1z0-007考試。Introduction to Oracle9i: SQL(1z0-007 Exam)屬於9i DBA認證考試中的一門，如果需要取得9i DBA證書，您可能還需要參加其他相關考試，詳情可訪問9i DBA認證專題，在那裡，你將看到所有9i DBA認證相關考試科目。

1. What does the FORCE option for creating a view do?
A.creates a view with constraints
B.creates a view even if the underlying parent table has constraints
C.creates a view in another schema even if you don't have privileges
D.creates a view regardless of whether or not the base tables exist
Answer: D

2. What are two reasons to create synonyms? (Choose two.)
A.You have too many tables.
B.Your tables are too long.
C.Your tables have difficult names.
D.You want to work on your own tables.
E.You want to use another schema's tables.
F.You have too many columns in your tables.
Answer: CE

3. The STUDENT_GRADES table has these columns:
STUDENT_ID NUMBER(12)
SEMESTER_END DATE
GPA NUMBER(4,3)
The registrar requested a report listing the students' grade point averages (GPA) sorted from highest grade point average to lowest.
Which statement produces a report  that  displays  the student ID and GPA in the   sorted order  requested by the registrar?
A.SELECT student_id, gpa
FROM student_grades
ORDER BY gpa ASC;
B.SELECT student_id, gpa
FROM student_grades
SORT ORDER BY gpa ASC;
C.SELECT student_id, gpa
FROM student_grades
SORT ORDER BY gpa;
D.SELECT student_id, gpa
FROM student_grades
ORDER BY gpa;
E.SELECT student_id, gpa
FROM student_grades
SORT ORDER BY gpa DESC;
F.SELECT student_id, gpa
FROM student_grades
ORDER BY gpa DESC;
Answer: F