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

Профиль

Бреиндампы

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

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

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

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

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

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

Oracle 1Z0-007: Introduction to Oracle9i: SQL

#71. Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater then 5000?

#72. You need to calculate the total of all salaries in the accounting department. Which group function should you use?

#73. Which SELECT statement will the result ‘elloworld’ from the string ‘HelloWorld’?

#74. Evaluate this SQL statement:

 SELECT e.employee_id, (.15* e.salary) + (.5 * e.commission_pct) 
 + (s.sales amount * (.35 * e.bonus)) AS CALC_VALUE 
 FROM employees e, sales s 
 WHERE e.employee_id = s.emp_id;

What will happen if you remove all the parentheses from the calculation?

#75. Which script displays '01-JAN-02' when the ENROLL_DATE value is '01-JUL-01'?

#76. Which three functions can be used to manipulate character, number, or date column values? (Choose three.)

#77. A new standard has been adopted in your department that all codes that contain only 3 characters must have a dash (-) and two character values appended to them. Which function can be used in your query to restrict the data displayed to only those codes containing 3 characters?

#78. Which statement concerning SQL functions is true?

#79. The STUDENT_GRADES table has these columns:

 STUDENT_ID       NUMBER(12) 
 SEMESTER_END     DATE 
 GPA              NUMBER(4,3)

The registrar has asked for a report on the average grade point average (GPA) for students enrolled during semesters that end in the year 2000. Which statement accomplish this?

#80. Evaluate the SQL statement:

 1 SELECT a.emp_name, a.sal, a.dept_id, b.maxsal 
 2 FROM employees a, 
 3 (SELECT dept_id, MAX(sal) maxsal 
 4. FROM employees 
 5 GROUP BY dept_id) b 
 6 WHERE a.dept_id = b.dept_id 
 7 AND a.sal < b.maxsal;

What is the result of the statement?

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

ген. 0.08

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

Oracle 1Z0-007