1z0-001 Oracle - Braindumps.com.ua: список вопросов для "Ineroduction to oracle:sql and pl/sql", страница: 8

Профиль

Бреиндампы

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

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

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

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

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

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

Oracle 1z0-001: Ineroduction to oracle:sql and pl/sql

#71. The EMPLOYEE table contains these columns:

 ID                NUMBER(9)     PK 
 LAST_NAME         VARCHAR2(25)  NN 
 DEPT ID           NUMBER(9)

Evaluate this SQL script

 DEFINE id_2 = 93004 
 SELECT * 
 FROMemployee 
 WHEREid = (&id_2)

Which change should you make to the script so that it will execute?

#72. Evaluate this SQL statement

 SELECTe.id, (.15 * e.salary) + (.25 * e.bonus) +  
 (s.sale_amount * (.15 * e.commission_pct)) 
 FROMemployee e, sale s 
 WHEPEe.id = s.emp_id;

What would happen if you removed all the parentheses from the calculation?

#73. Which is NOT an SQL*PIus command?

#74. When selecting data, which statement is valid about projection?

#75. Click on the EXHIBIT button and examine the table instance chart for the employee table.

You want to display each employee’s hire date from earliest to latest, Which SQL statement would you use?

#76. The EMPLOYEE table contains these columns:

 ID              NUMBER(9) 
 LAST_NAME       VARCHAR2(25) 
 FIRST_NAME      VARCHAR2(25) 
 COMMISSION      NUMBER(7,2)

You need to display the current commission for all employees. These are the desired results:
1.Display the commission multiplied by 1.5.
2.Exclude employees with a zero commission.
3.Display a zero for employees with a null commission value.
Evaluate this SQL command:

 SELECT id, last_name, first_name, commission * 1.5 
 FROM employee 
 WHEREcommission <> 0;

What does the statement provide?

#77. Which statement is true about nesting blocks?

#78. Examine the code:

 1 DECLARE 
 2 iNUMBER:=0; 
 3 v_date DATE; 
 4 BEGIN 
 5 i := i+1; 
 6 LOOP 
 7 v_date := v_date + 5; 
 B i := i+1; 
 9 EXIT WHEN i = 5; 
 10 END LOOP; 
 11 END;

You have encountered unexpected results when the above block of code is executed. How can you trace the values of the counter variable I and date variable V_DATE in the SQL*Plus environment?

#79. Examine the code:

 SET SERVEROUTPUT ON 
 DECLARE 
 v_name emp.ename%TYPE; 
 v_num NUMBER; 
 v_sal NUMBER(8,2); 
 BEGIN

-- This code displays salaries if larger than 10000

 SELECT ename, sal 
 INTO v_name, v_sal 
 FROM emp 
 WHERE empno = 101; 
 IF (v_sal .GT. 10000) THEN 
 DBMS_OUTPUT PUT_LINE (‘Salary IS ‘|| v_sal 
 || ‘FOR employee ‘|| v_name); 
 END IF; 
 END; 
 SET SERVEROUTPUT OFF

Which statement causes a compilation error when the above PLJSQL block is executed?

#80. The EMPLOYEE table has ten columns. Since you often query the table with conditions based on four or more columns, you created an index on all the columns in the table. Which result will occur?

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

ген. 0.08

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

Oracle 1z0-001