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;
A. The source and target platforms must be the same
B. Redo logs, control files and temp files are also transported
C. The transported database must have the same database identifier (DBID) as the source database and cannot be changed
D. The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported
E. Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format
A. A DBA can enable or disable an individual task in all maintenance windows.
B. A DBA cannot change the duration of the maintenance window after it is created.
C. In case of a long maintenance window, all Automated Maintenance Tasks are restarted every four hours.
D. A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window.
You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is jetting filled up very fast and it is running out of space. Your database flash recovery area is low on space and you have no more room on disk.
Proactively, which two options could you use to make more space available in the flash recovery?()
A. Change the RMAN archived log deletion policy
B. Use the RMAN CROSSCHECK command to reclaim the archived log space
C. Change the RMAN retention policy to retain backups for a shorter period of time
D. Use OS command to move files from the flash recovery area to some other location
You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11.
You executed the following commands:
Which two statements are true regarding the tasks accomplished with these commands?()
A. They import all metadata from the RCAT10 catalog.
B. They unregister the database from the RCAT10 catalog.
C. They do not register the databases registered in the RCAT10 catalog.
D. They register all databases registered in the RCAT10 catalog.
A. Drop the table.
B. Partition the table
C. Truncate the table.
D. Add a column to the table.
E. Rename a column in the table.
![](https://static.ppkao.com/ppmg/img/appqrcode.png)
最新试题
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 following ALTER command:SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;What is the purpose of the command?()
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?()
Which three functions are performed by the SQL Tuning Advisor? ()
Which two statements are true about the Automatic Diagnostic Repository (ADR)?()
What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?()
Examine the CREATE DISKGROUP command used to create a disk group:In which situation would you use this method of disk group creation?()
Which two commands never trigger an implicit rebalancing within the disk group?()
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?()
Which three tasks can be performed using a duplicate database?()