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

Профиль

Бреиндампы

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

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

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

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

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

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

Oracle 1Z0-031: Oracle9i: Database Fundamentals I

#41. You use the password utility with this statement to create a password file:
$orapwd file =$ORACLE_HOME/dbs/orapwPROD password=orapass entries=5
You set the REMOTE_LOGIN_PASSWORDFILE initialization parameter to NONE.
You execute this script:

 CREATE USER dba_prod 
 IDENTIFIED BY prod_123; 
 GRANT sysdba TO dba_prod

You issue this command using SQL*Plus:

 CONNECT dba_user/prod_123 AS sysdba;

What will be the result?

#42. You use the password utility with this statement to create a password file:
$orapwd file = $ORACLE_HOME/dbs/orapwPROD password=prodpass entries=5
You set the REMOTE_LOGIN_PASSWORDFILE initialization parameter to EXCLUSIVE, and you execute this script:

 CREATE USER sam 
 IDENTIFIED BY prod_123; 
 GRANT sysdba TO sam

If Sam connects AS SYSDBA, which statement is true?

#43. Using the password utility ORAPWD, you create a password file with a password of 'private'. How could you change the password?

#44. You need to administer the PROD database from a remote location, but you do not have access to a secure connection.
Which authentication method should you use?

#45. You use the password utility with this statement to create a password file:
$ORAPWD file = $ORACLE_HOME/dbs/orapwPROD
password=prodpass entries=5
You set the REMOTE_LOGIN_PASSWORDFILE initialization parameter to EXCLUSIVE, and you issue this command:

 CONNECT sys/change_on_install AS SYSDBA

Which result will occur?

#46. You need to create a view. Which OEM tool should you use?

#47. You use the password utility with this statement to create a password file:
$orapwd password=pass123 entries=5
Which statement about this statement is true?

#48. Which data dictionary view would you use to get a list of object privileges for all database users?

#49. Which type of file is part of the Oracle database?

#50. Consider this SQL statement:

 UPDATE employees SET first_name = 'John' 
 WHERE emp_id = 1009; 
 COMMIT;

What happens when a user issues the COMMIT in the above SQL statement?

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

ген. 0.091

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

Oracle 1Z0-031