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

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

#51. Examine the structures of the PATIENT, PHYSICIAN, and ADMISSION tables.

Which SQL statement will produce a list of all patients who have more than one physician?

Show comments for this question (1)
Add comments
Link to this question

#52. Which clause should you use to exclude group results?

Show comments for this question (1)
Add comments
Link to this question

#53. In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement?

Show comments for this question (1)
Add comments
Link to this question

#54. Which two are character manipulation functions? (Choose two.)

Show comments for this question (1)
Add comments
Link to this question

#55. The EMPLOYEES table contains these columns:

You need to write a query that will produce these results:
1. Display the salary multiplied by the commission_pct.
2. Exclude employees with a zero commission_pct.
3. Display a zero for employees with a null commission value.
Evaluate the SQL statement:

 SELECT LAST_NAME, SALARY*COMMISSION_PCT 
 FROM EMPLOYEES 
 WHERE COMMISSION_PCT IS NOT NULL;

What does the statement provide?

Show comments for this question (1)
Add comments
Link to this question

#56. Examine the structures of the EMPLOYEE and CURR_ORDER tables as shown below:

You queried the database with this SQL statement:

 SELECT a.last_name, a.first_name, a.job_id, NVL(a.commission, 0), b.avgcomm 
 FROM employee a, (SELECT job_id, AVG(commission) AVGCOMM 
 FROM employee 
 WHERE commission IS NOT NULL 
 GROUP BY job_id) b 
 WHERE a.job_id = b.job_id 
 AND a.commission < b.avgcomm;

Which is a result of this query?

Show comments for this question (1)
Add comments
Link to this question

#57. Examine the structures of the EMPLOYEE and CURR_ORDER tables.

To keep your top sales representatives motivated, your company plans to increase the bonuses of employees. You need to create a SELECT statement that returns the name, bonus, and maximum order amount associated with each employee for all employees whose bonus is less than 8 percent of their maximum order amount.
Which SELECT statement should you use?

Show comments for this question (1)
Add comments
Link to this question

#58. The PRODUCT table contains these columns:

 PRODUCT_ID       NUMBER(9) 
 PRODUCT_NAME     VARCHAR2(25) 
 COST             NUMBER(5,2) 
 LIST_PRICE       NUMBER(5,2) 
 SUPPLIER_ID      NUMBER(9)

You need to display product names, costs, supplier ids, and average list prices for all the products that cost more than the average cost of products provided by the same supplier. Which SELECT statement will achieve these results?