A. It improves resync operations.
B. This feature enables much faster file opens.
C. It improves performance as fewer extent pointers are needed in the shared pool.
D.It improves performance by reading from a copy of an extent closest to the node.
您可能感兴趣的试卷
你可能感兴趣的试题
A. The Automatic Memory Manager (AMM)
B. The SQL Tuning Advisor
C. The Segment Advisor
D. The SQL Access Advisor SQL
View the following SQL statements:
You want to back out transaction T2. Which option would you use?()
A. It is possible, but transaction T3 also backs out.
B. It is possible with the NOCASCADE_FORCE option.
C. It is possible with the NONCONFLICT_ONLY option.
D. It is not possible because it has conflicts with transaction T3.
A. the SQL text SQL
B. the execution plan
C. the execution context
D. the execution frequency
E. the system change number (SCN)
A. to avoid round trips to the server by enabling caching of query results in client memory
B. to improve performance by storing a copy of the data from the private SQL area of the PGA
C. to enhance the query performance by creating a cache in the client memory for sorting operations
D. to avoid the storing of query plans and results in the server by creating a cache in the client memory
What is the outcome of this block of code?()
A. It creates a task and workload, and executes the task.
B. It creates a task and workload but does not execute the task.
C. It produces an error because a template has not been created.
D. It produces an error because the SQL Tuning Set has not been created.
View the Exhibit to examine the Automatic SQL Tuning result details.Which action would you suggest for the selected SQL statement in the Exhibit?()
A. Accept the recommended SQL profile.
B.Collect statistics for the related objects.
C. Run the Access Advisor for the SQL statement.
D. Run the Segment Advisor for recommendations.
A. statistics recommendations
B. SQL Profile recommendations
C. Index-related recommendations
D. restructuring of SQL recommendations
A. The installation terminates with an error.
B. The installation proceeds with the default value without warnings and errors.
C. The installation proceeds with the default value but it would not be an OFA-compliant database.
D. The installation proceeds with the default value but a message would be generated in the alert log file.
A. It repairs blocks that have read disk I/O errors.
B. It checks whether the alias metadata directory and the file directory are linked correctly.
C. It repairs blocks by always reading them from the mirror copy and writing them to the original location.
D. It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.
Examine the following RMAN command:
Which two statements are true regarding the backup taken by using the above RMAN command?()
A. Only data files and the control file are backed up.
B. Archived redo logs are backed up only I f the database is open during the backup.
C. The backup is deleted after one day, regardless of the default retention policy settings.
D. The backup becomes obsolete after one day, regardless of the default retention policy settings.
最新试题
Which three statements are true about windows?()
Which two commands never trigger an implicit rebalancing within the disk group?()
You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.Which two statements are true about this backup operation?()
You are creating a database by using Database Configuration Assistant (DBCA). You have chosen the File System option as the storage mechanism. What would be the result of choosing this option?()
Examine the CREATE DISKGROUP command used to create a disk group:In which situation would you use this method of disk group creation?()
The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session?()
The user SYS creates a job by using the following command:Which two statements are true about the job that was created by the preceding command?()
While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it.Identify the two events that can occur in the event of a log switch?()
You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task:Which option illustrates the correct sequence that you must use?()
View the Exhibit and examine the output.You execute the following RMAN command to perform the backup operation:What is the multiplexing level in the preceding backup process()