当前分类: 1Z0-053
问题:单选题You upgraded Oracle Database 10g to Oracle Database 11g. How would this affect the existing users’ passwords?()A All passwords automatically become case-sensitive.B All passwords remain non-case-sensitive till they are changed.C All passwords remain...
查看答案
问题:单选题To view the results of the most recent Automatic SQL Tuning Advisor task, which sequence should you follow?()A EM Database home page, Software and Support, SQL Advisors, Automatic SQL Tuning Advisor.B EM Database home page, Software and Support, Adviso...
问题:多选题Identify the channel settings that can be performed using the CONFIGURE CHANNEL or ALLOCATE CHANNEL commands in RMAN ?()ALimiting the input/output (I/O) bandwidth consumptionBSpecifying the size of backup sets and backup piecesCSpecifying vendor-specif...
问题:单选题You want to set the following initialization parameters for your database instance: LOG_ARCHIVE_DEST_1 = ’LOCATION=/disk1/arch’ LOG_ARCHIVE_DEST_2 = ’LOCATION=/disk2/arch’ LOG_ARCHIVE_DEST_3 = ’LOACTION=/disk3/arch’ LOG_ARCHIVE_DEST_4 = ’LOCATION=/di...
问题:单选题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 ...
问题:单选题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...
问题:单选题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 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 ...
问题:多选题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...
问题:单选题What is an obsolete backup set?()A A backup set that is missing one or more backup set piecesB A backup that has exceeded the retention criteria and is no longer neededC A backup set that does not include archived redo logsD A backup set that can n...
问题:单选题Which mode of database shutdown requires an instance recovery at the time of the next database startup?()A ABORTB NORMALC IMMEDIATED TRANSACTIONAL...
问题:Which of the following tasks does the tool Incident Packagin...
问题:To set the history retention period for either window loggin...
问题:多选题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...
问题: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...
问题:单选题Which background process of a database instance,using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?()A ASMBB PMONC RBALD SMON...
问题:多选题What elements of globalization can be explicitly defined using the NLS_LANG environment variable?()ANLS_LANGUAGEBNLS_SORTCNLS_CALENDARDNLS_CHARACTERSETENLS_TERRITORY...
问题:单选题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...
问题:单选题If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT, what RMAN command would you run to correct the problem?()A recover lost blocksB recover corrupt blocksC recover media corrupt blocks from listD recover corru...