单选题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

第1题：

“请问您要去哪里？”可以用英文表达为（）。

• A、Where do you want to go？
• B、Where would you like to go？
• C、Where are you going？
• D、Where are they going？

第2题：

The accounts receivable department requested an accounts status to allow users to enter either a customer name, customer number, customer phone number and then display the customer out standing balance. You want to restrict the data retrieved based on values entered by the users. Which where clause would you write in the query to select statement to accomplish this task?（）

• A、&p_where_clause 
• B、:p_where_clause 
• C、WHERE CUST_ID=P_CUST_ID or cust_name=:p_cust_name or cust_phone=:p_cust_phone 
• D、Where cust_ID=&p_custid cust_name=&p_cust_name or cust_phone=&p_cust_phone

第3题：

第4题：

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

第5题：

Where do you configure SCREEN options？（）

• A、zones on which an attack might arrive
• B、zones you want to protect from attack
• C、interfaces on which an attack might arrive
• D、interfaces you want to protect from attack

第6题：

Given the following table definition: STOCK: item VARCHAR(30) status CHAR(1) quantity INT price DEC(7,2) If items are indicated to be out of stock by setting STATUS to NULL and QUANTITY and PRICE to zero, which of the following statements would be used to update the STOCK table to indicate that all the items whose description begins with the letter "S" are out of stock?（）

• A、UPDATE stock SET (status = NULL; quantity, price = 0) WHERE item LIKE S%
• B、UPDATE stock SET (status, quantity, price) = (NULL, 0, 0) WHERE item LIKE S%
• C、UPDATE stock SET status = NULL, SET quantity = 0, SET price = 0 WHERE item LIKE 'S%'
• D、UPDATE stock SET (status = NULL), (quantity = 0), (price = 0) WHERE item LIKE S%

第7题：

You create a data block based on a relation table containing a REF column. You select the REF column for your form module. Which statement about the REF column is true?（）

• A、It is created as a nondisplay item. 
• B、The Lock Record property is set to Yes. 
• C、It cannot be referenced in item level triggers. 
• D、It is placed on the canvas with the highest sequence number.

第8题：

第9题：

Which three are true regarding the use of outer joins?（）

• A、You cannot use IN operator in a condition that involves an outerjoin.
• B、You use (+) on both sides of the WHERE condition to perform an outerjoin.
• C、You use (*) on both sides of the WHERE condition to perform an outerjoin.
• D、You use an outerjoin to see only the rows that do not meet the join condition.
• E、In the WHERE condition, you use (+) following the name of the column in the table without matching rows, to perform an outerjoin.
• F、You cannot link a condition that is involved in an outerjoin to another condition by using the OR operator.

第10题：

You create a data block based on a relational table containing a REF column. You select the REF column for your form module. What is true about the items based on the REF column attributes?（）

• A、The Query Only property is set to Yes. 
• B、The Conceal Data property is set to Yes. 
• C、The Insert Allowed property is set to Yes. 
• D、The Update Allowed property is set to Yes.