Oracle试题:032的23-30题

shijunhua618

最新Oracle 9i DBA题库:032的23-30题
) _* r& Q: Q' M认证名称：orcacle9l database:fundamentals ii
- q3 }& T4 y$ W

23.Which usermanaged

backup performed on your database can be labeled as consistent?

A.a backup performed when the database is open

B.a backup performed on a tablespace after putting the tablespace into backup mode

C.a backup performed when the database is closed by using the SHUTDOWN ABORT command

D.a backup performed when all data files and control files are checkpointed with respect to the same

system change number (SCN)

Answer : D

24.Which two file types must be included in a closed database backup taken with operating system

commands? (Choose two.)

A.data files

B.control file

C.password file

D.online redo log files

E.initialization parameter file

Answer : AB

25.You plan to take a closed database backup using operating system commands. Which three

SHUTDOWN options are appropriate for this type of backup? (Choose three.)

A.ABORT

B.NORMAL

C.IMMEDIATE

D.TRANSACTIONAL

Answer : BCD

26.You work on a database that is used for application development and operates in NOARCHIVELOG

mode. The database has 10 tablespaces out of which two are read only. As a DBA, you know that

database downtime can be tolerated and have designed a backup strategy containing a weekly closed

database backup. Which files can you exclude from the weekly usermanaged

backup? (Choose all that

apply.)

A.control files

B.sqlnet.ora file

C.tnsnames.ora file

D.data files associated with readonly

tablespaces

E.data files associated with read/write tablespaces

Answer : BCD

27.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 strategy

containing a weekly closed database backup. The local naming method is used by clients to connect to

the database.

Which files should you include in this weekly usermanaged

backup? (Choose all that apply.)

A.control file

B.sqlnet.ora file

C.archived log files

D.tnsnames.ora file

E.listener configuration file

Answer : AC

28.You issue this SQL command to perform an online backup of the USER_DATA tablespace: ALTER

TABLESPACE user_data BEGIN BACKUP;

Next, you issue an operating system command to back up user_data01.dbf, the file that belongs to the

USER_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 not

completed before the instance failure.

D.The database open fails because the header of the user_data01.dbf data file is not synchronized with

the other database files.

E.The user_data01.dbf file is corrupted because of the instance failure during the online backup of the

data file.

Answer : BCD

29.You just completed a manual open database backup. However there seems to be a problem with the

database performance. You discover that the database is generating many log switches and the LGWR is

consuming lots of CPU time. You have an idea of what the problem is and you begin looking at the

information 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 : A

30.Because your business requirements do not permit you to shut down the database to perform

backups, you decide to perform online backups. You use the ALTER TABLESPACE .. BEGIN BACKUP

command to perform the backups. The command returns the following error:

ERROR at line 1:

ORA01123:

cannot start online backup; media recovery not enabled

What 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 readonly

tablespace.

Answer : B