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

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

#121. The EMPLOYEES table contains these columns:

 EMPLOYEE_ID    NUMBER(4) 
 ENAME          VARCHAR2 (25) 
 JOB_ID         VARCHAR2(10)

Which SQL statement will return the ENAME, length of the ENAME, and the numeric position of the letter "a" in the ENAME column, for those employees whose ENAME ends with a the letter "n"?

#122. Which four are valid Oracle constraint types? (Choose four.)

#123. Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?

#124. Which is an iSQL*Plus command?

#125. 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)

Which statement produces the number of different departments that have employees with last name Smith?

#126. Top N analysis requires _____ and _____. (Choose two.)

#127. Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?

#128. Evaluate this SQL statement:

 SELECT ename, sal, 12*sal+100 FROM emp;

The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"?

#129. You are the DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table.
Which set of statements accomplishes this?

#130. You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty.
Which statement accomplishes this task?

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

gen. 0.059

Server date 05:57 08-01-2009

Oracle 1Z0-035

Forum

Start online exam simulation

Master braindump