多选题Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correct？（）AThis clause is not valid for a temporary or undo tablespace.BIf the tablespace is in the NOLOGGING mode，no operation on the tablespace will generate 

题目
多选题
Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correct？（）
A

This clause is not valid for a temporary or undo tablespace.

B

If the tablespace is in the NOLOGGING mode，no operation on the tablespace will generate redo.

C

The tablespace will be in the NOLOGGING mode by default，if not specified while creating a tablespace.

D

The tablespace-level logging attribute can be overridden by logging specifications at the table，index， materialized view，materialized view log，and partition levels.

相似考题

1.You issued the following command:An index is then created on the ADMIN_WORK_AREA temporary table. Which two statements are true regarding the TBS_T1 tablespace in the above command? ()A. It stores only the temporary table but not its indexes.B. It stores both the temporary table as well as its indexes.C. It must be a nondefault temporary tablespace for the database.D. It can be a default or nondefault temporary tablespace for the database.E. It must be the default temporary tablespace of the user who issues the command.

2.Which two statements are true regarding the ORDER BY clause? （）A、The sort is in ascending by order by default.B、The sort is in descending order by default.C、The ORDER BY clause must precede the WHERE clause.D、The ORDER BY clause is executed on the client side.E、The ORDER BY clause comes last in the SELECT statement.F、The ORDER BY clause is executed first in the query execution.

3.Your database is running in the ARCHIVELOG mode. You placed a tablespace， tbs_1， offline with the immediate option. Which statement is correct in this scenario？ （）A、The operation would fail if tbs_1 were a read-only tablespace.B、The operation would fail if tbs_1 were a read/write tablespace.C、The operation would fail if tbs_1 were the default tablespace for the database.D、If the above operation were successful， media recovery would be required to bring the tablespace online.E、If the above operation were successful， instance recovery would be required to bring the tablespace online.

4.Which two statements are true regarding undo tablespaces（）A、The database can have more than one undo tablespace.B、The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.C、Undo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions.D、An undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.

