1Z0-035 Oracle - Braindumps.com.ua: question list for "Oracle 7.3 & 8 to Oracle9i DBA OCP Upgrade", page: 16

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

#151. Which are iSQL*Plus commands? (Choose all that apply.)

#152. Examine the description of the CUSTOMERS table:

 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)

The CUSTOMER_ID column is the primary key for the table. Which statement returns the city address and the number of customers in the cities Los Angeles or San Francisco?

#153. What does the FORCE option for creating a view do?

#154. A data manipulation language statement _____.

#155. Which two tasks can you perform using only the TO_CHAR function? (Choose two.)

#156. The DBA issues this SQL command:
CREATE USER scott IDENTIFIED by tiger;
What privileges does the user Scott have at this point?

#157. View the image below and examine the data in the EMPLOYEES table. Examine the subquery:

 SELECT last_name 
 FROM employees 
 WHERE salary IN (SELECT MAX(salary) 
 FROM employees 
 GROUP BY department_id);

Which statement is true?

#158. Examine the statement:
GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION; Which two are true? (Choose two.)

#159. Which best describes an inline view?

#160. Examine the structure of the EMPLOYEES and DEPARTMENTS tables:

 EMPLOYEES 
 EMPLOYEE_ID         NUMBER 
 DEPARTMENT_ID       NUMBER 
 MANAGER_ID          NUMBER 
 LAST_NAME           VARCHAR2(25) 
 DEPARTMENTS 
 DEPARTMENT_ID       NUMBER 
 MANAGER_ID          NUMBER 
 DEPARTMENT_NAME     VARCHAR2(35) 
 LOCATION_ID         NUMBER

You want to create a report displaying employee last names, department names, and locations. Which query should you use to create an equi-join?

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

gen. 0.069

Server date 06:07 08-01-2009

Oracle 1Z0-035

Forum

Start online exam simulation

Master braindump