Exhibit: View the Exhibit and examine the characteristic of the USERS tablespace. You observe that a large volume of inserts and deletes are happening on the TRANS table in the USERS tablespace and you suspect that the TRANS table is fragmented. Which advisory component would you refer to, in order to find information about table fragmentation?()
A. Memory Advisor
B. Segment Advisor
C. SLQ Tuning Advisor
D. SLQ Access Advisor
E. Automatic Database Diagnostic Monitor (ADDM)
您可能感兴趣的试卷
你可能感兴趣的试题
A. Set the CPU time per call in the users profile.
B. Set the CPU time per session in the users profile.
C. Set the CPU levels for the user’s group using Resource Manager.
D. Set the TIMED_STATISTICS parameter to TRUE in the parameter file.
A. The index tablespace contains bitmap indexes.
B. The index tablespace contains more than one data file.
C. The index tablespace supports only complete recovery.
D. The index tablespace is not a dictionary-managed tablespace.
E. There is a dependency relationship between a table and its indexes.
A. When a file is created in DGROUP1 with the template, it would have three-way mirroring.
B. When a file is created in DGROUP1, the MY_TEMP template becomes the default template.
C. When a file is created in DGROUP1 with the template, it would have two-way mirroring and file striping.
D. When a file is created in DGROUP1 with the template, it would have three-way mirroring and file striping.
E. When a file is created in DGROUP1 with the template, it would have two-way mirroring but no file striping.
A. Fixed views
B. The alert log file
C. The parameter file
D. The server parameter file
E. Dynamic performance views
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?()
A. Flashback logs are not deleted.
B. Flashback logs are deleted automatically.
C. Flashback logs are deleted only if you are using Recovery Manager (RMAN)
D. Flashback logs are deleted only if you are using Oracle Manager Files (OFM)
E. Flashback logs are deleted only if you are using Automatic Storage Management (ASM)
A. RMAN would use the current operating system location to place the backup.
B. RMAN would use the control file of the target database to maintain the backup.
C. RMAN would use the recovery catalog of the target database to maintain the backup.
D. RMAN would use the control file of the target database to maintain the backup metadata.
E. RMAN would use the recovery catalog of the target database to maintain the backup metadata.
Case 1:
1. Shut down the database and perform a backup.
2. Restore all the data files.
3. Mount the database.
4. Recover the database.
5. Without applying all the redo log files, open the database using the RESETLOGS option.
6. Back up the database.
Case 2:
1. Shut down the database and perform a backup.
2. Restore only the data files of the tablespace where user error damaged the data.
3. Mount the database.
4. Recover the database.
5. Open the database with the RESETLOGS option.
6. Back up the database.
Case 3:
1. Shut down the database.
2. Restore the data files.
3. Open the database.
4. Perform recovery to the current point in time.
Which case has the correct steps for an incomplete recovery?()
A. Only case 1
B. Only case 2
C. Only case 3
D. Case 1 and 2
E. Case 2 and 3
F. Case 1 and 3
G. All cases, case 1, case 2, case 3
A. DBWn
B. RVWR
C. ARCH
D. RECO
E. TRWR
A. assign users to consumer groups
B. set the resource plan for the instance
C. configure a simple resource plan and specify plan directives
D. configure a complex resource plan and specify plan directives
A. It would result in an error because the warning threshold cannot be more than the critical threshold.
B. The warning threshold is ignored and alerts would be generated when space usage exceeds the critical threshold.
C. The critical threshold is ignored and alerts would be generated when space usage exceeds the warning threshold.
D. Both threshold values are used and alerts are generated when space usage exceeds the respective threshold values.
最新试题
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 are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to ’LOG%t_%s_%r.dbf’. Why is %r used in the file name format?()
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?()
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?()
View the Exhibit and examine the Flashback Database architecture. Identify the missing component (shown with a "?") in the Flashback Database architecture.()
View the Exhibit. One of the important tables in the USERS tablespace was dropped and purged from the recycle bin at 9:00 a.m. You noticed this at 11:00 a.m. and you want to perform an incomplete recovery to recover the table. Which statement is true?()
Every Sunday, consistent backups are performed on your database. Because of a user error, you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday, which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available. What would you do in this scenario?()
You are working on Oracle Database 10g, which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option?()
You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area? ()