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

Профиль

Бреиндампы

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

Форумы

Продавец

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

#101. Which constraint can be defines only at the column level?

#102. What is true about the WITH GRANT OPTION clause?

#103. Which substitution variable would you use if you want to reuse the variable without prompting the user each time?

#104. The EMPLOYEES table has these columns:

 LAST NAME      VARCHAR2(35) 
 SALARY         NUMBER(8,2) 
 HIRE_DATE      DATE

Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement:

 ALTER TABLE EMPLOYEES 
 MODIFY (SALARY DEFAULT 5000);

What is true about your ALTER statement?

#105. The DBA issues this SQL command:

 CREATE USER scott 
 IDENTIFIES BY tiger;

What privileges does the user Scott have at this point?

#106. Which two statements complete a transaction? (Choose two)

#107. You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns:

 CUST_ID         NUMBER(4)         NOT NULL 
 CUST_NAME       VARCHAR2(100) 
 CUST_ADDRESS    VARCHAR2(150) 
 CUST_PHONE      VARCHAR2(20)

Which SELECT statement accomplishes this task?

#108. Which statement describes the ROWID data type?

#109. Evaluate the SQL statement

 DROP TABLE DEPT:

Which four statements are true of the SQL statement? (Choose four)

#110. You are granted the CREATE VIEW privilege. What does this allow you to do?

[1] ... [11] [12] [13] [14] [15] [16] [17] [18] [19] [20] [21] ... [85]

ген. 0.084

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

Oracle 1Z0-035

Форум

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

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