欢迎来到天天文库
浏览记录
ID:21373673
大小:105.98 KB
页数:18页
时间:2018-10-21
《OCP考试052最新考试题库原题-8-20180727》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、052题库解析最新15道题052-题库解析-8-20180727题库新特点:l最原有的题库基础上有添加了新的题库每周五晚8点-直播地址:ke.qq.com/course/326223ocp考试讨论群:836361015验证:ocpCUUG整理,官网:www.cuug.com七.StorageStructures19.Whichthreestructurescanspanmultipledatafiles?A)migratedrowsB)tableextentsC)temporarysegmentextents D)indexextentsE)chainedrowsF)segmentsAnswe
2、r:AEF20.Whichstructurecanspanmultipledatafiles? A)abigfiletablespaceB)apermanenttablespace C)asegmentD)atemporarytablespace E)anextentAnswer:C21.Whichfourdatabaseobjectsneverhaveanysegments?A)ApartitionedindexB)Aviewselectingfromapopulatedtable C)AnemptyindexD)AnOracleLoadertypeexternaltable E)Anempt
3、ytableF)Aviewselectingfromanemptytable G)AnOracleDataPumptypeexternaltable Answer:BDFG22.Whichthreeofthesemustbeaccessibletokeepadatabaseopen?A)Controlfile.B)Allmembersofaredologgroup.C)SYSTEMtablespace.D)SYSAUXtablespace.E)spfileAnswer:ABC23.WhichtwoofthesemustbeavailableREAD/WRITEtokeepadatabaseope
4、n?A)allcopiesofthecontrolfile.B)thepasswordfile.C)allmembersofthecurrentredologgroup.D)spfile.E)TEMPtablespaceF)SYSAUXtablespaceAnswer:AC24.ArchivelogmodeisenabledforyourdatabaseandDB_CREATE_FILE_DESTissetto‘/u01/oracle/db01’.Theparameters,DB_CREATE_ONLINE_LOG_DESN_nandDB_RECOVERY_FILE_DEST,andnotspec
5、ified.WhichfourarestoredinthelocationspecifiedbyDB_CREATE_FILE_DEST?A)auditlogsB)controlfilesC)redologsD)auditfilesE)datafilesF)archivedredologsG)tempfilesH)RMANbackupsAnswer:BCEG八.Checkpoint25.Whendoesanincrementalcheckpointoccur? A)whenanonlineredologswitchoccurs. B)whenDBWnwritesdirtybuffersaspartofit
6、snormal processing.C)whentheALTERSYSTEMCHECKPOINTstatement isexecuted.D)whenausertablespaceistabkenoffline. Answer:A九.InventoryDirectory24.WhichtwoaretrueabouttheInventorydirectory? A)ItissharedbyallOraclesoftwareinstallationsonasingleserver. B)ItisrequiredonlyforOracleGridInfrastructureandOracleDat
7、abase softwareInstallations.C)ItcanbecreatedonlyiftheORACLE_BASEenvironmentvariableis set.D)ItshouldbecreatedbeforeinstallingOraclesoftwareforthefirsttimeonaserver.E)Itisownedbytheoinstallgroup,whichmustbecr
此文档下载收益归作者所有