niusouti.com

多选题Which tablespaces are mandatory in an Oracle database for it to be operational（）AUndo tablespaceBUSERS tablespaceCSYSAUX tablespaceDSYSTEM tablespaceETemporary tablespace

题目
多选题
Which tablespaces are mandatory in an Oracle database for it to be operational（）
A

Undo tablespace

B

USERS tablespace

C

SYSAUX tablespace

D

SYSTEM tablespace

E

Temporary tablespace

相似考题

1.Examine the following command that is used to duplicate a database on the same host:Which two statements describe the effect after the database is duplicated successfully? ()A. The data files of the read-only tablespaces in the target database are not duplicatedB. The read-only tablespaces in the target database are still defined in new the databaseC. The read-only tablespaces in the target database are changed to online after duplicationD. The data files of the read-only tablespaces in the target database get duplicatedE. The read-only tablespaces in the target database are not defined in the new database

2.Examine the following command that is used to duplicate a database on the same host:RMAN> RUN{ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK;DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; \ }Which two statements describe the effect after the database is duplicated successfully? （）(Choose two)A. The data files of the read-only tablespaces in the target database are not duplicatedB. The read-only tablespaces in the target database are still defined in new the databaseC. The read-only tablespaces in the target database are changed to online after duplicationD. The data files of the read-only tablespaces in the target database get duplicatedE. The read-only tablespaces in the target database are not defined in the new database

3.Which Oracle Database component is audited by default if the unified Auditing option is enabled?()A. Oracle Data PumpB. Oracle Recovery Manager (RMAN)C. Oracle Label SecurityD. Oracle Database VaultE. Oracle Real Application Security

4.You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script:SQL>@utlu111i.sqlWhich statement about the execution of this script is true?（）A. It must be executed from the Oracle Database 11g environment.B. It must be executed only after the SYSAUX tablespace has been created.C. It must be executed from the environment of the database that is being upgraded.D. It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.E. It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

