1Z0-007 Oracle - Braindumps.com.ua: список вопросов для "Introduction to Oracle9i: SQL", страница: 11

Профиль

Бреиндампы

Получить последний дамп

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

Логин:
Пароль:
запомнить меня:

Контакты
Сайты по тематике
Cсылки

Авторизированые пользователи могут видеть ответы к вопросам.
Пожалуйста, авторизируйтесь или зарегистрируйтесь.

Список вопросов к экзамену:
Показать все комментарии

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]

ген. 0.087

Дата сервера 09:20 09-01-2009

Oracle 1Z0-007