1Z0-007 Oracle - Braindumps.com.ua: список вопросов для "Introduction to Oracle9i: SQL", страница: 6

Профиль

Бреиндампы

Получить последний дамп

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

Логин:
Пароль:
запомнить меня:

Контакты
Сайты по тематике
Cсылки

Авторизированые пользователи могут видеть ответы к вопросам.
Пожалуйста, авторизируйтесь или зарегистрируйтесь.

Список вопросов к экзамену:
Показать все комментарии

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?

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

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

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

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

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

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

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

#59. Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"?

#60. The CUSTOMERS table has these columns:

The CUSTOMER_ID column is the primary key for the table. Which two statements find the number of customers? (Choose two.)

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

ген. 0.071

Дата сервера 09:56 09-01-2009

Oracle 1Z0-007