1Z0-007 Oracle - Braindumps.com.ua: question list for "Introduction to Oracle9i: SQL", page: 4

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-007: Introduction to Oracle9i: SQL

#31. You query the database with this SQL statement:

 SELECT bonus 
 FROM salary 
 WHERE bonus BETWEEN 1 AND 250 
 OR (bonus IN(190, 500, 600) 
 AND bonus BETWEEN 250 AND 500);

Which value could the statement return?

#32. Examine the structure of the STUDENTS table:

You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999.
Which SQL statement accomplishes this task?

#33. Examine the structure of the LINE_ITEM table.

You must display the order number, line item number, product identification number, and quantity of each item where the quantity ranges from 10 through 100. The order numbers must be in the range of 1500 through 1575. The results must be sorted by order number from lowest to highest and then further sorted by quantity from highest to lowest.
Which statement should you use to display the desired result?

#34. The ITEM table contains these columns:

 ITEM_ID       NUMBER(9) 
 COST          NUMBER(7,2) 
 RETAIL        NUMBER(7,2)

You need to create a report that displays the cost, the retail price, and the profit for item number 783920. To calculate the profit, subtract the cost of the item from its retail price, and then deduct an administrative fee of 25 percent of this derived value.
Which SELECT statement produces the desired results?

#35. The ITEM table contains these columns:

 ITEM_ID       NUMBER(9) 
 COST          NUMBER(7,2) 
 RETAIL        NUMBER(7,2)

The RETAIL and COST columns contain values greater than zero. Evaluate these two SQL statements:

 1. SELECT item_id, (retail * 1.25) + 5.00 - (COST * 1.10) - (COST * .10) 
 AS Calculated Profit FROM item;

 2. SELECT item_id, retail * 1.25 + 5.00 - COST * 1.10 - 
 COST * .10 "Calculated Profit" FROM item;

What will be the result?

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

#37. Which two statements are true about WHERE and HAVING clauses? (Choose two)

#38. You are sorting data in a table in you SELECT statement in descending order. The column you are sorting on contains NULL records, where will the NULL record appears?

#39. The ACCOUNT table contains these columns:

 ACCOUNT_ID            NUMBER(12) 
 PREVIOUS_BALANCE      NUMBER(7,2) 
 PAYMENTS              NUMBER(7,2) 
 NEW_PURCHASES         NUMBER(7,2) 
 CREDIT_LIMIT          NUMBER(7)

You need to display the account number, finance charge, and current balance for accounts 1500 through 2000 with a current balance greater than the account's credit limit. The finance charge is .9 percent (.009) of the previous balance. Adding the previous balance value,new purchases value, and finance charge value, and then subtracting the payments value yields the current balance value.
Evaluate this statement:

 SELECT account_id, NVL(previous_balance, 0) * .009 finance_charge, 
 NVL(new_purchases, 0) + (NVL(previous_balance, 0) * 1.009) - NVL(payments, 0) 
 CURRENT balance 
 FROM account 
 WHERE (new_purchases + (previous_balance * 1.009)) - payments > credit_limit 
 AND account_id BETWEEN 1500 AND 2000;

Which statement about this SELECT statement is true?

#40. Examine the description of the EMPLOYEES table:

Which statement shows the maximum salary paid in each job category of each department?

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

gen. 0.555

Server date 10:29 22-11-2008

Oracle 1Z0-007

Forum

Start online exam simulation

Master braindump

User braindumps