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

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2461)

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

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

#22. You need to display the last names of those employees who have the letter “A” as the second character in their names.
Which SQL statement displays the required results?

#23. In which scenario would TOP N analysis be the best solution?

#24. Evaluate this SQL statement:

 SELECT c.customer_id, o.order_id, o.order_date, p.product_name 
 FROM customer c, curr_order o, product p 
 WHERE customer.customer_id = curr_order.customer_id 
 AND o.product_id = p.product_id 
 ORDER BY o.order_amount;

This statement fails when executed. Which change will correct the problem?

#25. You want to display the titles of books that meet these criteria:
1. Purchased before January 21, 2001
2. Price is less then $500 or greater than $900
You want to sort the results by their data of purchase, starting with the most recently bought book.
Which statement should you use?

#26. For which task would you use the WHERE clause in a SELECT statement?

#27. The STUDENT_GRADES table has these columns:

 STUDENT_ID        NUMBER(12) 
 SEMESTER_END      DATE 
 GPA               NUMBER(4,3)

The registrar has requested a report listing the students' grade point averages (GPA), sorted from highest grade point average to lowest within each semester, starting from the earliest date. Which statement accomplishes this?

#28. The ORDERS table has these columns:

The ORDERS table tracks the Order nnmher, the order total, and the customer to whom the Order belongs. Which two statements retrieve orders with an inclusive total that ranges between 100.00 and 2000.00 dollars? (Choose two.)

#29. Examine the structure of the PRODUCT table.

You want to display all product identification numbers of products for which there are 500 or more available for immediate sale. You want the product numbers displayed alphabetically by supplier, then by product number from lowest to highest. Which statement should you use to achieve the required results?

#30. Examine the data in TEACHER table.

Which query should you use to return the following values from the TEACHER table?
Name Subject
Jones, Karen HST_REVOL
Hopewell, Mary Elizabeth HST_RELIG

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

gen. 0.061

Server date 07:02 22-11-2008

Oracle 1Z0-007

Forum

Start online exam simulation

Master braindump

User braindumps