Examine the CREATE DISKGROUP command used to create a disk group:
SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY
DISK ’ORCL: FRA3’ NAME misc1, ’ORCL: FRA4’ NAME misc2;
In which situation would you use this method of disk group creation?()
A. When two-way disk mirroring is required for the allocation units
B. When three-way disk mirroring is required for the allocation units
C. When using hardware mirroring or RAID
D. When disk mirroring is required for the Automatic Storage Management (ASM) disks
您可能感兴趣的试卷
你可能感兴趣的试题
A. A job chain can contain a nested chain of jobs
B. The jobs in a job chain cannot have more than one dependency
C. A job of the CHAIN type can be run using event-based or time-based schedules
D. The jobs in a job chain can be executed only by using the events generated by the Scheduler
View the Exhibit and examine the disk groups created at the time of migrating the database storage to Automatic Storage Management (ASM).
Why does the FRA disk group initially have more free space even though both DATA and FRA disk groups are provided with the same size?()
A. Because the FRA disk group will not support dynamic rebalancing
B. Because the FRA disk group is not configured to support mirroring
C. Because disks in the FRA disk group are not formatted at this stage
D. Because the FRA disk group will support only a single size of allocation unit
In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.
Which method must you use to recover the lost data?()
A. Complete Recovery with online redo log
B. Complete Recovery with archived redo log
C. Tablespace Point-in-Time Recovery (TSPITR)
D. Incomplete Recovery with system change number (SCN)
A. Building the SQL profile
B. Recommending optimization of materialized views
C. Checking query objects for missing and stale statistics
D. Recommending bitmap, function-based, and B-tree indexes
E. Recommending restructuring SQL queries that are using bad plans
A. Set MEMORY_TARGET to zero
B. Set the STATISTICS_LEVEL parameter to BASIC
C. Set the WORKAREA_SIZE_POLICY parameter to MANUAL
D. Set the PGA_AGGREGATE_TARGET parameter to nonzero value
A. A user cannot set privileges on the persistent lightweight jobs
B. Persistent lightweight jobs generate a large amount of metadata
C. It is possible to create fully self-contained persistent lightweight jobs
D. The use of a template is mandatory to create persistent lightweight jobs
E. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time
A. Only one window can be open at any given time
B. Consumer groups are associated with windows
C. Windows work with job classes to control resource allocation
D. The database service name must be provided during windows creation
E. Windows can automatically start job or change resource allocation among jobs for various time periods.
A. Backup retention policy
B. Default backup device type
C. Default destinations for backups
D. Multiple backup device types for single backup
E. Default section size for backups
While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed
that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it.
Identify the two events that can occur in the event of a log switch?()
A. An entry is created in the alert log file and the database instance continues to function normally
B. The log switch hangs occur for transactions until free space is available in the flash recovery area
C. The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area
D. The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented
Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.
Which tool or utility would you use to start the listener?()
A. Oracle Net Manager
B. Listener Control utility
C. Database Configuration Assistant
D. Oracle Net Configuration Assistant
最新试题
Which three tasks can be performed using a duplicate database?()
Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN).()
Examine the following RMAN script: RMAN> run { debug on; allocate channel c1 type disk; backup datafile 5; } Which statement describes the purpose of the script?()
You want to configure the Flashback Database feature and retain flashback logs for three days. Presently the database is open and configured in ARCHIVELOG mode. The following steps must be performed in the correct sequence to do this: 1. Set the retention target: SQL> ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320; 2. Enable Flashback Database: SQL> ALTER DATABASE FLASHBACK ON; 3. Mount the database: SQL> STARTUP MOUNT EXCLUSIVE 4. Shutdown the instance: SQL> SHUTDOWN IMMEDIATE 5. Open the database: SQL> ALTER DATABASE OPEN; Choose the correct sequence.()
Which two statements are true about a job chain?()
Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to the tape drive fast enough. What could be a solution to make tape streaming happen during the backup?()
Which three statements are true about persistent configuration?()
Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility would you use to start the listener?()
Which option is best practice for creating a recovery catalog owner in the catalog database?()
Which two statements are true about encrypting RMAN backup?()