|
|
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)
|
|
|
|
 gen. 0.117
|
Server date 20:06 12-03-2010
|
Developed by Zip © 2006
|
|
|
|
|
1Z0-035 certification
1Z0-035 master dump