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 possib

第1题：

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.

第2题：

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.

第3题：

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.

第4题：

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.

第5题：

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

第6题：

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

第7题：

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

第8题：

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 subquery
• F、 Multiple columns or expressions can be compared between the main query and subquery

第9题：

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.

第10题：

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