EvaluatethefollowingSQLstatementusedtocreatethePRODUCTStable：CREATETABLEproducts（product_i

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

A.BlockMediaRecoverymustbeusedwithRMAN.

B.Youmustperformcompleterecoveryofindividualblocks.

C.YoumusthaveafullRMANbackup，notanincrementalbackup.

D.YoumustusetheDBVERIFYutilitybeforeusingtheBlockMediaRecoveryfeature.

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

A.AccesspathanalysisisnotperformedfortheSQLstatements.

B.SQLstructureanalysisisnotperformedfortheSQLstatements.

C.SQLProfilerecommendationsarenotgeneratedfortheSQLstatements.

D.ThestalenessandabsenceofthestatisticsarenotcheckedfortheobjectsinthequerysuppliedtotheSQLTuningAdvisor.

A.Thecorrespondingindexesforthetablearealsotruncated.

B.DeletetriggersonthetablearefiredduringtheexecutionoftheTRUNCATEcommand.

C.ThechildtableistruncatedwhentheTRUNCATEcommandisappliedontheparenttable.

D.Thehigh-watermark（HWM）issettopointtothefirstusabledatablockinthetablesegment.

E.NoundoorverylittleundodataisgeneratedduringtheexecutionoftheTRUNCATEcommand

A.FILE

B.PARFILE

C.LOGFILE

D.FEEDBACK

A.CREATESYNONYMordFORorders;ThiscommandisissuedbyOE

B.CREATEPUBLICSYNONYMordFORorders;ThiscommandisissuedbyOE

C.CREATESYNONYMordFORoe.orders;Thiscommandisissuedbythedatabaseadministrator

D.CREATEPUBLICSYNONYMordFORoe.orders;Thiscommandisissuedbythedatabaseadministrator

.- 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

A.byusingtheANALYZEutility

B.byusingtheDBVERIFYutility

C.byusingtheDB_BLOCK_CHECKINGparameter

D.byusingtheDBMS_REPAIRpackage

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

A.Theextentsinundotablespaceretaindatauntilthenextfulldatabasebackup.

B.Theextentscontainingcommitteddataintheundotablespaceareneveroverwritten.

C.Theextentswhichnolongercontainuncommitteddataintheundotablespacearenotoverwrittenforatleast15minutes.

D.Theextentscontainingcommitteddataintheundotablespacearenotoverwrittenuntiltheinstanceisshutdown.

A.ItignoresNULLvalues

B.Reversingtheorderoftheintersectedtablesalterstheresult

C.ThenamesofcolumnsinallSELECTstatementsmustbeidentical

D.ThenumberofcolumnsanddatatypesmustbeidenticalforallSELECTstatementsinthequery