更多“Which tablespaces are mandatory in an Oracle database for it”相关问题

  • 第1题：

    Which Oracle Database component is audited by default if the unified Auditing option is enabled?（）

    • A、Oracle Data Pump
    • B、Oracle Recovery Manager (RMAN)
    • C、Oracle Label Security
    • D、Oracle Database Vault
    • E、Oracle Real Application Security

    正确答案:B

  • 第2题：

    The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking would be performed？（）

    • A、 The Oracle database will not perform block checking for any of the data blocks.
    • B、 The Oracle database will perform block checking for the default permanent tablespace only. 
    • C、 The Oracle database will perform block checking for the data blocks in all user tablespaces.
    • D、 The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.
    • E、 The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX tablespaces.

    正确答案:D

  • 第3题：

    The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed？（）  

    • A、 The Oracle database will perform block checking for the index blocks only
    • B、 The Oracle database will not perform block checking for any of the data blocks
    • C、 The Oracle database will perform block checking for the default permanent tablespace only
    • D、 The Oracle database will perform block checking for the data blocks in all user tablespaces
    • E、 The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only

    正确答案:E

  • 第4题：

    Examine the following command that is used to duplicate a database on the same host: RMAN> RUN { ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; / } Which two statements describe the effect after the database is duplicated successfully? （）(Choose two)

    • A、The data files of the read-only tablespaces in the target database are not duplicated
    • B、The read-only tablespaces in the target database are still defined in new the database
    • C、The read-only tablespaces in the target database are changed to online after duplication
    • D、The data files of the read-only tablespaces in the target database get duplicated
    • E、The read-only tablespaces in the target database are not defined in the new database

    正确答案:A,B

  • 第5题：

    In order to enable remote administration of users and tablespaces on an Oracle database, which of the following types of files must exist in the database?（）

    • A、Password file 
    • B、Initialization file 
    • C、Datafile 
    • D、Control file 
    • E、Nothing - SYSDBA privileges are not required for these actions

    正确答案:E

  • 第6题：

    单选题
    In order to enable remote administration of users and tablespaces on an Oracle database, which of the following types of files must exist in the database?（）
    A

    Password file 

    B

    Initialization file 

    C

    Datafile 

    D

    Control file 

    E

    Nothing - SYSDBA privileges are not required for these actions


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

  • 第7题：

    单选题
    You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script: SQL>@utlu111i.sql Which statement about the execution of this script is true?（）
    A

    It must be executed from the Oracle Database 11g environment.

    B

    It must be executed only after the SYSAUX tablespace has been created.

    C

    It must be executed from the environment of the database that is being upgraded.

    D

    It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.

    E

    It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.


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

  • 第8题：

    多选题
    You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces arecreated by default in HR_PDB?（）
    A

    SYSTEM

    B

    SYSAUX

    C

    EXAMPLE

    D

    UNDO

    E

    TEMP

    F

    USERS


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

  • 第9题：

    单选题
    You are creating tablespaces in Oracle. Which of the following keywords or clauses permits the datafiles of a database to grow automatically in order to accommodate data growth?（）
    A

    DEFAULT STORAGE 

    B

    EXTENT MANAGEMENT 

    C

    AUTOEXTEND 

    D

    DATAFILE


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

  • 第10题：

    多选题
    Which statements are true about logical structures of the Oracle database（）
    A

    Each segment contains one or more extents.

    B

    Multiple tablespaces can share a single data file

    C

    A data block is the smallest unit of input/output （I/O） in data files.

    D

    It is possible to have tablespaces of different block sizes in a database.

    E

    Each data block in the database always corresponds to one operating system block


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

  • 第11题：

    多选题
    Which three statements are true regarding the logical structure of the Oracle database？（）
    A

    Each segment contains one or more extents.

    B

    Multiple tablespaces can share single data file.

    C

    A data block is the smallest unit of I/O for data files.

    D

    It is possible to have tablespaces of different block sizes in a database.

    E

    Each data block in the database always corresponds to one OS block.


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

  • 第12题：

    单选题
    You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process，you execute the following script：   SQL>@utlu111i.sql   Which statement about the execution of this script is true？（）
    A

     It must be executed from the Oracle Database 11g environment.

    B

     It must be executed only after the SYSAUX tablespace has been created.

    C

     It must be executed from the environment of the database that is being upgraded.

    D

     It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.

    E

     It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.


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

  • 第13题：

    Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）

    • A、The database is in mount state.
    • B、One of the tablespaces is offline.
    • C、One of the tablespaces is read only.
    • D、The database operates in ARCHIEVELOG mode. 
    • E、The database operates in NOARCHIEVELOG mode.

    正确答案:E

  • 第14题：

    The DB_BLOCK_CHECKING initialization parameter is set to OFF. 数据库块检测初始化参数被设定为关  Which block checking would be performed?（）

    • A、The Oracle database will perform block checking for the index blocks only 
    • B、The Oracle database will not perform block checking for any of the data blocks 
    • C、The Oracle database will perform block checking for the default permanent tablespace only 
    • D、The Oracle database will perform block checking for the data blocks in all user tablespaces 
    • E、The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only Oracle

    正确答案:E

  • 第15题：

    You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process，you execute the following script：   SQL>@utlu111i.sql   Which statement about the execution of this script is true？（）

    • A、 It must be executed from the Oracle Database 11g environment.
    • B、 It must be executed only after the SYSAUX tablespace has been created.
    • C、 It must be executed from the environment of the database that is being upgraded.
    • D、 It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
    • E、 It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

    正确答案:C

  • 第16题：

    Which tablespaces are mandatory in an Oracle database for it to be operational（）

    • A、Undo tablespace
    • B、USERS tablespace
    • C、SYSAUX tablespace
    • D、SYSTEM tablespace
    • E、Temporary tablespace

    正确答案:C,D

  • 第17题：

    多选题
    Which tablespaces are mandatory in an Oracle database for it to be operational（）
    A

    Undo tablespace

    B

    USERS tablespace

    C

    SYSAUX tablespace

    D

    SYSTEM tablespace

    E

    Temporary tablespace


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

  • 第18题：

    单选题
    You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）
    A

    One tablespace has only one datafile

    B

    Many tablespaces can share one datafile

    C

    One tablespace can have many datafiles

    D

    One datafile can contain many tablespaces


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

  • 第19题：

    多选题
    SQ L*Loader is a utility that can perform which two tasks？（）
    A

    Load data from a disk， tape， or named pipes.

    B

    Load data into an Oracle database using DML statements.

    C

    Extract， reorganize， and insert data within an Oracle database.

    D

    Load data from external files into tables in an Oracle database.

    E

    Load data into an Oracle database using operating system commands.

    F

    Load data directly from a non-Oracle database to an Oracle database.


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

  • 第20题：

    单选题
    The DB_BLOCK_CHECKING initialization parameter is set to OFF. 数据库块检测初始化参数被设定为关  Which block checking would be performed?（）
    A

    The Oracle database will perform block checking for the index blocks only 

    B

    The Oracle database will not perform block checking for any of the data blocks 

    C

    The Oracle database will perform block checking for the default permanent tablespace only 

    D

    The Oracle database will perform block checking for the data blocks in all user tablespaces 

    E

    The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only Oracle


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

  • 第21题：

    多选题
    Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups. Which two backups would you be able to perform when the database is being accessed by users？（）
    A

    Backup of offline tablespaces.

    B

    Backup of read-only tablespaces.

    C

    Backup of system-critical tablespaces.

    D

    Backup of online， locally managed tablespaces.

    E

    Backup of read/write dictionary-managed tablespaces.


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

  • 第22题：

    多选题
    Examine the following command that is used to duplicate a database on the same host：   RMAN> RUN {  ALLOCATE AUXILIARY CHANNEL， aux 1 DEVICE TYPE DISK； DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY； / } Which two statements describe the effect after the database is duplicated successfully？（）
    A

    The data files of the read-only tablespaces in the target database are not duplicated

    B

    The read-only tablespaces in the target database are still defined in new the database

    C

    The read-only tablespaces in the target database are changed to online after duplication

    D

    The data files of the read-only tablespaces in the target database get duplicated

    E

    The read-only tablespaces in the target database are not defined in the new database


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

  • 第23题：

    单选题
    Your boss at Certkiller .com wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）
    A

    The database is in mount state.

    B

    One of the tablespaces is offline.

    C

    One of the tablespaces is read only.

    D

    The database operates in ARCHIEVELOG mode.

    E

    The database operates in NOARCHIEVELOG mode.


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

  • 第24题：

    单选题
    The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking would be performed？（）
    A

     The Oracle database will not perform block checking for any of the data blocks.

    B

     The Oracle database will perform block checking for the default permanent tablespace only. 

    C

     The Oracle database will perform block checking for the data blocks in all user tablespaces.

    D

     The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.

    E

     The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX tablespaces.


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

相关内容