1Z0-035 Oracle - Braindumps.com.ua: список вопросов для "Oracle 7.3 & 8 to Oracle9i DBA OCP Upgrade", страница: 10

Профиль

Бреиндампы

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

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

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

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

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

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

Oracle 1Z0-035: Oracle 7.3 & 8 to Oracle9i DBA OCP Upgrade

#91. Which clause should you use to exclude group results?

#92. A subquery can be used to _________.

#93. The EMPLOYEES table contains these columns:

 LAST_NAME         VARCHAR2 (25) 
 SALARY            NUMBER (6,2) 
 COMMISSION_PCT    NUMBER (6)

You need to write a query that will produce these results:
1. Display the salary multiplied by the commission_pct.
2. Exclude employees with a zero commission_pct.
3. Display a zero for employees with a null commission value. Evaluate the SQL statement:

 SELECT LAST_NAME, SALARY*COMMISSION_PCT 
 FROM EMPLOYEES 
 WHERE COMMISSION_PCT IS NOT NULL;

What does the statement provide?

#94. Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"?

#95. Which is an /SQL*Plus command?

#96. What does the TRUNCATE statement do?

#97. You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 2000 bytes. The column can currently hold 1000 bytes per value. The table contains 20000 rows.
Which statement is valid?

#98. Which statement creates a new user?

#99. Which three are true regarding the use of outer joins? (Choose three.)

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

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

ген. 0.141

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

Oracle 1Z0-035

Форум

Начать тестирование

Главный бреиндамп