OCP考试052最新考试题库原题-8-20180727

《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