全世界で最大の認証試験授権センターの1つのPrometricは観察から分かって、だんだん多くなる企業が関連していて試験認証を設計する時に、理論基礎だけを重視しないで、更に実際の応用を重視します。ここ数年国際認証試験の成り行きを観察して、だんだん多くなるの企業は認証を人材のふるい分ける標準の1つとして、たくさんの国際証明はひとまとまりの完備している知識体系を発展します、試験の方向も前の理論の試験方式を重視することを実践の試験方式を重視することになります。
TestPassPort 実践試験の 9i DBA 1Z0-007 は最も標準的な技術を正確的に書き入れ、認証した専門家と作者の出版した新製品だけを使います.
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