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

Профиль

Бреиндампы

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

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

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

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

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

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

Oracle 1Z0-007: Introduction to Oracle9i: SQL

#41. Management has asked you to calculate the value 12*salary* comossion_pct for all the employees in the EMP table. The EMP table contains these columns:

Which statement ensures that a value is displayed in the calculated columns for all employees?

#42. Examine the description of the STUDENTS table:

Which two aggregate functions are valid on the START_DATE column? (Choose two)

#43. The EMPLOYEE tables has these columns:

You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column. Which SQL statement displays the desired results?

#44. You would like to display the system date in the format "Monday, 01 June, 2001". Which SELECT statement should you use?

#45. Evaluate the SQL statement:

 SELECT ROUND(TRUNC(MOD(1600,10),-1),2) 
 FROM dual;

What will be displayed?

#46. Examine the description of the MARKS table:

SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects. Examine this SELECT statement based on the MARKS table:

 SELECT subj1+subj2 total_marks, std_id 
 FROM marks 
 WHERE subj1 > AVG(subj1) AND subj2 > AVG(subj2) 
 ORDER BY total marks;

What is the result of the SELECT statement?

#47. Which three SELECT statements display 2000 in the format “$2,000.00”? (Choose three)

#48. Examine the description of the EMPLOYEES table:

Which statement shows the department ID, minimum salary, and maximum salary paid in that department, only of the minimum salary is less then 5000 and the maximum salary is more than 15000?

#49. Which two are true about aggregate functions? (Choose two.)

#50. Which four statements correctly describe functions that are available in SQL? (Choose four)

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

ген. 0.072

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

Oracle 1Z0-007