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

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

#11. The EMPLOYEE tables has these columns:

 LAST_NAME        VARCHAR2(35) 
 SALARY           NUMBER(8,2) 
 COMMISSION_PCT   NUMBER(5,2)

You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column. Which SQL statement displays the desired results?

#12. Examine the data from the ORDERS and CUSTOMERS table.

Which SQL statement retrieves the order ID, customer ID, and order total for the orders that are placed on the same day that Martin places his orders?

#13. 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?

#14. Evaluate the SQL statement:

 1 SELECT a.emp_name, a.sal, a.dept_id, b.maxsal 
 2 FROM employees a, 
 3 (SELECT dept_id, MAX(sal) maxsal 
 4 FROM employees 
 5 GROUP BY dept_id) b 
 6 WHERE a.dept_id = b.dept_id 
 7 AND a.sal < b.maxsal;

What is the result of the statement?

#15. Examine the data in the EMPLOYEES and DEPARTMENTS tables:

Also examine the SQL statements that create the EMPLOYEES and DEPARTMENTS tables:

 CREATE TABLE departments 
 (department_id NUMBER PRIMARY KEY, 
 department_name VARCHAR2(30)); 
 CREATE TABLE employees 
 (EMPLOYEE_ID NUMBER PRIMARY KEY, 
 EMP_NAME VARCHAR2(20), 
 DEPT_ID NUMBER REFERENCES 
 departments(department_id), 
 MGR_ID NUMBER REFERENCES 
 employees(employee id), 
 MGR_ID NUMBER REFERENCES 
 employees(employee id), 
 JOB_ID VARCHAR2(15). 
 SALARY NUMBER); 
 ON the EMPLOYEES,

On the EMPLOYEES table, EMPLOYEE_ID is the primary key.
MGR_ID is the ID of managers and refers to the EMPLOYEE_ID.
DEPT_ID is foreign key to DEPARTMENT_ID column of the DEPARTMENTS table. On the DEPARTMENTS table, DEPARTMENT_ID is the primary key.
Examine this DELETE statement:

 DELETE 
 FROM departments 
 WHERE department id = 40;

What happens when you execute the DELETE statement?

#16. Which three are DATETIME data types that can be used when specifying column definitions? (Choose three.)

#17. Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table?

#18. Evaluate the set of SQL statements:

 CREATE TABLE dept 
 (deptno NUMBER(2), 
 dname VARCNAR2(14), 
 loc VARCNAR2(13)); 
 ROLLBACK; 
 DESCRIBE DEPT

What is true about the set?

#19. Which data dictionary table should you query to view the object privileges granted to the user on specific columns?

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

Evaluate this SQL statement:

 SELECT employee_id, e.department_id, department_name, 
 salary 
 FROM employees e, departments d 
 WHERE e.department_id = d.department_id;

Which SQL statement is equivalent to the above SQL statement?

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

gen. 0.134

Server date 06:36 22-11-2008

Oracle 1Z0-035

Forum

Start online exam simulation

Master braindump