A. ASMB
B. ARBn
C. RBAL in the ASM instance
D. RBAL in the database instance
您可能感兴趣的试卷
你可能感兴趣的试题
Consider the following configuration:
/devices/diskP1 is a member of disk group grp1.
/devices/diskP2 is a member of disk group grp1.
/devices/diskP3 is a member of disk group grp1.
/devices/diskP4 is a candidate disk.
/devices/diskQ1 is a member of disk group grp2.
/devices/diskQ2 is a member of disk group grp2.
/devices/diskQ3 is a member of disk group grp2.
/devices/diskQ4 is a candidate disk.
Which command will add the disk /devices/diskP4 to the disk group, grp1?()
A. ALTER DISKGROUP grp1 ADD DISK ’/devices/diskP1’, ADD DISK ’/devices/diskP4’;
B. ALTER DISKGROUP grp1 ADD DISK ’/devices/disk*4’;
C. ALTER DISKGROUP grp1 ADD DISK ’/devices/diskP*’;
D. ALTER DISKGROUP grp1 ADD DISK ’/devices/diskQ*’, ADD DISK ’/devices/diskP*’;
A. ASM_POWER_LIMIT
B. ASM_DISKSTRING
C. ASM_DISKGROUPS
D. LARGE_POOL_SIZE
A. CREATE TABLESPACE DATA1 DATAFILE ’+grp1/abc(datafile)’;
B. CREATE TABLESPACE DATA1 DATAFILE ’+grp1’;
C. CREATE TABLESPACE DATA1 DATAFILE ’+data1(tempfile)’;
D. CREATE TABLESPACE DATA1 DATAFILE ’+grp1.256.34359’;
A. The database will not start.
B. The database will start but will not retain the undo data in the undo segment.
C. The database will start, and the undo segment will contain the undo data for at least one hour.
D. The database will start, and the undo segment will retain the undo data for at least 15 minutes.
A. The database must be in the ARCHIVELOG mode.
B. The automatic memory tuning must be enabled.
C. The change tracking feature must be enabled.
D. The automatic memory tuning must be disabled.
A. Memory Advisor
B. Segment Advisor
C. Undo Advisor
D. SQL Tuning Advisor
A.ADDM
B.AWR
C.Cursor Cache
D.SQL Tuning Sets
E.Flash Recovery Area
A.DBMS_SERVER_ALERT
B.DBMS_ADVISOR
C.DBMS_RESOURCE_MANAGER
D.DBMS_REPAIR
A. SQL Tuning Advisor
B. SQL Access Advisor
C. Undo Advisor
D. Segment Advisor
A. SQL Tuning Advisor
B. Undo Advisor
C. ADDM
D. Memory Advisor
最新试题
In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file: In what sequence would you use this process to perform the recovery?()
You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area? ()
You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and usermanaged consistent backups are performed every Sunday night. On Thursday morning, you find that an important table has been dropped and purged. With reference to this scenario, up to what point in time can the data be recovered?()
You performed a backup of the flash recovery area by using the following command for the first time:RMAN> BACKUP RECOVERY AREA; Which files in the flash recovery area are backed up?()
Your database operates in ARCHIVELOG mode. Usermanaged consistent backups are performed every Sunday night. On Tuesday, client A drops a table at 8:00 a.m. as follows: SQL> DROP TABLE cust_ord PURGE; Table dropped. Client B executes a query at 9:00 a.m. on the same table as follows: SQL> SELECT * FROM cust_ord;SELECT * FROM cust_ord* ERROR at line 1: ORA00942: table or view does not exist Client B needs the dropped table and reports the problem to you. With reference to this scenario, which action should you take?()
View the Exhibit and examine the Flashback Database architecture. Identify the missing component (shown with a "?") in the Flashback Database architecture.()
A data file became corrupted in your database due to bad sectors on the disk. Because of corruption, you lost all the important tables in that data file.Which method would you use for recovery?()
You executed the following query in your database: FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()
You disabled the Flashback Database feature by using the following command: SQL> ALTER DATABASE FLASHBACK OFF; What would be the effect of this command on the existing flashback logs?()
One of the tablespaces is readonly in your database. The loss of all control files forced you to recreate the control file. Which operation do you need to perform after recreating the control file and opening the database?()