Online Access Free 11gocmu Exam Questions

You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter. The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals:
SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS('SH','SALES',GRANULARITY=>'GLOBAL');
You need statistics to be collected more quickly. What can you do to achieve this?

• A.Set the STATISTICS_LEVEL parameter to BASIC.
• B.Set DYNAMIC_SAMPLING to level 4.
• C.Increase the value of STALE_PERCENT for the partition table.
• D.Set the INCREMENTAL value to TRUE for the partition table.

You backed up the database at 8 a.m. today using an online backup. Accounting made a large change to the underlying data between 10 a.m. and noon. Which of the following actions would ensure that the changes could be recovered using the 8 a.m. backup?

• A.Create a manual incremental online database backup.
• B.Create a brand-new backup after all the changes have been applied.
• C.There is no way to make the changes recoverable based on the 8 a.m. backup.
• D.Back up all the archived redo logs generated since the 8 a.m. backup.
• E.Perform an online backup of the tablespace(s) that contained changed data.

You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online.
Which statement about performing user-managed backups in a 24x7 environment is true?

• A.You must have change tracking enabled in your database
• B.Your database must be running in NOARCHIVELOG mode
• C.To back up a tablespace, it must first be taken offline
• D.To back up a tablespace, it must be in backup mode

You issued the following commands to configure setting in RMAN;
RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1;
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;
RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2;
RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2;
RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
Then you issued the following command to take the backup:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which statement is true about the execution of the above command?

• A.It backs up two copies of data files to tape and disk, and two copies of archived log file on tape
• B.The backup will terminate because the FORMAT clause was not configured for the channel
• C.It backs up the data files and archived log files to disk, making two copies of each data file and archived log file
• D.It backs up the data files and archived log files to tape, making two copies of each data file and archived log file

View the Exhibit to examine the error obtained during the I/O calibration process. There are no data files on raw devices. What is the reason for this error?

• A.The DISK_ASYNCH_IO parameter is set to TRUE.
• B.The pending area has not been created before running the I/O calibration process.
• C.Another session runs the I/O calibration process concurrently.
• D.The FILESYSTEMIO_OPTIONS parameter is set to NONE.