2、WhichtwoaretrueaboutOptimizerStatistics?❑A)TheydonotpersistacrossInstancerestarts.❑B)TheyareautomaticallyupdatedwhenDDLstatementsexecute.❑C)TheyaregatheredbytheManageabilityMonitor(MMON)backgroundpr
原创 2018-07-06 11:25:24
762阅读
1、.WhichtwoaretrueabouttheArchive(ARCn)processes?❑A)Theyautomaticallydeleteobsoletearchivelogstomakespacefornewarchivelogs.❑B)TheyareusedduringInstancerecovery.❑C)Theyarchiveredodirectlyfromtheredolog
原创 2018-07-05 13:42:04
1004阅读
提示:文章写完后,目录可以自动生成,如何生成可参考右边的帮助文档 文章目录MySQL和Oracle区别应用场景相同点不同点规模数据量并发性持久性主从复制事务隔离级别语法不同 MySQL和Oracle区别Oracle支持大并发,大访问量,是OLTP(On-Line Transaction Processing联机事务处理系统)最好的工具应用场景对于Mysql数据库: ①Mysql属于轻量级数据库,小
该系列专题为2018年4月OCP-052考题变革后的最新题库题库为小麦苗解答,若解答有不对之处,可留言,也可联系小麦苗进行修改。 注:OCP-052最新题库完整详细解答版请联系小麦苗私聊。解题不易...
原创 2021-08-06 15:22:58
85阅读
38.choosethebestanswerViewtheExhibitandexaminethedatainthePROMOTIONStable.PROMO_BEGIN_DATEisstoredinthedefaultdateformat,dd-mon-rr.Youneedtoproduceareportthatprovidesthename,cost,andstartdateofallprom
原创 2019-02-26 16:08:29
410阅读
39.choosethebestanswerViewtheExhibitandexaminethedescriptionoftheEMPLOYEEStable.Youwanttocalculatethetotalremunerationforeachemployee.Totalremunerationisthesumoftheannualsalaryandthepercentagecommissi
原创 2019-02-26 16:35:53
710阅读
44、(9-12)chooseallthatapplyViewtheExhibitandexaminethedetailsoftheORDER_ITEMStable.EvaluatethefollowingSQLstatements:Statement1:SELECTMAX(unit_price*quantity)"MaximumOrder"FROMorder_items;St
原创 2019-02-27 11:43:46
577阅读
46、(10-4)choosetwo:ExaminethedataintheCUST_NAMEcolumnoftheCUSTOMERStable.CUST_NAMELexDeHaanRenskeLadwigJoseManuelUrmanJasonMallinYouwanttoextractonlythosecustomernamesthathavethreenamesanddisplaythe*s
原创 2019-02-28 10:16:40
373阅读
47、(10-6)choosetwoYouneedtocalculatethenumberofdaysfrom1stJanuary2007tilldate.Datesarestoredinthedefaultformatofdd-mon-rr.WhichtwoSQLstatementswouldgivetherequiredoutput?A)SELECTTO_DATE(SYSDATE,'D
原创 2019-02-28 11:37:22
462阅读
该系列专题为2018年4月OCP-052考题变革后的最新题库题库为小麦苗解答,若解答有不对之处,可留言,也可联系小麦苗进行修改。 注:OCP-052最新题库完整详细解答版请联系小麦苗私聊。解题不易...
原创 2021-08-06 15:12:59
54阅读
19.choosethebestanswerViewtheExhibitandexaminethestructureofthePROMOTIONStable.EvaluatethefollowingSQLstatement:SQL>SELECTpromo_name,CASEWHENpromo_cost>=(SELECTAVG(promo_cost)FROMpromotionsWHERE
原创 2019-02-26 15:18:57
458阅读
40、(8-7)choosetwoWhichtwostatementsaretrueregardingviews?(Choosetwo.)A)Asimpleviewinwhichcolumnaliaseshavebeenusedcannotbeupdated.B)TheORREPLACEoptionisusedtochangethedefinitionofanexistingviewwithout
原创 2019-02-26 17:06:51
346阅读
42、(9-1)choosethebestanswer:WhichstatementistrueabouttheOracleSQL,DELETEandTRUNCATEstatements?A)DELETEbutnotTRUNCATEstatementcanbeusedtoremovedatafromselectivecolumnsandrowsofatable.B)DELETEandTRUNCAT
原创 2019-02-27 10:35:03
471阅读
45、(9-16)choosethebestanswer:ViewtheExhibitandexaminethedataintheEMPLOYEEStable.Youwanttogenerateareportshowingthetotalcompensationpaidtoeachemployeetodate(迄今为止支付给每位员工的总补偿).Youissuethefollowingquery:S
原创 2019-02-28 09:34:55
309阅读
41、(8-14)choosetwoViewtheExhibitandexaminethestructureoftheORDERStable.ThecolumnsORDER_MODEandORDER_TOTALhavethedefaultvalues'direct'and0respectively.WhichtwoINSERTstatementsarevalid?(Choosetw
原创 2019-02-27 09:49:56
583阅读
43、(9-2)choosethreeWhichthreetaskscanbeperformedbyDDLstatements?A)preventingdataretrievalfromatableoutsideofofficehoursB)modifyingatabletopreventdatathatviolatecertainconditionsfrombeingenteredinacolu
原创 2019-02-27 11:10:45
743阅读
一、宏观上:1、Oracle是大型的数据库而Mysql是中小型数据库;Mysql是开源的,Oracle是收费的,且价格昂贵。2、Oracle支持大并发,大访问量,是OLTP的最好的工具。3、安装占用的内存也是有差别,Mysql安装完成之后占用的内存远远小于Oracle所占用的内存,并且Oracle越用所占内存也会变多。二、微观上:1、对于事务的支持Mysql对于事务默认是不支持的,只是有某些存储引
OCP|052】OCP最新题库解析(052)--小麦苗解答版 OCP最新题库解析历史连接(052):http://mp.weixin.qq.com/s/bUgn4-uciSndji_pUbLZfA⊙ 【OCP最新题库解析(052)--题20】Which command is used to dis
原创 2021-05-20 18:45:32
169阅读
OCP|052】OCP最新题库解析(052)--小麦苗解答版 OCP最新题库解析历史连接(052):http://mp.weixin.qq.com/s/bUgn4-uciSndji_pUbLZfA    【OCP|052】OCP最新题库解析(052)--小麦苗解答版   OCP最新题库解析历史连接(052):http://mp.weixin.qq.com/s/bUgn4-uciSndji_pU
原创 2021-08-06 11:12:24
74阅读
  • 1
  • 2
  • 3
  • 4
  • 5