网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
What is true of using group functions on columns that contain NULL values?（）
A
Group functions on columns ignore NULL values.
B
Group functions on columns returning dates include NULL values.
C
Group functions on columns returning numbers include NULL values.
D
Group functions on columns cannot be accurately used on columns that contain NULL values.
E
Group functions on columns include NULL values in calculations if you use the keyword INC_NULLS.
参考答案
参考解析
解析：
暂无解析
更多 “单选题What is true of using group functions on columns that contain NULL values?（）A Group functions on columns ignore NULL values.B Group functions on columns returning dates include NULL values.C Group functions on columns returning numbers include NULL values.D Group functions on columns cannot be accurately used on columns that contain NULL values.E Group functions on columns include NULL values in calculations if you use the keyword INC_NULLS.” 相关考题
考题
What is true about updates through a view? ()
A. You cannot update a view with group functions.B. When you update a view group functions are automatically computed.C. When you update a view only the constraints on the underlying table will be in effect.D. When you update a view the constraints on the views always override the constraints on the underlying tables.
考题
The EMPLOYEES table has these columns:Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement:What is true about your ALTER statement?()
A. Column definitions cannot be altered to add DEFAULT values.B. A change to the DEFAULT value affects only subsequent insertions to the table.C. Column definitions cannot be altered at add DEFAULT values for columns with a NUMBER data type.D. All the rows that have a NULL value for the SALARY column will be updated with the value 5000.
考题
Which two statements are true regarding the USING clause in table joins?（）A、It can be used to join a maximum of three tables B、It can be used to restrict the number of columns used in a NATURAL join C、It can be used to access data from tables through equijoins as well as nonequijoins D、It can be used to join tables that have columns with the same name and compatible data types
考题
What is true of using group functions on columns that contain NULL values?（）A、Group functions on columns ignore NULL values.B、Group functions on columns returning dates include NULL values.C、Group functions on columns returning numbers include NULL values.D、Group functions on columns cannot be accurately used on columns that contain NULL values.E、Group functions on columns include NULL values in calculations if you use the keyword INC_NULLS.
考题
A Cluster Administrator is implementing a custom resource group for a new web application. The goal is to ensure the resource group is always active. Preference should be given to the priority node at startup time，but fallback to the priority node should be scheduled during a nonbusy time. Using custom resource group options， what combination best achieve the desired resource group behavior？（） A、 Online On All Available Nodes，using a setting timerB、 Online On Home Node Only，using a fallback timerC、 Online On Home Node Only，using both setting and fallback timersD、 Online On First Available Node，using both settling and fallback timers
考题
What is the purpose of using VPN hardware acceleration equipment?（）A、To offload encryptions functions from router memoryB、To use WebVPN instead of IPSecC、To decrease performance and efficiencyD、To offload encryption functions from a router CPU
考题
What can be done to enable the debug information for functions to be displayed when using‘ksh -x’to debug a script？（）A、Run the script using ‘ksh -fx’.B、Run the script using ‘ksh -a function -x’.C、Edit the script and add ‘set -x’ at the beginning.D、Edit the script and add ‘set -x’ at the beginning of each function.
考题
Which two statements are true regarding the USING and ON clauses in table joins?（）A、Both USING and ON clauses can be used for equijoins and nonequijoins B、Amaximum of one pair of columns can be joined between two tables using the ON clause C、The ON clause can be used to join tables on columns that have different names but compatible data types D、The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause
考题
Which statement about recovering from the loss of a redo log group is true?（）A、If the lost redo log group is ACTIVE, you should first attempt to clear the log file.B、If the lost redo log group is CURRENT, you must clear the log file.C、If the lost redo log group is ACTIVE, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.D、If the lost redo log group is CURRENT, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.
考题
You need to recommend a solution for deploying and managing App2. What should you recommend？（） A、Publish App2 as a RemoteApp program.B、Deploy App2 by using a Group Policy logon script.C、Assign App2 by using Group Policy software distribution.D、Publish App2 by using Group Policy software distribution.
考题
You need to recommend a solution for managing administrative rights for the branch office client computers. The solution must meet the companys technical requirements.What should you recommend configuring？（）A、Account Policies by using GPOsB、Local Users and Groups by using Group Policy preferencesC、Restricted Groups by using GPOsD、Security Options by using Group Policy preferences
考题
单选题A Cluster Administrator is implementing a custom resource group for a new web application. The goal is to ensure the resource group is always active. Preference should be given to the priority node at startup time，but fallback to the priority node should be scheduled during a nonbusy time. Using custom resource group options， what combination best achieve the desired resource group behavior？（）A
Online On All Available Nodes，using a setting timerB
Online On Home Node Only，using a fallback timerC
Online On Home Node Only，using both setting and fallback timersD
Online On First Available Node，using both settling and fallback timers
考题
单选题Your developers have created table to store some of their program's data. After examining the slow Query Log, you see that they are using the LIKE operator and SUBSTER （ ） functions against a VARCHAR (10000) column quite often. An example of the start of one row of data: 'GREEN01020495888331993-12-10/2…' What should you do to improve the overall performance?（）A
Convert the column to TEXT and add a fulltext index to the tableB
Create multiple prefix indexes of differing lengthsC
Convert their column to BINARYD
Redesign the table so that the most commonly searched for string patterns are in their own columns
考题
单选题Using the report wizard you create a tabular report to display all the columns in the EMP table. The records are ordered by the deptname and job columns. You need to create a hierarchical report that breaks on the deptname and job values. Using the data model how would you create this break structure?（）A
Specify the break order on the gemp group Property palette. B
Specify a break order on the dept_name and job columns property palettes. C
Click and drag the dept_name and jobs column out and above of the gemp group to create a new parent group. D
Change the position of the dept_name and the job columns within the gemp group.
考题
单选题You need to recommend a deployment strategy for App1. What should you recommend？（）A
Assign App1 to users by using a Group Policy.B
Publish App1 to users by using a Group Policy.C
Deploy App1 as a RemoteApp program by using an MSI file.D
Deploy App1 as a RemoteApp program by using an RDP file.
考题
多选题Which two statements are true regarding the USING and ON clauses in table joins?（）ABoth USING and ON clauses can be used for equijoins and nonequijoinsBAmaximum of one pair of columns can be joined between two tables using the ON clauseCThe ON clause can be used to join tables on columns that have different names but compatible data typesDThe WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause
考题
多选题Which two statements are true regarding the USING clause in table joins?（）AIt can be used to join a maximum of three tablesBIt can be used to restrict the number of columns used in a NATURAL joinCIt can be used to access data from tables through equijoins as well as nonequijoinsDIt can be used to join tables that have columns with the same name and compatible data types
考题
单选题which one of the following should maria do to display the release date in a text column?（）A
used the number and time format options B
used the @date to text functions to convert time to text C
concatenated the date types using mathematical operators D
used the @text functions to convert time and number data to text in text columns
考题
多选题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 parameter 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.
考题
单选题What is the purpose of using VPN hardware acceleration equipment?（）A
To offload encryptions functions from router memoryB
To use WebVPN instead of IPSecC
To decrease performance and efficiencyD
To offload encryption functions from a router CPU
考题
单选题What is true about updates through a view? （）A
You cannot update a view with group functions.B
When you update a view group functions are automatically computed.C
When you update a view only the constraints on the underlying table will be in effect.D
When you update a view the constraints on the views always override the constraints on the underlying tables.
考题
多选题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
考题
单选题What is true of using group functions on columns that contain NULL values?（）A
Group functions on columns ignore NULL values.B
Group functions on columns returning dates include NULL values.C
Group functions on columns returning numbers include NULL values.D
Group functions on columns cannot be accurately used on columns that contain NULL values.E
Group functions on columns include NULL values in calculations if you use the keyword INC_NULLS.
热门标签
最新试卷
