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.
A. ADR diagnostic files
B. all the optimizer statistics
C. initialization parameter settings
D. PL/SQL functions, procedures, and packages
E. the table and index definitions and actual data
最新试题
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?（）
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?（）
Examine the following RMAN script:Which statement describes the purpose of the script?（）
Examine the following ALTER command:SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;What is the purpose of the command?（）
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?（）
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 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?（）
Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN.（）
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 statements are true about persistent configuration?（）