1Z0-007 Oracle - Braindumps.com.ua: question list for "Introduction to Oracle9i: 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-007: Introduction to Oracle9i: SQL

#141. You just issued the following statement.

 ALTER TABLE marketing 
 DROP COLUMN profit;

Which of the following choices identified when the column will actually be removed from database.

#142. Which of the following can be a valid column name?

#143. You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty.
Which statement accomplishes this task?

#144. Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table?

#145. Which three statements correctly describe the functions and use of constraints? (Choose three.)

#146. Which two statements about NOT NULL constraints are true? (Choose two.)

#147. The PO_DETAIL table contains these columns:

 PO_NUM           NUMBER         NOT NULL       Primary Key 
 PO_LINE_ID       NUMBER         NOT NULL       Primary Key 
 PRODUCT_ID       NUMBER Foreign Key to PRODUCT_ID column of the PRODUCT table 
 QUANTITY         NUMBER 
 UNIT_PRICE       NUMBER(5,2)

Evaluate this statement:

 ALTER TABLE po_detail 
 ENABLE CONSTRAINT po_num_pk;

For which task would you issue this statement?

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

#149. Examine the structure of the EMPLOYEE table.

Which CREATE TABLE statement should you use to create the EMPLOYEE table?

#150. Which syntax turns an existing constraint on?

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

gen. 0.1

Server date 04:57 08-01-2009

Oracle 1Z0-007

Forum

Start online exam simulation

Master braindump

User braindumps