|
|
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?
|
|
|
|
 gen. 0.079
|
Server date 13:54 15-03-2010
|
Developed by Zip © 2006
|
|
|
|
|
1Z0-007 certification
1Z0-007 master dump