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

[单选题]

Whatshouldyoulookatfirsttocomputethenumberofundoblockswrittenpersecondtodisk？（）

A.V$UNDOSTAT

B.V$TRANSACTION

C.V$ROLLSTAT

D.DBA_UNDO_EXTENTS

E.DBA_ROLLBACK_SEGS

查看答案

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

您可能会需要：

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

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

更多“Whatshouldyoulookatfirsttocomp…”相关的问题

第1题

TheEMPLOYEEStableisstoredintheSAMPLEtablespace.ThecorrespondingIPK_EMPindexfortheEMPLOYEES

table’sprimarykeyisstoredintheINDXtablespace.Outof12partitions，onlypartitionP1oftheSALEStableisstoredintheSAMPLEtablespace.Whichobjectwillbeexportedbythiscommand？（）expsystem/managertablespaces=SAMPLE

A.OnlytheEMPLOYEEStable.

B.OnlytheEMPLOYEEStableanditscorrespondingprimarykeyindex.

C.TheEMPLOYEEStableandpartitionP1.

D.TheEMPLOYEEStable，IPK_EMPindex，andtheSALEStable.

点击查看答案

第2题

AUNIXusernamedBobwantstoreplacehischessprogramwithanewone，butheisnotsurewheretheoldoneisin

stalled.BobiscurrentlyabletorunaJavachessprogramstartingfromhishomedirectory/home/bobusingthecommand：java-classpath/test：/home/bob/downloads/*.jargames.ChessBob’sCLASSPATHisset（atlogintime）to：/usr/lib：/home/bob/classes：/opt/java/lib：/opt/java/lib/*.jarWhatisapossiblelocationfortheChess.classfile？（）

A./test/Chess.class

B./home/bob/Chess.class

C./test/games/Chess.class

D./usr/lib/games/Chess.class

E./home/bob/games/Chess.class

点击查看答案

第3题

Examinethestatement：SQL>CREATETABLESPACEuser_data2>EXTENTMANAGEMENTLOCAL3>SEGMENTSPACEMANAGEMENTAUTO；Whichtwpassumptionsmustbetrueforthisstatementtoexecutesuccessfully？（）

A.OracleManagedFilesareusedforthisinstance.

B.TheUSER_DATAtablespaceismanagedusingFET$/UET$tables.

C.TheCOMPATIBLEinitializationparametermustbe9.0.0orhigher.

D.SpacewithinsegmentsintheUSER_DATAtablespaceismanagedwithfreelists.

点击查看答案

第4题

YouwanttodroptheTBS1tablespacefromyourdatabase.Youalsowanttodeletethecorrespondingdatafilesautomatically，andnothavetodoitmanually.Whatshouldyoudo？（）

A.UsetheDROPDATAFILEcommand.

B.UsetheDROPTABLESPACEcommand.

C.EnsurethatalldatabasefilesareOracleManagedFilesbeforeusingtheDROPTABLESPACE command.

D.EnsurethattheDB_FILE_CREATE_DESTinitializationparameterissetbeforeusingtheDROP TABLESPACEcommand.

点击查看答案

第5题

Which iSQL*Plus feature can be used to replace values in the WHERE clause?（）

A.substitution variables

B.replacement variables

C.prompt variables

D.instead-of variables

E.This feature cannot be implemented through iSQL*Plus.

点击查看答案

第6题

WhichtwostatementsregardingthecontrolfileandRecoverManageraretrue？（）

A.Thecontrolfilecangrowinsize.

B.ThecontrolfilecanstoreRMANscripts.

C.CONTROL_FILE_RECORD_KEEP_TIMEdeterminesretentiontimeforRMANrecords.

D.TheRMANcatalogcanexistsolelyinthecontrolfileofthetargetdatabase.

点击查看答案

第7题

YoudiscoverthatadiskfailureoccurredonDISK3wherethedatafilebelongingtotheUSER_DATAtablespac

eisstored.Thedatabaseiscurrentlyopenandyouneedtorecoverthedatafile.YouwillrestorethedatafiletoDISK2.WhatisthecorrectsequenceRMANcommandstorestoreandrecoverthedatafile？（）

A.A

B.B

C.C

D.D

点击查看答案

第8题

The EMP table contains these columns:EMPLOYEE_ID NUMBER(4)EMPNAME VARCHAR2 (25)SALARY NUMB

ER(9,2)HIRE_DATE DATEYou query the database with this SQL statement:SELECT empname,hire_date HIREDATE, salaryFROM EMPORDER BY hire_date;How will the results be sorted?（）

A.randomly

B.ascending by date

C.descending by date

D.ascending alphabetically

E.descending alphabetically

点击查看答案

第9题

WhatistrueregardingtheroleOracleNetprovidesinaclientserverconnectionwithnomiddletier？（）