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

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

#101. Under which situation is it necessary to use an explicit cursor?

#102. You attempt to create the salary table with this command:

 1. CREATE TABLE salary 
 2 .(employee_idNUMBER(9) 
 3.CONSTRAINT salary_pk PRIMARY KEY, 
 4.1995_saIaryNUMBER(8 ,2), 
 5 .manager_nameVARCHAR2(25) 
 6.CONSTRAINT mgr_name_nn NOT NULL, 
 7 .$salary_96NUMBER(8 2));

Which two lines of this statement will return errors? (Choose two.)

#103. Which statement is true when a DROP TABLE command is executed on a table?

#104. 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 adds a new column after the NAME column to hold phone numbers?

#105. Which datatype should you use for interest rates with varying and unpredictable decimal places, such as 1.234, 3.4, 5, and 1.23?

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

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

#108. You query the database with this command:

 SELECT last_name, first_name 
 FROM employee 
 WHERE salary IN 
 (SELECT salary 
 FROM employee 
 WHERE dept_no = 3 OR dept_no = 5);

Which values are displayed?

#109. Evaluate this SQL script:

 CREATE ROLE manager; 
 CREATE ROLE clerk; 
 CREATE ROLE inventory; 
 CREATE USER scott IDENTIFIED BY tiger; 
 GRANT inventory TO clerk; 
 GRANT clerk TO manager; 
 GRANT inventory TO scott

How many roles will user SCOTT have access to?

#110. Using SQL*Plus, you created a user with this command:

 CREATE USER jennifer IDENTIFIED BY jbw122;

What should you do to allow the user database access?

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

gen. 0.244

Server date 07:33 22-11-2008

Oracle 1z0-001

Forum

Start online exam simulation

Master braindump

User braindumps