1Z0-035 Oracle - Braindumps.com.ua: question list for "Oracle 7.3 & 8 to Oracle9i DBA OCP Upgrade", 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-035: Oracle 7.3 & 8 to Oracle9i DBA OCP Upgrade

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

#102. What is true about the WITH GRANT OPTION clause?

#103. Which substitution variable would you use if you want to reuse the variable without prompting the user each time?

#104. The EMPLOYEES table has these columns:

 LAST NAME      VARCHAR2(35) 
 SALARY         NUMBER(8,2) 
 HIRE_DATE      DATE

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?

#105. The DBA issues this SQL command:

 CREATE USER scott 
 IDENTIFIES BY tiger;

What privileges does the user Scott have at this point?

#106. Which two statements complete a transaction? (Choose two)

#107. You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns:

 CUST_ID         NUMBER(4)         NOT NULL 
 CUST_NAME       VARCHAR2(100) 
 CUST_ADDRESS    VARCHAR2(150) 
 CUST_PHONE      VARCHAR2(20)

Which SELECT statement accomplishes this task?

#108. Which statement describes the ROWID data type?

#109. Evaluate the SQL statement

 DROP TABLE DEPT:

Which four statements are true of the SQL statement? (Choose four)

#110. You are granted the CREATE VIEW privilege. What does this allow you to do?

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

gen. 0.274

Server date 06:31 22-11-2008

Oracle 1Z0-035

Forum

Start online exam simulation

Master braindump