问题:单选题An online tablespace,TEST_TBS,is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason,if the TEST_TBS tablespace does not include autoextensible data files?()A TE...
查看答案
问题:单选题Over the course of a day,a department performed multiple DML statements (inserts, updates, deletes) on multiple rows of data in multiple tables. The manager would like a report showing the time, table name,and DML type for all changes that were made. W...
问题:单选题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 ...
问题:To set the history retention period for either window loggin...
问题:User SCOTT wants to back out the transactions on the REGIONS...
问题:Which initialization parameter in an ASM instance specifies ...
问题:What RMAN command is used to execute a tablespace point-in-t...
问题:单选题Which command creates an image copy?()A backup as copyB backup copyC copy as backupD copy back...
问题:Examine the following command that is used to duplicate a da...
问题:多选题Which three statements about performance analysis by SQL Performance Analyzer are true? ()(Choose three.)AIt detects changes in SQL execution plans.BIt produces results that can be used to create the SQL plan baseline.CThe importance of SQL statements ...
问题:You want to create the Recovery Manager (RMAN) Virtual Priva...
问题:Your database is running In ARCIIIVELOG mode. One of the dat...
问题:多选题The NLS_SORT parameter sets the default sort method for which of the following operations?()AWHERE clauseBORDER BY clauseCBETWEEN clauseDNLSSORT functionENLS_SORT function...
问题:Automatic PGA Memory Management eliminates the need to manua...
问题:多选题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...
问题:You plan to collect the Automatic Workload Repository (AWR) ...
问题:多选题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...
问题:单选题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...
问题:You run the following commands: RMAN> list expired backup;...
问题:单选题Which of the following is true about job chains?()A They consist of one or more Scheduler programs.B They are used to implement dependency scheduling.C They are used to implement time-based scheduling.D They are used to implement event-based schedu...