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

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

#71. The EMPLOYEE table contains these columns:

 ID                NUMBER(9)     PK 
 LAST_NAME         VARCHAR2(25)  NN 
 DEPT ID           NUMBER(9)

Evaluate this SQL script

 DEFINE id_2 = 93004 
 SELECT * 
 FROMemployee 
 WHEREid = (&id_2)

Which change should you make to the script so that it will execute?

#72. Evaluate this SQL statement

 SELECTe.id, (.15 * e.salary) + (.25 * e.bonus) +  
 (s.sale_amount * (.15 * e.commission_pct)) 
 FROMemployee e, sale s 
 WHEPEe.id = s.emp_id;

What would happen if you removed all the parentheses from the calculation?

#73. Which is NOT an SQL*PIus command?

#74. When selecting data, which statement is valid about projection?

#75. Click on the EXHIBIT button and examine the table instance chart for the employee table.

You want to display each employee’s hire date from earliest to latest, Which SQL statement would you use?

#76. The EMPLOYEE table contains these columns:

 ID              NUMBER(9) 
 LAST_NAME       VARCHAR2(25) 
 FIRST_NAME      VARCHAR2(25) 
 COMMISSION      NUMBER(7,2)

You need to display the current commission for all employees. These are the desired results:
1.Display the commission multiplied by 1.5.
2.Exclude employees with a zero commission.
3.Display a zero for employees with a null commission value.
Evaluate this SQL command:

 SELECT id, last_name, first_name, commission * 1.5 
 FROM employee 
 WHEREcommission <> 0;

What does the statement provide?

#77. Which statement is true about nesting blocks?

#78. Examine the code:

 1 DECLARE 
 2 iNUMBER:=0; 
 3 v_date DATE; 
 4 BEGIN 
 5 i := i+1; 
 6 LOOP 
 7 v_date := v_date + 5; 
 B i := i+1; 
 9 EXIT WHEN i = 5; 
 10 END LOOP; 
 11 END;

You have encountered unexpected results when the above block of code is executed. How can you trace the values of the counter variable I and date variable V_DATE in the SQL*Plus environment?

#79. Examine the code:

 SET SERVEROUTPUT ON 
 DECLARE 
 v_name emp.ename%TYPE; 
 v_num NUMBER; 
 v_sal NUMBER(8,2); 
 BEGIN

-- This code displays salaries if larger than 10000

 SELECT ename, sal 
 INTO v_name, v_sal 
 FROM emp 
 WHERE empno = 101; 
 IF (v_sal .GT. 10000) THEN 
 DBMS_OUTPUT PUT_LINE (‘Salary IS ‘|| v_sal 
 || ‘FOR employee ‘|| v_name); 
 END IF; 
 END; 
 SET SERVEROUTPUT OFF

Which statement causes a compilation error when the above PLJSQL block is executed?

#80. The EMPLOYEE table has ten columns. Since you often query the table with conditions based on four or more columns, you created an index on all the columns in the table. Which result will occur?

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

gen. 0.396

Server date 06:52 22-11-2008

Oracle 1z0-001

Forum

Start online exam simulation

Master braindump

User braindumps