单选题Your database is in ARCHIVELOG mode. You have two online redo log groups，each of which contains one redo member. When you attempt to start the database， you receive the following errors：（）A ALTER DATABASE DROP LOGFILE GROUP 1B ALTER DATABASE CLEAR LOGFILE GROUP 1C ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1D ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’
单选题
Your database is in ARCHIVELOG mode. You have two online redo log groups，each of which contains one redo member. When you attempt to start the database， you receive the following errors：（）
A
ALTER DATABASE DROP LOGFILE GROUP 1
B
ALTER DATABASE CLEAR LOGFILE GROUP 1
C
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1
D
ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’
参考解析
解析：
暂无解析
相关考题：
单选题Which components are needed for successful and most efficient recovery.（）A The backup RB3 and the current online redo log filesB the backup RB2 and the archived redo log files after the log sequence number 15622C Backup R81 and the archived redo log hies after the log sequence number 12871D The backup RB3 and the archived redo log files after the log sequence number 16721
单选题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
单选题Tape streaming is not happening while performing RMAN tape backup. On investigation， you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to the tape drive fast enough. What could be a solution to make tape streaming happen during the backup？（）A Configure backup optimizationB Configure the channel to increase MAXOPENFILESC Configure the channel to increase the capacity with the RATE parameterD Configure the channel to adjust the tape buffer size with the BLKSIZE option
多选题You are using a recovery catalog to maintain Recovery Manager （RMAN） backup information for your production database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups. Identify two options for completing this task.（）AReregistering the target database in recovery catalogBTransporting the new tablespaces to the recovery catalog databaseCSyncronizing the recovery catalog with the target database control fileDPerforming a fresh backup of the target database to include the new data files in the catalog database
单选题Your database is in ARCHIVELOG mode. You have two online redo log groups，each of which contains one redo member. When you attempt to start the database， you receive the following errors：（）A ALTER DATABASE DROP LOGFILE GROUP 1B ALTER DATABASE CLEAR LOGFILE GROUP 1C ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1D ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’
单选题You issued the following command on the temporary tablespace LMTEMP in your database： SQLALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M； Which requirement must be fulfilled for this command to succeed？（）A The tablespace must be locally managed.B The tablespace must have only one temp file.C The tablespace must be made nondefault and offline.D The tablespace can remain as the default but must have no active sort operations.
多选题You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups. Identify two prerequisites to perform the backups.（）AThe database must be opened in restricted mode.BThe database must be configured to run in ARCHIVELOG mode.CThe tablespaces are required to be in backup mode before taking the backup.DThe tablespaces are required to be in read-only mode before taking the backup
单选题To clean up old records that are in a Flashback Data Archive and are past the retention period， what must the DBA do？（）A TRUNCATE the archive table.B DROP the Flashback Data Archive.C Nothing；expired rows are automatically removed.D Nothing；expired rows are moved to an archive table.E Delete entries from the archive where the metadata date retained is greater than the retention period.
单选题How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has alreadycompleted?（）AIssue the ALTER DISKGROUP ... ADD DISK command.BIssue the ALTER DISKGROUP ... UNDROP DISKS command.CIssue the ALTER DISKGROUP ... DROP DISK CANCEL command.DRetrieve the disk from the Recycle Bin after the operation completes
单选题Examine the following values of the initialization parameters in the database having the SID ORCL: BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST= The environment variables have the following value: ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1 What is the location of the Automatic Diagnostic Repository (ADR) home?（）A/u01/app/oracle/product/11.1.0/db_1B/u01/app/oracleC$ORACLE_HOME/bdumpD$ORACLE_HOME/log
单选题Given the following steps, which would be the correct order to create a backup of an Oracle database in NOARCHIVELOG mode?（） 1.shutdown immediate from RMAN 2.Log into RMAN 3.startup mount from RMAN 4.backup database 5.alter database open 6.backup database plus archivelog delete inputA2，3，1，4，5B2，1，3，6，5C1，3，5，4D2，1，3，5，6E2，1，3，4，5
单选题Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS which statement is true？（）A You cannot perform the TSPITR with the constraints enabled.B You must perform the TSPITR recovery of both tablespaces for it to be successful.C You can perform TSPITR only on the USERS tablespace.D RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it automatically.E The TSPITR will only be successful if the constraint is enabled.
多选题The EMP table exists in your schema. You want to execute the following query： SELECT ename， sal FROM emp AS OF TIMESTAMP （SYSTIMESTAMP - INTERVAL ’6’ MINUTE） WHERE ename = ’ALLEN’； What are the minimum requirements for the statement to execute successfully？（）AARCHIVELOG mode must be enabledBRow Movement must be enabled for the tableCFLASHBACK must be set to ON for the databaseDThe UNDO_MANAGEMENT parameter must be set to AUTOEThe UNDO_RETENTION parameter must be set appropriately
多选题Which operation requires that you create an auxiliary instance manually before executing the operation？（）ABackup-based database duplication.BActive database duplication.CTablespace point-in-time recovery.DNo operation requires the creation of an auxiliary instance.
单选题What command is used to reset a database to a previous incarnation？（）A reset incarnationB incarnation resetC reset database to incarnationD reset database incarnationE reset databse incarnation number
单选题What does the DB_FLASHBACK_RETENTION_TARGET parameter configure？（）A An upper limit on how far you can flash back the database，depending on the information in the redo logsB An upper limit on how far you can flash back the database，depending on the information in the undo tablespaceC The amount of time for which the flashback data is to be kept in the flash recovery area， provided that there is enough spaceD The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace，provided that there is enough space
单选题What does the output on this report indicate？（） RMAN report need backup； RMAN retention policy will be applied to the command RMAN retention policy is set to redundancy 1 Report of files with less than 1 redundant backups File #bkps Name 5 0 C:///ORACLE/ORADATA/ORCL/MY_DATA_01.DBFA The my_data_01.dbf datafile is corrupted and needs to be restored.B The my_data_01.dbf datafile has not yet been backed up. This report does not imply that the data in the datafile can not be recovered.C The my_data_01.dbf datafile has not yet been backed up. This report implies that the data in the datafile can not be recovered.D The my_data_01.dbf datafile no longer meets the retention criteria for backups.E Datafile 5 is missing.
单选题What is the danger associated with stopping a running job by using the STOP_JOB procedure？（）A The job will need to be reenabled before it will execute again.B The job may hold locks on objects referenced within it.C All jobs within the job group will also be stopped.D The job may leave data in an inconsistent state.E There is no danger in using the STOP_JOB procedure.
单选题To view the results of the most recent Automatic SQL Tuning Advisor task, which sequence should you follow?（）AEM Database home page, Software and Support, SQL Advisors, Automatic SQL Tuning Advisor.BEM Database home page, Software and Support, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor.CEM Database home page, Software and Support, Support Workbench, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor.DEither B or CEAll of the above
单选题You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2. The SALES table has a materialized view， materialized log， indexes， referential integrity constraint， and triggers with the PRECEDES clause existing on it. What action is required for dependent objects when you perform online table redefinition？（）A The dependent materialized view should have a complete refresh performed after the online table redefinition process.B Triggers with the PRECEDES clause should be disabled before the online table redefinition process.C Referential integrity constraints must be manually enabled after the online table redefinition process.D The materialized log should be dropped before the online table redefinition process.
单选题You issue the following RMAN command to set a retention policy on a database: RMANCONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of issuing this command?（）AAfter two days, a backup will be marked obsoleteBAfter two days, a backup will be deleted from the mediaCIf the RMAN repository has records of two or more recent backups of a file, then older backups will be deleted from the media.DIf the RMAN repository has records of two or more recent backups of a file, then older backups will be marked obsolete.
多选题Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command： RESTORE CONTROLFILE FROM AUTOBACKUP； Which of the following statements is true？（）AThe command restores only the missing control file.BThe command restores all the control files.CThe command fails because the database is running.DThis is the correct way to address this problem.EThis is not the correct way to address this problem.
多选题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
多选题Which statement describes the significance of the CHANGE FAILURE command in RMAN？（）AIt is used to change failure priority only for HIGH or LOW priorities.BIt is used to execute the advised repair script.CIt is used to change failure priority only for the CRITICAL priority.DIt is used to explicitly close the open failures.EIt is used to inform the database about the repair after the repair script executes.
多选题Which two client requests are captured during database replay Capture？（）AFlashback queriesBShared server requestsCLogin and logoff activities of sessionsDDirect path load of data from external files by using utilities such as SQL *loaderEData definition language （DDL） and data manipulation language （DML） operations
多选题You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps. What configuration would you effect to achieve your objective？（）ASet the ASM compatibility attribute for the ASM disk group to 11.1.0.BSet the RDBMS compatibility attribute for the ASM disk group to 11.1.0.CSet the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.DSet the COMPATIBLE initialization parameter for the database instance to 11.1.0.
单选题What is the default AU size of an ASM disk group？ What is the maximum AU size in an ASM disk group？（）A 100KB default， 10TB maximumB 256KB default， 1024MB maximumC 10MB default， 126PB maximumD 64KB default， 1EB maximumE 1MB default， 64MB maximum
单选题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 online backup，including backing up the archived redo logs.B Just back up the database datafiles without shutting down the database.C You will have to wait until you can shut down the database to perform the backup.D Mark 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.E Only 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