单选题Which datatype is returned by the FIND_MENU_ITEM built-in function?（）A number B Boolean C menuitem D VARCHAR2

第1题：

lisa is writing a formula to determine the number of elements in a list. she wants to ensure that a value is returned, even if the value her function is evaluating turns out to be a null string . which one of the following can she so to accomplish this ?（）

• A、use a defaule formula of 1 
• B、use @elements and add 1 to the total 
• C、use the @count function instead of @elements 
• D、use @texttotime to ensure that all strings arte converted to date-time values 

第2题：

Which of the following datatypes are used in situations where you want an ordered set of data elements, where every element is the same datatype, and where you predefine the number of elements that appear in the set?（）

• A、REF 
• B、TABLE 
• C、CLOB 
• D、VARRAY

第3题：

第4题：

Which datatype is returned by the FIND_MENU_ITEM built-in function?（）

• A、number 
• B、Boolean 
• C、menuitem 
• D、VARCHAR2 

第5题：

以下的PL/SQL声明哪个是正确的？（）

• A、v_id NUMBER(4);
• B、v_x, v_y, v_z VARCHAR2(10);
• C、v_birthdate DATE NOT NULL;
• D、v_in_stock BOOLEAN := 1;

第6题：

The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4) NOT NULL CUSTOMER_NAME VARCHAR2(100) NOT NULL STREET_ADDRESS VARCHAR2(150) CITY_ADDRESS VARCHAR2(50) STATE_ADDRESS VARCHAR2(50) PROVINCE_ADDRESS VARCHAR2(50) COUNTRY_ADDRESS VARCHAR2(50) POSTAL_CODE VARCHAR2(12) CUSTOMER_PHONE VARCHAR2(20) The CUSTOMER_ID column is the primary key for the table. Which two statements find the number of customers? （）

• A、SELECT TOTAL(*) FROM customer;
• B、SELECT COUNT(*) FROM customer;
• C、SELECT TOTAL(customer_id) FROM customer;
• D、SELECT COUNT(customer_id) FROM customer;
• E、SELECT COUNT(customers) FROM customer;
• F、SELECT TOTAL(customer_name) FROM customer;

第7题：

Which three statements describe the functionality of the DO_KEY built-in?（）

• A、It accepts both a built-in and a key name as argument. 
• B、If no key trigger is defined, the specified built-in executes. 
• C、Its parameter must be specified in upper case, enclosed in single quotation marks. 
• D、It performs the same task as if you pressed the function key associated with the specified argument. 
• E、It executes the key trigger that corresponds to the built-in specified as its parameter. 

第8题：

第9题：

When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?（）

• A、SET_JOB_ARGUMENT_VALUE
• B、SET_JOB_VALUE_ANYDATA
• C、SET_JOB_ANYDATA_VALUE
• D、SET_SPECIAL_JOB_VALUE
• E、SET_JOB_ANYTYPE_VALUE

第10题：

What is the data type returned by the CREATE_TIMER built-in?（）

• A、long
• B、timer
• C、number
• D、varchar2