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

Профиль

Бреиндампы

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

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2461)

Network Appliance (2)

Авторизация

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

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

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

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

Oracle 1Z0-035: Oracle 7.3 & 8 to Oracle9i DBA OCP Upgrade

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

#2. Examine the structure of the EMPLOYEES table:

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

Which three statements inserts a row into the table? (Choose three)

#3. You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others.
Which statement accomplishes this?

#4. Examine the data in the EMPLOYEES table:

Which three subqueries work? (Choose three)

#5. The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table.
As a user of the database, you created a table called HR in your schema.
What happens when you execute this query?

 SELECT * 
 FROM HR;

#6. Which two statements about views are true? (Choose two.)

#7. Examine the description of the EMPLOYEES table:

 EMP_ID         NUMBER(4)         NOT NULL 
 LAST_NAME      VARCHAR2(30)      NOT NULL 
 FIRST_NAME     VARCHAR2(30) 
 DEPT_ID        NUMBER(2) 
 JOB_CAT        VARCHARD2(30) 
 SALARY         NUMBER(8,2)

Which statement shows the maximum salary paid in each job category of each department?

#8. Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns:

 LAST NAME         VARCNAR2(35)     NOT NULL 
 SALARY            NUMBER(9,2)      NOT NULL 
 COMMISION_PCT     NUMBER(4,2)

Which statement ensures that a value is displayed in the calculated columns for all employees?

#9. Which syntax turns an existing constraint on?

#10. Examine the description of the STUDENTS table:

 STD_ID       NUMBER(4) 
 COURSE_ID    VARCHARD2(10) 
 START_       DATE DATE 
 END_DATE     DATE

Which two aggregate functions are valid on the START_DATE column? (Choose two)

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

ген. 0.076

Дата сервера 13:41 20-11-2008

Oracle 1Z0-035

Форум

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

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