×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
Which command meets these two criteria?
1 Runs the backup at full speed
2 Either finishes the task in the allotted time, or terminates Recovery Manager (RMAN) with an error if it fails to finish the task in the allotted time.
1 Runs the backup at full speed
2 Either finishes the task in the allotted time, or terminates Recovery Manager (RMAN) with an error if it fails to finish the task in the allotted time.
2.
A query on the sales table returned the following error:
Tue May 11 07:05:40 2004
Some indexes or index [sub]partitions of table
SCOTT. SALES have been marked unusable.
Which statement caused this error to be returned when you issued the query?
Tue May 11 07:05:40 2004
Some indexes or index [sub]partitions of table
SCOTT. SALES have been marked unusable.
Which statement caused this error to be returned when you issued the query?
3.
You set SGA parameters in your database as:
DB_CACHE_SIZE=24MB
JAVA_POOL_SIZE=48MB
SHARED_POOL_SIZE=96MB
You plan to upgrade to Oracle Database 10g. You need to provide an additional 20 MB memory space to accommodate internal overhead allocations for metadata.
Which SGA parameter(s) would you modify?
DB_CACHE_SIZE=24MB
JAVA_POOL_SIZE=48MB
SHARED_POOL_SIZE=96MB
You plan to upgrade to Oracle Database 10g. You need to provide an additional 20 MB memory space to accommodate internal overhead allocations for metadata.
Which SGA parameter(s) would you modify?
4.
What does the Character Set Scanner command line utility do?
5.
Which Oracle-supplied package is used by Data Pump Export and Import worker processes to load and unload metadata information?
6.
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/D*'; Which task would be accomplished by the command?
disk, /devices/D4, to the disk group dgroupA and execute the following command: SQL> ALTER DISKGROUP dgroupA ADD DISK '/devices/D*'; Which task would be accomplished by the command?
7.
You set SGA parameters in your database as: DB_CACHE_SIZE =24 MB JAVA_POOL_SIZE =48 MB
SHARED_POOL_SIZE =96 MB You plan to upgrade to Oracle Database 10 g . You need to provide an additional 20 MB memory space to accommodate internal overhead allocations for metadata. Which SGA parameter(s) would you modify?
SHARED_POOL_SIZE =96 MB You plan to upgrade to Oracle Database 10 g . You need to provide an additional 20 MB memory space to accommodate internal overhead allocations for metadata. Which SGA parameter(s) would you modify?
8.
Consider the following command to add a new disk group called "tdgroupA" with two failover groups:
CREATE DISKGROUP tdgrouopA NORMAD REDUNDANCY
FAILOVERGROUP control01 DISK
'/devices/A1',
'/devices/A2',
'/devices/A3'
FAILOVERGROUP control02 DISK
'/devices/B1',
'/devices/B2',
'/devices/B3';
The disk "/devices/A1" is currently a member disk of a disk group by name "tdgroup1"
Which task would be accomplished by the command?
CREATE DISKGROUP tdgrouopA NORMAD REDUNDANCY
FAILOVERGROUP control01 DISK
'/devices/A1',
'/devices/A2',
'/devices/A3'
FAILOVERGROUP control02 DISK
'/devices/B1',
'/devices/B2',
'/devices/B3';
The disk "/devices/A1" is currently a member disk of a disk group by name "tdgroup1"
Which task would be accomplished by the command?
9.
You want the database to send an e-mail to the senior database administrator whenever the Warning threshold for the Database CPU time metric is reached. Which option would you use to accomplish this activity?
10.
Which Oracle-supplied package is used by Data Pump Export and Import worker processes to load and unload metadata information?