1z0-001 Oracle - Braindumps.com.ua: question list for "Ineroduction to oracle:sql and pl/sql", page: 2

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2461)

Network Appliance (2)

Authorization

Login:
Password:
remember me:

Contacts
Certification links
Links

Authorized user can see question and answers.
Please log in or sign up.

Exam question list:
Show all comments

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]

gen. 0.145

Server date 07:37 22-11-2008

Oracle 1z0-001

Forum

Start online exam simulation

Master braindump

User braindumps