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

#141. Examine the SQL statement that creates ORDERS table:

 CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, 
 ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN 
 ('CREDIT', 'CASH')), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), 
 ORD_TOTAL NUMBER, PRIMARY KEY (order_id, order_date));

For which columns would an index be automatically created when you execute the above SQL statement? (Choose two.)

#142. What is true of using group functions on columns that contain NULL values?

#143. The STUDENT_GRADES table has these columns:

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

Which statement finds the highest grade point average (GPA) per semester?

#144. In which four clauses can a subquery be used? (Choose four.)

#145. Examine this statement:

 SELECT student_id, gpa FROM student_grades WHERE gpa > &&value;

You run the statement once, and when prompted you enter a value of 2.0. A report is produced. What happens when you run the statement a second time?

#146. Which SQL statement returns a numeric value?

#147. What are two reasons to create synonyms? (Choose two.)

#148. What is true about updates through a view?

#149. You need to write a SQL statement that returns employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.
Which statement accomplishes this task?

#150. The CUSTOMERS table has these columns:

 CUSTOMER_ID         NUMBER(4)        NOT NULL 
 CUSTOMER_NAME       VARCHAR2(100)    NOT NULL 
 STREET_ADDRESS      VARCHAR2(150) 
 CITY_ADDRESS        VARCHAR2(50) 
 STATE_ADDRESS       VARCHAR2(50) 
 PROVINCE_ADDRESS    VARCHAR2(50) 
 COUNTRY_ADDRESS     VARCHAR2(50) 
 POSTAL_CODE         VARCHAR2(12) 
 CUSTOMER_PHONE      VARCHAR2(20)

A promotional sale is being advertised to the customers in France. Which WHERE clause identifies customers that are located in France?

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

gen. 0.07

Server date 06:11 08-01-2009

Oracle 1Z0-035

Forum

Start online exam simulation

Master braindump