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

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

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

#141. The EMPLOYEE table contains these columns:

 LAST_NAME     VARCHAR2(25) 
 FIRST_NAME    VARCHAR2(25) 
 SALARY        NUMBER(7,2)

You need to display the names of employees that earn more than the average salary of all employees.
Evaluate this SQL statement

 SELECT last_name. first_name 
 FROMemployee 
 WHEREsalary > AVG(salary);

Which change should you make to achieve the desired results?

#142. The EMPLOYEE table contains these columns:

 FIRST_NAME    VARCHAR2(25) 
 COMMISSION    NUMBER(3,2)

Evaluate this SQL statement

 SELECT first_name, commission 
 FROM employee 
 WHERE commission = 
 (SELECTcommission 
 FROM employee 
 WHEREUPPER(first_name) = ‘SCOTT’)

What would cause this statement to fail?

#143. Evaluate this PL/SQL block:

 DECLARE 
 v_result NUMBER(2); 
 BEGIN 
 DELETE 
 FROM employee 
 WHERE dept_id IN (10, 20, 30); 
 v_result := SQL%ROWCOUNT; 
 COMMIT; 
 END;

What will be the value of V_RESULT if no rows are deleted?

#144. Evaluate this PL/SQL block:

 BEGIN 
 FOR i IN 1.10 LOOP 
 IF i = 4 OR I = 6 THEN 
 NULL; 
 ELSE 
 INSERT INTO test(results) 
 VALUES (I); 
 END IF; 
 COMMIT; 
 END LOOP; 
 ROLLBACK; 
 END;

How many values will be inserted into the TEST table?

#145. You need to create a PL/SQL program to insert records into the employee table. Which block of code successfully uses the INSERT command?

#146. Which two conditions in a PL/SQL block cause an exception to occur? (Choose two.)

#147. How do you declare a PL/SQL table of records to hold the rows selected from the EMP table?

#148. You issue this command:

 CREATE PUBLIC SYNONYM emp 
 FOR ed.employee

Which task has been accomplished?

#149. Click on the EXHIBIT button and examine the structure of the DEPARTMENT and EMPLOYEE tables.

Evaluate this SQL statement:

 CREATE INDEX emp_dept_id_idx 
 ON employee(dept_id);

Which result will the statement provide?

#150. Click on the EXHIBIT button and examine the table instance chart for the patient table.

You need to create the patient_id_seq sequence to be used with the patient table’s primary key column. The sequence should begin at 1000, have a maximum value of 999999999, never reuse any numbers, and increment by 1.
Which statement would you use to complete this task?

[1] ... [11] [12] [13] [14] [15] [16] [17] [18]

gen. 0.086

Server date 11:39 08-01-2009

Oracle 1z0-001

Forum

Start online exam simulation

Master braindump

User braindumps