Viewthisparametersettinginyourdatabase：DB_CREATE_FILE_DEST=’D：\oracle\product\10.2.0\oradata\oracle’Youcreatedatablespacebyusingthiscommand：CREATETABLESPACEUSERS；WhichtwostatementsaretrueabouttheUSERStablespace？（）A.Thetablespacehastwodatafiles.B.Anerroris

题目

Viewthisparametersettinginyourdatabase：DB_CREATE_FILE_DEST=’D：\oracle\product\10.2.0\oradata\oracle’Youcreatedatablespacebyusingthiscommand：CREATETABLESPACEUSERS；WhichtwostatementsaretrueabouttheUSERStablespace？（）

A.Thetablespacehastwodatafiles.

B.Anerrorisreportedandtablespacecreationfails.

C.Datafilesarecreatedwithnamesgeneratedbytheinstance.

D.Thetablespacecanbeextendedwithoutspecifyingthedatafile.

E.DatafilesbelongingtotheUSERStablespacecannotberenamed.

相似考题

1.ClicktheExhibitbutton.GiventheJSPcode:1.<%2.pageContext.setAttribute("product&quotClicktheExhibitbutton.GiventheJSPcode：1.<%2.pageContext.setAttribute（"product"，3.newcom.example.Product（"Pizza"，0.99））；4.%>5.<%--insertcodehere--%>Whichtwo，insertedatline5，outputthenameoftheproductintheresponse？（）A.<%=product.getName（）%>B.<jsp：useBeanid="product"class="com.example.Product"/><%=product.getName（）%>C.<jsp：useBeanid="com.example.Product"scope="page"><%=product.getName（）%></jspuseBean>D.<jsp：useBeanid="product"type="com.example.Product"scope="page"/><%=product.getName（）%>

2.Examine the following values of the initialization parameters in the database having the SID ORCL:BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdumpUSER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udumpCORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdumpDIAGNOSTIC_DEST=The environment variables have the following value:ORACLE_BASE=/u01/app/oracleORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1What is the location of the Automatic Diagnostic Repository (ADR) home?（）A./u01/app/oracle/product/11.1.0/db_1B./u01/app/oracleC.$ORACLE_HOME/bdumpD.$ORACLE_HOME/log

3.WhenyoutrytostarttheDatabaseControlbyusingtheemctlstartdbconsolecommandthefollowingerrorisdisplayed：TZsettoAmerica/New_yorkOC4JConfigurationissue./u01/app/oracle/product/10.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_orcl.us.oracle.comnotfound.WhichtwoenvironmentvariablesdoyouneedtosetappropriatelytoavoidsucherrorsandstarttheDatabaseControlsuccessfully？（）A.NLS_LANGB.ORACLE_SIDC.ORACLE_HOMED.ORACLE_BASEE.LD_LIBRARY_PATH

4.The PRODUCTS table has these columns:PRODUCT_ID NUMBER(4)PRODUCT_NAME VARCHAR2(45)PRICE NUMBER(8,2)Evaluate this SQL statement:SELECT *FROM PRODUCTSORDER BY price, product _ name;What is true about the SQL statement? （）A. The results are not sorted.B. The results are sorted numerically.C. The results are sorted alphabetically.D. The results are sorted numerically and then alphabetically.

更多“Viewthisparametersettinginyourdatabase:DB_CREATE_FILE_DEST=’D:\oracle\product\10.2.0\orada ”相关问题

  • 第1题：

    Youhavecontrol-fileautobackupsenabled.WhenstartingyourdatabasefromSQL*Plus，youreceivethefollowingerrormessage：SQL>startupORA-01078：failureinprocessingsystemparametersLRM-00109：couldnotopenparameterfile，C：\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE\INITORCL.ORAUsingRMAN，howwouldyourespondtothiserror？（）

    A.Issuethestartupnomountcommandandthenissuetherestoreparameterfilecommandfromthe RMANprompt.

    B.IssuethestartupnomountcommandandthenissuetherestorespfilecommandfromtheRMANprompt.

    C.Issuethestartupnomountcommandandthenissuetherestorespfilefromautobackupcommand fromtheRMANprompt.

    D.Issuethestartupnomountcommandandthenissuetherestorespfilefrombackupcommand from theRMANprompt.

    E.IssuetherestorespfilefromautobackupcommandfromtheRMANprompt.


    参考答案：C

  • 第2题：

    如下面这段监听配置中,sid_name的值来自于哪个参数? SID_LIST_LISTENER = (SID_DESC =(GLOBAL_DBNAME = orcl ) (ORACLE_HOME = ／u01／app／oracle／product／ 10. 2.0／db_1) (SID_NAME = orcl ) )()

    A. INSTANCE_NAME

    B. DB_NAME

    C. DB_UNIQUE_NAME

    D. SERVICE_NAMES

    E. GLOBAL_NAMES


    参考答案A

  • 第3题：

    41、已知程序如下，该程序实现的功能为_____。 （10) main（) （20) { int counter； （30) ... //输入N值的语句，略 （40) long product = 1； （50) for counter = 1 to N step 2 （60) { product = product * counter； } （70) return product; （80) }

    A．product = 1*3*5*...* (N-1)

    B．product = 1*2*3*...*(N-1)

    C．product = 1+ 2+3+...+ (N-1)

    D．product = 1+3+5+...+(N-1)


    product = 1*3*5*...* (N-1)

  • 第4题：

    Youmanuallycreateanadditionallistenerprocess,L1,for&en

    Youmanuallycreateanadditionallistenerprocess，L1，fordatabasesPROD，

    PAYDBandFINDB.Whilestartingupthelistenerprocess，yougetthefollowingerrormessage：LSNRCTL>startl1

    Starting/u01/app/oracle/product/10.1.0/db_1/bin/tnslsnr：pleasewait...

    TNSLSNRforLinux：Version10.1.0.2.0-Production

    Systemparameterfileis/u01/app/oracle/product/10.1.0/db_1/network/admin/listener.oraLogmessageswrittento/u01/app/oracle/product/10.1.0/db_1/network/log/l1.logErrorlisteningon：

    （ADDRESS=（PROTOCOL=TCP）（HOST=144.23.230.185）（port=8899））

    TNS-12542：TNS：addressalreadyinuseTNS-12560：

    TNS：protocoladaptererrorTNS-00512：Addressalreadyinuse

    LinuxError：98：Addressalreadyinuse

    Listenerfailedtostart.Seetheerrormessage（s）above...

    Whatactionwouldyoutaketoovercomethiserrorwithoutdisruptinganyexistingdatabasecommunications？（）


    参考答案：D

  • 第5题：

    已知程序如下，该程序实现的功能为_____。 （10) main（) （20) { int counter； （30) ... //输入N值的语句，略 （40) long product = 1； （50) for counter = 1 to N step 2 （60) { product = product * counter； } （70) return product; （80) }

    A．product = 1*3*5*...* (N-1)

    B．product = 1*2*3*...*(N-1)

    C．product = 1+ 2+3+...+ (N-1)

    D．product = 1+3+5+...+(N-1)


    sum = 1!+2!+...+n!

相关内容