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

Профиль

Бреиндампы

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

Форумы

Продавец

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

#81. Examine the data from the ORDERS and CUSTOMERS tables.

Evaluate the SQL statement:

 SELECT * 
 FROM orders 
 WHERE cust_id = (SELECT cust_id 
 FROM customers 
 WHERE cust_name = 'Smith');

What is the result when the query is executed?

#82. You need to display the last names of those employees who have the letter “A” as the second character in their names.
Which SQL statement displays the required results?

#83. You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created.
You want to look at the definition of the view (the SELECT statement on which the view was create.)
How do you obtain the definition of the view?

#84. Evaluate this SQL statement:

 SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME 
 FROM EMP e, DEPARTMENT d 
 WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID;

In the statement, which capabilities of a SELECT statement are performed?

#85. Which two are character manipulation functions? (Choose two.)

#86. Which three statements correctly describe the functions and use of constraints? (Choose three.)

#87. You define a multiple-row subquery in the WHERE clause of an SQL query with a comparison operator "=".
What happens when the main query is executed?

#88. You need to calculate the total of all salaries in the accounting department. Which group function should you use?

#89. What is true about joining tables through an equijoin?

#90. Scott issues the SQL statements:

 CREATE TABLE dept 
 (deptno NUMBER(2), 
 dname VARCHAR2(14), 
 loc VARCHAR2(13)}; 
 GRANT SELECT 
 ON DEPT 
 TO SUE;

If Sue needs to select from Scott's DEPT table, which command should she use?

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

ген. 0.083

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

Oracle 1Z0-035

Форум

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

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