The listener has shut down unexpectedly. You want to view the listener log file and listener trace file to find the cause of the problem. How can you view the contents of the listener log file and the listener trace file?()
时间:2022-11-10
By using the transaction identifier provided by () for a particular row change, you can use theFlashback Transaction Query to see the operation performed by the transaction.
You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to YYYYMMDD. The default format of which two data types would be affected by this setting?()
In the parameter file of the production database, the BACKGROUND_DUMP_DEST parameter is set to $ORACLE_HOME/users. Which two types of files would you find in this location?()
时间:2022-11-09
You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup?()
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 FLASHBACK TABLE command: FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’); Which two statements are correct? ()
You have a disk group, DGROUP1, with three disks and NORMAL redundancy. You execute the following command to create a template for the disk group: ALTER DISKGROUP dgroup1 ADD TEMPLATE my_temp ATTRIBUTES (MIRROR FINE); Which statement is true?()
时间:2022-11-08
There was media failure and you need to check the data files for any block corruption. Which option would you use to create a report on any corruptions found within the database?()
You are performing an incomplete recovery because some important tables have been dropped and purged from the Recycle Bin. Which clause can you NOT use to perform the incomplete recovery by using the RMAN utility?()
When performing a backup using Recovery Manager (RMAN), which four types of files can be backed up with the RMAN BACKUP command?()
You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file?()
时间:2022-11-06
SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions. What could be the reason?()
You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option?()
时间:2022-11-05
You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table?()