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

Профиль

Бреиндампы

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

Форумы

Продавец

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

#71. Examine the structure of the EMPLOYEES table:

 EMPLOYEE_ID      NUMBER Primary Key 
 FIRST_NAME       VARCHAR2(25) 
 LAST_NAME        VARCHAR2(25) 
 DEPARTMENT_ID    NUMBER 
 SALARY           NUMBER

What is the correct syntax for an inline view?

#72. Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater then 5000?

#73. When should you create a role? (Choose two)

#74. Which three statements about subqueries are true? (Choose three)

#75. Examine the structure of the EMPLOYEES table:

 EMPLOYEE_ID      NUMBER NOT NULL 
 EMP_NAME         VARCHAR2(30) 
 JOB_ID           VARCHAR2(20) DEFAULT 'SA_REP' 
 SAL              NUMBER 
 COMM_PCT         NUMBER 
 MGR_ID           NUMBER 
 DEPARTMENT_ID    NUMBER

You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below:
JOB_ID: Default value specified for this column definition.
SAL: Maximum salary earned for the job ID SA_REP.
COMM_PCT: Default value specified for this commission percentage column, if any.
If no default value is specified for the column, the value should be NULL.
DEPARTMENT_ID: Supplied by the user during run time through substitution variable.
Which UPDATE statement meets the requirements?

#76. Which two statements about sequences are true? (Choose two)

#77. Which four are correct guidelines for naming database tables? (Choose four)

#78. Examine the structure of the EMPLOYEES table:

 Column name        Data type    Remarks 
 EMPLOYEE_ID        NUMBER       NOT NULL, Primary Key 
 LAST_NAME          VARCNAR2(30) 
 FIRST_NAME         VARCNAR2(30) 
 JOB_ID             NUMBER 
 SAL                NUMBER 
 MGR_ID             NUMBER       References EMPLOYEE_ID column 
 DEPARTMENT_ID      NUMBER

You need to create an index called NAME_IDX on the first name and last name fields of the EMPLOYEES table. Which SQL statement would you use to perform this task?

#79. Which operator can be used with a multiple-row subquery?

#80. Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables.

For which situation would you use a nonequijoin query?

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

ген. 0.091

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

Oracle 1Z0-035

Форум

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

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