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

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

#191. Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She granted SELECT privilege to Scott on this view. Which option enables Scott to eliminate the need to qualify the view with the name MARY .EMP_DEP_LOC_VU each time the view is referenced?

#192. Which two statements about sequences are true? (Choose two)

#193. Which SELECT statement will display the next value of the PARTS_ID_SEQ sequence by actually retrieving the value from the sequence?

#194. You issue this statement:

 CREATE PUBLIC SYNONYM part 
 FOR linda.product;

Which task was accomplished by this statement?

#195. User Mark wants to eliminate the need to type the full table name when querying the TRANSACTION_HISTORY table existing in her schema. All other database users should use the schema and full table name when referencing this table.
Which statement should user Marilyn execute?

#196. The TEACHER table in your schema contains these columns:

 ID              NUMBER(9)         NOT NULL        Primary Key 
 LAST_NAME       VARCHAR2(25) 
 FIRST_NAME      VARCHAR2(25) 
 SUBJECT_ID      NUMBER(9)

You execute this statement:

 CREATE INDEX teacher_name_idx 
 ON teacher(first_name, last_name);

Which statement is true?

#197. The LINE_ITEM table contains these columns:

 LINE_ITEMID       NUMBER(9) 
 ORDER_ID          NUMBER(9) 
 PRODUCT_ID        VARCHAR2(9) 
 QUANTITY          NUMBER(5)

You created a sequence called LINE_ITEMID_SEQ to generate sequential values for the LINE_ITEMID column. Evaluate this SELECT statement:

 SELECT line_itemid_seq.CURRVAL 
 FROM dual;

Which task will this statement accomplish?

#198. Evaluate this statement:

 CREATE SEQUENCE line_item_id_seq 
 START WITH 10001 
 MAXVALUE 999999999 
 NOCYCLE;

Which statement about this CREATE SEQUENCE statement is true?

#199. Which statement should you use to eliminate the need for all users to qualify Marilyn's INVENTORY table with her schema when querying the table?

#200. Which statement will user Barbara use to create a private synonym when referencing the EMPLOYEE table existing in user Chan's schema?

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

gen. 0.071

Server date 03:56 08-01-2009

Oracle 1Z0-007

Forum

Start online exam simulation

Master braindump

User braindumps