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 type D

第1题：

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 

第2题：

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

第3题：

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.

第4题：

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.

第5题：

You issue the following command on the RMAN prompt.   RMAN> REPORT NEED BACKUP DAYS = 5 DATABASE；   Which statement is true about executing this command？（）

• A、 It will display a list of files that need incremental backup.
• B、 It will display a list of files that need backup after five days.
• C、 It will display a list of files that were backed up in the last five days.
• D、 It will display a list of files that have not been backed up in the last five days.
• E、 It will apply the current retention policy to determine the files that need to be backed up.

第6题：

Which statement is true regarding subqueries?（）

• A、The LIKE operator cannot be used with single-row subqueries 
• B、The NOT IN operator is equivalent to IS NULL with single-row subqueries 
• C、=ANY and =ALL operators have the same functionality in multiple-row subqueries 
• D、The NOT operator can be used with IN, ANY, and ALL operators in multiple-row subqueries 

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Which three statements are true regarding subqueries?（）

• A、Subqueries can contain GROUP BY and ORDER BY clauses 
• B、Main query and subquery can get data from different tables 
• C、Main query and subquery must get data from the same tables 
• D、Subqueries can contain ORDER BY but not the GROUP BY clause 
• E、Only one column or expression can be compared between the main query and subquery
• F、 Multiple columns or expressions can be compared between the main query and subquery

第14题：

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.

第15题：

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

第16题：

Which statement is true regarding Flashback Version Query？ （）

• A、 It returns versions of rows only within a transaction.
• B、 It can be used in subqueries contained only in a SELECT statement.
• C、 It will return an error if the undo retention time is less than the lower bound time or SCN specified.
• D、 It retrieves all versions including the deleted as well as subsequently reinserted versions of the rows.

第17题：

You issue the following command on the RMAN prompt.   REPORT NEED BACKUP DAYS 5；   Which statement is true about executing this command？（）  

• A、 It will display a list of files that need incremental backup
• B、 It will display a list of files that need backup after five days
• C、 It will display a list of files that were backed up in the last five days
• D、 It will display a list of files that have not been backed up in the last five days
• E、 It will apply the current retention policy to determine the files that need to be backed up

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：