long
timer
number
varchar2
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
点击查看答案
You are maintaining a database of credit card transactions. You want the data to be returned automatically in the chronological order of the credit card numbers without using the ORDER BY clause in the query. Which type of cluster will you use to obtain the desired result？（） A、 Hash clusterB、 Index clusterC、 Sorted hash clusterD、 Real Application cluster
What is the data type returned by the CREATE_TIMER built-in?（）A、longB、timerC、numberD、varchar2
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 );
Which value is valid for the iterate parameter in the CREATE_TIMER built-in function?（）A、CYCLE B、ITERATEC、NO_REPEAT D、REUSE
Windows Communication Foundation （WCF） application uses a data contract that has several data members. You need the application to throw a Serialization Exception if any of the data members are not present when a serialized instance of the data contract is deserialized. What should you do？（）A、 Add the Known Type attribute to the data contract.Set a default value in each of the data member declarations.B、 Add the Known Type attribute to the data contract.Set the Order property of each data member to unique integer value.C、 Set the Emit Default Value property of each data member to false.D、 Set the Is Required property of each data member to true.
单选题A system administrator has determined that the /development filesystem needs to be changed from JFS to JFS2 to take advantage of the new capabilites available in JFS2. What is the method to convert the /development filesystem from type JFS to JFS2？（）A Umount the /development filesystem and remount it using the following command： mount -t jfs2 /developmentB Edit the /etc/filesystems file to change the type paramter to jfs2 and change the log parameter to jfs2logC Backup the /development filesystem data， delete the JFS /development filesystem， create the new JFS2 /development filsystem， and restore the data to the /development filesystemD Backup the /development filesystem data， change the /development filesystem using the following command，chfs -t type=jfs2 /development.then， restore the data to the /development filesystem
