A. DBMS_RLS.STATIC
B. DBMS_RLS.DYNAMIC
C. DBMS_RLS.SHARED_STATIC
D. DBMS_RLS.CONTEXT_SENSITIVE
E. DBMS_RLS.SHARED_CONTEXT_SENSITIVE
您可能感兴趣的试卷
你可能感兴趣的试题
A. RBAL
B. CKPT
C. SMON
D. PMON
E. MMON
F. CTWR
G. DBWR
A. control file
B. RMAN files
C. password file
D. parameter file
E. flashback logs
F. data file copies
G. core dump files
H. archived log files
I. RMAN recovery scripts
J. control file autobackpus
A. Enterprise Manager GUI
B. DBMS_TRACE package APIs
C. DBMS_ADVISOR package APIs
D. DBMS_MONITOR package APIs
E. $ORACLE_HOME/rdbms/admin/addmrpt.sql script
A. The location used for control files.
B. The location used for redo log files.
C. The location set by using $ORACLE_BASE
D. The location set by using $ORACLE_HOME
E. The location set by using CORE_DUMP_DEST
F. The location set by using BACKGROUND_DUMP_DEST
A. It would result in an error because the template cannot be used along with the disk group.
B. It would result in an error because the path cannot be specified while creating a tablespace in a disk group.
C. It would create a tablespace with a data file that has an alias, and its attributes are set by the user-defined template.
D. It would create a tablespace with a data file that does not have an alias, and its attributes are set by the user-defined template.
A. The database re-created the missing redo log files automatically.
B. The database continues to function normally with the existing files.
C. The database allows only queries, no other statements are allowed.
D. The database returns and error and the database instance shuts down.
E. The user sessions that generate redo logs are terminated automatically.
A. Export and import the mapping table.
B. Drop and re-create the mapping table.
C. Truncate the mapping table and reinsert the values.
D. Use the ALTER TABLE .. REBUILD command to defragment the mapping table.
A. You find that one of the redo log members in each redo log group is lost.
B. You find that a data file that belongs to the USERS tablespace is damaged.
C. You find that a data file that belongs to the SYSTEM tablespace is damaged.
D. You find that the current redo log group is damaged and is not available for recovery.
E. You realized while performing a recovery that an archived redo log file needed for recovery is lost.
A. The subplan must belong to the consumer group, SYS_GROUP.
B. The total CPU usage at any given level must be less than 100%.
C. The subplans can be used to restrict the degree of parallelism for a user.
D. You can use a resource plan instead of a consumer group to implement a priority ranking within the plan.
A. This operation resets the SCN for the database.
B. This operation creates a new incarnation of the database.
C. This operation moves all the redo log files to a different location.
D. This operation deletes the old redo log files and creates new redo log files.
E. This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.
最新试题
Your database operates in ARCHIVELOG mode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence, 230, is not archived, and it contained information from 10:35 a.m. onwards. The current time is 11:00 a.m. Because of a disk crash, you executed the following command to perform an incomplete recovery: RMAN> RUN { 2> SET UNTIL SEQUENCE 230 THREAD 1; 3> ALTER DATABASE MOUNT; 4> RESTORE DATABASE; 5> RECOVER DATABASE; 6> ALTER DATABASE OPEN RESETLOGS;7> }; With reference to this scenario, which statement is true?()
You lost the index tablespace in your database. You are not able to use tablespace pointintime recovery on the index tablespace. What could be the reason for this?()
You are connected to Recovery Manager (RMAN) without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup,you need the database ID (DBID). In which two sources would you find the DBID? ()
You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area? ()
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?()
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?()
In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog and restored the control file by using the following command: RMAN> RESTORE CONTROLFILE; Which two operations do you need to perform after restoring the control file from backup?()
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 noticed that the index tablespace in your database requires a recovery. However, instead of performing a media recovery, you decided to recreate the indexes in a new tablespace. Which two options would you use to reduce the time it takes to recreate the indexes?()
You decided to change the location of the flash recovery area. You executed the following command: Which statement is true?()