没有合适的资源？快使用搜索试试~ 我知道了~

文库首页考试认证Oracle认证ocp考试题库

ocp考试题库

oracle

5星 · 超过95%的资源需积分: 11 27 下载量 169 浏览量 2012-07-06 10:54:41 上传评论 1 收藏 8.93MB PDF 举报

温馨提示

试读

177页

此文件是给想得到ocp认证的一个捷径，里面的内容是靠oracle认证数据库专家的题库，

资源推荐

资源详情

资源评论

Testinside

Exam :Oracle1Z0047

Title   :OracleDatabaseSQLExpert

Version:V2.23

TestInside,help you pass any IT exam!

Testinside

ImportantNote,PleaseReadCarefully

OtherTestInsideproducts

OfflineTestingEngine

UsetheofflineTestingengineproducttopracticethequestionsinanexamenvironment.

Buildafoundationofknowledgewhichwillbeusefulalsoafterpassingtheexam.

DownloadtheTestingEngineVersionof1Z0047

More TestInside Oracle OtherOracleCertification Products

LatestVersion

We are constantly reviewing our products. New material is added and old material is revised. Free

updatesareavailablefor90daysafterthepurchase.YoushouldcheckyourmemberzoneatTestInside

andupdate34daysbeforethescheduledexamdate.

Hereistheproceduretogetthelatestversion:

1.Goto http://www.TestInside.com

2.LogintheUserCenter

3.Thelatestversionsofallpurchasedproductsaredownloadablefromhere.Justclickthelinks.

Feedback

Ifyouspotapossibleimprovementthenpleaseletusknow.Wealwaysinterestedinimprovingproduct

quality.

Feedbackshouldbesendtosales@TestInside.com.Youshouldincludethefollowing:Examnumber,

version,pagenumber,questionnumber,andyourlogin Account.

Ourexpertswillansweryourmailpromptly.

Explanations

Thisproductdoesnotincludeexplanationsatthemoment.Ifyouareinterestedinprovidingexplanations

forthisexam,pleasecontactsales@TestInside.com.

Testinside

1.YouneedtoloadinformationaboutnewcustomersfromtheNEW_CUSTtableintothetablesCUST

andCUST_SPECIAL.Ifanewcustomerhasacreditlimitgreaterthan10,000,thenthedetailshavetobe

insertedintoCUST_SPECIAL.AllnewcustomerdetailshavetobeinsertedintotheCUSTtable.Which

techniqueshouldbeusedtoloadthedatamostefficiently?

A.externaltable

B.theMERGEcommand

C.themultitableINSERTcommand

D.INSERTusingWITHCHECKOPTION

Answer:C

2.ViewtheExhibitandexaminethedescriptionoftheCUSTOMERStable.

YouwanttoaddaconstraintontheCUST_FIRST_NAMEcolumnoftheCUSTOMERStablesothatthe

valueinsertedinthecolumndoesnothavenumbers.

WhichSQLstatementwouldyouusetoaccomplishthetask?

A.ALTERTABLECUSTOMERS

ADDCONSTRAINTcust_f_name

CHECK(REGEXP_LIKE(cust_first_name,'^AZ'))NOVALIDATE;

B.ALTERTABLECUSTOMERS

ADDCONSTRAINTcust_f_name

CHECK(REGEXP_LIKE(cust_first_name,'^[09]'))NOVALIDATE;

C.ALTERTABLECUSTOMERS

Testinside

ADDCONSTRAINTcust_f_name

CHECK(REGEXP_LIKE(cust_first_name,'[[:alpha:]]'))NOVALIDATE;

D.ALTERTABLECUSTOMERS

ADDCONSTRAINTcust_f_name

CHECK(REGEXP_LIKE(cust_first_name,'[[:digit:]]'))NOVALIDATE;

Answer:C

3.WhichthreetaskscanbeperformedusingregularexpressionsupportinOracleDatabase10g?

(Choosethree.)

A.Itcanbeusedtoconcatenatetwostrings.

B.Itcanbeusedtofindoutthetotallengthofthestring.

C.Itcanbeusedforstringmanipulationandsearchingoperations.

D.Itcanbeusedtoformattheoutputforacolumnorexpressionhavingstringdata.

E.Itcanbeusedtofindandreplaceoperationsforacolumnorexpressionhavingstringdata.

