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

Профиль

Бреиндампы

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

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

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

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

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

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

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

#11. You need to perform a major update on the EMPLOYEE table. You have decided to disable the PRIMARY KEY constraint on the empid column and the CHECK constraint on the job column. What happens when you try to enable the constraints after the update is completed?

#12. Which statement is valid within the executable section of a PL/SQL block?

#13. Examine this block of code:

 SET SERVEROUTPUT ON 
 DECLARE 
 x NUMBER; 
 v_sal NUMBER; 
 v_found VARCHAR2(10) := ‘TRUE’; 
 BEGIN 
 x = ’1’ 
 v_sal := 1000; 
 DECLARE 
 v_found VARCHAR2(10); 
 y NUMBER; 
 BEGIN 
 IF (v_sal > 500) THEN 
 v_found := ‘YES’; 
 END IF; 
 DBMS_OUTPUT.PUT_LINE (‘VALUE OF v_found IS ‘II v_found); 
 DBMS_OUTPUT.PUT_LINE (‘VALUE OF v_sal IS ‘II v_sal); 
 y := 20; 
 END; 
 DBMS_OUTPUT.PUT_LINE (‘VALUE OF v_found IS ‘II v_found); 
 DBMS_OUTPUT.PUT_LINE (‘VALUE OF Y IS ‘ || TO_CHAR(y)); 
 END; 
 SET SERVEROUTPUT OFF

What is the result of executing this block of code?

#14. Examine this block or code:

 SET SERVEROUTPUT ON 
 DECLARE 
 x NUMBER; 
 v_sal NUMBER; 
 v_round VARCHAR2(10) := ‘TRUE’; 
 BEGIN 
 x = ’1’: 
 v_sal := 1000; 
 DECLARE 
 v_round VARCHAR2(10); 
 y NUMBER; 
 BEGIN 
 IF (v_sal > 500) THEN 
 v_round := ‘YES’; 
 END IF; 
 DBMS_OUTPUT.PUT_LINE (‘VALUE OF v_round IS ‘|| v_round); 
 DBMS_OUTPUT.PUT_LINE (‘VALUE OR v_sal IS ‘II v_sal); 
 y := 20; 
 END; 
 DBMS_OUTPUT.PUT_LINE (‘VALUE OF v_round IS ‘|| v_found); 
 DBMS_OUTPUT.PUT_LINE (‘VALUE OF Y IS ‘ TO_CHAR(y)); 
 END; 
 SET SERVEROUTPUT OFF

Why does this code produce an error when executed?

#15. Examine the declaration section:

 DECLARE 
 CURSOR emp_cursor(p_deptno NUMBER, p_job VARCHAR2) 
 IS 
 SELECT empno, ename 
 FROM emp 
 WHERE deptno = p_deptno 
 AND job = p_job; 
 BEGIN 
 …

Which statement opens this cursor successfully?

#16. Your company wants to give each employee a $100 salary increment. You need to evaluate the results from the EMP table prior to the actual modification. If you do not want to store the results in the database, which statement is valid?

#17. You need to execute a script file named QUERYEMP.SQL from your SQL*PIus environment. Which command do you use?

#18. The PRODUCT table contains these columns:

 ID             NUMBER(9) 
 COST           NUMBER(7,2) 
 SALE_PRICE     NUMBER(7,2)

Management has asked you to calculate the net revenue per unit for each product if the cost of each product is increased by 10% and the sale price of each product is increased by 25%. You issue this SQL statement

 SELECT id, sale_price * 1.25- COST* 1.10 
 FROM product;

Which conclusion can you draw from the results?

#19. You want to display the average salary for departments 20 and 50, but only if those departments have an average salary of at least 2000. Which statement will produce the required results?

#20. Click on the EXHIBIT button and examine the table instance chart for the cars table.

You query the database with this command:

 SELECT lot_no “Lot NUMBER”, COUNT(*) “NUMBER OF Cars Available” 
 FROM cars 
 WHERE model = ‘Fire’ 
 GROUP BY lot_no 
 HAVING COUNT(*) > 10 
 ORDER BY COUNT(*);

Which clause restricts which groups are displayed?

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

ген. 0.102

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

Oracle 1z0-001