【OCP｜052】2018最新考试题库原题-8-cuug

《【OCP｜052】2018最新考试题库原题-8-cuug》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、cuug-052题库解析最新15道题www.cuug.com题库新特点：l最原有的题库基础上有添加了新的题库www.cuug.com七.StorageStructures19.Whichthreestructurescanspanmultipledatafiles？A)migratedrowsB)tableextentsC)temporarysegmentextents D)indexextentsE)chainedrowsF)segmentsAnswer：AEFwww.cuug.com20.Whichstructurecanspanmultipledatafiles? A)a

2、bigfiletablespaceB)apermanenttablespace C)asegmentD)atemporarytablespace E)anextentAnswer：Cwww.cuug.com21.Whichfourdatabaseobjectsneverhaveanysegments？A)ApartitionedindexB)Aviewselectingfromapopulatedtable C)AnemptyindexD)AnOracleLoadertypeexternaltable E)AnemptytableF)Aviewselectingfromane

3、mptytable G)AnOracleDataPumptypeexternaltable Answer：BDFGwww.cuug.com22.Whichthreeofthesemustbeaccessibletokeepadatabaseopen?A)Controlfile.B)Allmembersofaredologgroup.C)SYSTEMtablespace.D)SYSAUXtablespace.E)spfileAnswer：ABCwww.cuug.com23.WhichtwoofthesemustbeavailableREAD/WRITEtokeepadatabas

4、eopen?A)allcopiesofthecontrolfile.B)thepasswordfile.C)allmembersofthecurrentredologgroup.D)spfile.E)TEMPtablespaceF)SYSAUXtablespaceAnswer：ACwww.cuug.com24.ArchivelogmodeisenabledforyourdatabaseandDB_CREATE_FILE_DESTissetto‘/u01/oracle/db01’.Theparameters,DB_CREATE_ONLINE_LOG_DESN_nandDB_RECO

5、VERY_FILE_DEST,andnotspecified.WhichfourarestoredinthelocationspecifiedbyDB_CREATE_FILE_DEST?A)auditlogsB)controlfilesC)redologsD)auditfilesE)datafilesF)archivedredologsG)tempfilesH)RMANbackupsAnswer：BCEGwww.cuug.com八.Checkpoint25.Whendoesanincrementalcheckpointoccur? A)whenanonlineredologswitch

6、occurs. B)whenDBWnwritesdirtybuffersaspartofitsnormal processing.C)whentheALTERSYSTEMCHECKPOINTstatement isexecuted.D)whenausertablespaceistabkenoffline. Answer：Awww.cuug.com九.InventoryDirectory24.WhichtwoaretrueabouttheInventorydirectory? A)ItissharedbyallOraclesoftwareinstallationsonasing

7、leserver. B)ItisrequiredonlyforOracleGridInfrastructureandOracleDatabase softwareInstallations.C)ItcanbecreatedonlyiftheORACLE_BASEenvironmentvariableis set.D)ItshouldbecreatedbeforeinstallingOraclesoftwareforthefirsttimeonaserver.E)Itisownedbytheoinstallgroup,