多选题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
参考解析
解析：
暂无解析
相关考题：
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
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.
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
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
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
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.
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.
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
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 onlyB、 The Oracle database will not perform block checking for any of the data blocksC、 The Oracle database will perform block checking for the default permanent tablespace onlyD、 The Oracle database will perform block checking for the data blocks in all user tablespacesE、 The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only
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.
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
Which tablespaces are mandatory in an Oracle database for it to be operational（）A、Undo tablespaceB、USERS tablespaceC、SYSAUX tablespaceD、SYSTEM tablespaceE、Temporary tablespace
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
单选题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?（）APassword file BInitialization file CDatafile DControl file ENothing - SYSDBA privileges are not required for these actions
单选题You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）AOne tablespace has only one datafileBMany tablespaces can share one datafileCOne tablespace can have many datafilesDOne datafile can contain many tablespaces
单选题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?（）AIt must be executed from the Oracle Database 11g environment.BIt must be executed only after the SYSAUX tablespace has been created.CIt must be executed from the environment of the database that is being upgraded.DIt must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.EIt must be executed from both the Oracle Database 11g and Oracle Database 9i environments.
多选题SQ L*Loader is a utility that can perform which two tasks？（）ALoad data from a disk， tape， or named pipes.BLoad data into an Oracle database using DML statements.CExtract， reorganize， and insert data within an Oracle database.DLoad data from external files into tables in an Oracle database.ELoad data into an Oracle database using operating system commands.FLoad data directly from a non-Oracle database to an Oracle database.
多选题You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces arecreated by default in HR_PDB?（）ASYSTEMBSYSAUXCEXAMPLEDUNDOETEMPFUSERS
单选题The DB_BLOCK_CHECKING initialization parameter is set to OFF. 数据库块检测初始化参数被设定为关 Which block checking would be performed?（）AThe Oracle database will perform block checking for the index blocks only BThe Oracle database will not perform block checking for any of the data blocks CThe Oracle database will perform block checking for the default permanent tablespace only DThe Oracle database will perform block checking for the data blocks in all user tablespaces EThe Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only Oracle
单选题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?（）ADEFAULT STORAGE BEXTENT MANAGEMENT CAUTOEXTEND DDATAFILE
多选题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？（）ABackup of offline tablespaces.BBackup of read-only tablespaces.CBackup of system-critical tablespaces.DBackup of online， locally managed tablespaces.EBackup of read/write dictionary-managed tablespaces.
多选题Which statements are true about logical structures of the Oracle database（）AEach segment contains one or more extents.BMultiple tablespaces can share a single data fileCA data block is the smallest unit of input/output （I/O） in data files.DIt is possible to have tablespaces of different block sizes in a database.EEach data block in the database always corresponds to one operating system block
多选题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？（）AThe data files of the read-only tablespaces in the target database are not duplicatedBThe read-only tablespaces in the target database are still defined in new the databaseCThe read-only tablespaces in the target database are changed to online after duplicationDThe data files of the read-only tablespaces in the target database get duplicatedEThe read-only tablespaces in the target database are not defined in the new database
多选题Which three statements are true regarding the logical structure of the Oracle database？（）AEach segment contains one or more extents.BMultiple tablespaces can share single data file.CA data block is the smallest unit of I/O for data files.DIt is possible to have tablespaces of different block sizes in a database.EEach data block in the database always corresponds to one OS block.
单选题Your boss at Certkiller .com wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）AThe database is in mount state.BOne of the tablespaces is offline.COne of the tablespaces is read only.DThe database operates in ARCHIEVELOG mode.EThe database operates in NOARCHIEVELOG mode.
单选题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.
单选题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.