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

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

#81. You issue this command:

 CREATE PUBLIC SYNONYM emp 
 FOR ed.employee;

Which task has been accomplished?

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

You created the patient_id_seq sequence to be used with the patient table’s primary key column. The sequence begins at 1000, has a maximum value of 999999999, and increments by 1. You need to write a script to insert a row into the patient table and use the sequence you created. Which script would you use to complete this task?

#83. Given this CURSOR statement

 DECLARE 
 CURSOR query_cursor (v_salary) IS 
 SELECT last_name, salary, dept_no 
 FROM employee 
 WHERE salary > v_salary;

Why does this statement cause an error?

#84. Which SELECT statement would you use in a PL/SQL block to query the employee table and retrieve the last name and salary of the employee whose id is 3?

#85. 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?

#86. Evaluate this PL/SQL block:

 BEGIN 
 FOR i IN 1 .5 LOOP 
 IF i = 1 THEN NULL; 
 ELSIF i = 3 THEN COMMIT; 
 ELSIF i = 5 THEN ROLLBACK; 
 ELSE INSERT INTO test(results) VALUES(i); 
 END IF; 
 END LOOP; 
 COMMIT; 
 END;

How many values will be permanently inserted into the TEST table?

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

#88. The structure of the DEPT table is as follows:

 Name       Null?         Type 
 DEPTNO     NOT NULL      NUMBER(2) 
 DNAME                    VARCHAR2(14) 
 LOC                      VARCHAR2(13)

Examine the declaration section:

 DECLARE 
 TYPE dept_table_type IS TABLE OF dept%ROWTYPE 
 INDEX BY BINARY_INTEGER; 
 dept_table dept_table_type;

You need to assign the LOC field in record 15, the value of ‘Atlanta’. Which PL/SQL statement makes this assignment?

#89. Examine the structure of the STUDENT table:

 Name             Null             Type 
 STUD_ID          NOT NULL         NUMBER(S) 
 NAME             NOT NULL         VARCHAR2(25) 
 ADDRESS                           VARCHAR2(50) 
 GRADUATION                        DATE

Which statement inserts a new row into the STUDENT table?

#90. You are updating the employee table. Jane has been granted the same privileges as you on the employee table. You ask Jane to log on to the database to check your work before you issue a COMMIT command. What can Jane do to the employee table?

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

gen. 3.642

Server date 09:31 22-11-2008

Oracle 1z0-001

Forum

Start online exam simulation

Master braindump

User braindumps