1z0-001 Oracle - Braindumps.com.ua: список вопросов для "Ineroduction to oracle:sql and pl/sql", страница: 7

Профиль

Бреиндампы

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

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

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

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

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

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

Oracle 1z0-001: Ineroduction to oracle:sql and pl/sql

#61. Which data dictionary view contains the definition of a view?

#62. Click on the EXHIBIT button and examine the employee table.

You create a view with this command:

 CREATE VIEW dept_salary_vu 
 AS SELECT dept_no, salary, last_name 
 FROM employee 
 WHERE salary> 45000 
 WITH CHECK OPTION;

For which employee can you update the dept_no column?

#63. Click on the EXHIBIT button and examine the table instance chart for the patient table.

You created the patient_vu view based on id_number and last_name from the patient table.
What is the best way to modify the view to contain only those patients born in 1997?

#64. In the declarative section of a PL/SQL block, you created but did not initialize a number variable. When the block executes, what will be the initial value of the variable?

#65. Which SELECT statement displays all the employees who do not have any subordinates?

#66. Which statement about using a subquery in the FROM clause is true?

#67. Which SELECT statement displays the order id, product id, and quantity of items in the ITEM table that match both the product id and quantity of an item in order 605? (Do not display the details for order 605.)

#68. You attempt to query the database with this command:

 SELECT dept_no, AVG(MONTHS_BETWEEN(SYSDATE, hire_date)) 
 FROM employee 
 WHERE AVG(MONTHS_BETWEEN(SYSDATE, hire_date)) > 60 
 GROUP BY dept_no 
 ORDER BY AVG(MONTHS_BETWEEN(SYSDATE, hire_date));

Why does this statement cause an error?

#69. In which order does the Oracle Server evaluate clauses?

#70. Which statement describes the use of a group function?

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

ген. 0.064

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

Oracle 1z0-001