×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
You work as a database administrator for Certkiller .com. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the
objective, which component would you configure on each database server?
objective, which component would you configure on each database server?
2.
The data file belonging to the SYSTEM tablespace is corrupted and no backup of the file is available.
How do you recover the data file?
How do you recover the data file?
3.
You work as a database administrator for Certkiller .com. You started the instance using the init.ora file. You have two control files and three redo log groups in your database. You decided to protect the database against
failures by adding one more control file.
Which file is the appropriate way to perform this task?
failures by adding one more control file.
Which file is the appropriate way to perform this task?
4.
You work as a database administrator for Certkiller .com. You find that the database performance degrades while you backup the Certkiller database using Recovery Manager (RMAN). The Certkiller database is running
in shared server mode. The database instance is currently using 60% of total operating system memory. You
suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation?
in shared server mode. The database instance is currently using 60% of total operating system memory. You
suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation?
5.
You work as a database administrator for Certkiller .com. In your production database, the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database.
The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database, you want to accomplish this task with no impact on the user's connections.
Which activity must you have completed before accomplishing this task?
The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database, you want to accomplish this task with no impact on the user's connections.
Which activity must you have completed before accomplishing this task?
6.
Which three statements regarding the column-level Virtual Database Policy (VPD) policy are true? (Choose
three.)
7.
Which four policy rule categories are available in the Policy Framework? (Choose four.)
8.
You are checking every 10 minutes for alerts regarding the violation of tablespace usage threshold. Some of the tablespaces' fullness was not detected on time. As a result the transactions were aborted before you had a
chance to resolve the space issue. What would you do to avoid transactional failures?
chance to resolve the space issue. What would you do to avoid transactional failures?
9.
You create a locally managed tablespace by using the following SQL statement:
CREATE TABLESPACE hr_tbs
DATAFILE 'data.dat' SIZE 1M REUSE
AUTOEXTEND ON MAXSIZE 100M;
The warning and critical tablespace usage threshold values are set to 85% and 97%, respectively. Which two
statements regarding the threshold-based alerts generation for the HR_TBS tablespace are correct? (Choose
two.)
10.
While using buffer cache advisory, you find that no statistics have been collected. Which task would you perform to collect the statistics?