当前分类: 1Z0-053
问题:单选题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?()A They will be renamed.B Nothing will hap...
查看答案
问题:单选题You have discovered that one of three control files has been lost. What steps would you follow to recover that control file?() a. Shut down the database. b. Restore a control-file copy from backup media. c. Use the create control file command to cr...
问题:单选题Which is not a valid way of backing up a control file?()A Backing up the control file to traceB Copying the existing control file of the database to the backup location during a hot backup C Copying the existing control file of the database to the b...
问题:多选题What elements of globalization can be explicitly defined using the NLS_LANG environment variable?()ANLS_LANGUAGEBNLS_SORTCNLS_CALENDARDNLS_CHARACTERSETENLS_TERRITORY...
问题:多选题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...
问题:On the development database rac0, there are six raw devices:...
问题:多选题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 o...
问题:To set the history retention period for either window loggin...
问题:多选题What is the purpose of the RMAN recovery catalog?()AIt must be used because all RMAN-related backup and recovery metadata information is contained in it.BIt provides a convenient, optional, repository of backup- and recovery-related metadata.CIt provid...
问题:单选题Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?()A SQL Repair AdvisorB SQL OptimizerC SQL Access AdvisorD SQL Tuning Advisor...
问题:单选题On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30am. Which option must you use to check whether a flashback operation can recover the database to the specified time?()A Check the alert log fileB ...
问题:单选题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?()A Put the database in hot backup mode and perform an ...
问题:单选题Which command creates an image copy?()A backup as copyB backup copyC copy as backupD copy back...
问题:You want to create the Recovery Manager (RMAN) Virtual Priva...
问题:What is the result of this command?() RMAN> Report need back...
问题:单选题Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR?()A All objects in the databaseB Tables owned by SYS and SYSTEMC Data dictionary tablesD NCHAR columnsE CHAR columns...
问题:What RMAN command is used to execute a tablespace point-in-t...
问题:单选题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 o...
问题:What is the purpose of the RMAN recovery catalog?()...
问题:多选题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 passwor...