Your browser does not support JavaScript!
AMA University Answers
Login Register

Advanced Database Management Systems

Showing 76-139 of 139 answers

The types of user-managed backup you can perform are dependent on whether your database is running in ARCHIVELOG mode.
  • True Correct
To create a duplicate database, put the following steps in the correct order: 1. Start the auxiliary instance as NOMOUNT. 2. Allocate auxiliary channels if necessary. 3. Run the RMAN DUPLICATE command. 4. Create a password file for the auxiliary instance. 5. Ensure network connectivity to the auxiliary instance. 6. Open the auxiliary instance. 7. Start the source database in MOUNT or OPEN mode. 8. Create an initialization parameter file for the auxiliary instance. 9. Create backups or copy existing backups and archived log files to a common location accessible by the auxiliary instance.
  • 4, 5, 8, 1, 7, 9, 2, 3, 6 Correct
To enable password encryption for a specific backup, use the ______ command
  • set encryption Correct
To use guaranteed restore points, you must also enable these prerequisites: The COMPATIBLE initialization parameter must be 10.2 or higher.
  • True Correct
To use guaranteed restore points, you must also enable these prerequisites: You must have a flash recovery area configured.
  • True Correct
To use guaranteed restore points, you must also enable these prerequisites: You must have archived redo log files available starting from the time of the first guaranteed restore point.
  • True Correct
To use guaranteed restore points, you must also enable these prerequisites:The database must be running in ARCHIVELOG mode.
  • True Correct
Under what circumstances would you use the RMAN command UPGRADE CATALOG?
  • When you are using a version of the recovery catalog that is older than that required by the RMAN target database client. Correct
Using Database Replay consists of four main steps: 1. Workload capture 2. Workload preprocessing 3. Workload replay 4. Analysis and reporting
  • True Correct
What are the default characteristics of an ASM file created with no options?
  • The ASM object is striped but not mirrored. Correct
What happens to the rows in FLASHBACK_TRANSACTION_QUERY when part of the transaction is no longer available in the undo tablespace?
  • The OPERATION column contains the value UNKNOWN. Correct
What happens to the state of an ASM instance when a connected RDBMS instance fails?
  • There is no effect on the ASM instance. Correct
What is the difference between a critical and a noncritical datafile in a recovery scenario?
  • To recover a critical datafile, the database must be in MOUNT mode. To recover a noncritical datafile, the database can be open. Correct
What is the difference between a full backup and a whole database backup?
  • A full backup consists of a backup of one or more datafiles or tablespaces, whereas a whole database backup contains all datafiles, for all tablespaces plus the control file. Correct
What is the difference between an RMAN local script and an RMAN global script?
  • A local script is available only for a single target database. Correct
What is the difference between coarse striping and fine striping for files in a disk group?
  • Coarse striping spreads files in units of 1MB each across all disks, and fine striping spreads files in units of 128KB. Correct
What is the difference between the V$LOG and V$LOGFILE views?
  • V$LOG contains the status of the online redo log groups and V$LOGFILE contains the status of individual redo log group members. Correct
What is the maximum number of database writer processes (DBWn) in an Oracle database instance?
  • 20 Correct
What is the value for INSTANCE_TYPE in the init.ora file or SPFILE for an ASM instance?
  • ASM Correct
What method does RMAN use to enable fast incremental backup?
  • It uses a block change tracking file. Correct
When restoring a database to a new host, what is the first command you should run as part of the restoration process?
  • SET DBID Correct
When using the VERSIONS BETWEEN clause for Flashback Version Query, what can’t you use to restrict the number of rows returned by the query?
  • A guaranteed restore point Correct
When you run the RMAN RESTORE CONTROLFILE command, where does RMAN put the previous version of the control file?
  • To all locations defined by the CONTROL_FILES initialization parameter unless overridden with the TO ‘>filename Correct
When you want to create a duplexed backupset, what is the maximum number of copies of each backup piece you can create with one BACKUP command?
  • A maximum of four. Correct
When you want to restore backup, either to the same database or to a different database, you must specify the decryption password with ________
  • set decryption Correct
Which is the best method for recovering a tempfile?
  • Add another tempfile to the TEMP tablespace and drop the corrupted or missing tempfile while the database is running. Correct
Which of the following are not RMAN standalone commands?
  • ALLOCATE CHANNEL Correct
Which of the following background processes exist in both an ASM instance and an RDBMS instance, and also support ASM disk groups?
  • RBAL Correct
Which of the following clauses is not valid for the RMAN DUPLICATE command?
  • SKIP OFFLINE Correct
Which of the following columns is not in the data dictionary view FLASHBACK_TRANSACTION_QUERY?
  • ORA_ROWSCN Correct
Which of the following commands does not back up the current control file?
  • SQL< ALTER SYSTEM BACKUP CURRENT CONTROLFILE; Correct
Which of the following CREATE RESTORE POINT commands will preserve the restore point past the time specified by the initialization parameter CONTROL_FILE_RECORD_KEEP_TIME?
  • CREATE RESTORE POINT SAVE_IT_NOW PRESERVE Correct
Which of the following data dictionary views contains a list of the tables using a Flashback Data Archive?
  • DBA_FLASHBACK_ARCHIVE_TABLES Correct
Which of the following does not occur when you register a target database with the recovery catalog database using the REGISTER DATABASE command?
  • Information about manual tablespace backups is registered in the recovery catalog. Correct
