单选题Which statement is true regarding the COALESCE function?（）A It can have a maximum of five expressions in a list B It returns the highest NOT NULL value in the list for all rows C It requires that all expressions in the list must be of the same data typ

第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 statement is true regarding the INTERSECT operator?（）

• A、It ignores NULL values 
• B、Reversing the order of the intersected tables alters the result 
• C、The names of columns in all SELECT statements must be identical 
• D、The number of columns and data types must be identical for all SELECT statements in the query 

第3题：

第4题：

Which statement regarding the contents of the V$PARAMETER view is true？（）

• A、displays only the list of default values
• B、displays only the list of all basic parameters
• C、displays the currently in effect parameter values
• D、displays only the list of all advanced parameters
• E、displays the list of all the parameter files of a database

第5题：

Which four statements correctly describe functions that are available in SQL? （）

• A、INSTR returns the numeric position of a named character.
• B、NVL2 returns the first non-null expression in the expression list.
• C、TRUNCATE rounds the column, expression, or value to n decimal places.
• D、DECODE translates an expression after comparing it to each search value.
• E、TRIM trims the heading of trailing characters (or both) from a character string.
• F、NVL compares two expressions and returns null if they are equal, or the first expression of they are not equal.
• G、NULLIF compares twp expressions and returns null if they are equal, or the first expression if they are not equal.

第6题：

Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the contents of the V$PARAMETER view is true？（）

• A、Displays only the list of default values
• B、Displays only the list of all basic parameters
• C、Displays the currently in effect parameter values
• D、Displays only the list of all advanced parameters
• E、Displays the list of all the parameter files of a database
• F、Displays the current contents of the server parameter file.

第7题：

Which single access list statement will combine all four of these statements into a single statement that will have exactly the same effect（）。

• A、access-list 10 permit 172.29.16.0 0.0.0.255
• B、access-list 10 permit 172.29.16.0 0.0.1.255
• C、access-list 10 permit 172.29.16.0 0.0.3.255
• D、access-list 10 permit 172.29.16.0 0.0.15.255
• E、access-list 10 permit 172.29.0.0 0.0.255.255

第8题：

第9题：

Which two are true about aggregate functions? （）

• A、You can use aggregate functions in any clause of a SELECT statement.
• B、You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.
• C、You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.
• D、You can pass column names, expressions, constants, or functions as parameter to an aggregate function.
• E、You can use aggregate functions on a table, only by grouping the whole table as one single group.
• F、You cannot group the rows of a table by more than one column while using aggregate functions.

第10题：

You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package. Which statement is true regarding the ACL created?（）

• A、It is a list of remote database links stored in the XML file that are available to the users of the database.
• B、It is a list of users and network privileges stored in the XML file according to which a group of users can connect to one or more hosts.
• C、It is a list of users and network privileges stored in the data dictionary according to which a group of users can connect to one or more hosts.
• D、It is the list of the host names or the IP addresses stored in the data dictionary that can connect to your database through PL/SQL network utility packages such as UTL_TCP.