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

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

#131. Evaluate this statement:

 SELECT * 
 FROM greg.customer;

If as user Chan you execute this statement successfully, which statement must be true?

Show comments for this question (1)
Add comments
Link to this question

#132. Logged on as user Ann, you issue these SQL statements:

 CREATE TABLE customer ( 
 customer_id NUMBER, 
 company_id VARCHAR2(30), 
 contact_name VARCHAR2(30), 
 contact_title VARCHAR2(20), 
 address VARCHAR2(30), 
 city VARCHAR2(25), 
 region VARCHAR2(10), 
 postal_code VARCHAR2(20), 
 country_id NUMBER, 
 phone VARCHAR2(20), 
 fax VARCHAR2(20), 
 credit_limit NUMBER (7,2)); 
 CREATE PUBLIC SYNONYM cust 
 FOR customer; 
 GRANT SELECT ON customer TO chan;

Which SELECT statements could user Chan issue to access the CUSTOMER table? (Choose all that apply.)

Show comments for this question (1)
Add comments
Link to this question

#133. Evaluate this CREATE TABLE statement:

 CREATE TABLE curr_order ( 
 id NUMBER, 
 customer_id NUMBER, 
 emp_id NUMBER, 
 order_dt TIMESTAMP WITH LOCAL TIME ZONE, 
 order_amt NUMBER(7,2), 
 ship_method VARCHAR2(5));

Which statement about the ORDER_DT column is true?

Show comments for this question (1)
Add comments
Link to this question

#134. Examine the structure of the PRODUCT table.

You need to reduce the LIST_PRICE column precision to 6 with a scale of 2 and ensure that when inserting a row into the PRODUCT table without a value for the LIST_PRICE column, a price of $5.00 will automatically be inserted. The PRODUCT table currently contains no records. Which statement should you use?

Show comments for this question (1)
Add comments
Link to this question

#135. Which statements about data types are true? (Choose all that apply.)

Show comments for this question (1)
Add comments
Link to this question

#136. Which ALTER TABLE statement should you use to add a PRIMARY KEY constraint on the MANUFACTURER_ID column of the INVENTORY table?

Show comments for this question (1)
Add comments
Link to this question

#137. The EMPLOYEES table has these columns:

Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement:

 ALTER TABLE EMPLOYEES 
 MODIFY (SALARY DEFAULT 5000);

What is true about your ALTER statement?

Show comments for this question (1)
Add comments
Link to this question

#138. You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 2000 bytes. The column can currently hold 1000 bytes per value. The table contains 20000 rows. Which statement is valid?