参考答案和解析
正确答案： C,B
解析： 暂无解析
更多“多选题Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correct？（）AThis clause is not valid for a temporary or undo tablespace.BIf the tablespace is in the NOLOGGING mode，no operation on the tablespace will generate ”相关问题

  • 第1题：

    You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows: CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M TABLESPACE GROUP ''; Which statement regarding the above command is correct?（）

    • A、It will create the tablespace TEMP1 in group G1.
    • B、It will create the tablespace TEMP1 in group G3.
    • C、It will not add the tablespace TEMP1 to any group.
    • D、It will create the tablespace TEMP1 in the default group.

    正确答案:C

  • 第2题：

    Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correct？（）

    • A、This clause is not valid for a temporary or undo tablespace.
    • B、If the tablespace is in the NOLOGGING mode，no operation on the tablespace will generate redo.
    • C、The tablespace will be in the NOLOGGING mode by default，if not specified while creating a tablespace.
    • D、The tablespace-level logging attribute can be overridden by logging specifications at the table，index， materialized view，materialized view log，and partition levels.

    正确答案:A,D

  • 第3题：

    Your boss at Certkiller .com wants you to clarify Oracle 10g. Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correcte？（）

    • A、This clause is not valid for a temporary or undotablespace.
    • B、If thetablespaceis in the NOLOGGING mode， no operation on thetablespacewill generate redo.
    • C、Thetablespacewill be IntheNOLOGGING mode by default， if not specified while creating atablespace.
    • D、Thetablespace-level logging attribute can be overridden by logging specification at the table， index， materialized view， materialized view log， and partition levels.

    正确答案:A,D

  • 第4题：

    Which two statements regarding the LOGGING clause of the CREATE TABLESPACE. .. statement are correct？（）

    • A、This clause is not valid for a temporary or undo tablespace.
    • B、If the tablespace is in the NOLOGGING mode， no operation on the tablespace will generate redo.
    • C、The tablespace will be in the NOLOGGING mode by default， if not specified while creating a tablespace.
    • D、The tablespace­level logging attribute can be overridden by logging specifications at the table， index， materialized view， materialized view log， and partition levels.

    正确答案:A,D

  • 第5题：

    You have three temporary tablespace groups named G1， G2， and G3 in your database. You are creating a new temporary tablespace as follows：   CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE ’/u1/data/temp1.dbf’ SIZE 10M TABLESPACE GROUP ；   Which statement regarding the above command is correct？（）  

    • A、 It will create the tablespace TEMP1 in group G1.
    • B、 It will create the tablespace TEMP1 in group G3.
    • C、 It will not add the tablespace TEMP1 to any group.
    • D、 It will create the tablespace TEMP1 in the default group.

    正确答案:C

  • 第6题：

    多选题
    Which two statements are true regarding the ORDER BY clause? （）
    A

    The sort is in ascending by order by default.

    B

    The sort is in descending order by default.

    C

    The ORDER BY clause must precede the WHERE clause.

    D

    The ORDER BY clause is executed on the client side.

    E

    The ORDER BY clause comes last in the SELECT statement.

    F

    The ORDER BY clause is executed first in the query execution.


    正确答案： A,D
    解析： 暂无解析

  • 第7题：

    多选题
    Which two statements regarding the LOGGING clause of the CREATE TABLESPACE. .. statement are correct？（）
    A

    This clause is not valid for a temporary or undo tablespace.

    B

    If the tablespace is in the NOLOGGING mode， no operation on the tablespace will generate redo.

    C

    The tablespace will be in the NOLOGGING mode by default， if not specified while creating a tablespace.

    D

    The tablespace­level logging attribute can be overridden by logging specifications at the table， index， materialized view， materialized view log， and partition levels.


    正确答案： A,C
    解析： 暂无解析

  • 第8题：

    多选题
    Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correct？（）
    A

    This clause is not valid for a temporary or undo tablespace.

    B

    If the tablespace is in the NOLOGGING mode，no operation on the tablespace will generate redo.

    C

    The tablespace will be in the NOLOGGING mode by default，if not specified while creating a tablespace.

    D

    The tablespace-level logging attribute can be overridden by logging specifications at the table，index， materialized view，materialized view log，and partition levels.


    正确答案： B,A
    解析： 暂无解析

  • 第9题：

    多选题
    Which two statements are true regarding undo tablespaces（）
    A

    The database can have more than one undo tablespace.

    B

    The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.

    C

    Undo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions.

    D

    An undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.


    正确答案： C,B
    解析： A答案：可以有一个或多个undo表空间，A答案正确。 
    sys@TEST0924> select TABLESPACE_NAME，CONTENTS from dba_tablespaces； TABLESPACE_NAME CONTENTS ------------------------------ --------- SYSTEM PERMANENT SYSAUX PERMANENT UNDOTBS1 UNDO TEMP TEMPORARY USERS PERMANENT UNDOTBS2 UNDO 
    EXAMPLE PERMANENT LXTBS PERMANENT FLA_TBS1 PERMANENT FLA_TBS2 PERMANENT 10 rows selected. 
    B答案：UNDO_TABLESPACE只能用于自动undo段模式，B答案错误

  • 第10题：

    单选题
    The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. Which statement regarding retention of undo data is correct？（）
    A

    Undo data becomes obsolete after 1，000 seconds.

    B

    Undo data gets refreshed after every 1，000 seconds.

    C

    Undo data will be stored permanently after 1，000 seconds.

    D

    Committed undo data would be retained for 1，000 seconds if free undo space is available.

    E

    Undo data will be retained in the UNDO tablespace for 1，000 seconds，then it gets moved to the TEMPORARY tablespace to provide read consistency.


    正确答案： E
    解析： 暂无解析

  • 第11题：

    多选题
    Your boss at Certkiller .com wants you to clarify Oracle 10g. Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correcte？（）
    A

    This clause is not valid for a temporary or undotablespace.

    B

    If thetablespaceis in the NOLOGGING mode， no operation on thetablespacewill generate redo.

    C

    Thetablespacewill be IntheNOLOGGING mode by default， if not specified while creating atablespace.

    D

    Thetablespace-level logging attribute can be overridden by logging specification at the table， index， materialized view， materialized view log， and partition levels.


    正确答案： B,A
    解析： 暂无解析

  • 第12题：

    多选题
    Which two statements are true regarding the ORDER BY clause? （）
    A

    It is executed first in the query execution

    B

    It must be the last clause in the SELECT statement

    C

    It cannot be used in a SELECT statement containing a HAVING clause

    D

    You cannot specify a column name followed by an expression in this clause

    E

    You can specify a combination of numeric positions and column names in this clause


    正确答案： E,C
    解析： 暂无解析

  • 第13题：

    ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?（）

    • A、The data is decrypted during SORT and JOIN operations.
    • B、The data remains encrypted when it is read into memory.
    • C、The data remains encrypted when it is stored in the redo logs.
    • D、The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.

    正确答案:C

  • 第14题：

    Which two statements are true regarding the ORDER BY clause? （）

    • A、It is executed first in the query execution 
    • B、It must be the last clause in the SELECT statement 
    • C、It cannot be used in a SELECT statement containing a HAVING clause
    • D、You cannot specify a column name followed by an expression in this clause 
    • E、You can specify a combination of numeric positions and column names in this clause

    正确答案:B,E

  • 第15题：

    Your database contains a temporary tablespace， index tablespace， undo tablespace， and a read-only tablespace apart from the SYSTEM and SYSAUX tablespaces. If a media failure occurs resulting in the loss of any of these tablespaces， which tablespace is NOT required for the database to start？（）

    • A、 undo tablespace
    • B、 index tablespace
    • C、 read-only tablespace
    • D、 temporary tablespace

    正确答案:D

  • 第16题：

    You issued the following command：   CREATE GLOBAL TEMPORARY TABLE admin_work_area   （startdate DATE， enddate DATE， class CHAR（20）） ON COMMIT DELETE ROWS TABLESPACE tbs_t1；   An index is then created on the ADMIN_WORK_AREA temporary table.  Which two statements are true regarding the TBS_T1 tablespace in the above command？（） 

    • A、 It stores only the temporary table but not its indexes.
    • B、 It stores both the temporary table as well as its indexes.
    • C、 It must be a nondefault temporary tablespace for the database.
    • D、 It can be a default or nondefault temporary tablespace for the database.
    • E、 It must be the default temporary tablespace of the user who issues the command.

    正确答案:B,D

  • 第17题：

    The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. Which statement regarding retention of undo data is correct？（）

    • A、Undo data becomes obsolete after 1，000 seconds.
    • B、Undo data gets refreshed after every 1，000 seconds.
    • C、Undo data will be stored permanently after 1，000 seconds.
    • D、Committed undo data would be retained for 1，000 seconds if free undo space is available.
    • E、Undo data will be retained in the UNDO tablespace for 1，000 seconds，then it gets moved to the TEMPORARY tablespace to provide read consistency.

    正确答案:D

  • 第18题：

    多选题
    You issued the following command：   CREATE GLOBAL TEMPORARY TABLE admin_work_area   （startdate DATE， enddate DATE， class CHAR（20）） ON COMMIT DELETE ROWS TABLESPACE tbs_t1；   An index is then created on the ADMIN_WORK_AREA temporary table.  Which two statements are true regarding the TBS_T1 tablespace in the above command？（）
    A

    It stores only the temporary table but not its indexes.

    B

    It stores both the temporary table as well as its indexes.

    C

    It must be a nondefault temporary tablespace for the database.

    D

    It can be a default or nondefault temporary tablespace for the database.

    E

    It must be the default temporary tablespace of the user who issues the command.


    正确答案： E,C
    解析： 暂无解析

  • 第19题：

    单选题
    Your database contains a temporary tablespace， index tablespace， undo tablespace， and a read-only tablespace apart from the SYSTEM and SYSAUX tablespaces. If a media failure occurs resulting in the loss of any of these tablespaces， which tablespace is NOT required for the database to start？（）
    A

     undo tablespace

    B

     index tablespace

    C

     read-only tablespace

    D

     temporary tablespace


    正确答案： D
    解析： 暂无解析

  • 第20题：

    多选题
    Which two statements are true regarding the USING and ON clauses in table joins?（）
    A

    Both USING and ON clauses can be used for equijoins and nonequijoins

    B

    Amaximum of one pair of columns can be joined between two tables using the ON clause

    C

    The ON clause can be used to join tables on columns that have different names but compatible data types

    D

    The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause


    正确答案： A,C
    解析： 暂无解析

  • 第21题：

    多选题
    Which two statements are true regarding the MRKT tablespace（）
    A

    No more data files can be added to the tablespace.

    B

    Segment space is managed by free lists in the tablespace.

    C

    A user created without being assigned a default tablespace uses this tablespace.

    D

    The tablespace can be dropped with the current setting with segments present in it.


    正确答案： D,A
    解析： 暂无解析

  • 第22题：

    单选题
    You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows: CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE /u1/data/temp1.dbf SIZE 10M TABLESPACE GROUP ;Which statement regarding the above command is correct?（）
    A

    It will create the tablespace TEMP1 in group G1

    B

    It will create the tablespace TEMP1 in group G3 

    C

    It will not add the tablespace TEMP1 to any group

    D

    It will create the tablespace TEMP1 in the default group

    E

    It will throw an error with message 'specified group is not available

    F

    It will create a new group with a system-generated name and add the tablespace TEMP1 to it.


    正确答案： E
    解析： 暂无解析

  • 第23题：

    单选题
    Your database is running in the ARCHIVELOG mode. You placed a tablespace， tbs_1， offline with the immediate option. Which statement is correct in this scenario？ （）
    A

    The operation would fail if tbs_1 were a read-only tablespace.

    B

    The operation would fail if tbs_1 were a read/write tablespace.

    C

    The operation would fail if tbs_1 were the default tablespace for the database.

    D

    If the above operation were successful， media recovery would be required to bring the tablespace online.

    E

    If the above operation were successful， instance recovery would be required to bring the tablespace online.


    正确答案： E
    解析： 暂无解析

  • 第24题：

    单选题
    You are attempting to create an Oracle-Managed Files （OMF） tablespace in a production database with the following statement and receive the following error message：   CREATE TABLESPACE tbsl；  ORA-02199： missing DATAFILE/TEMPFILE clause oerr ora 2199  02199， 00000， “missing DATAFILE/TEMPFILE clause”  *Cause： A CREATE TABLESPACE statement has no DATAFILE/TEMPFTLE clause.  *Action： specify DATAFILE/TEMPFILE clause.   What is the corrective action to create the OMF based tablespace？（）
    A

    A

    B

    B

    C

    C

    D

    D


    正确答案： D
    解析： 暂无解析

相关内容