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

Профиль

Бреиндампы

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

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2461)

Network Appliance (2)

Авторизация

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

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

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

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

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]

ген. 0.095

Дата сервера 14:03 20-11-2008

Oracle 1Z0-007