Answer:CDE

4.ViewtheExhibitandexaminethestructureoftheEMPtablewhichisnotpartitionedandnotan

indexorganizedtable.

EvaluatethefollowingSQLstatement:

ALTERTABLEemp

DROPCOLUMNfirst_name;

Whichtwostatementsaretrueregardingtheabovecommand?(Choosetwo.)

A.TheFIRST_NAMEcolumnwouldbedroppedprovideditdoesnotcontainanydata.

B.TheFIRST_NAMEcolumnwouldbedroppedprovidedatleastoneormorecolumnsremaininthe

table.

C.TheFIRST_NAMEcolumncanberolledbackprovidedtheSETUNUSEDoptionisaddedtotheabove

SQLstatement.

D.TheFIRST_NAMEcolumncanbedroppedevenifitispartofacompositePRIMARYKEYprovided

theCASCADEoptionisused.

Testinside

Answer:BD

5.EvaluatetheCREATETABLEstatement:

CREATETABLEproducts

(product_id   NUMBER(6)CONSTRAINTprod_id_pk  PRIMARYKEY,

product_name  VARCHAR2(15));

WhichstatementistrueregardingthePROD_ID_PKconstraint?

A.Itwouldbecreatedonlyifauniqueindexismanuallycreatedfirst.

B.Itwouldbecreatedandwoulduseanautomaticallycreateduniqueindex.

C.Itwouldbecreatedandwoulduseanautomaticallycreatednonuniqueindex.

D.Itwouldbecreatedandremainsinadisabledstatebecausenoindexisspecifiedinthecommand.

Answer:B

6.Whichtwostatementsaretrue?(Choosetwo.)

A.TheUSER_SYNONYMSviewcanprovideinformationaboutprivatesynonyms.

B.TheuserSYSTEMownsallthebasetablesanduseraccessibleviewsofthedatadictionary.

C.AllthedynamicperformanceviewsprefixedwithV$areaccessibletoallthedatabaseusers.

D.TheUSER_OBJECTSviewcanprovideinformationaboutthetablesandviewscreatedbytheuser

only.

E.DICTIONARYisaviewthatcontainsthenamesofallthedatadictionaryviewsthattheusercan

access.

Answer: AE

7.ViewtheExhibitandexaminethedescriptionoftheORDERStable.

WhichtwoWHEREclauseconditionsdemonstratethecorrectusageofconversionfunctions?(Choose

two.)

剩余176页未读，继续阅读

评论收藏

内容反馈

资源评论

资源反馈

评论星级较低，若资源使用遇到问题可联系上传者，3个工作日内问题未解决可申请退款~

two_tiger

2012-10-26

感觉挺不错的，很有用
hustlid2011

2014-10-30

感觉还不错，多多练习啦

oracle_redhat

粉丝: 0
资源: 1

上传资源快速赚钱

我的内容管理展开

我的资源快来上传第一个资源

我的收益

登录查看自己的收益

我的积分登录查看自己的积分

我的C币登录后查看C币余额

我的收藏

我的下载

下载帮助

前往需求广场，查看用户热搜

ocp考试题库

2021年OCP考试题库.pdf

OCP考试题库1Z0-053修改版

oracle 11g ocp考试题库

oracle ocp考试题库

oracle11G OCP考试题库

oracle OCP 考试题库

OCP考试题库，含题目和答案分开的word

2021年oracle 12C OCP考试题库

oracle 10g ocp考试题库 007

OCP10g_OCP考试题库EXE

MySQL8.0认证 ocp(175题)

ocp考试题库.zip

2021OCP考试题库.zip

最新ocp考试题库，内含答案

oracle 11g ocp 考试题库

MySQL OCP5.7考试题目大全.docx

oca和ocp考试题库(pdf)和模拟考试器(exe)

最新OCP 052考试题库！

OCP题库软件

ocp题库ocp题库

Oracle_11g_OCP最新题库(PDF+VCE)2013.10.25考试过

ocp 052 题库

oracle11g ocp ppt+题库 全套

OCP题库题库题库题库

mysql 8.0 ocp 题库

ocp考试047题库

OCP_题库&考试模拟器

OCP 053最新题库

最新资源

oracle11g ocp ppt+题库全套