1Z0-007 Oracle - Braindumps.com.ua: question list for "Introduction to Oracle9i: SQL", page: 16

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-007: Introduction to Oracle9i: SQL

#151. Which two statements about creating constraints are true? (Choose two)

#152. Which constraint can be defines only at the column level?

#153. Which statement explicitly names a constraint?

#154. Examine the SQL statements that creates ORDERS table:

 CREATE TABLE orders 
 (SER_NO NUMBER UNIQUE, 
 ORDER_ID NUMBER, 
 ORDER_DATE DATE NOT NULL 
 STATUS VARCHARD2(10) 
 CHECK (status IN (‘CREDIT’,’CASH’)), 
 PROD_ID_NUMBER 
 REFERENCES PRODUCTS(PRODUCT_ID), 
 ORD_TOTAL NUMBER, 
 PRIMARY KEY (ORDER id, ORDER DATE));

For which columns would an index be automatically created when you execute the above SQL statement? (Choose two)

#155. For which two constraints does the Oracle Server implicitly create a unique index? (Choose two.)

#156. Your attempt to disable a constraints result in the following error
Ora:02297: cannot disable constraint – dependencies exist.
Which of the following types of the constraints is likely causing interference with your disablement of this one?

#157. Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:

Which UPDATE statement is valid?

#158. Examine the structure if the EMPLOYEES and NEW EMPLOYEES tables:

Which MERGE statement is valid?

#159. Examine the data in the EMPLOYEES and EMP_HIST tables:

The EMP_HIST table is updated at the end of every year. The employee ID, name, job ID, and salary of each existing employee are modified with the latest data. New employee details are added to the table.
Which statement accomplishes this task?

#160. Which are DML statements? (Choose all that apply)

[1] ... [11] [12] [13] [14] [15] [16] [17] [18] [19] [20] [21] ... [31]

gen. 0.059

Server date 04:57 08-01-2009

Oracle 1Z0-007

Forum

Start online exam simulation

Master braindump

User braindumps