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

Профиль

Бреиндампы

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

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

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

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

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

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

Oracle 1Z0-007: Introduction to Oracle9i: SQL

#61. Examine the structures of the EMPLOYEES and TAX tables.

TAX_PERCENT NUMBER Percentage tax for given salary range You need to find the percentage tax applicable for each employee. Which SQL statement would you use?

#62. Examine the data in the WORKORDER table.

The WORKORDER table contains these columns:

 WO_ID          NUMBER     PK 
 CUST_ID        NUMBER 
 REQUIRED_DT    DATE 
 COMPL_DT       DATE 
 AMOUNT         NUMBER(7,2)

Which statement regarding the use of aggregate functions on the WORKORDER table is true?

#63. The INVENTORY table contains these columns:

 ID_NUMBER          NUMBER        PK 
 CATEGORY           VARCHAR2(10) 
 LOCATION           NUMBER 
 DESCRIPTION        VARCHAR2(30) 
 PRICE              NUMBER(7,2) 
 QUANTITY           NUMBER

You want to return the total of the extended amounts for each item category and location, including only those inventory items that have a price greater than $100.00. The extended amount of each item equals the quantity multiplied by the price. Which SQL statement will return the desired result?

#64. The EVENT table contains these columns:

 EVENT_ID        NUMBER 
 EVENT_NAME      VARCHAR2(30) 
 EVENT_DESC      VARCHAR2(100) 
 EVENT_TYPE      NUMBER 
 LOCATION_ID     NUMBER

You have been asked to provide a report of the number of different event types at each location. Which SELECT statement will produce the desired result?

#65. Which two statements about the evaluation of clauses in a SELECT statement are true? (Choose two.)

#66. Examine the structures of the EMPLOYEE and DEPARTMENT tables:
EMPLOYEE

 EMP_ID         NUMBER               NOT NULL       PK 
 NAME           VARCHAR(30)          NOT NULL 
 FNAME          VARCHAR(25)          NOT NULL 
 DEPT_NO        NUMBER 
 TITLE          VARCHAR2(25)

DEPARTMENT

 DEPT_ID         NUMBER          NOT NULL     PK 
 DEPT_NAME       VARCHAR2(25)

You need to produce a list of departments, including the department names, that have more than three administrative assistants. Which SELECT statement will produce the desired result?

#67. Which two tasks can you perform by using the TO_CHAR function? (Choose two)

#68. Examine the data in the LINE_ITEM table.

You query the database and return the value 23. Which script did you use?

#69. Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?

#70. Examine the structure of the EMPLOYEES table:

What is the correct syntax for an inline view?

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

ген. 0.054

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

Oracle 1Z0-007