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

Профиль

Бреиндампы

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

Форумы

Продавец

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

#51. Evaluate these two SQL statements:

 SELECT last_name, salary , hire_date 
 FROM EMPLOYEES 
 ORDER BY salary DESC; 
 SELECT last_name, salary, hire_date 
 FROM EMPLOYEES 
 ORDER BY 2 DESC;

What is true about them?

#52. You would like to display the system date in the format "Monday, 01 June, 2001". Which SELECT statement should you use?

#53. The CUSTOMERS table has these columns:

 CUSTOMER_ID        NUMBER(4)        NOT NULL 
 CUSTOMER_NAME      VARCHAR2(100)    NOT NULL 
 STREET_ADDRESS     VARCHAR2(150) 
 CITY_ADDRESS       VARCHAR2(50) 
 STATE_ADDRESS      VARCHAR2(50) 
 PROVINCE_ADDRESS   VARCHAR2(50) 
 COUNTRY_ADDRESS    VARCHAR2(50) 
 POSTAL_CODE        VARCHAR2(12) 
 CUSTOMER_PHONE     VARCHAR2(20)

Which statement finds the rows in the CUSTOMERS table that do not have a postal code?

#54. Which SELECT statement will the result ‘ello world’ from the string ‘Hello World’?

#55. Evaluate this SQL statement:

 SELECT e.employee_id, (.15* e.salary) + (.5 * e.commission_pct) 
 + (s.sales amount * (.35 * e.bonus)) AS CALC_VALUE 
 FROM employees e, sales s 
 WHERE e.employee_id = s.emp_id;

What will happen if you remove all the parentheses from the calculation?

#56. From SQL*Plus, you issue this SELECT statement:

 SELECT* 
 FROM orders;

You use this statement to retrieve data from a data table for __________. (Choose all that apply)

#57. You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20. Which SQL statement would you use to create the view EMP_VU?

#58. Examine the structure of the STUDENTS table:

 STUDENT_ID      NUMBER NOT NULL, Primary Key 
 STUDENT_NAME    VARCHAR2(30) 
 COURSE_ID       VARCHAR2(10) NOT NULL 
 MARKS           NUMBER 
 START_DATE      DATE 
 FINISH_DATE     DATE

You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999. Which SQL statement accomplishes this task?

#59. Which four statements correctly describe functions that are available in SQL? (Choose four)

#60. Examine the data from the EMP table:

The COMMISSION column shows the monthly commission earned by the employee. Which three tasks would require subqueries or joins in order to perform in a single step? (Choose three)

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

ген. 0.06

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

Oracle 1Z0-035

Форум

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

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