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

Профиль

Бреиндампы

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

Форумы

Продавец

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

#61. The CUSTOMERS table has these columns:

 CUSTOMER_ID         NUMBER(4)     NOT NULL 
 CUSTOMER_NAME       VARCHAR2(100) NOT NULL 
 STREET_ADDRESS      VARCHAR2(150) 
 CITY_ADDRESS        VARCHAR2(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. Which two statements find the number of customers? (Choose two.)

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

#63. Which two statements are true regarding the ORDER BY clause? (Choose two)

#64. 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?

#65. Which are DML statements? (Choose all that apply)

#66. Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She granted SELECT privilege to Scott on this view. Which option enables Scott to eliminate the need to qualify the view with the name MARY .EMP_DEP_LOC_VU each time the view is referenced?

#67. Examine the structure of the EMPLOYEES table:

 EMPLOYEE_ID   NUMBER Primary Key 
 FIRST_NAME    VARCHAR2(25) 
 LAST_NAME     VARCHAR2(25) 
 HIRE_DATE     DATE

You issue these statements:

 CREATE TABLE new_emp ( employee_id NUMBER, name VARCHAR2(30)); 
 INSERT INTO new_emp SELECT employee_id , last_name FROM employees; 
 SAVEPOINT s1; 
 UPDATE new_emp SET name = UPPER(name); 
 SAVEPOINT s2; 
 DELETE FROM new_emp; 
 ROLLBACK TO s2; 
 DELETE FROM new_emp WHERE employee_id =180; 
 UPDATE new_emp SET name = 'James'; 
 ROLLBACK TO s2; 
 UPDATE new_emp SET name = 'James' WHERE employee_id =180; 
 ROLLBACK;

At the end of this transaction, what is true?

#68. Which two are attributes of /SQL*Plus? (Choose two)

#69. In which scenario would index be most useful?

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

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

ген. 0.087

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

Oracle 1Z0-035

Форум

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

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