You are creating a cluster. The tables in the cluster have a relatively uniform distribution of values in the index column and the queries against the clustered table will almost use an equality operator to retrieve the desired row. Which type of cluster will you create?()
A、 Index cluster
B、 Hash cluster
C、 Sorted Hash cluster
D、 Real Application Cluster
相关问题推荐
-
You are the Database Administrator for WonderWeb, which has recently acquired a media company TXGlobal. You have been assigned the task to migrate all the database applications of TXGlobal to the database server of WonderWeb. To accommodate more database applications, you need to add disks to the existing disk group. Whenever you add or remove disks from the disk group, Automatic Storage Management (ASM) rebalancing distributes the data evenly across all the disks of the disk group. Which background process performs this actual rebalancing activity, resulting in the movement of data extents in the disk groups?()
A、 ASMB
B、 ARBn
C、 RBAL in the ASM instance
D、 RBAL in the database instance
-
View the Exhibit.You executed the following command to perform a backup of the USERS tablespace: RMAN> BACKUP TABLESPACE USERS; Which three types of files are backed up? ()
Aall the data files belonging to the USERS tablespace
Bpassword file
Conline redo log files
Dthe current control file
Earchived redo log files
Fthe current server parameter file
Gdata files belonging to the USERS tablespace and all the default tablespaces
-
The current time is 12:00 noon. You want to recover the USERS tablespace from a failure that occurred at 11:50 a.m. You discover that the only member of an unarchived redo log group containing information from 11:40 a.m. onwards is corrupt. With reference to this scenario, if you are not using Recovery Manager (RMAN), which recovery method would you use?()
A、 time-based recovery
B、 log sequence recovery
C、 cancel-based recovery
D、 change-based recovery
-
You are performing an incomplete recovery because a tablespace is dropped and purged from the Recycle Bin. In which mode will you execute the following code?() RMAN>RUN { SET UNTIL SEQUENCE THREAD ; RESTORE DATABASE; RECOVER DATABASE; }
A、 NOMOUNT
B、 MOUNT
C、 OPEN
D、 RESTRICTED
-
Last night, a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database? ()
AThe database opens normally.
BThe database prompts for a database recovery.
CThe database writer writes to a trace file, indicating that the temporary file is not found.
DThe database gets mounted and throws an error indicating that the temporary file requires recovery.