Online Access Free 1Z0-007 Exam Questions

The STUDENT_GRADES table has these columns
STUDENT_ID NUMBER(12)
SEMESTER_END DATE
GPA NUMBER(4,3)
Which statement finds students who have a grade point average (GPA) greater than 3.0 for the calendar year 2001?

• A.SELECT student_id, gpa
  FROM student_grades
  WHERE semester_end BETWEEN '01-JAN-2001' AND '31-DEC-2001'
  AND gpa gt 3.0;
• B.SELECT student_id, gpa
  FROM student_grades
  WHERE semester_end BETWEEN '01-JAN-2001' AND '31-DEC-2001'
  OR gpa > 3.;
• C.SELECT student_id, gpa
  FROM student_grades
  WHERE semester_end BETWEEN '01-JAN-2001' AND '31-DEC-2001'
  OR gpa > 3.0;
• D.SELECT student_id, gpa
  FROM student_grades
  WHERE semester_end BETWEEN '01-JAN-2001' AND '31-DEC-2001'
  AND gpa > 3.0;
• E.SELECT student_id, gpa
  FROM student_grades
  WHERE semester_end > '01-JAN-2001' OR semester_end < '31-DEC-2001' AND gpa >= 3.0;

Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?

• A.SELECT ename, salary*12 "Annual Salary" FROM employees;
• B.SELECT ename, salary*12 AS INITCAP("ANNUAL SALARY") FROM employees
• C.SELECT ename, salary*12 'Annual Salary' FROM employees;
• D.SELECT ename, salary*12 AS Annual Salary FROM employees;

Evaluate the SQL statement:
SELECT ROUND (TRUNC(MOD(1600,10),-1),2)
FROM dual;
What will be displayed?

• A.1
• B.An error statement
• C.0.00
• D.0

What is true about sequences?

• A.The start value of the sequence is always 1.
• B.A sequence always increments by 1.
• C.The minimum value of an ascending sequence defaults to 1.
• D.The maximum value of descending sequence defaults to 1.

Examine the data in the EMPLOYEES and DEPARTMENTS tables.

You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use?

• A.SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);
• B.SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e.department_id = d.department_id);
• C.SELECT last_name, department_name FROM employees JOIN departments (+);
• D.SELECT last_name, department_name FROM employees , departments(+);
• E.SELECT last_name, department_name FROM employees(+) , departments ON (e.department_id = d.department_id);
• F.SELECT last_name, department_name FROM employees(+) e JOIN departments d ON (e.department_id = d.department_id);