To implement Automatic Memory Management (AMM), you set the following parameters:When you try to start the database instance with these parameter settings, you receive the following error message:SQL
原创
2018-03-15 11:48:33
1455阅读
点赞
1评论
Examine the following query output:You issue the following command to import tables into the hr schema:$ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE
原创
2018-03-15 16:09:44
870阅读
点赞
1评论
65、(22-16)choosethebestanswer:TheCUSTOMERStablehasthefollowingstructure:Youneedtowriteaquerythatdoesthefollowingtasks:Displaythefirstnameandtaxamountofthecustomers.Taxis5%oftheircreditlimit.Onlythosec
原创
2019-03-07 10:14:22
316阅读
69、(31-1)choosethebestanswer:Evaluatethefollowingquery:SELECTINTERVAL'300'MONTH,INTERVAL'54-2'YEARTOMONTH,INTERVAL'11:12:10.1234567'HOURTOSECONDFROMdual;Whatisthecorrectoutputo
原创
2019-03-08 09:41:27
493阅读
67、(25-8)choosethebestanswer:ViewtheExhibitandexaminethestructureofCUSTOMERStable.Evaluatethefollowingquery:SQL>SELECTcust_id,cust_cityFROMcustomersWHEREcust_firstnameNOTLIKE'A%g_%'ANDcust_
原创
2019-03-07 11:26:34
391阅读
68、(29-13)choosetwo:Whichtwostatementsaretrue?(Choosetwo.)A)DICTIONARYisaviewthatcontainsthenamesofallthedatadictionaryviewsthattheusercanaccess.B)TheuserSYSTEMownsallthebasetablesanduser-accessiblevi
原创
2019-03-07 11:57:14
488阅读
71、(32-18)choosethreeWhichthreestatementsindicatetheendofatransaction?(Choosethree.)A)afteraCREATEstatementisissuedB)afteraSELECTstatementisissuedC)afteraROLLBACKisissuedD)afteraSAVEPOINTisissuedE)aft
原创
2019-03-08 11:48:56
365阅读
以下是Database 12c的OCM OCP认证的 认证路径：
12c OCP:
原创
2013-04-17 22:46:23
1025阅读
66、(22-19)choosetwoExaminethestructureproposedfortheTRANSACTIONStable:Whichtwostatementsaretrueregardingthecreationandstorageofdataintheabovetablestructure?A)TheTRANS_DATEcolumnwouldbeabletostoreday,m
原创
2019-03-07 10:56:08
490阅读
70、(31-2)choosethebestanswer:ViewtheExhibitandexaminethestructureoftheBooktable.TheBOOKStablecontainsdetailsof100books.Examinethecommandsexecutedandtheiroutcome:SQL>INSERTINTObooksVALUES('ADV11
原创
2019-03-08 10:13:30
701阅读
72、ViewtheexhibitforthestructureoftheSTUDENTandFACULTYtables.STUDENTNameNull?TypeSTUDENT_IDNOTNULLNUMBER(2)STUDENT_NAMEVARCHAR2(20)FACULTY_IDVARCHAR2(2)LOCATION_IDNUMBER(2)FACULTYNameNull?TypeFACULTY_
原创
2019-03-08 13:13:33
764阅读
1评论
7.daily_ords_lstiscreatedinlocallymanagedtablespaceORDERS_TBSwhichusesautomaticsegmentspacemanagement.CREATETABLEdaily_ords_list(ordnoNUMBER,ord_dateDATE)PCTFREE20;Whichtwoaretrue?A)80%ofeverydatabloc
原创
2019-04-24 13:14:39
594阅读
SQL*Loader是Oracle提供的一个非常有用的工具，可以实现批量数据的高速加载，它将数据从外部文件加载到Oracle数据库的表中，本篇将对Oracle 12c的SQL*Loader进行简单的介绍和演示。1 SQL*Loader介绍SQL*Loader的使用，是通过Oracle的命令行指令sqlldr实现，该指令是客户端工具，可通过KEY-VALUE的形式指定对应的选项，或者使用参数文件和控
转载
2021-04-27 19:03:42
498阅读
2评论
53、(12-14)choosethebestanswer:ExaminethecommandtocreatetheBOOKStable.SQL>CREATETABLEbooks(book_idCHAR(6)PRIMARYKEY,titleVARCHAR2(100)NOTNULL,publisher_idVARCHAR2(4),author_idVARCHAR2(50));TheBOOK_I
原创
2019-03-04 11:32:13
452阅读
59、(16-8)choosetwo:WhichtwostatementsaretrueregardingtheUSINGandONclausesintablejoins?A)TheONclausecanbeusedtojointablesoncolumnsthathavedifferentnamesbutcompatibledatatypes.B)Amaximumofonepairofcolum
原创
2019-03-05 13:10:51
374阅读
54、(12-15)choosethebestanswer:ViewtheExhibitandexaminethestructureoftheORDER_ITEMSandORDERStables.YouareaskedtoretrievetheORDER_ID,PRODUCT_ID,andtotalprice(UNIT_PRICEmultipliedbyQUANTITY),wherethetota
原创
2019-03-04 13:21:11
256阅读
60、(16-10)choosethebestanswer:EvaluatethefollowingSQLcommands:SQL>CREATESEQUENCEord_seqINCREMENTBY10STARTWITH120MAXVALUE9999NOCYCLE;SQL>CREATETABLEord_items(ord_noNUMBER(4)DEFAULTord_seq.NEXTVAL
原创
2019-03-05 14:26:27
375阅读
55、(13-3)choosethebestanswer:WhichstatementistrueregardingtheSESSION_PRIVSdictionaryview?A)Itcontainstheobjectprivilegesgrantedtootherusersbythecurrentusersession.B)Itcontainsthesystemprivilegesgrante
原创
2019-03-04 14:02:11
361阅读
56、(14-14)choosethebestanswer:Youneedtocreateatablewiththefollowingcolumnspecifications:EmployeeID(numericdatatype)foreachemployeeEmployeeName(characterdatatype)thatstorestheemployeenameHiredate,which
原创
2019-03-04 14:38:47
317阅读
57、(14-17)choosetwo:ExaminethestructureoftheDEPARTMENTStableYouexecutethefollowingcommand:SQL>ALTERTABLEdepartmentsSETUNUSED(country);Whichtwostatementsaretrue?A)Anewcolumn,COUNTRY,canbeaddedtotheD
原创
2019-03-05 10:21:21
382阅读
