Oracle基础真题及答案近年合集.pdfVIP

Oracle基础真题及答案近年合集

1.01Oracle11G题库337中文版01

2.01Oracle认证1Z0-062-01

3.01Oracle认证1z0-071-01

4.02Oracle11G题库337中文版02

5.02Oracle认证1Z0-062-02

6.02Oracle认证1z0-071-02

7.03Oracle11G题库337中文版03

8.03Oracle认证1Z0-062-03

9.04Oracle11G题库337中文版04

10.04Oracle认证1Z0-062-04

真题及答案1/131

01Oracle11G题库337中文版01

1.[多选题]IdentifytwosituationsinwhichyoucanuseDataRecoveryAdvisorforrecovery.(Choosetwo.)

确定哪两种情况下，你可以使用用于恢复的数据恢复顾问。

A)Theuserhasdroppedanimportanttablethatneedstoberecovered.

B)Thedatabasefilesarecorruptedwhenthedatabaseisopen)

C)Youarenotabletostartupthedatabaseinstancebecausetherequireddatabasefilesaremissing.

D)Thearchivedlogfilesaremissingforwhichbackupisnot

答案:BC

解析:

2.[单选题]ExaminethefollowingvaluesoftheinitializationparametersinthedatabasehavingtheSID

ORCL:

检查以下在数据库中具有ORCLSID的初始化参数的值：

BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdu

mpUSER_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

Theenvironmentvariableshavethefollowing

value:ORACLE_BASE=/u01/app/oracle

ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1

WhatisthelocationoftheAutomaticDiagnosticRepository(ADR)home?

A)/u01/app/oracle/product/11.1.0/db_1

B)/u01/app/oracle

C)$ORACLE_HOME/bdump

D)$ORACLE_HOME/log

答案:B

解析:

3.[单选题]Observ