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

Профиль

Бреиндампы

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

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

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

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

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

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

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

#31. You have decided to permanently remove all the data from the STUDENT table, and you need the table structure in the future. Which single command performs this?

#32. Which table name is valid?

#33. Examine the structure of the STUDENT table:

 Name          Null?       Type 
 STUD ID       NOT NULL    NUMBER(S) 
 NAME          NOT NULL    VARCHAR2(25) 
 PHONE         NOT NULL    VARCHAR2(9) 
 ADDRESS                   VARCHAR2(50) 
 GRADUATION                DATE

There are 100 records in the STUDENT table. You want to change the name of the GRADUATION column to GRAD_DATE.
Which statement is true?

#34. You need to update employee salaries. If the salary of an employee is less than 1000, the salary needs to be incremented by 10%. Use a SQL*PIus substitution variable to accept the employee number.
Which PL/SQL block successfully updates the salaries?

#35. Within a PL/SQL loop, you need to test if the current fetch was successful. Which SQL cursor attribute would you use to accomplish this task?

#36. Which two conditions in a PL/SQL block cause an exception to occur? (Choose two.)

#37. Evaluate this PL/SQL block:

 BEGIN 
 FOR i IN 1.10 LOOP 
 IF i = 4 OR i = 6 THEN 
 NULL; 
 ELSE 
 INSERT INTO test(results) 
 VALUES (I); 
 END IF; 
 COMMIT; 
 END LOOP; 
 ROLLBACK; 
 END;

How many values will be inserted into the TEST table?

#38. Which statement about multiple column sub queries is true?

#39. Examine the results from the report:

 Department       %Employees     %Salary 
 10               21.43          30.152 
  0               35.71          37.47 
 30               42.86          32.39

Which SELECT statement produces the report?

#40. Examine the code:

 SELECT employee.ename 
 FROM emp employee 
 WHERE employee.empno NOT IN 
 (SELECT manager.mgr 
 FROM emp manager);

What is the NOT IN operator equivalent to, in the above query?

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

ген. 0.063

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

Oracle 1z0-001