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

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

car insurance quotes (1)

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

#1. Examine the data in the EMPLOYEES and DEPARTMENTS tables.

You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use?

#2. Examine the structure of the EMPLOYEES table:

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

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

#3. You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others.
Which statement accomplishes this?

#4. Examine the data in the EMPLOYEES table:

Which three subqueries work? (Choose three)

#5. The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table.
As a user of the database, you created a table called HR in your schema.
What happens when you execute this query?

 SELECT * 
 FROM HR;

#6. Which two statements about views are true? (Choose two.)

#7. Examine the description of the EMPLOYEES table:

 EMP_ID         NUMBER(4)         NOT NULL 
 LAST_NAME      VARCHAR2(30)      NOT NULL 
 FIRST_NAME     VARCHAR2(30) 
 DEPT_ID        NUMBER(2) 
 JOB_CAT        VARCHARD2(30) 
 SALARY         NUMBER(8,2)

Which statement shows the maximum salary paid in each job category of each department?

#8. Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns:

 LAST NAME         VARCNAR2(35)     NOT NULL 
 SALARY            NUMBER(9,2)      NOT NULL 
 COMMISION_PCT     NUMBER(4,2)

Which statement ensures that a value is displayed in the calculated columns for all employees?

#9. Which syntax turns an existing constraint on?

#10. Examine the description of the STUDENTS table:

 STD_ID       NUMBER(4) 
 COURSE_ID    VARCHARD2(10) 
 START_       DATE DATE 
 END_DATE     DATE

Which two aggregate functions are valid on the START_DATE column? (Choose two)

[1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] ... [85]

gen. -0.094

Server date 06:22 22-08-2008

Oracle 1Z0-035

Forum

Start online exam simulation

Master braindump