当前分类: 1Z0-053
问题:You are using Recovery Manager (RMAN) with a recovery catalo...
查看答案
问题:A database is running In ARCHIVBXXMS mode. It has two online...
问题:多选题Using Oracle Enterprise Manager to set SGA pool values manually, for which of the following pools does Oracle EM offer advice to set the value appropriately?()ADB_CACHE_SIZEBSHARED_POOL_SIZECLARGE_POOL_SIZEDJAVA_POOL_SIZEESGA_MAX_SIZEFSORT_AREA_SIZE...
问题:单选题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...
问题:To set the history retention period for either window loggin...
问题:单选题You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the sug...
问题:单选题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 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?()A A base catalog existsB ...
问题:单选题Every resource plan must contain an allocation to which consumer group?()A LOW_GROUPB SYS_GROUPC DEFAULT_GROUPD BASE_GROUPE OTHER_GROUPS...
问题:单选题Which of the following tasks is not performed by the job coordinator?()A Update job log when a job completesB Spawn and remove job slavesC Write/read job info to/from memory cacheD Query job tableE Pass job information to job slaves...
问题:单选题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...
问题:多选题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...
问题:单选题Which command creates an image copy?()A backup as copyB backup copyC copy as backupD copy back...
问题:Which statement is true regarding online redefinition for th...
问题:多选题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...
问题:单选题While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?()A It updates the existing SQL profiles with current statistics.B I...
问题:单选题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 ...
问题:What RMAN command is used to execute a tablespace point-in-t...
问题:多选题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...