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

Профиль

Бреиндампы

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

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

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

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

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

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

Oracle 1Z0-007: Introduction to Oracle9i: SQL

#81. The EMP table has these columns:

 ENAME          VARCHAR2(35) 
 SALARY         NUMBER(8,2) 
 HIRE_DATE      DATE

Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results?

#82. Which SELECT statement will the result ‘ello world’ from the string ‘Hello World’?

#83. Evaluate the SQL statement:

 SELECT ROUND(45.953, -1), TRUNC(45.936, 2) 
 FROM dual;

Which values are displayed?

#84. The CUSTOMERS table has these columns:

 CUSTOMER_ID        NUMBER (4)            NOT NULL 
 CUSTOMER_NAME      VARCHAR2 (100)        NOT NULL 
 STREET_ADDRESS     VARCHAR2 (150) 
 CITY_ADDRESS       VARHCAR2 (50) 
 STATE_ADDRESS      VARCHAR2 (50) 
 PROVINCE_ADDRESS   VARCHAR2 (50) 
 COUNTRY_ADDRESS    VARCHAR2 (50) 
 POSTAL_CODE        VARCHAR2 (12) 
 CUSTOMER_PHONE     VARCHAR2 (20)

The CUSTOMER_ID column is the primary key for the table. You need to determine how dispersed your customer base is. Which expression finds the number of different countries represented in the CUSTOMERS table?

#85. You want to use single row function in your SQL statements which three of the following are number functions? (Choose three).

#86. You are using single row function in a SELECT statement which function can best be catergorized as similar in function to an IF-THEN-ELSE statement?

#87. Which of the following functions are available in SQL? (Choose four)

#88. Examine the structure of the EMPLOYEES and DEPARTMENTS tables:

Evaluate this SQL statement:

 SELECT employee_id, e.department_id, department_name, 
 salary 
 FROM employees e, departments d 
 WHERE e.department_id = d.department_id;

Which SQL statement is equivalent to the above SQL statement?

#89. Examine the data in the EMPLOYEES and DEPARTMENTS tables.

You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use?

#90. In which case would you use a FULL OUTER JOIN?

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

ген. 0.063

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

Oracle 1Z0-007