OCP考试052最新考试题库原题90803Word格式.docx
《OCP考试052最新考试题库原题90803Word格式.docx》由会员分享，可在线阅读，更多相关《OCP考试052最新考试题库原题90803Word格式.docx（5页珍藏版）》请在冰豆网上搜索。
34.Whichfouraretrueaboutauditing?
A）DMLstatementscanbeauditedwhentheyfailtoexecuteB）Selectstatementscanbeauditedwhentheyexecutesuccessfully.C）AllOracleauditingoperationsoccurbydefault.D）NoOracleauditingoperationsoccurbydefault.
E）DDLstatementscanbeauditedwhentheyfailtoexecute.F）Someauditingisactivebeforethedatabaseisopen.G）Auditrecordsareneverstoredinthedatabase.H）Auditrecordsarealwaysstoredinthedatabase.
ABEF
34.Examinethissessionoutput:
SQL>
connectscott/tigerConnected.
selectname,value2fromv$parameter
3wherename='
audit_trail'
;
NAMEVALUE
----------------------------------------audit_trailDB
auditallonemp;
Auditsucceeded.
Whichtwowillgenerateanauditrecord?
A）everyUPDATEstatementexecutedbySCOTTthatupdatesSCOTT.EMP.B）everyDDLstatementexecutedbySCOTTthataffectsSCOTT.EMP.C）anyDMLstatementexecutedbySYSonSCOTT.EMP.D）onlythefirstSELECTstatementexecutedbySCOTTinasessiononSCOTT.EMP
E）everyUPDATEstatementexecutedbySCOTTthatupdatesHR.EMP
Answer:
AB
十.DBlink
36.yousuccessfullyexecutedthesemands:
connectscott/tigerprod1;
CREAETDATABASELINKdb_prod2
CONNECTTOscottIDENTIFIEDBYtigerUSING'
PROD2'
Whichtypeofdatabaselinkiscreated?
A）privatecurrentuserdatabaselinkB）publicconnecteduserdatabaselinkC）publiccurrentuserdatabaselinkD）privatefixeduserdatabaselinkE）publicfixeduserdatabaselink
十五.ExternalTable
37.whichistrueaboutexternaltables?
A）Segmentsareallocatedforexternaltables.B）Theymayhaveindexes.
C）Theydonotsupportpartitioning.
D）TheORACLE_DATAPUMPaccessdrivercanbeusedtowritedatatoexternaltables.
E）DMLoperationsmaybeperformedonexternaltables.
CREATETABLEscott.countries_ext
ORGANIZATIONEXTERNAL（
TYPEOracle_DATAPUMP
DEFAULTDIRECTORYdir--生成dmp文件存放路径LOCATION（'
countries_ext.dmp'
）--生成外部文件的名称
）
ASSELECT*FROMscott.countries;
--数据来源于实体表
38.Whichtwoaretrueaboutexternaltables?
A）TheycanbestoredinanASMClusterFileSystem（ACFS）.B）TheycanalwaysbeupdatedusingSQL.C）TheysupporttheORACLE_DATAPUMPaccessdriver.D）Theyhaveextents.
E）TheysupportallDMLoperations.
AC
39.Youwanttoaccessemployeedetailscontainedinflatfilescreatedbyanapplication.Whichtwomethodswillachievethis?
A）UseaBFILEcolumninatabletoaccesstheflatfile.B）UseanOracleLoadertypeExternaltable.
C）UseanOracleDataPumptypeExternaltable.
D）UseaCLOBcolumninatabletoaccesstheflatfile.
E）UseaLONGRAWcolumninatabletoaccesstheflatfile.
FlatFile:
平面文件,我们平常见到的txt、csv等都属于平面文件。
⼗六.Temporarytable
40.Examinethismand:
CREATEGLOBALTEMPORARYTABLEreport_work_area（startdateDATE,
enddateDATE,classCHAR（20））
ONMITPRESERVEROWS;
WhichthreestatementsaretrueaboutrowsinsertedintoREPORT_WORK_AREA?
A）RowswillbelostifaROLLBACKisdone.B）Rowswillbelostuponsessionfailure.
C）Rowsarevisibletoallsessionsloggedinbythesameuseruntilthesessionthatinsertedtherowsterminates.
D）RowsarevisibletoallsessionsloggedinbyallusersgrantedtheDBAroleuntilthesessionthatinsertedtherowsterminates.E）Rowswillbelostuponsessionnormaltermination.
F）Rowsarevisiblegloballytoallsessionsloggedinbyanyuseruntilthesessionthatinsertedtherowsterminates.
ABE
deleterows用于事务相关,也就在事务结束后truncatedatainthetemporarytable.
preserverows表示在会话结束后清除临时表的数据
前者在事务提交后数据就已经清除了．
后者在会话中止时或者导常退出时数据都会被清除掉．
⼗十七.ADDM
41.WhichthreearetrueabouttheAutomaticDatabaseDiagnosticMonitor（ADDM）?
A）ItimprovesdatabaseperformancebyautomaticallyimplementingOracle‘sbestpractices.
B）ItcanassisttheDBAindiagnosingdatabaseinstancestartupfailures.C）ItcanbeusedbyexecutingthePL/SQLproceduresintheDBMS_ADDMpackage.
D）ItrunsautomaticallyaftereachAutomaticWorkloadRepositorysnapshotiscreated.
E）Itprovidesremendationstoimprovedatabaseperformance.
F）ItsfindingsareaccessibleonlybyusingOracleEnterpriseManager.
CDE
42.WhichistrueabouttheAutomaticDiagnosticRepository（ADR）？
A）ItisusedonlyiftheDIAGNOSTIC_DESTparameterismanuallyconfigured.
B）Itonlycontainsthealertlogandtracefilesforbackgroundprocesses.C）ItslocationisalwayssetbytheORACLE_BASEvariable.D）Itincludesdiagnosticdataforcriticalerrorsforeachserverandbackgroundprocess.
在Oracle的11g版本中，alert文件的位置发生了变化，与此同时Oracle提供了一个命令行工具ADRCI，它可以很便利的查看数据库中出现的异常。
1.查看到adrci命令行帮助
$adrci-help
2.使用helpshowalert命令查看帮助文档adrci>
help
3.使用showalert列出各个目录下的日志目录adrci>
showalert
ADR的结构和位置：
初始化参数diagnostic_dest指定了ADR的根目录。
即使你忽略了该初始化参数。
oracle也会创建ADR。
如果你设置了ORACLE_BASE环境变量，那么diagnostic_dest缺省值是该目录。
如果你没有设置ORACLE_BASE变量，该参数值为$ORACLE_HOME/log目录。
ADR存储所有oracle产品的诊断数据。
ADR为每一个oracle产品及其实例分配一个单独的home目录。
因此一个ADR目录包含多个home目录。
每一个ADR的home目录是一个为每一个数据库实例或其它oracle产品或组件存储其诊断文件。
其目录结构如下：
ADR_base/diag/product_type/product_id/instance_id/，比如一个diagnostic_dest初始化参数为/u05/app/oracle。
那么一个oracle数据库的sid为prod1的home目录就如下所示：
/u05/app/oracle/diag/rdbms/prod1/prod1/
43.WhichtwostatementsaretrueabouttheAutomaticDiagnosticRepository（ADR）？
A）ItonlyexistsifDIAGNOSTIC_DESTisconfiguredintheSPFILE.B）Itincludesdiagnosticdataforcriticalerrorsforbackgroundprocesses.C）Itonlycontainsthealertlog.D）Itonlycontainstracefiles.
E）Itincludesdiagnosticdataforcriticalerrorsforclientprocesses.F）Itincludesdiagnosticdataforcriticalerrorsforserverprocess.
BF
⼗八.FRA
44.WhichtwoaretrueabouttheFastRecoveryArea（FRA）?
A）Itshouldbelargerthanthedatabase.
B）OnlyconsistentbackupscanbestoredintheFRA.C）SpacemanagementintheFRAisinfluencedbythedatabasebackupretentionpolicy.
D）Itmustresideonthesamefilesystemasthedatabasedatafiles.E）AdatabasemustbeinARCHIVELOGmodetousetheFRA.
45.YourdatabaseisopeninARCHIVELOGmode.LOG_ARCHIVE_DESTissettoFastRecoveryArea（FRA）andItis100%fullwhenalogswitchtakesplace.
Noalternativeoroptionalarchivedestinationsaredefined.Whatistheoute?
A）Obsoletebackupsareautomaticallydeletedandnewarchivelogsaregenerated.
B）Allactivesessionshanguntilthedatabaseadministrator（DBA）makesspaceavailableintheFRA.
C）Thearchivelogentriesaremadeinthediagnosticdestinationandwhenspaceisavailable,newarchivelogsaregenerated.D）Allactivesessionsaredisconnectedandtheirtransactionsrolledback.
E）Noarchivelogsaregenerated.
A（验证过）
46.YourDB_RECOVERY_FILE_DEST_SIZEIS8G,Currently，5Gofthespaceisusedofwhich4Gconsistsofobsoletebackups,Youexecutethismand;
ALTERSYSTEMSETdb_recovery_file_dest_size=2G;
Whatistheoute?
A）ItchangesDB_RECOVERY_FILE_DEST_SIZEto2Ganddeletestheobsoletebackups
B）ItchangesDB_RECOVERY_FILE_DEST_SIZEto5GC）ItfailsbecauseDB_RECOVERY_FILE_DEST_SIZEisastaticparameterD）ItchangesDB_RECOVERY_FILE_DEST_SIZEto2Gwithoutdeletingvalidbackups
E）Itfailsbecausethenewsizeislessthan5G
D（验证过）
升级会员 