多选题Which two tasks can your perform by using the TO_CHAR function? （）AConvert 10 to 'TEN'BConvert '10' to 10CConvert '10' to '10'DConvert 'TEN' to 10EConvert a date to a character expressionFConvert a character expression to a date

第1题：

回到10！（）

• A、Ease to ten!
• B、Return to ten!
• C、Port ten!
• D、Nothing to ten!

第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题：

Which two tasks can you perform using only the TO_CHAR function? （）

• A、convert 10 to 'TEN'
• B、convert '10' to 10
• C、convert 10 to '10'
• D、convert 'TEN' to 10
• E、convert a date to a character expression
• F、convert a character expression to a date

第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题：

A pSeries technical specialist is performing a solutions assurance with a customer for a new single-frame 10-node p655 system being attached to a currently installed HMC.  Which of the following questions should be asked to gather all the required information to determine whether the p655 solution can connect to the HMC？（）

• A、Are there at least ten RS-232 ports available on the HMC？
• B、Are there at least ten RS-422 ports available on the HMC？
• C、Are there at least ten RS-232 and two RS-422 ports available on the HMC？
• D、Are there at least two RS-232 and ten RS-422 ports available on the HMC？

第7题：

Which three tasks can be performed using regular expression support in Oracle Database 10g？（）

• A、 it can be used to concatenate two strings.
• B、 it can be used to find out the total length of the string.
• C、 it can be used for string manipulation and searching operations.
• D、 it can be used to format the output for a column or expression having string data.
• E、 it can be used to find and replace operations for a column or expression having string data.

第8题：

第9题：

Which two tasks can your perform by using the TO_CHAR function? （）

• A、Convert 10 to 'TEN'
• B、Convert '10' to 10
• C、Convert '10' to '10'
• D、Convert 'TEN' to 10
• E、Convert a date to a character expression
• F、Convert a character expression to a date

第10题：

Which statement accomplish this? （）

• A、CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);
• B、CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);
• C、CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);
• D、CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);
• E、CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);
• F、CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE DEFAULT SYSDATE);