1z0-001 Oracle - Braindumps.com.ua: список вопросов для "Ineroduction to oracle:sql and pl/sql", страница: 3

Профиль

Бреиндампы

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

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

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

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

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

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

Oracle 1z0-001: Ineroduction to oracle:sql and pl/sql

#21. Click on the EXHIBIT button and examine the employee table.

You attempt to query the database with this command:

 SELECT dept_no, last_name, SUM(salary) 
 FROM employee 
 WHERE salary < 50000 
 GROUP BY dept_no 
 ORDER BY last_name;

Which clause causes an error?

#22. Click on the EXHIBIT button and examine the structure of the BOOK_TITLE, COPY, and CHECK_OUT tables.

You need to create the BOOKS_AVAILABLE view. These are the desired results:
1.Include the title of each book.
2.Include the availability of each book.
3.Order the results by the author.
Evaluate this SQL statement

 CREATE VIEW books_available 
 AS 
 SELECT b.title, c.availability 
 FROMbook_title b, copy c 
 WHEREB.id = c.title_id 
 ORDER BY b.author

What does the statement provide?

#23. The view EMP_VIEW is created based on the table EMP as follows:

 CREATE OR REPLACE VIEW emp_view 
 AS 
 SELECT deptno, SUM(sal) TOT_SAL, COUNT(*) NUM_EMP 
 FROM emp 
 GROUP BY deptno;

What happens when the following command is issued?

 UPDATE emp_view 
 SET tot_sal = 20000 
 WHERE deptno = 10;

#24. Which statement shows the view definition of the view EMP_VIEW that is created based on the table EMP?

#25. In which section of a PL/SQL block is a user-defined exception raised?

#26. Examine the table structures:
EMP Table

 Name       Null?          Type 
 EMPNO      NOT NULL       NUMBER(4) 
 NAME                      VARCHAR2(10) 
 JOB                       VARCHAR2(9) 
 MGR                       NUMBER(4) 
 HIREDATE                  DATE 
 SALARY                    NUMBER(7,2) 
 COMM                      NUMBER(7,2) 
 DEPTNO     NOT NULL       NUMBER(2)

TAX Table

 Name       Null?        Type 
 TAXGRADE                NUMBER 
 LOWSAL                  NUMBER 
 HIGHSAL                 NUMBER

You want to create a report that displays the employee details along with the tax category of each employee. The tax category is determined by comparing the salary of the employee from the EMP table to the lower and upper salary values in the TAX table. Which SELECT statement produces the required results?

#27. The PLAYER table contains these columns:

 ID            NUMBER(9) 
 NAME          VARCHAR(2) 
 MANAGER_ID    NUMBER(9)

In this instance, managers are players and you need to display a list of players. Evaluate these two SQL statements:

 SELECT p.name, m.name 
 FROMplayer p, player m 
 WHEREm.id = p.manager_id; 
 SELECT p.name, m.name 
 FROMplayer p, player m 
 WHEREm.manager_id = p.id;

How will the results differ?

#28. Which operator is NOT appropriate in the join condition of a non-equi join SELECT statement?

#29. In which situation should you use an outer join query?

#30. You need to store currency data and you know that the data will always have two digits to the right of the decimal point. However, the number of digits to the left of the decimal place will vary greatly. Which datatype would be most appropriate to store this data?

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

ген. 0.072

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

Oracle 1z0-001