1z0-042 Oracle - Braindumps.com.ua: список вопросов для "Oracle Database 10g: Administration I", страница: 5

Профиль

Бреиндампы

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

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

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

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

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

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

Oracle 1z0-042: Oracle Database 10g: Administration I

#41. Your boss at Company.com wants you to clarify Oracle 10g. Which statement regarding the contents of the V$PARAMETER view is true?

#42. Exhibit, HR Database properties

You work as a database administrator for Company.com. You have two database, SALES and HR; created on the same machine using Oracle database 120g. For the SALES database, the initialization parameter COMPTIBLE is set to 9.2.0 and for the HR database, COMPATIBLE is set to 10.0 .0. The sales_tbs tablespace is create in the SALES database as follows:

 CREATE TABLESPACE sales_tbs DATAFILE '/Company/Companydata/sales_tbs.dbf'

The hr_tbs tablespace created in the HR database is as follows:

 CREATIVE TABLESPACE hr_tbs DATAFILE '/Company/Companydata/hr_tbs.dbf' SIZE 50M

Which two statements are correct in this scenario?

#43. You work as a database administrator for Company.com. In your development environment environment, the developers are responsible for modifying the table structure according to the application requirements. However, you want to keep track of the ALTER TABLE commands being executed by developers, so you enable auditing to achieve this objective. Which two views would you refer to find out the audit information? Choose two

#44. Your boss at Company.com wants you to clarify Oracle 10g. Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correcte? Choose two.

#45. You work as a database administrator for Company.com. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason, an d you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views, you find that the buffer cache hit ratio is 81% but no alerts are being generated.
What could be the reason for this problem?

#46. You work as a database administrator for Company.com. In your transaction application, you have scheduled a job to update the optimizer statistics at 05:00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected? Choose three

#47. You work as a database administrator for Company.com. You want to be notified when the number of disk I/O increases by 10% of what it was yesterday. You create a baseline metric for yesterday's disk I/O performance. How do you use the baseline metrics to achieve your objective?

#48. You work as a database administrator for Company.com. in the production database you have granted resumable system privilege to the connect role. resumable space operation has been enabled for all user session. you want users not to be aware of any kind of space-related problems while performing transactions. instead, you want the problem to be resolved by a database trigger automatically.
Which combination of triggering time and event would you use to achieve this objective?

#49. You work as a database administrator for Company.com. You enabled tracing while creating a listener to your database.
What additional information is available to you when you enable tracing?

#50. You work as a database administrator for Company.com. Your database is in NOARCHIVELOG mode and you want to perform a backup.
Which type of backup would be appropriate in this case?

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

ген. 0.066

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

Oracle 1z0-042