Which of the following initialization parameters control Automatic Shared Memory Management (ASSM)?
  • SGA_TARGET Correct
Which of the following initialization parameters is not required to configure Flashback Database operations?
  • UNDO_RETENTION Correct
Which of the following initialization parameters is not valid?
  • LOG_ARCHIVE_DEST = ‘SERVICE=RMTDB99’ Correct
Which of the following is not a valid status for an online redo log group?
  • INVALID Correct
Which of the following is the default substitution variable for the FORMAT clause of the BACKUP command?
  • %t Correct
Which of the following methods can you use to retrieve the current System Change Number (SCN)?
  • Query the CURRENT_SCN column of the V$DATABASE view. Correct
Which of the following parameters are required for an ASM instance?
  • INSTANCE_TYPE Correct
Which of the following procedures will run a SQL Access Advisor job against a single SQL statement?
  • DBMS_ADVISOR.QUICK_TUNE Correct
Which of the following procedures will run a SQL Tuning Advisor job against a SQL Tuning Set?
  • DBMS_SQLTUNE.EXECUTE_TUNING_TASK Correct
Which of the following roles should you grant to the recovery catalog owner?
  • RECOVERY_CATALOG_OWNER Correct
Which of the following statement is not true regarding database backups?
  • As of Oracle Database 11g, RMAN supports only online backups. Correct
Which of the following two dynamic performance views can you use to identify the relationship between Oracle server sessions and RMAN channels?
  • V$PROCESS and V$SESSION Correct
Which tablespaces contain critical datafiles that must be recovered when the database is offline?
  • SYSTEM and UNDO Correct
Which two dynamic performance views can you use to identify files that need to be backed up, regardless of whether you are in ARCHIVELOG mode or NOARCHIVELOG mode?
  • V$DATAFILE and V$CONTROLFILE Correct
writes new or changed data blocks (known as dirty blocks) in the buffer cache to the datafiles.
  • database w riter Correct
You can use DELETE_REPLAY_INFO to delete a report in the replay directory.
  • True Correct
You can use two different methods to authenticate a database administrator: operating system (OS) authentication or password file authentication.
  • True Correct
You can use V$BACKUP_ASYNC_IO to monitor asynchronous RMAN I/O. What column or columns do you use to determine which file is the bottleneck during a backup?
  • A large value for LONG_WAITS / IO_COUNT Correct
You have configured backup optimization for your database using CONFIGURE BACKUP OPTIMIZATION ON. For which of the following commands will RMAN not skip a backup if the files are identical?
  • BACKUP TABLESPACE USERS; Correct
You have created a virtual private catalog to separate your RMAN administration duties among several DBAs for 20 different databases. Which role must you grant to each virtual catalog owner to allow the person to access existing registered databases?
  • RECOVERY_CATALOG_OWNER Correct
You have just received a pager alert indicating that the flash recovery area is below 3 percent free space. Which view and column can you query for a possible corrective action for this space condition?
  • DBA_OUTSTANDING_ALERTS, SUGGESTED_ACTION Correct
You have lost all online control files. Specify the correct order for the following tasks: · Restore the control file from backup or run CREATE CONTROLFILE. · Start database recovery and specify the keywords BACKUP CONTROLFILE. · Start up the database in MOUNT mode. · Open the database with RESETLOGS. · Shut down the database.
  • 5, 1, 3, 2, 4 Correct
You have lost the most recent archived redo log files from the recovery catalog database as well as the tablespace containing the RMAN catalog. You can do an incomplete restore of the recovery catalog database to a point in time after the target databases were registered with the recovery catalog. What commands can you use to resynchronize the target database’s metadata and backup information with the recovery catalog database?
  • Use the RESYNC CATALOG command to update the recovery catalog with the latest records from the target database’s control file and the CATALOG START WITH command to record any additional backups that are no longer in the target database’s control file. Correct
You run the following command to create a whole database backup: RMAN< backup as copy database spfile plus archivelog delete input; What does the DELETE INPUT clause do?
  • After the backup completes, RMAN deletes the archived log files from the flash recovery area and any other archived log file destinations. Correct
You set the initialization parameter BACKUP_TAPE_IO_SLAVES to TRUE. What effect does this have on the type of I/O that the server processes perform for RMAN if you are using tape?
  • Tape I/O is automatically asynchronous. Correct
You want to remap your database links so that they do not reference production database objects. Within which Database Replay step do you perform the remapping?
  • During the workload replay step Correct
You want to switch from AMM to ASMM. What is the correct statement you need to run?
  • alter system set memory_max_target = 0; Correct
You will perform complete closed database recovery. Put the following steps in the correct order. 1. Open the database to users. 2. Identify files needed for recovery. 3. Start up the database in MOUNT mode. 4. Bring the datafiles online. 5. Apply archived and online redo log files to roll forward. 6. Oracle applies undo to roll back uncommitted changes. 7. Restore recovery-related files containing committed and uncommitted transactions
  • 2, 7, 4, 3, 5, 1, 6 Correct
Your database is running in NOARCHIVELOG mode, and you perform occasional incremental level 1 backups in MOUNT mode. To what point in time can you recover the database if you lose a datafile for the USERS tablespace?
  • You can recover the entire database up to the point in time of the last incremental level 1 backup Correct
Your server’s physical memory is 8GB and no other applications or Oracle instances are running on the server. For a new Oracle instance running a decision support system, what is a good starting point for setting PGA_AGGREGATE_TARGET?
  • 3.2GB Correct
All courses