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.
You want to perform the following operations for the DATA ASM disk group:
Which command accomplishes these tasks?()
A. ALTER DISKGROUP data CHECK;
B. ALTER DISKGROUP data CHECK DISK;
C. ALTER DISKGROUP data CHECK FILE;
D. ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1;
最新试题
Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode?()
In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.Which method must you use to recover the lost data?()
After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?()
Examine the parameter setting in your database:Which statement is correct about the database?()
Examine the following RMAN script:Which statement describes the purpose of the script?()
Which two commands never trigger an implicit rebalancing within the disk group?()
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?()
Which two statements are true about the Automatic Diagnostic Repository (ADR)?()
Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN.()
View the exhibit and examine the TRANS table's storage information.After a massive delete operation, you executed the following statement to shrink the TRANS table:SQL> ALTER TABLE trans SHRINK SPACE CASCADE;Which statement describes the outcome of the command?()