单选题which one of the following should maria do to display the release date in a text column?（）A used the number and time format options B used the @date to text functions to convert time to text C concatenated the date types using mathematical operators D

第1题：

nancy used a rich text field on a form to capture data. she would like to display the data in a view. which of the following should she do?（）

• A、use @texttorichtext
• B、use a richtext title field
• C、use the @text（fieldname） in the  column formula
• D、nothing rich text display in the views

第2题：

在Visual FoxPro中，在输出text和endtext语句中有：<< date（）>>时， 则会输出date（）.

第3题：

jim has created a field hint for the address field. Users tell him this text disappears when they click in the address field. which one of the following is most likely reason?（）

• A、 the address field is computed 
• B、 jim should have used a text popup       
• C、 jim stored the field hint in the database    
• D、 field hint only display when the user has not clicked in the field （field hint）

第4题：

Which operational mode command can be used to synchronize the local system time with an NTP server?（）

• A、set ntp time 64.32.129.3
• B、set clock ntp 64.32.129.3
• C、set time 64.32.129.3
• D、set date ntp 64.32.129.3

第5题：

Examine the description of the STUDENTS table: STD_ID NUMBER(4) COURSE_ID VARCHARD2(10) START_DATE DATE END_DATE DATE Which two aggregate functions are valid on the START_DATE column?（）

• A、SUM(start_date)
• B、AVG(start_date)
• C、COUNT(start_date)
• D、AVG(start_date, end_date)
• E、MIN(start_date)
• F、MAXIMUM(start_date)

第6题：

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

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

which one of the following should maria do to display the release date in a text column?（）

• A、used the number and time format options 
• B、used the @date to text functions to convert time to text 
• C、concatenated the date types using mathematical operators 
• D、used the @text functions to convert time and number data to text in text columns 

第14题：

Which of the following local files is used to run the date command on the remote machine "Earth" using the following rexec command without request for a password？ rexec Earth date（）。

• A、~/ .rhosts
• B、$HOME/.netrc
• C、/etc/hosts.equiv
• D、/etc/security/user

第15题：

Which of the following are all valid DB2 data types?（）

• A、LONG VARCHAR, SMALLINT, NUMBER, BLOB
• B、DECIMAL, DATE, DBCLOB, INTERVAL
• C、NUMERIC, TIMESTAMP, BYTE, FLOAT
• D、NUM, TIME, XML, DOUBLE

第16题：

Which operational mode command can be used to synchronize the local system with an NTP server?（）

• A、set ntp time 64.32.129.3
• B、set clock ntp 64.32.129.3
• C、set time 64.32.129.3
• D、set date ntp 64.32.129.3

第17题：

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'

第18题：

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

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：