多选题Which two tasks can you perform using only 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题：

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

第2题：

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);

第3题：

You need to create a table named ORDERS that contains four columns: 1.an ORDER_ID column of number data type 2.a CUSTOMER_ID column of number data type 3.an ORDER_STATUS column that contains a character data type 4.a DATE_ORDERED column to contain the date the order was placed When a row is inserted into the table, if no value is provided for the status of the order, the value PENDING should be used instead. Which statement accomplishes this?（）

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

第4题：

Which two statements are true regarding working with dates?（）

• A、The default internal storage of dates is in the numeric format 
• B、The default internal storage of dates is in the character format 
• C、The RR date format automatically calculates the century from the SYSDATE function and does not allow the user to enter the century 
• D、The RR date format automatically calculates the century from the SYSDATE function but allows the user to enter the century if required

第5题：

Your company uses SQL Server 2005. You are implementing a series of views that are used in ad hoc queries. The views are used to enforce your companys security policy of abstracting data.  Some of these views perform slowly. You create indexes on those views to increase performance, while still maintaining the companys security policy. One of the views returns the current date as one of the columns. The view returns the current date by using the GETDATE（　） function. This view does not allow you to create an index. You need to create an index on the view.  Which two actions should you perform?（）

• A、 Remove all deterministic function calls from within the view. 
• B、 Remove all nondeterministic function calls from within the view. 
• C、 Schema-bind all functions that are called from within the view. 
• D、 Create the view and specify the WITH CHECK OPTION clause.

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

What two statements are true regarding the recommendations received from the SQL Access Advisor?（）(Choose two.)

• A、It cannot generate recommendations that support multiple workload queries.
• B、It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.
• C、It can recommend partitioning only on tables that have at least 10,000 rows.
• D、It can recommend only B-tree indexes and not bitmap or function-based indexes

第14题：

For which action can you use the TO_DATE function? （）

• A、Convert any date literal to a date
• B、Convert any numeric literal to a date
• C、Convert any character literal to a date
• D、Convert any date to a character literal
• E、Format '10-JAN-99' to 'January 10 1999'

第15题：

You need to create a table named ORDERS that contain four columns: 1. an ORDER_ID column of number data type 2. aCUSTOMER_ID column of number data type 3. an ORDER_STATUS column that contains a character data type 4. aDATE_ORDERED column to contain the date the order was placed. When a row is inserted into the table, if no value is provided when the order was placed, today's date should be used instead. Which statement accomplishes 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 VARCHAR2 (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);

第16题：

What two statements are true regarding the recommendations received from the SQL Access Advisor？（）

• A、 It cannot generate recommendations that support multiple workload queries.
• B、 It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.
• C、 It can recommend partitioning only on tables that have at least 10，000 rows.
• D、 It can recommend only B-tree indexes and not bitmap or function-based indexes.

第17题：

TestKing.com uses SQL Server 2005. You are implementing a series of views that are used in ad hoc queries. The views are used to enforce TestKing.coms security policy of abstracting data. Some of these views perform slowly. You create indexes on those views to increase performance， while still maintaining the company’s security policy. One of the views returns the current date as one of the columns. The view returns the current date by using the GETDATE（） function. This view does not allow you to create an index. You need to create an index on the view. Which two actions should you perform？（）

• A、Remove all deterministic function calls from within the view.
• B、Remove all nondeterministic function calls from within the view.
• C、Schema-bind all functions that are called from within the view.
• D、Create the view and specify the WITH CHECK OPTION clause.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：