网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
多选题
Which three 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.


参考答案

参考解析
解析: A答案:每个段包含一个或多个区,正确。 
B答案:一个数据文件只能属于一个表空间,故错误。 
C答案:Oracle data block是最小的I/O单位,正确 
D答案:可以是不同的块大小,需要指名非标准块的位置。 
E答案:每个数据库里面的数据库对应一个或多个操作系统块,故E错误。
更多 “多选题Which three statements are true about logical structures of the Oracle database()AEach segment contains one or more extents.BMultiple tablespaces can share a single data file.CA 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.” 相关考题
考题 Which three statements are true about Oracle Data Pump export and import operations?() A. You can detach from a data pump export job and reattach later.B. Data pump uses parallel execution server processes to implement parallel import.C. Data pump import requires the import file to be in a directory owned by the oracle owner.D. The master table is the last object to be exported by the data pump.E. You can detach from a data pump import job and reattach later.

考题 Which two statements correctly describe the relation between a data file and the logical databasestructures()A、An extent cannot spread across data files.B、A segment cannot spread across data files.C、A data file can belong to only one tablespace.D、A data file can have only one segment created in it.E、A data block can spread across multiple data files as it can consist of multiple operating system (OS) blocks.

考题 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

考题 Which three statements about subqueries are true? ()A、A main query can have more than one subquery.B、A subquery can have more than one main query.C、The subquery and main query must retrieve data from the same table.D、The subquery and main query can retrieve data from different tables.E、Only one column or expression can be compared between the subquery and main query.F、Multiple columns or expression can be compared between the subquery and main query.

考题 Which two statements about bigfile tablespaces are true? ()A、The bigfile tablespace have only one data file.B、The segment space management is automatic.C、The extent management is dictionary managed.D、The database can have only one bigfile tablespace.E、The bigfile tablespace can be converted to a smallfile tablespace.

考题 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 fileC、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

考题 Which three statements are true about Oracle Data Pump export and import operations?()A、You can detach from a data pump export job and reattach later.B、Data pump uses parallel execution server processes to implement parallel import.C、Data pump import requires the import file to be in a directory owned by the oracle owner.D、The master table is the last object to be exported by the data pump.E、You can detach from a data pump import job and reattach later.

考题 Which two statements are true about simple views?()A、Views can be created as read only.B、Views are data segments like tables.C、Views can be created on the basis of more than one table.D、Data manipulation language (DML) operations cannot be performed on views.

考题 Which two statements are true regarding transactions in an Oracle database()A、Multiple transactions can use the same undo segment.B、A transaction is assigned an undo segment when it is started.C、More than one transaction cannot share the same extent in the undo tablespace.D、The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.

考题 Which three statements are true regarding the data types in Oracle Database 10g/11g?()A、Only one LONG column can be used per table B、A TIMESTAMP data type column stores only time values with fractional seconds C、The BLOB data type column is used to store binary data in an operating system file D、The minimum column width that can be specified for a VARCHAR2 data type column is one E、The value for a CHAR data type column is blank-padded to the maximum defined column width

考题 The DB_BLOCK_CHECKING initialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles, every time the DBWn writes?()A、The Oracle database will check all data blocks by going through the data on each block, making sure the data is self-consistent.B、DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.C、The Oracle database will check data blocks belonging to the SYSTEM tablespace only, by going through the data on each block, making sure the data is self-consistent.D、The Oracle database will check data blocks belonging to the SYSAUX tablespace only, by going through the data on each block, making sure the data is self-consistent.E、The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only, by going through the data on each block, making sure the data is self-consistent

考题 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.

考题 Which three 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.

考题 多选题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.

考题 多选题Which three statements about subqueries are true? ()AA main query can have more than one subquery.BA subquery can have more than one main query.CThe subquery and main query must retrieve data from the same table.DThe subquery and main query can retrieve data from different tables.EOnly one column or expression can be compared between the subquery and main query.FMultiple columns or expression can be compared between the subquery and main query.

考题 多选题Which three statements are true regarding the data types in Oracle Database 10g/11g?()AOnly one LONG column can be used per tableBA TIMESTAMP data type column stores only time values with fractional secondsCThe BLOB data type column is used to store binary data in an operating system fileDThe minimum column width that can be specified for a VARCHAR2 data type column is oneEThe value for a CHAR data type column is blank-padded to the maximum defined column width

考题 多选题Which three statements are true about logical structures of the Oracle database()AEach segment contains one or more extents.BMultiple tablespaces can share a single data file.CA 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.

考题 多选题Which three statements are true about Oracle Data Pump export and import operations?()AYou can detach from a data pump export job and reattach later.BData pump uses parallel execution server processes to implement parallel import.CData pump import requires the import file to be in a directory owned by the oracle owner.DThe master table is the last object to be exported by the data pump.EYou can detach from a data pump import job and reattach later.

考题 多选题Which two statements are true regarding transactions in an Oracle database()AMultiple transactions can use the same undo segment.BA transaction is assigned an undo segment when it is started.CMore than one transaction cannot share the same extent in the undo tablespace.DThe transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.

考题 多选题Which two statements correctly describe the relation between a data file and the logical databasestructures()AAn extent cannot spread across data files.BA segment cannot spread across data files.CA data file can belong to only one tablespace.DA data file can have only one segment created in it.EA data block can spread across multiple data files as it can consist of multiple operating system (OS) blocks.

考题 多选题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

考题 单选题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.

考题 多选题Which two statements about bigfile tablespaces are true? ()AThe bigfile tablespace have only one data file.BThe segment space management is automatic.CThe extent management is dictionary managed.DThe database can have only one bigfile tablespace.EThe bigfile tablespace can be converted to a smallfile tablespace.

考题 多选题Which three statements are true regarding single-row functions?()AThey can accept only one argument.BThey can be nested up to only two levels.CThey can return multiple values of more than one data type.DThey can be used in SELECT, WHERE, and ORDER BY clauses.EThey can modify the data type of the argument that is referenced.FThey can accept a column name, expression, variable name, or a user-supplied constant as arguments.

考题 多选题Which two statements correctly describe the relation between a data file and the logical database structures()AAn extent cannot spread across data files.BA segment cannot spread across data files.CA data file can belong to only one tablespace.DA data file can have only one segment created in it.EA data block can spread across multiple data files as it can consist of multiple operating system (OS)blocks

考题 多选题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.

考题 单选题The DB_BLOCK_CHECKING initialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles, every time the DBWn writes?()A The Oracle database will check all data blocks by going through the data on each block, making sure the data is self-consistent.B DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.C The Oracle database will check data blocks belonging to the SYSTEM tablespace only, by going through the data on each block, making sure the data is self-consistent.D The Oracle database will check data blocks belonging to the SYSAUX tablespace only, by going through the data on each block, making sure the data is self-consistent.E The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only, by going through the data on each block, making sure the data is self-consistent