1z0-001 Oracle - Braindumps.com.ua: question list for "Ineroduction to oracle:sql and pl/sql", page: 16

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-001: Ineroduction to oracle:sql and pl/sql

#151. In which section of a PL/SQL block is a user-defined exception raised?

#152. Click on the EXHIBIT button and examine the table instance chart for the cars table.

Which SELECT statement will display style, color, and lot number for all cars based on the model entered at the prompt, regardless of case?

#153. In the declarative section of a PL/SQL block, you created but did not initialize a number variable.
When the block executes, what will be the initial value of the variable?

#154. In which order does the Oracle Server evaluate clauses?

#155. You attempt to query the database with this command:

 SELECT dept_no, AVG(MONTHS_BETWEEN(SYSDATE, hire_date)) 
 FROM employee 
 WHERE AVG(MONTHS_BETWEEN(SYSDATE, hire_date)) > 60 
 GROUP BY dept_no 
 ORDER BY AVG(MONTHS_BETWEEN(SYSDATE, hire_date));

Why does this statement cause an error?

#156. The PART table contains these columns:

 ID              NUMBER(7)     PK 
 COST            NUMBER(7,2) 
 PRODUCT_ID      NUMBER(7)

Evaluate these two SQL statements:

 1.SELECT ROUND(MAX(COST),2), 
 ROUND(MIN(COST),2),ROUND(SUM(COST),2), 
 ROUND(AVG(COST),2) 
 FROM part

 2.SELECT product_id, ROUND(MAX(COST),2), 
 ROUND(MIN(COST) 2),ROUND(SUM(COST),2), 
 ROUND(AVG(COST),2) 
 FROM part 
 GROUP BY product_id;

How will the results differ?

#157. You are a user of the PROD database which contains over 1000 tables, and you need to determine the number or tables you can access. Which data dictionary view could you query to display this information?

#158. Evaluate these two SQL commands:

 1. SELECT DISTINCT object_type 
 FROM user_objects;

 2 .SELECT object_type 
 FROM all_objects;

How will the results differ?

#159. How do you send the output of your SQL*PIus session to a text operating system rile called MYOUTPUT .LST?

#160. The PRODUCT table contains these columns:

 ID             NUMBER(9)     PK 
 COST           NUMSER(72) 
 SALE_PRICE     NUMBER(7,2)

Management has asked you to calculate the net revenue per unit for each product if the cost of each product is increased by 10% and the sale price of each product is increased by 25%.
You issue this SQL statement

 SELECT id, sale_price * 1.25- COST * 1.10 
 FROM product

Which conclusion can you draw from the results?

[1] ... [11] [12] [13] [14] [15] [16] [17] [18]

gen. 0.071

Server date 11:39 08-01-2009

Oracle 1z0-001

Forum

Start online exam simulation

Master braindump

User braindumps