×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
Which process performs the rebalance data extent movements across ASM disk groups in ASM?
2.
You want to have a compatible audit trail of everything that has happened to the jobs in the job class named JOB_CLASSA.
What should the logging level be for JOB_CLASSA?
What should the logging level be for JOB_CLASSA?
3.
The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump. Which option of Data Pump Import would you
use to accomplish this?
use to accomplish this?
4.
Consider the following configuration:
/devices/D1 is a member of disk group dgroupA.
/devices/D2 is a member of disk group dgroupA.
/devices/D3 is a member of disk group dgroupA.
You plan to add a new disk, /devices/D4, to the disk group dgroupA and execute the following command:
SQL> ALTER DISKGROUP dgroupA ADD DISK '/devices/D4' ;
Which task would be accomplished by the command?
/devices/D1 is a member of disk group dgroupA.
/devices/D2 is a member of disk group dgroupA.
/devices/D3 is a member of disk group dgroupA.
You plan to add a new disk, /devices/D4, to the disk group dgroupA and execute the following command:
SQL> ALTER DISKGROUP dgroupA ADD DISK '/devices/D4' ;
Which task would be accomplished by the command?
5.
Which task would you perform to convert little-endian CLOB data to the big endian format while transporting from Oracle9i database to Oracle 10g database?
6.
The system was running a normal workload during the last 24 hours. You need to ensure that with the same workload you should be able to flashbash tables by three hours.
What would you do to find the system recommendations for the undo retention period and the undo tablespace size?
What would you do to find the system recommendations for the undo retention period and the undo tablespace size?
7.
You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace:
ALTER TABLE employee SHRINK SPACE CASCADE;
Which statement is correct in this scenario?
ALTER TABLE employee SHRINK SPACE CASCADE;
Which statement is correct in this scenario?
8.
How frequently does the Automatic Database Diagnostic Monitor (ADDM) analysis run by default?
9.
Which four statements regarding the block change track file are correct? (Choose four)
10.
You define the Warning threshold for the tablespace usage metric for the USERS tablespace to be 35%. Because of this, several alerts are being raised. After observing this, you decide to increase the Warning
threshold and clear all old alerts related to tablespace usage metric. Where would you fund the information about cleared alerts?
threshold and clear all old alerts related to tablespace usage metric. Where would you fund the information about cleared alerts?