Introduction to Oracle9i: SQL: 1Z0-007 Exam Premium File as PDF & Test Engine

Why wait to start studying? The moment your order is complete, your 1Z0-007 practice questions land in your inbox within one minute. That is 110 Oracle Introduction to Oracle9i: SQL questions, ready when you are.

Oracle 1Z0-007 Exam Overview:

Oracle 1Z0-007 Exam Syllabus Topics:

Oracle Introduction to Oracle9i: SQL Exam FAQs and Straight Answers

Oracle Introduction to Oracle9i: SQL Sample Questions:

Question 1

The CUSTOMERS table has these columns:
CUSTOMER_ID NUMBER(4) NOT NULL
CUSTOMER_NAME VARCHAR2(100) NOT NULL
CUSTOMER_ADDRESS VARCHAR2(150)
CUSTOMER_PHONE VARCHAR2(20)
You need to produce output that states "Dear Customer customer_name, ".
The customer_name data values come from the CUSTOMER_NAME column in the CUSTOMERS table.
Which statement produces this output?

A. SELECT "Dear Customer", customer_name || ',' FROM customers;
B. SELECT 'Dear Customer ' || customer_name ',' FROM customers;
C. SELECT 'Dear Customer ' || customer_name || ',' || FROM customers;
D. SELECT "Dear Customer " || customer_name || "," FROM customers;
E. SELECT dear customer, customer_name, FROM customers;
F. SELECT 'Dear Customer ' || customer_name || ',' FROM customers;

Question 2

What does the TRUNCATE statement do?

A. Removes foreign keys from a table
B. Shortens the table to 10 rows
C. Removes all rows from a table
D. Removes the table
E. Removes all columns from a table

Question 3

Exhibit

The COMMISSION column shows the monthly commission earned by the employee.
Which two tasks would require subqueries or joins in order to be performed in a single step? (Choose two.)

A. listing the employees who earn the same amount of commission as employee 3
B. finding the number of employees who earn a commission that is higher than the average commission of the company
C. finding the total commission earned by the employees in department 10
D. listing the employees who do not earn commission and who are working for department 20 in descending order of the employee ID
E. listing the departments whose average commission is more that 600
F. listing the employees whose annual commission is more than 6000

Question 4

You define a multiple-row subquery in the WHERE clause of an SQL query with a comparison operator "=".
What happens when the main query is executed?

A. The main query executes with the last value returned by the subquery.
B. The main query executes with the first value returned by the subquery.
C. The main query executes with all the values returned by the subquery.
D. You cannot define a multiple-row subquery in the WHERE clause of a SQL query.
E. The main query fails because the multiple-row subquery cannot be used with the comparison operator.

Question 5

Scott issues the SQL statements:

If Sue needs to select from Scott's DEPT table, which command should she use?

A. SELECT *
FROM SCOTT.DEPT;
B. SELECT *
FROM DEPT;
C. SELECT *
FROM ALL_USERS
WHERE USER_NAME = 'SCOTT'
AND TABLE NAME = 'DEPT';
D. SELECT *
FROM DBA.SCOTT.DEPT;

Solutions: