Instantly download 1Z0-007 training test engine

Oracle 1Z0-007 Exam Overview:

Oracle 1Z0-007 Exam Syllabus Topics:

Oracle Introduction to Oracle9i: SQL Sample Questions:

Question 1

Which three SELECT statements displays 2000 in the format "$2,000.00"? (Choose three)

A. SELECT TO CHAR (2000, '$N,NNN.NN') FROM dual;
B. SELECT TO CHAR (2000, '$2,000.00') FROM dual;
C. SELECT TO CHAR (2000, '$0,000.00') FROM dual;
D. SELECT TO CHAR (2000, '$9,999.00') FROM dual;
E. SELECT TO CHAR (2000, '$9,999.99') FROM dual;
F. SELECT TO CHAR (2000,'$#,###.##') FROM dual;

Question 2

When should you create a role? (Choose two)

A. To simplify the process of creating new users using the CREATE USER xxx IDENTIFIED by yyy statement.
B. To grant a group of related privileges to a user.
C. When the number of people using the database is very high.
D. To simplify profile maintenance for a user who is constantly traveling.
E. To simplify the process of granting and revoking privileges.

Question 3

Examine the data of the EMPLOYEES table.
EMPLOYEES (EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID)

Which statement lists the ID, name, and salary of the employee, and the ID and name of the employee's manager, for all the employees who have a manager and earn more than 4000?

A. salary,
B. employee_id "Mgr_id", m.emp_name "Manager"
FROM employees e, employees m
WHERE e.mgr_id = m.employee_id
AND e.salary > 4000;
C. SELECT e.employee_id "Emp_id", e.emp_name "Employee",
D. salary,
E. salary,
F. mgr_id "Mgr_id", m.emp_name "Manager"
FROM employees e, employees m
WHERE e.employee_id = m.employee_id
AND e.salary > 4000;
G. SELECT e.employee_id "Emp_id", e.emp_name "Employee",
H. SELECT employee_id "Emp_id", emp_name "Employee",
salary,
employee_id "Mgr_id", emp_name "Manager"
FROM employees
WHERE salary > 4000;
I. mgr_id "Mgr_id", m.emp_name "manager"
FROM employees e, employees m
WHERE e.mgr_id = m.employee_id
AND e.salary > 4000;
J. SELECT e.employee_id "Emp_id", e.emp_name "Employee",
K. SELECT e.employee_id "Emp_id", e.emp_name "Employee",
L. salary,
M. employee_id "Mgr_id", m.emp_name "Manager"
FROM employees e, employees m
WHERE e.mgr_id = m.mgr_id
AND e.salary > 4000;

Question 4

The EMPLOYEES table contains these columns:
EMPLOYEE_ID NUMBER(4)
LAST_NAME VARCHAR2 (25)
JOB_ID VARCHAR2(10)
You want to search for strings that contain 'SA_' in the JOB_ID column. Which SQL statement do you use?

A. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_' ESCAPE "\";
B. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_';
C. SELECT employee_id, last_name, job_id FROM employees WHERE job_id = '%SA_';
D. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA\_%' ESCAPE '\';

Question 5

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

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

Solutions: