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

Профиль

Бреиндампы

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

Форумы

Продавец

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

#41. The ORDERS table has these columns:

ORDER_ID            NUMBER(4)    NOT NULL 
 CUSTOMER_ID       NUMBER(12)    NOT NULL 
 ORDER_TOTAL       NUMBER(10,2)

The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs. Which two statements retrieve orders with an inclusive total that ranges between 100.00 and 2000.00 dollars? (Choose two.)

#42. Examine the data in the EMPLOYEES and EMP_HIST tables:

The EMP_HIST table is updated at the end of every year. The employee ID, name, job ID, and salary of each existing employee are modified with the latest data. New employee details are added to the table.
Which statement accomplishes this task?

#43. Which two statements about subqueries are true? (Choose two.)

#44. Examine the data of the EMPLOYEES table.
EMPLOYEES (EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID)

Evaluate this SQL statement:

 SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary, 
 m.employee_id "Mgr_id", m.emp_name "Manager" 
 FROM employees e, employees m 
 WHERE e.mgr_id = m.employee_id 
 AND e.salary > 4000;

What is its output?

#45. You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table.
Some of the employees may not have a phone number available.
Which data manipulation operation do you perform?

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

#47. Which two statements accurately describe a role? (Choose two.)

#48. What is necessary for your query on an existing view to execute successfully?

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

#50. Examine the data in the EMPLOYEES table.

On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. The JOB_ID column is a NOT NULL column. Evaluate this DELETE statement:

 DELETE employee_id, salary, job_id 
 FROM employees 
 WHERE dept_id = 90;

Why does the DELETE statement fail when you execute it?

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

ген. 0.087

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

Oracle 1Z0-035

Форум

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

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