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

Профиль

Бреиндампы

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

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

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

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

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

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

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

#51. For which three tasks would you use the WHERE clause? (Choose three.)

#52. As a DBA, you have just created a user account for employee Smith by using the CREATE USER command Smith should be able to create tables and packages in his schema. Which command will the DBA need to execute next so that Smith can perform his tasks successfully?

#53. Which privilege concerns system level security?

#54. Evaluate this SQL script:

 CREATE ROLE manager; 
 CREATE ROLE clerk; 
 CREATE ROLE inventory; 
 CREATE USER scott IDENTIFIED BY tiger; 
 GRANT inventory TO clerk; 
 GRANT clerk TO manager; 
 GRANT inventory TO scott

How many roles will user SCOTT have access to?

#55. You want to retrieve the employee details from the EMP table and process them in PL/SQL block, Which type of variable do you create in the PL/SQL block to retrieve all the rows and columns using a single SELECT statement from the EMP table?

#56. The EMPLOYEE table contains these columns:

 LAST_NAME      VARCHAR2(25) 
 FIRST_NAME     VARCHAR2(25) 
 SALARY         NUMBER(7,2)

You need to display the names of employees that earn more than the average salary of all employees.
Evaluate this SQL statement

 SELECT last_name, first_name 
 FROMemployee 
 WHEREsalary > AVG(salary);

Which change should you make to achieve the desired results?

#57. You attempt to query the database with this command:

 SELECT name, salary 
 FROM employee 
 WHERE salary = 
 (SELECT salary 
 FROM employee 
 WHERE last_name = ‘Wagner’ OR dept_no = 233);

Why could this statement cause an error?

#58. In which section of a PL/SQL block is a user-defined exception raised?

#59. Which script would you use to query the data dictionary to view only the name of the primary key constraints by using a substitution parameter for the table name?

#60. You are a user of the PROD database which contains over 1000 tables, and you need to determine the number of tables you can access. Which data dictionary view could you query to display this information?

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

ген. 0.099

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

Oracle 1z0-001