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

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

#21. The EMP table contains these columns:

 LAST NAME        VARCHAR2(25) 
 SALARY           NUMBER(6,2) 
 DEPARTMENT_ID    NUMBER(6)

You need to display the employees who have not been assigned to any department. You write the SELECT statement:

 SELECT LAST_NAME, SALARY, DEPARTMENT_ID 
 FROM EMP 
 WHERE DEPARTMENT_ID = NULL;

What is true about this SQL statement?

#22. Evaluate the SQL statement:

 SELECT ROUND(TRUNC(MOD(1600,10),-1),2) 
 FROM dual;

What will be displayed?

#23. Examine the description of the MARKS table:

 STD_ID           NUMBER(4) 
 STUDENT_NAME     VARCHAR2(30) 
 SUBJ1            NUMBER(3) 
 SUBJ2            NUMBER(3)

SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects. Examine this SELECT statement based on the MARKS table:

 SELECT subj1+subj2 total_marks, std_id 
 FROM marks 
 WHERE subj1 > AVG(subj1) AND subj2 > AVG(subj2) 
 ORDER BY total_marks;

What is the result of the SELECT statement?

#24. Which /SQL*Plus feature can be used to replace values in the WHERE clause?

#25. You want to display the titles of books that meet these criteria:
1. Purchased before January 21, 2001
2. Price is less then $500 or greater than $900
You want to sort the results by their data of purchase, starting with the most recently bought book.
Which statement should you use?

#26. Which statement explicitly names a constraint?

#27. Examine the SQL statements that creates ORDERS table:

 CREATE TABLE orders 
 (SER_NO NUMBER UNIQUE, 
 ORDER_ID NUMBER, 
 ORDER_DATE DATE NOT NULL 
 STATUS VARCHARD2(10) 
 CHECK (status IN (‘CREDIT’,’CASH’)), 
 PROD_ID_NUMBER 
 REFERENCES PRODUCTS(PRODUCT_ID), 
 ORD_TOTAL NUMBER, 
 PRIMARY KEY (ORDER id, ORDER DATE));

For which columns would an index be automatically created when you execute the above SQL statement? (Choose two)

#28. You created a view called EMP_DEPT_VU that contains three columns from the EMPLOYEES and DEPARTMENTS tables:
EMPLOYEE_ID, EMPLOYEE_NAME AND DEPARTMENT_NAME.
The DEPARTMENT_ID column of the EMPLOYEES table is the foreign key to the primary key DEPARTMENT_ID column of the DEPARTMENTS table.
You want to modify the view by adding a fourth column, MANAGER_ID of NUMBER data type from the EMPLOYEES tables.
How can you accomplish this task?

#29. For which two constraints does the Oracle Server implicitly create a unique index? (Choose two.)

#30. Which three SELECT statements displays 2000 in the format “$2,000.00”? (Choose three)

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

gen. 0.876

Server date 09:02 22-11-2008

Oracle 1Z0-035

Forum

Start online exam simulation

Master braindump