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

Профиль

Бреиндампы

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

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

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

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

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

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

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

#81. You issue this command:

 CREATE PUBLIC SYNONYM emp 
 FOR ed.employee;

Which task has been accomplished?

#82. Click on the EXHIBIT button and examine the table instance chart for the patient table.

You created the patient_id_seq sequence to be used with the patient table’s primary key column. The sequence begins at 1000, has a maximum value of 999999999, and increments by 1. You need to write a script to insert a row into the patient table and use the sequence you created. Which script would you use to complete this task?

#83. Given this CURSOR statement

 DECLARE 
 CURSOR query_cursor (v_salary) IS 
 SELECT last_name, salary, dept_no 
 FROM employee 
 WHERE salary > v_salary;

Why does this statement cause an error?

#84. Which SELECT statement would you use in a PL/SQL block to query the employee table and retrieve the last name and salary of the employee whose id is 3?

#85. Evaluate this PL/SQL block:

 DECLARE 
 v_result NUMBER(2); 
 BEGIN 
 DELETE 
 FROM employee 
 WHERE dept_id IN (10, 20, 30); 
 v_result := SQL%ROWCOUNT; 
 COMMIT; 
 END;

What will be the value of V_RESULT if no rows are deleted?

#86. Evaluate this PL/SQL block:

 BEGIN 
 FOR i IN 1 .5 LOOP 
 IF i = 1 THEN NULL; 
 ELSIF i = 3 THEN COMMIT; 
 ELSIF i = 5 THEN ROLLBACK; 
 ELSE INSERT INTO test(results) VALUES(i); 
 END IF; 
 END LOOP; 
 COMMIT; 
 END;

How many values will be permanently inserted into the TEST table?

#87. You need to create a PL/SQL program to insert records into the employee table. Which block of code successfully uses the INSERT command?

#88. The structure of the DEPT table is as follows:

 Name       Null?         Type 
 DEPTNO     NOT NULL      NUMBER(2) 
 DNAME                    VARCHAR2(14) 
 LOC                      VARCHAR2(13)

Examine the declaration section:

 DECLARE 
 TYPE dept_table_type IS TABLE OF dept%ROWTYPE 
 INDEX BY BINARY_INTEGER; 
 dept_table dept_table_type;

You need to assign the LOC field in record 15, the value of ‘Atlanta’. Which PL/SQL statement makes this assignment?

#89. Examine the structure of the STUDENT table:

 Name             Null             Type 
 STUD_ID          NOT NULL         NUMBER(S) 
 NAME             NOT NULL         VARCHAR2(25) 
 ADDRESS                           VARCHAR2(50) 
 GRADUATION                        DATE

Which statement inserts a new row into the STUDENT table?

#90. You are updating the employee table. Jane has been granted the same privileges as you on the employee table. You ask Jane to log on to the database to check your work before you issue a COMMIT command. What can Jane do to the employee table?

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

ген. 0.104

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

Oracle 1z0-001