问题：多选题The following query will provide what information about transportable tablespaces for the current database？（） select d.platform_name "Source"， t.platform_name "Compatible Targets"， endian_format from v$transportable_platform t， v$database d where t.endian_format = （select endian_format from v$transportable_platform t， v$database d where d.platform_name = platform_name）；AThe list of target platforms having the same endian format as the source databaseBThe list of target platforms requiring endian conversionCThe list of target platforms that will not require endian conversionDThe list of all target platforms that can receive transportable tablespaces from the source databaseENone of the above
查看答案
问题：单选题You are maintaining the SALES database. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity. Which parameter should you specify to control the speed of the rebalancing activity？（）AASM_POWER_LIMITBASM_DISKSTRINGCASM_DISKGROUPSDINSTANCE_TYPE
问题：单选题You want to create the Recovery Manager （RMAN） Virtual Private Catalog （VPC） to maintain a separation of responsibilities along with a consolidation of RMAN repository. Which condition must be met before you create the VPC？（）AA base catalog existsBThe recovery catalog is emptyCThe base recovery catalog must be droppedDA target database is registered in the recovery catalog
问题：多选题Which two prerequisites are needed for performing workload capture and replay？（）AClose all sessions performing queries using database linksBrunning the database in shared server modeCThe database on which the workload is replayed has to be a restore of the original database to a specific SCNDsetting up the directory to capture the workload
问题：单选题What RMAN command is used to execute a tablespace point-in-time recovery？（）ArecoverBduplicateCrestoreDcopyENone of the above
问题：多选题Which two statements are true about encrypting RMAN backup？（）AThe transparent encryption of backups uses the encryption walletBThe database uses the same encryption key for every encrypted backupCThe password encryption of backups only uses the password while creating and restoring backupDIf transparent encryption is configured， you cannot use the SET ENCRYPTION BY PASSWORD command to make password-protected backups
问题：单选题Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs？（）AIt cannot be done in parallel.BIt can be done at the table level or partition level.CIt does not require additional storage because the operation is done online.DLocal and global indexes are maintained automatically during the operation.
问题：单选题You are using Recovery Manager （RMAN） with a recovery catalog to back up your production database. The backups 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 file 3） Start the target database instance 4） Mount the database 5） Restore the data files 6） Open the database with RESETLOGS option 7） Recover the data files 8） Set DBID for the target database Which option illustrates the correct sequence that you must use？（）A8， 1， 3， 2， 4， 5， 7， 6B1， 8， 3， 4， 2， 5， 7， 6C1， 3， 4， 2， 8， 5， 6， 7D1， 3， 2， 4， 6， 5， 7， 8
问题：多选题Which client requests to the database can be captured as a part of the workload capture？（）Aflashback queryBdistributed transactionsClogging in and logging out of sessionsDall DDL statements having bind variablesEdirect path load of data from external files
问题：多选题Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available. Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（）Aredo logsBcontrol fileCtemporary files of temporary tablespaceDthe latest backup of only the damaged data fileEthe latest backup of all the data files In the USERS tablespace
问题：单选题Examine the following RMAN script： RMAN> run { debug on； allocate channel c1 type disk； backup datafile 5； } Which statement describes the purpose of the script？（）AThe data file is checked for physical corruption and backed up if found clean.BThe backup of data file 5 is performed and the interactive messages during the backup are suppressed.CThe existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.DThe backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed
问题：单选题Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION to record thestatus of the operation?（）A ADD DIRECTORYB DROP DISKC RESIZE DISKD REBALANCEE ADD FAILGROUP
问题：单选题To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）A The database will open, and the tablespace automatically comes out of the backup modeB The database will be mounted, and recovery must be performed on the USERS tablespace.C The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.D The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.
问题：单选题Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（）APut the database in hot backup mode and perform an online backup，including backing up the archived redo logs.BJust back up the database datafiles without shutting down the database.CYou will have to wait until you can shut down the database to perform the backup.DMark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.EOnly back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the course of the remaining backup
问题：单选题Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement？（）ANLS_LANGBNLS_COMPCNLS_SORTDNone of the above
问题：单选题You run the following commands： RMAN> list expired backup； RMAN> delete expired backup； What will happen to the backup set pieces associated with the backups that appear in the list expired backup command？（）AThey will be renamed.BNothing will happen to them. The backup set pieces do not exist.CThey will be deleted immediately since they are not in the flash recovery area.DYou will need to manually remove the physical files listed in the output of the commands.EThey will become hidden files and removed 10 days later.
问题：多选题To set the history retention period for either window logging or job logging individually， which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used？（）ALOG_HISTORYBJOB_LOG_RETENTIONCWINDOW_LOG_RETENTIONDWHICH_LOGELOG_NAME
问题：多选题You have a database with the following tablespaces： SYSTEM， SYSAUX， UNDO， USERS， TEMP. You want to"roll back" the data in the USERS tablespace to the way it looked yesterday. Which tablespaces do you need to perform a point-in-time restore operation on in order to complete this task？（）ASYSTEMBSYSAUXCUNDODUSERSETEMPFThis restore is not possible
问题：多选题You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file， if it has already been backed up.（）AThe data file backup is done with multiple channelsBThe data files is in the read-write mode after being backed up in the read only modeCThe backup was taken after the data files was taken offline-normal or is in the read only modeDThe data file backup complies with the back retention policy and the backup duplexing fe ture
问题：单选题Which command creates an image copy？（）Abackup as copyBbackup copyCcopy as backupDcopy back
