You issued the following command on the temporary tablespace LMTEMP in your database:SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M;Which requirement must be fulfilled for this command to succeed?（）A. The tablespace must be locally managed.B. The table

题目

You issued the following command on the temporary tablespace LMTEMP in your database:SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M;Which requirement must be fulfilled for this command to succeed?（）

A. The tablespace must be locally managed.

B. The tablespace must have only one temp file.

C. The tablespace must be made nondefault and offline.

D. The tablespace can remain as the default but must have no active sort operations.

相似考题

1.7． Hi! This is_______ new teacher．__________ name is Linda．A． your; MyB． his; YourC． your ; HerD． her; His

2.You’re going to have a quiz ( )by another two in the ( )month.A. followed,followedB. followed,followingC. following,followedD. following,following

3.Mr. Tyler used to eat with a napkin______ under his chin.()A. assumedB. tuckedC. rackedD. issued

4.The great()in the world today is whether there will be war or peace.A、problemB、differenceC、issueD、tissue

更多“You issued the following command on the temporary tablespace LMTEMP in your database:SQL&g ”相关问题

  • 第1题：

    What's ( )job? Are ( ) British?

    A. your, your

    B. you, your

    C. your, you


    正确答案：C

  • 第2题：

    Which statement about the enabling of table compression in Oracle Database 11g is true?()

    A. Compression can be enabled at the table, tablespace, or partition level for direct loads only.

    B. Compression can be enabled only at the table level for both direct loads and conventional DML.

    C. Compression can be enabled at the table, tablespace, or partition level for conventional DML only.

    D. Compression can be enabled at the table, tablespace, or partition level for both direct loads and conventional DML.


    参考答案：D

  • 第3题：

    （ ） – Is Miss White __________ English teacher, Maria?

    – No, she teaches __________ geography.

    A．your；my

    B．you；mine

    C．you；us

    D．your；us


    正确答案：D

  • 第4题：

    Merry Christmas, George! Here is a card for ________, with ________ best withes.

    A.you…your

    B.you…our

    C.us…our

    D.us…your


    参考答案：B

  • 第5题：

    YouaremaintainingyourOLTPdatabaseinOracle10g.YouhavenotsetthewarninglevelandcriticallevelthresholdvaluesforspaceusageoftheDATA1tablespace.Whatwillbetheimpact?()

    A.Nowarninglevelorcriticallevelalertwillbegenerated.

    B.Awarninglevelalertwillneverbegenerated，butacriticallevelalertwillbegeneratedwhen97percentspaceoftheDATA1tablespaceisused.

    C.Acriticallevelalertwillneverbegenerated，butawarninglevelalertwillbegeneratedwhen85percentspaceoftheDATA1tablespaceisused.

    D.Awarninglevelalertwillbegeneratedat85percentspaceusageoftheDATA1tablespace，andacriticallevelalertisgeneratedat97percentspaceusageoftheDATA1tablespace.


    参考答案：D

  • 第6题：


    请在第_____处填上正确答案。

    A.class
    B.exam
    C.issue
    D.final

    答案：B
    解析：
    要在考试开考前几分钟到达考场。

相关内容