1Z0-007 Oracle - Braindumps.com.ua: question list for "Introduction to Oracle9i: SQL", page: 1

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2460)

Network Appliance (2)

Authorization

Login:
Password:
remember me:

Contacts
Certification links
Links

Authorized user can see question and answers.
Please log in or sign up.

Exam question list:
Show all comments

Oracle 1Z0-007: Introduction to Oracle9i: SQL

#1. Which SELECT statement should you use if you want to display unique combinations of the POSITION and MANAGER values from the EMPLOYEE table?

#2. Which two are attributes of iSQL*Plus? (Choose two)

#3. 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?

#4. Which is an /SQL*Plus command?

#5. You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns:

Which SELECT statement accomplishes this task?

#6. Evaluate this SQL statement:

 SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME. 
 FROM EMP e, DEPARTMENT d 
 WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID;

In the statement, which capabilities of a SELECT statement are performed?

#7. Which two statements are true regarding the ORDER BY clause? (Choose two)

#8. From SQL*Plus, you issue this SELECT statement:

 SELECT* FROM orders;

You use this statement to retrieve data from a data table for __________. (Choose all that apply)

#9. Evaluate this SQL*Plus command:
START delaccount
Which task will this command accomplish?

#10. Which SQL SELECT statement performs a projection, a selection, and join when executed?

[1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] ... [31]

gen. -0.874

Server date 01:57 06-09-2008

Oracle 1Z0-007

Forum

Start online exam simulation

Master braindump

User braindumps