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 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 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.
Which three statements are true regarding subqueries?（）A、Subqueries can contain GROUP BY and ORDER BY clauses B、Main query and subquery can get data from different tables C、Main query and subquery must get data from the same tables D、Subqueries can contain ORDER BY but not the GROUP BY clause E、Only one column or expression can be compared between the main query and subqueryF、 Multiple columns or expressions can be compared between the main query and subquery
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 statements are true regarding a tablespace（）A、It can span multiple databases.B、It can consist of multiple data files.C、It can contain blocks of different sizes.D、It can contain segments of different sizes.E、It can contain a part of a nonpartitioned segment
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 statements are true regarding the Oracle Data Pump export and import operations（）A、You cannot export data from a remote database.B、You can rename tables during an import operation.C、You can overwrite existing dump files during an export operation.D、You can compress the data during export but not the metadata because it is not supported
Which three statements are true regarding single-row functions？（）A、 They can accept only one argument.B、 They can be nested up to only two levels.C、 They can return multiple values of more than one data type.D、 They can be used in SELECT， WHERE， and ORDER BY clauses. E、 They can modify the data type of the argument that is referenced.F、 They can accept a column name， expression， variable name， or a user-supplied constant as arguments.
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
You are managing an Oracle Database 10g database that uses Oracle Managed Files （OMF）. You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true？（）A、 One block change tracking file is created for each data file. By default， the file is created in DB_CREATE_FILE_DEST.B、 One block change tracking file is created for each data file. By default， the file is created in BACKGROUND_DUMP_DEST.C、 One block change tracking file is created for the database. By default， the file is created in DB_CREATE_FILE_DEST.D、 One block change tracking file is created for the database. By default， the file is created in BACKGROUND_DUMP_DEST.
Which two statements are true regarding a tablespace（）A、It can span multiple databases.B、It can consist of multiple data files.C、It can contain blocks of different sizes.D、It can contain segments of different sizes.E、It can contain a part of a nonpartitioned segment.
Which two statements are true regarding the Oracle Data Pump export and import operations（）A、You cannot export data from a remote database.B、You can rename tables during an import operation.C、You can overwrite existing dump files during an export operation.D、You can compress the data during export but not the metadata because it is not supported.
How can you configure High Availability for interacting with a non-Oracle database using WebLogic?（）A、Configure multiple physical data sources and reuse the same JNDI name for each.B、Use the "compatibility" option of Active GridLink to enable compatibility with non-Oracle databases.C、Configure a single physical data source for each node in a database cluster and wrap it using Multi Data Source.D、Configure a Data Source Group that contains a physical connection pool to each node in the database cluster.
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 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 statements are true regarding a tablespace（）AIt can span multiple databases.BIt can consist of multiple data files.CIt can contain blocks of different sizes.DIt can contain segments of different sizes.EIt can contain a part of a nonpartitioned segment
多选题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 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
单选题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？（）AThe Oracle database will check all data blocks by going through the data on each block， making sure the data is self-consistent.BDBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.CThe 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.DThe 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.EThe 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