1Z0-007 試験問題を無料オンラインアクセス

You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created.
You want to look at the definition of the view (the SELECT statement on which the view was create.)
How do you obtain the definition of the view?

• A.Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
• B.Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.
• C.Use the DESCRIBE command in the EMP_DEPT VU view.
• D.Use the DESCRIBE VIEW command on the EMP_DEPT VU view.
• E.Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.
• F.Use the DEFINE VIEW command on the EMP_DEPT VU view.

STUDENT_ID NUMBER(12)
SEMESTER_END DATE
GPA NUMBER(4,3)
Which statement finds the highest grade point average (GPA) per semester?

• A.SELECT MAX(gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student_grades;
• B.SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL;
• C.SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL GROUP BY semester_end;
• D.SELECT MAX(gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;
• E.SELECT (gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;

Which syntax turns an existing constraint on?

• A.ALTER TABLE table_name
  ENABLE CONSTRAINT constraint_name;
• B.ALTER TABLE table_name
  TURN ON CONSTRAINT constraint_name;
• C.ALTER TABLE table_name
  TURN ON CONSTRAINT constraint_name;
• D.ALTER TABLE table_name
  STATUS = ENABLE CONSTRAINT constraint_name;
• E.ALTER TABLE table_name
  ENABLE constraint_name;
• F.ALTER TABLE table_name
  STATUS ENABLE CONSTRAINT constraint_name;

Examine the structures of the EMPLOYEES and TAX tables.

You need to find the percentage tax applicable for each employee. Which SQL statement would you use?

• A.SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary > t.min_salary, tax_percent
• B.SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary BETWEEN t.min_salary AND t.max_salary;
• C.You cannot find the information because there is no common column between the two tables.
• D.SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE MIN(e.salary) = t.min_salary AND MAX(e.salary) = t.max_salary

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 SORT ORDER BY gpa;
• B.SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;
• C.SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;
• D.SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;
• E.SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;
• F.SELECT student_id, gpa FROM student_grades ORDER BY gpa;