-
You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.Which two statements are true about this backup operation?（）
A . Backup compression should be enabled
B . Parallelism for the channel should be set to 2
C . All the files must be backed up as backup sets
D . The backup may be stored either on disk or on media with media manager
-
When you are allowing RMAN to backup your archived redo log files，how does RMAN know which archived redo logs to back up from your archive log destination？（）
A . RMAN keeps a list of archive logs in a text file.
B . The DBA must manually tell RMAN which archive logs to backup.
C . RMAN has access to target control file and/or catalog information.
D . RMAN looks at the ARCHIVE_LOG_DEST parameter of your target database and backs up all archive logs found.
-
You issued the following RMAN command to back up the database:
https://assets.asklib.com/images/image2/2018080209472183076.jpg
Which two statements are true regarding the backup performed?（）
A . Archived redo log files are backed up along with data files.
B . Only data files are backed up and a restore point named FY06Q4 is created.
C . Archived log files are backed up along with data files, and the archived log files are deleted.
D . The command creates a restore point named FY06Q4 to match the SCN at which this backup is consistent.
-
What command would you use to set a persistent setting in RMAN so that backups are all written to a tape device?（）
A . CONFIGURE DEFAULT DEVICE TYPE TO TAPE MEDIA
B . CONFIGURE DEFAULT DEVICE TYPE TO TAPE
C . CONFIGURE DEFAULT DEVICE TYPE TO SBT
D . CONFIGURE DEFAULT DEVICE TYPE TO SBT_TAPE
-
You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN). Identify two scenarios is which you must have a recovery catalog.（）
A . To store the backup information of multiple database
B . To restrict the amount of space that is used by the backups
C . To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
D . To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.
-
You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database. Which two statements are true about this backup operation? （）(Choose two.)
A . Backup compression should be enabled
B . Parallelism for the channel should be set to 2
C . All the files must be backed up as backup sets
D . The backup may be stored either on disk or on media with media manager
-
You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）
A . online redo log files
B . alert log files
C . control file
D . datafiles associated with the SYSTEM tablespace
-
You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?（）
A . Database Datafiles
B . Database Control Files
C . Online redo logs
D . Archived redo logs
E . The database SPFILE
F . None of the above, all these files are backed up.&e
-
You performed a backup of the flash recovery area by using the following command for the first time： RMAN> BACKUP RECOVERY AREA; Which files in the flash recovery area are backed up？（）
A . flashback logs
B . current control file
C . control file autobackups
D . incremental backup set
-
In Recovery Manager （RMAN）， you have set control file autobackup to ON by using the following command： CONFIGURE CONTROLFILE AUTOBACKUP ON; Which two events would cause the control file to be backed up automatically？ （）
A . a tablespace is taken offline
B . the database instance is restarted
C . a new data file is added to an existing tablespace
D . a successful backup is recorded in the RMAN repository
E . the RMAN connection is disconnected from the target database
-
You are perfoming security testing on an existing asp.net web page.You notice that you are able to issue unauthorised postback requests to the page. You need to prevent unauthorised post back requests. which page directive you use？（）
A . <%@Page strict = "true" %>
B . <%@Page enableViewStateMac = "true" %>
C . <%@Page EnableEventValidation = "true" %>
D . <%@Page Aspcompact = "true" %>
-
In Recovery Manager （RMAN）， you have set control file autobackup to ON by using the following command： CONFIGURE CONTROLFILE AUTOBACKUP ON； Which two events would cause the control file to be backed up automatically？ （）
A . A tablespace is taken offline.
B . The database instance is restarted.
C . A new data file is added to an existing tablespace.
D . A successful backup is recorded in the RMAN repository.
E . The RMAN connection is disconnected from the target database.
-
You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).Identify two scenarios is which you must have a recovery catalog. （）(Choose two.)
A . To store the backup information of multiple database
B . To restrict the amount of space that is used by the backups
C . To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
D . To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.
-
You want to take a complete database backup using RMAN. The backup should consist onlythe used blocks from your database. Which two statements are true about this backup operation？（）
A . Backup compression should be enabled
B . Parallelism for the channel should be set to 2
C . All the files must be backed up as backup sets
D . The backup may be stored either on disk or on media with media manager
-
You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup?（）
A . You are backing up to tape and your tape device performs its own compression.
B . You are making image copies, and you have not enabled tablespace compression.
C . You are using disk-based backups and disk space in your Flash Recovery Area, or other disk-based backup destinations are limited.
D . You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage.
E . You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves media costs and archival storage.
-
You create a mobile Web application. You need to use a Command control to post user input from the UI elements back to the server. What are two possible ways to achieve this goal?（）
A . Place the Command control within an instance of the System.Web.UI.MobileControls.SelectionList control.
B . Place the Command control within an instance of the System.Web.UI.MobileControls.ObjectList control.
C . Place the Command control within an instance of the System.Web.UI.MobileControls.Form control.
D . Place the Command control within an instance of the System.Web.UI.MobileControls.Panel control.
-
You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）
A . A backup of the target database when it is mounted
B . A backup of online redo log files when the database is open
C . A backup of only used data blocks in the file beingbeingbackup up
D . A backup of online， read/write data files when the database is open
E . A backup of only those data blocks that have changed since a previous backup
F . A backup of online， read/write data files when the database is in the NOMOUNT state.
-
What RMAN command must you use before you can back up a database using the recovery catalog？（）
A . create catalog
B . install database
C . catalog database
D . merge Catalog with database
E . register database
-
View the Exhibit.You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS； Which three types of files are backed up？ （）
A . all the data files belonging to the USERS tablespace
B . password file
C . online redo log files
D . the current control file
E . archived redo log files
F . the current server parameter file
G . data files belonging to the USERS tablespace and all the default tablespace
-
You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command？（）
A . Datafiles
B . Current control file
C . Server parameter file （spfile）
D . Password file
-
You are using RMAN to perform a closed database backup of your database. You issue these RMAN commands： STARTUP MOUNT； BACKUP FORMAT ’/BACKUP/df_%d_%s_%p.bus’ DATABASE filesperset = 2； Which components are included in the backup？（）
A . Only the data files.
B . Only the data files and the online logs.
C . The data files， control files， and the online logs.
D . The data files and control files， but not the online logs.
-
You are performing an incomplete recovery because some important tables have been dropped and purged from the Recycle Bin. Which clause can you NOT use to perform the incomplete recovery by using the RMAN utility？（）
A . UNTIL CANCEL
B . UNTIL SCN
C . UNTIL SEQUENCE
D . UNTIL TIME
-
判断正误：When you are interviewing, you could use a comfortable sitting posture, for example, sitting close to the back of the chair.
-
You are using Recovery Manager （RMAN) with a recovery catalog to back up your production d
You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. Thebackups and the archived redo log files are copied to a tape drive on a daily basis.Because of media failure,you lost your production database completely along with the recovery catalog database.You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task:1) Restore an autobackup of the server parameter file.2) Restore the control file3) Start the target database instance4) Mount the database5) Restore the data files6) Open the database with RESETLOGS option7) Recover the data files8) Set DBID for the target databaseWhich option illustrates the correct sequence that you must use？（）
A.8，1，3，2，4，5，7，6
B.1，8，3，4，2，5，7，6
C.1，3，4，2，8，5，6，7
D.1，3，2，4，6，5，7，8
