|
|
Authorized user can see question and answers.
Please log in or sign up. 
|
#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?
Show comments for this question (0)
Add comments
Link to this question
|
|
#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
Show comments for this question (1)
Add comments
Link to this question
|
|
#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?
Show comments for this question (0)
Add comments
Link to this question
|
|
#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
Show comments for this question (0)
Add comments
Link to this question
|
|
#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?
Show comments for this question (0)
Add comments
Link to this question
|
|
#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?
Show comments for this question (0)
Add comments
Link to this question
|
|
|
|
 gen. 0.058
|
Server date 05:52 02-12-2008
|
Developed by Zip © 2006
|
|
|
|
|
Forum
Master braindump