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

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

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

#71. Examine the structure of the EMPLOYEES table:

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

What is the correct syntax for an inline view?

#72. Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater then 5000?

#73. When should you create a role? (Choose two)

#74. Which three statements about subqueries are true? (Choose three)

#75. Examine the structure of the EMPLOYEES table:

 EMPLOYEE_ID      NUMBER NOT NULL 
 EMP_NAME         VARCHAR2(30) 
 JOB_ID           VARCHAR2(20) DEFAULT 'SA_REP' 
 SAL              NUMBER 
 COMM_PCT         NUMBER 
 MGR_ID           NUMBER 
 DEPARTMENT_ID    NUMBER

You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below:
JOB_ID: Default value specified for this column definition.
SAL: Maximum salary earned for the job ID SA_REP.
COMM_PCT: Default value specified for this commission percentage column, if any.
If no default value is specified for the column, the value should be NULL.
DEPARTMENT_ID: Supplied by the user during run time through substitution variable.
Which UPDATE statement meets the requirements?

#76. Which two statements about sequences are true? (Choose two)

#77. Which four are correct guidelines for naming database tables? (Choose four)

#78. Examine the structure of the EMPLOYEES table:

 Column name        Data type    Remarks 
 EMPLOYEE_ID        NUMBER       NOT NULL, Primary Key 
 LAST_NAME          VARCNAR2(30) 
 FIRST_NAME         VARCNAR2(30) 
 JOB_ID             NUMBER 
 SAL                NUMBER 
 MGR_ID             NUMBER       References EMPLOYEE_ID column 
 DEPARTMENT_ID      NUMBER

You need to create an index called NAME_IDX on the first name and last name fields of the EMPLOYEES table. Which SQL statement would you use to perform this task?

#79. Which operator can be used with a multiple-row subquery?

#80. Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables.

For which situation would you use a nonequijoin query?

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

gen. 0.289

Server date 06:26 22-11-2008

Oracle 1Z0-035

Forum

Start online exam simulation

Master braindump