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

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

#101. Examine the data from the ORDERS and CUSTOMERS tables.

Evaluate the SQL statement:

 SELECT * 
 FROM orders 
 WHERE cust_id = (SELECT cust_id 
 FROM customers 
 WHERE cust_name = 'Smith');

What is the result when the query is executed?

#102. Evaluate this SQL statement:

 SELECT product_id, product_name, price 
 FROM product 
 WHERE supplier_id IN 
 (SELECT supplier_id 
 FROM product 
 WHERE price > 120 
 OR qty_in_stock > 100);

Which values will be displayed?

#103. Which statement regarding subqueries is true?

#104. Evaluate this SELECT statement:

 SELECT employee_id, name 
 FROM employee 
 WHERE employee_id NOT IN (SELECT employee_id 
 FROM employee 
 WHERE department_id = 30 
 AND job = 'CLERK');

What would happen if the inner query returned a NULL value?

#105. Examine the data from the DONATION table (PLEDGE_ID is the primary key).

This statement fails when executed:

 SELECT amount_pledged, amount_paid 
 FROM donation 
 WHERE donor_id = 
 (SELECT donor_id 
 FROM donation 
 WHERE amount_pledged = 1000.00 
 OR pledge_dt = '05-JAN-2002');

Which two changes could correct the problem? (Choose two.)

#106. A subquery can be used to _________.

#107. Which three statements about subqueries are true? (Choose three)

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

#109. Which operator can be used with a multiple-row subquery?

#110. Which two statements about subqueries are true? (Choose two.)

[1] ... [11] [12] [13] [14] [15] [16] [17] [18] [19] [20] [21] ... [31]

gen. 0.093

Server date 07:06 22-11-2008

Oracle 1Z0-007

Forum

Start online exam simulation

Master braindump

User braindumps