Examine the following ALTER command:SQ...

单项选择题 Examine the following ALTER command:
SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;
What is the purpose of the command?（）

A. It cancels all pending disk drops within the disk group.
B. It restores disks that are being dropped as the result of a DROP DISKGROUP operation
C. It mounts disks in the disk group for which the drop-disk operation has already been co pleted
D. It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed
E. It adds previously dropped disks back into the disk group

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题 You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task:

Which option illustrates the correct sequence that you must use?（）

A. 8, 1, 3, 2, 4, 5, 7, 6
B. 1, 8, 3, 4, 2, 5, 7, 6
C. 1, 3, 4, 2, 8, 5, 6, 7
D. 1, 3, 2, 4, 6, 5, 7, 8

点击查看答案

2.多项选择题Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN)while duplicating a running database?（）

A. Creating the control file for the duplicate database
B. Restoring the target data files to the duplicate database
C. Performing complete recovery using all available backups
D. Generating a new, unique DBID for the duplicate database
E. Copying the online redo log files from the target database to the duplicate database

点击查看答案

3.单项选择题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?（）

A. Configure backup optimization
B. Configure the channel to increase MAXOPENFILES
C. Configure the channel to increase the capacity with the RATE parameter
D. Configure the channel to adjust the tape buffer size with the BLKSIZE option

点击查看答案

4.多项选择题 The user SYS creates a job by using the following command:

Which two statements are true about the job that was created by the preceding command?（）

A. The job is enabled by default after creation
B. The job is automatically dropped after the end date
C. The job executes with the privileges of the user SYS
D.

点击查看答案

5.多项选择题Which three tasks can be performed using a duplicate database?（）

A. Testing the backup and recovery procedures
B. Testing the upgrade of an Oracle database to a new release
C. Testing the effect of an application changes on database performance
D. Continuously updating archive log files from the target database to support failover

点击查看答案

6.单项选择题 Examine the CREATE DISKGROUP command used to create a disk group:

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

点击查看答案

7.单项选择题 You executed the following commands in a database session:

What could have caused the recycle bin to clean up?（）

A. There is demand for space from the new table从
B. The undo tablespace does not have sufficient free space
C. The new table name is the same as the table name in the recycle bin
D. The temporary tablespace that is assigned to you does not have sufficient free space

点击查看答案

8.单项选择题 View the exhibit and examine the TRANS table's storage information.

After a massive delete operation, you executed the following statement to shrink the TRANS table:
SQL> ALTER TABLE trans SHRINK SPACE CASCADE;
Which statement describes the outcome of the command?（）

A. An error is produced.
B. The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjusted
C. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchanged
D. The unused space in the table is reclaimed and returned to the tablespace and the data manipulation language (DML) triggers on the table are fired during the shrinking process

点击查看答案

9.多项选择题Which two statements are true about a job chain?（）

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

点击查看答案

10.单项选择题 Note the following statements that use flashback technology:
1. FLASHBACK TABLE <table> TO SCN <scn>;
2. SELECT * FROM <table> AS OF SCN 123456;
3. FLASHBACK TABLE <table> TO BEFORE DROP;
4. FLASHBACK DATABASE TO TIMESTAMP <timestamp>;
5. SELECT * FROM <table> VERSIONS AS OF SCN 123456 AND 123999;
Which of these statements will be dependent on the availability of relevant undo data in the undo segment?（）

A. 1, 2, and 5
B. 1, 3, and 4
C. 2, 3, 4, and 5
D. 1, 2, 3, 4, and 5

点击查看答案