单选题In a database with the database character set of US7ASCII and a national character set of UTF-8, which datatypes would be capable of storing Unicode data by default?（）A VARCHAR2B CHARC NVARCHAR2D CLOBE LONG

第1题：

Automatic data conversion will occur if which of the following happens？（）

• A、 The client and server have different NLS_LANGUAGE settings
• B、 The client and server character sets are not the same，and the database character set is not a strict superset of the client character set
• C、 The client and server are in different time zones
• D、 The client requests automatic data conversion
• E、 The AUTO_CONVERT initialization parameter is set to TRUE

第2题：

In a design situation, there are multiple character sets that can properly encode your data. Which three should influence your choice of character set?（）

• A、Syntax when writing queries involving JOINS
• B、Memory usage when working with the data 
• C、Character set mapping index hash size
• D、Disk usage when storing data

第3题：

第4题：

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

第5题：

You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set.   How will you migrate your database from UTF8 to AL16UTF16？（）  

• A、 by using the RMAN utility
• B、 by using the export/import utility
• C、 by using the ALTER DATABASE command
• D、 by enabling the change tracking feature

第6题：

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.

第7题：

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

第8题：

第9题：

Automatic data conversion will occur if which of the following happens?（）

• A、The client and server have different NLS_LANGUAGE settings.
• B、The client and server character sets are not the same, and the database character set is not a strict superset of the client character set.
• C、The client and server are in different time zones.
• D、The client requests automatic data conversion.
• E、The AUTO_CONVERT initialization parameter is set to TRUE.

第10题：

You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB). The characteristics of the non-CDB are as follows: -Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit -Character set: AL32UTF8 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit The characteristics of the CDB are as follows: -Version: Oracle Database 12c Release 1 64-bit -Character Set: AL32UTF8 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit Which technique should you use to minimize down time while plugging this non-CDB into the CDB?（）

• A、Transportable database
• B、Transportable tablespace
• C、Data Pump full export/import
• D、The DBMS_PDB package
• E、RMAN