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

#131. The STUDENT_GRADES table has these columns:

 STUDENT_ID      NUMBER(12) 
 SEMESTER_END    DATE 
 GPA             NUMBER(4,3)

The registrar requested a report listing the students' grade point averages (GPA) sorted from highest grade point average to lowest.
Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar?

#132. Which describes the default behavior when you create a table?

#133. Which four are attributes of single row functions? (Choose four.)

#134. You need to create a table named ORDERS that contains four columns:
- an ORDER_ID column of number data type
- a CUSTOMER_ID column of number data type
- an ORDER_STATUS column that contains a character data type
- a DATE_ORDERED column to contain the date the order was placed
When a row is inserted into the table, if no value is provided for the status of the order, the value PENDING should be used instead.
Which statement accomplishes this?

#135. Examine the structure of the EMPLOYEES table:

 EMPLOYEE_ID   NUMBER Primary Key 
 FIRST_NAME    VARCHAR2(25) 
 LAST_NAME     VARCHAR2(25)

Which three statements insert a row into the table? (Choose three.)

#136. The user Sue issues this SQL statement:

 GRANT SELECT ON sue.EMP TO alice WITH GRANT OPTION;

The user Alice issues this SQL statement:

 GRANT SELECT ON sue.EMP TO reena WITH GRANT OPTION;

The user Reena issues this SQL statement:

 GRANT SELECT ON sue.EMP TO timber;

The user Sue issues this SQL statement:

 REVOKE SELECT ON sue.EMP FROM alice;

For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?

#137. The EMPLOYEES table contains these columns:

 EMPLOYEE_ID      NUMBER(4) 
 LAST_NAME        VARCHAR2 (25) 
 JOB_ID           VARCHAR2(10)

You want to search for strings that contain 'SA_' in the JOB_ID column. Which SQL statement do you use?

#138. The CUSTOMERS table has these columns:

 CUSTOMER_ID           NUMBER(4)         NOT NULL 
 CUSTOMER_NAME         VARCHAR2(100)     NOT NULL 
 CUSTOMER_ADDRESS      VARCHAR2(150) 
 CUSTOMER_PHONE        VARCHAR2(20)

You need to produce output that states "Dear Customer customer_name, ". The customer_name data values come from the CUSTOMER_NAME column in the CUSTOMERS table.
Which statement produces this output?

#139. What is true about sequences?

#140. Which object privileges can be granted on a view?

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

gen. 0.196

Server date 05:08 08-01-2009

Oracle 1Z0-035

Forum

Start online exam simulation

Master braindump