题目内容（请给出正确答案）

[主观题]

EvaluatethefollowingSQLstatementusedtocreatethePRODUCTStable：CREATETABLEproducts（product_i

dNUMBER（3）PRIMARYKEY，product_descVARCHAR2（25），qtyNUMBER（8，2），rateNUMBER（10，2），total_valueAS（qty*rate））PARTITIONBYRANGE（total_value）（PARTITIONp1VALUESLESSTHAN（100000），PARTITIONp2VALUESLESSTHAN（150000），PARTITIONp3VALUESLESSTHAN（MAXVALUE））COMPRESSFORALLOPERATIONS；Whichstatementistrueregardingthiscommand？（）

A.Itexecutessuccessfullybutpartitionpruningcannothappenforthispartitionkey.

B.ItproducesanerrorbecausetheTOTAL_VALUEcolumncannotbeusedasapartitionkey.

C.ItproducesanerrorbecausecompressioncannotbeusedfortheTOTAL_VALUEpartitionkey.

D.ItexecutessuccessfullybutthevaluesintheTOTAL_VALUEcolumnwouldnotbephysically storedinthepartitions.

查看答案

如搜索结果不匹配，请联系老师获取答案

您可能会需要：

重置密码查看订单联系客服

安装上学吧APP，拍照搜题省时又省心！

更多“EvaluatethefollowingSQLstateme…”相关的问题

第1题

Whileworkingonthedatabase，youreceivethefollowingerror：01578：ORACLEdatablockcorrupted（file6

，block54）ORA-01110：datafile6：’u01/oracle/oradata/data1.dbf’YoudecidetorecoverthecorrupteddatablockbyusingtheBlockMediaRecoveryfeature.WhichoptionisNOTadisadvantageofusingblockmediarecovery？（）

A.BlockMediaRecoverymustbeusedwithRMAN.

B.Youmustperformcompleterecoveryofindividualblocks.

C.YoumusthaveafullRMANbackup，notanincrementalbackup.

D.YoumustusetheDBVERIFYutilitybeforeusingtheBlockMediaRecoveryfeature.

点击查看答案

第2题

In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with yo

ur t1 table data. You then TRUNCATE this table to empty it.（）Mysql＞ SELECT * INTO OUTFILE ‘/tmp/t1.sql‘ from t1;mysql＞ TRUNCATE t1;

A.$ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sql

B.Mysql＞ INSERT INTO t1 VALUES FROM ‘/tmp/t1.sql‘

C.$ mysql – u root – p – h localhost test ＜ /tmp/t1.sql

D.Mysql＞ LOAD DATA INFILE ‘/tmp/t1.sql‘ INTO TABLE t1

E.$ mysqlinport – u root – p – h localhost test /tmp/t1.sql

点击查看答案

第3题

WhichstatementistruewhenyouruntheSQLTuningAdvisorwithlimitedscope？（）

A.AccesspathanalysisisnotperformedfortheSQLstatements.

B.SQLstructureanalysisisnotperformedfortheSQLstatements.

C.SQLProfilerecommendationsarenotgeneratedfortheSQLstatements.

D.ThestalenessandabsenceofthestatisticsarenotcheckedfortheobjectsinthequerysuppliedtotheSQLTuningAdvisor.

点击查看答案

第4题

WhichthreedescriptionsarecorrectabouttheeffectsoftheTRUNCATEcommandonatable（）

A.Thecorrespondingindexesforthetablearealsotruncated.

B.DeletetriggersonthetablearefiredduringtheexecutionoftheTRUNCATEcommand.

C.ThechildtableistruncatedwhentheTRUNCATEcommandisappliedontheparenttable.

D.Thehigh-watermark（HWM）issettopointtothefirstusabledatablockinthetablesegment.

E.NoundoorverylittleundodataisgeneratedduringtheexecutionoftheTRUNCATEcommand

点击查看答案

第5题

YouareusingtheDBVERIFYutilitytocheckthedatafilesforanyblockcorruption.Youwanttowritetheoutputofthedbvcommandtoafilenottothescreen.WhichparameteroftheDBVERIFYutilitywillyouuse？（）

A.FILE

B.PARFILE

C.LOGFILE

D.FEEDBACK

点击查看答案

第6题

TheORDERStablebelongstotheuserOE.OEhasgrantedtheSELECTprivilegeontheORDERStabletotheuserHR.WhichstatementwouldcreateasynonymORDsothatHRcanexecutethefollowingquerysuccessfully?（）

A.CREATESYNONYMordFORorders;ThiscommandisissuedbyOE

B.CREATEPUBLICSYNONYMordFORorders;ThiscommandisissuedbyOE

C.CREATESYNONYMordFORoe.orders;Thiscommandisissuedbythedatabaseadministrator

D.CREATEPUBLICSYNONYMordFORoe.orders;Thiscommandisissuedbythedatabaseadministrator

点击查看答案

第7题

Consider the following scenario for your database:- Backup optimization is enabled in RMAN

.- The recovery window is set to 7 days in RMAN.- The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007.- The TOOLS tablespace is read-only since November 4, 2007.On November 23, 2007, you issue the RMAN command to back up the database to disk.Which statement is true regarding the backup of the TOOLS tablespace?（）

A. The RMAN backup fails because the TOOLS tablespace is read-only

B. The RMAN skips the backup of the tablespace because backup optimization is enabled

C. The RMAN makes backup because optimization can be enabled only for backups to disk

D. The RMAN makes the backup because no backup of the tablespace exists within the seven day window

点击查看答案

第8题

YouwanttochecktheEMPtableintheuser，Scott’sschemaforblockcorruption.Youalsowanttofixthecorruptedblocks，ifany.Howwillyouaccomplishtherequiredtask？（）

A.byusingtheANALYZEutility

B.byusingtheDBVERIFYutility

C.byusingtheDB_BLOCK_CHECKINGparameter

D.byusingtheDBMS_REPAIRpackage

点击查看答案

第9题

YourdatabaseisrunningunderautomaticundomanagementandtheUNDO_RETENTIONparameterissetto900se

c.Youexecutedthefollowingcommandtoenableretentionguarantee：SQL>ALTERTABLESPACEundotbs1RETENTIONGUARANTEE；Whateffectwouldthisstatementhaveonthedatabase？（）

A.Theextentsinundotablespaceretaindatauntilthenextfulldatabasebackup.

B.Theextentscontainingcommitteddataintheundotablespaceareneveroverwritten.

C.Theextentswhichnolongercontainuncommitteddataintheundotablespacearenotoverwrittenforatleast15minutes.

D.Theextentscontainingcommitteddataintheundotablespacearenotoverwrittenuntiltheinstanceisshutdown.

点击查看答案

第10题

WhichstatementistrueregardingtheINTERSECToperator?（）

A.ItignoresNULLvalues

B.Reversingtheorderoftheintersectedtablesalterstheresult

C.ThenamesofcolumnsinallSELECTstatementsmustbeidentical

D.ThenumberofcolumnsanddatatypesmustbeidenticalforallSELECTstatementsinthequery

点击查看答案