1Z0-031 Oracle - Braindumps.com.ua: список вопросов для "Oracle9i: Database Fundamentals I", страница: 7

Профиль

Бреиндампы

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

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

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

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

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

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

Oracle 1Z0-031: Oracle9i: Database Fundamentals I

#61. You used the password file utility to create a password file as follows:
$orapwd file=$ORACLE_HOME/dbs/orapwDB01
password=orapass entries=5
You created a user and granted only the SYSDBA privilege to that user as follows:

 CREATE USER dba_user 
 IDENTIFIED BY dba_pass; 
 GRANT sysdba TO dba_user;

The user attempts to connect to the database as follows:

 CONNECT dba_user/orapass AS sysdba;

Why does the connection fail?

#62. You are creating a new database. You do NOT want users to use the SYSTEM tablespace for sorting operations. What should you do when you issue the CREATE DATABASE statement to prevent this?

#63. An INSERT statement failed and is rolled back. What does this demonstrate?

#64. Select the memory structure(s) that would be used to store the parse information and actual value of the bind variable id for the following set of commands:

 VARIABLE id NUMBER; 
 BEGIN 
 :id:=1; 
 END;

#65. Which constraint state prevents new data that violates the constraint from being entered, but allows invalid data to exist in the table?

#66. What determines the initial size of a tablespace?

#67. Which background process performs a checkpoint in the database by writing modified blocks from the database buffer cache in the SGA to the data files?

#68. A table can be dropped if it is no longer needed, or if it will be reorganized. Which three statements are true about dropping a table? (Choose three.)

#69. A network error unexpectedly terminated a user's database session. Which two events occur in this scenario? (Choose two.)

#70. Which is a complete list of the logical components of the Oracle database?

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

ген. 0.071

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

Oracle 1Z0-031