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

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

#121. The EMPLOYEE table contains these columns:

 LAST_NAME         VARCHAR2(25) 
 FIRST_NAME        VARCHAR2(25) 
 DEPT ID           NUMBER(9)

You need to display the names of employees that are not assigned to a department. Evaluate this SQL statement:

 SELECT last_name, first_name 
 FROM employee 
 WHEREdept_id = NULL;

Which change should you make to achieve the desired result?

#122. Which statement about SQL is true?

#123. Evaluate this IF statement

 IF v_value> 100 THEN 
 v_new_value = 2 * v_value; 
 ELSIF v_value > 200 THEN 
 v_new_value =3 * v_value; 
 ELSIF v_value <300 THEN 
 v_new_value =4 * v_value; 
 ELSE 
 v_new_value := 5 * v_value; 
 END IF;

What would be assigned to V_NEW_VALUE if V_VALUE is 250?

#124. Which statement is true when writing a cursor FOR loop?

#125. 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 code:

 DECLARE 
 dept_rec dept%ROWTYPE; 
 BEGIN 
 SELECT * 
 INTO dept_rec 
 FROM dept 
 WHERE deptno = 10; END;

Which PL/SQL statement displays the location of the selected department?

#126. Which statement about implicit cursors is true?

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

#128. In SQL*Plus, you issued this command:

 DELETE FROM dept 
 WHERE dept_id = 901;

You received an integrity constraint error because a child record was found. What could you do to make the statement execute?

#129. Which update statement produces the following error?
ORA-02291: integrity constraint (SYS_C23) violated - parent key not found

#130. Examine the structure of the STUDENT table:

 Name            Null           Type 
 STUD ID         NOT NULL       NUMBER(3) 
 NAME            NOT NULL       VARCHAR2(25) 
 ADDRESS                        VARCHAR2(50) 
 GRADUATION                     DATE

Which statement inserts a new row into the STUDENT table?

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

gen. 0.078

Server date 11:37 08-01-2009

Oracle 1z0-001

Forum

Start online exam simulation

Master braindump

User braindumps