Oracle Certification

9i DBA 1z0-007 考試題庫由我們的資深IT認證講師及產品專家精心打造，包括了當前最新的全套全真1z0-007考試試題，全部附有正確答案。所有購買本站認證考題的客戶都將得到60天的免費升級服務，保證了對Introduction to Oracle9i: SQL考試題庫的完整覆蓋。 助妳壹次通過 Introduction to Oracle9i: SQL 認證考試，壹次不過全額退款！

1z0-007考題都是1z0-007證照考試試題原題，對正式考試覆蓋率達96％以上，答案由多位專業資深講師原版破解得出，正確率100％，只要您使用本站的題庫參加 Introduction to Oracle9i: SQL 證照考試，我們保證您壹次輕松通過考試；
 

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