网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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、It requires that at least one of the expressions in the list must have a NOT NULL value
参考答案
更多 “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、It requires that at least one of the expressions in the list must have a NOT NULL value” 相关考题
考题
An access list was written with the four statements shown in the graphic.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-list10 permit 172.29.16.00.0.0.255B.access-list10 permit 172.29.16.00.0.1.255C.access-list10 permit 172.29.16.00.0.3.255D.access-list10 permit 172.29.16.00.0.15.255E.access-list10 permit 172.29.0.00.0.255.255
考题
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.255B.access-list 10 permit 172.29.16.0 0.0.1.255C.access-list 10 permit 172.29.16.0 0.0.3.255D.access-list 10 permit 172.29.16.0 0.0.15.255E.access-list 10 permit 172.29.0.0 0.0.255.255
考题
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
考题
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 valuesB、Displays only the list of all basic parametersC、Displays the currently in effect parameter valuesD、Displays only the list of all advanced parametersE、Displays the list of all the parameter files of a databaseF、Displays the current contents of the server parameter file.
考题
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
考题
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 subqueryF、 Multiple columns or expressions can be compared between the main query and subquery
考题
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.255B、access-list 10 permit 172.29.16.0 0.0.1.255C、access-list 10 permit 172.29.16.0 0.0.3.255D、access-list 10 permit 172.29.16.0 0.0.15.255E、access-list 10 permit 172.29.0.0 0.0.255.255
考题
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.
考题
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.
考题
Which statement regarding the contents of the V$PARAMETER view is true？（）A、displays only the list of default valuesB、displays only the list of all basic parametersC、displays the currently in effect parameter valuesD、displays only the list of all advanced parametersE、displays the list of all the parameter files of a database
考题
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.
考题
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.
考题
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.
考题
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 backupB、 It will display a list of files that need backup after five daysC、 It will display a list of files that were backed up in the last five daysD、 It will display a list of files that have not been backed up in the last five daysE、 It will apply the current retention policy to determine the files that need to be backed up
考题
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
考题
多选题Which four statements correctly describe functions that are available in SQL? （）AINSTR returns the numeric position of a named character.BNVL2 returns the first non-null expression in the expression list.CTRUNCATE rounds the column, expression, or value to n decimal places.DDECODE translates an expression after comparing it to each search value.ETRIM trims the heading of trailing characters (or both) from a character string.FNVL compares two expressions and returns null if they are equal, or the first expression of they are not equal.GNULLIF compares twp expressions and returns null if they are equal, or the first expression if they are not equal.
考题
单选题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
It requires that at least one of the expressions in the list must have a NOT NULL value
考题
单选题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.255B
access-list 10 permit 172.29.16.0 0.0.1.255C
access-list 10 permit 172.29.16.0 0.0.3.255D
access-list 10 permit 172.29.16.0 0.0.15.255E
access-list 10 permit 172.29.0.0 0.0.255.255
考题
单选题Which statement regarding the contents of the V$PARAMETER view is true？（）A
displays only the list of default valuesB
displays only the list of all basic parametersC
displays the currently in effect parameter valuesD
displays only the list of all advanced parametersE
displays the list of all the parameter files of a database
考题
单选题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.
考题
多选题Which two are true about aggregate functions? （）AYou can use aggregate functions in any clause of a SELECT statement.BYou can use aggregate functions only in the column list of the SELECT clause and in the WHERE clause of a SELECT statement.CYou can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.DYou can pass column names, expressions, constants, or functions as parameters to an aggregate function.EYou can use aggregate functions on a table, only by grouping the whole table as one single group.FYou cannot group the rows of a table by more than one column while using aggregate functions.
考题
单选题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 backupB
It will display a list of files that need backup after five daysC
It will display a list of files that were backed up in the last five daysD
It will display a list of files that have not been backed up in the last five daysE
It will apply the current retention policy to determine the files that need to be backed up
考题
单选题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
考题
单选题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 valuesB
Displays only the list of all basic parametersC
Displays the currently in effect parameter valuesD
Displays only the list of all advanced parametersE
Displays the list of all the parameter files of a databaseF
Displays the current contents of the server parameter file.
考题
单选题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
考题
多选题Which three statements are true regarding subqueries?（）ASubqueries can contain GROUP BY and ORDER BY clausesBMain query and subquery can get data from different tablesCMain query and subquery must get data from the same tablesDSubqueries can contain ORDER BY but not the GROUP BY clauseEOnly one column or expression can be compared between the main query and subqueryFMultiple columns or expressions can be compared between the main query and subquery
考题
单选题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
热门标签
最新试卷