Oracle试题:032的23-30题
最新Oracle 9i DBA题库:032的23-30题认证名称：orcacle9l database:fundamentals ii
23.Which usermanagedbackup performed on your database can be labeled as consistent?A.a backup performed when the database is openB.a backup performed on a tablespace after putting the tablespace into backup modeC.a backup performed when the database is closed by using the SHUTDOWN ABORT commandD.a backup performed when all data files and control files are checkpointed with respect to the samesystem change number (SCN)Answer : D24.Which two file types must be included in a closed database backup taken with operating systemcommands? (Choose two.)A.data filesB.control fileC.password fileD.online redo log filesE.initialization parameter fileAnswer : AB25.You plan to take a closed database backup using operating system commands. Which threeSHUTDOWN options are appropriate for this type of backup? (Choose three.)A.ABORTB.NORMALC.IMMEDIATED.TRANSACTIONALAnswer : BCD26.You work on a database that is used for application development and operates in NOARCHIVELOGmode. The database has 10 tablespaces out of which two are read only. As a DBA, you know thatdatabase downtime can be tolerated and have designed a backup strategy containing a weekly closeddatabase backup. Which files can you exclude from the weekly usermanagedbackup? (Choose all thatapply.)A.control filesB.sqlnet.ora fileC.tnsnames.ora fileD.data files associated with readonlytablespacesE.data files associated with read/write tablespacesAnswer : BCD27.You work on a database that is used for application development and operates in ARCHIVELOG mode.As a DBA, you know that database downtime can be tolerated and have designed a backup strategycontaining a weekly closed database backup. The local naming method is used by clients to connect tothe database.Which files should you include in this weekly usermanagedbackup? (Choose all that apply.)A.control fileB.sqlnet.ora fileC.archived log filesD.tnsnames.ora fileE.listener configuration fileAnswer : AC28.You issue this SQL command to perform an online backup of the USER_DATA tablespace: ALTERTABLESPACE user_data BEGIN BACKUP;Next, you issue an operating system command to back up user_data01.dbf, the file that belongs to theUSER_DATA tablespace.You then experience an instance failure. Which three statements are true? (Choose three.)A.The user_data01.dbf file needs to be restored from an earlier backup and recovered.B.The online backup of the USER_DATA tablespace can be ended with an ALTER DATABASE command.C.The backup of user_data01.dbf is unusable for future recoveries if the operating system copy was notcompleted before the instance failure.D.The database open fails because the header of the user_data01.dbf data file is not synchronized withthe other database files.E.The user_data01.dbf file is corrupted because of the instance failure during the online backup of thedata file.Answer : BCD29.You just completed a manual open database backup. However there seems to be a problem with thedatabase performance. You discover that the database is generating many log switches and the LGWR isconsuming lots of CPU time. You have an idea of what the problem is and you begin looking at theinformation in V$BACKUP and in V$DATAFILE_HEADER.What do you suspect is the problem?A.One or more data files have a status of ACTIVE.B.One or more data files have a status of ONLINE.C.One or more data files have a status of OFFLINE.D.One or more data files have a status of NOT ACTIVE.Answer : A30.Because your business requirements do not permit you to shut down the database to performbackups, you decide to perform online backups. You use the ALTER TABLESPACE .. BEGIN BACKUPcommand to perform the backups. The command returns the following error:ERROR at line 1:ORA01123:cannot start online backup; media recovery not enabledWhat could be the reason for this error?A.The database is in the MOUNT state.B.The database is in NOARCHIVELOG mode.C.The command was executed on the SYSTEM tablespace.D.The command was executed on a temporary tablespace.E.The command was executed on a readonlytablespace.Answer : B
页:
[1]