long
timer
number
varchar2
多选题Which three statements are true regarding the data types in Oracle Database 10g/11g?()AOnly one LONG column can be used per tableBA TIMESTAMP data type column stores only time values with fractional secondsCThe BLOB data type column is used to store binary data in an operating system fileDThe minimum column width that can be specified for a VARCHAR2 data type column is oneEThe 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?()AHash clusterBIndex clusterCSorted hash clusterDReal Application cluster
单选题What is the data type returned by the CREATE_TIMER built-in?()A longB timerC numberD varchar2
单选题Which datatype is returned by the FIND_MENU_ITEM built-in function?()A number B Boolean C menuitem D 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 layer 2 protocol encapsulation type supports synchronous and asynchronous circuis and has built-in security mechanisms?()A Frame RelayB HDLCC x.25D PPP
单选题What does the value returned by the method getID() found in class java.awt.AWTEvent uniquely identify?()A The particular event instance.B The source of the event.C The set of events that were triggered by the same action.D The type of event.E The type of component from which the event originated.