多选题Which four are types of functions available in SQL? ()AstringBcharacterCintegerDcalendarEnumericFtranslationGdateHconversion
多选题
Which four are types of functions available in SQL? ()
A
string
B
character
C
integer
D
calendar
E
numeric
F
translation
G
date
H
conversion
参考解析
解析:
暂无解析
相关考题:
Which four are valid Oracle constraint types? () A. CASCADEB. UNIQUEC. NONUNIQUED. CHECKE. PRIMARY KEYF. CONSTANTG. NOT NULL
Which four are types of functions available in SQL? ()A、stringB、characterC、integerD、calendarE、numericF、translationG、dateH、conversion
Which four are attributes of single row functions? ()A、cannot be nestedB、manipulate data itemsC、act on each row returnedD、return one result per rowE、accept only one argument and return only one valueF、accept arguments which can be a column or an expression
Which two statistical data types are available on the statistics page of the WebUI? ()(Choose two.)A、cache statisticsB、client browser typeC、server response timeD、HTTP response codes
When a valid SQL Query in a DB Read step returns 0 rows, which branch of the step will be executed? ()A、Timeout B、SQL Error C、Successful D、Connection Not Available
Which of the following connector types is commonly identified by two rows of pins with four in onerow and five in the other?()A、DB-9B、RJ-45C、SCD、BNC
Which of the following broadband types can provide the MOST available bandwidth?()A、DSLB、FiberC、SatelliteD、Cable
Which four types of objects can be thrown using the throw statement?()A、 ErrorB、 EventC、 ObjectD、 ExceptionE、 ThrowableF、 RuntimeException
Which four types of object can be thrown using the throw statement?()A、 ErrorB、 EventC、 ObjectD、 ExceptionE、 ThrowableF、 Runtime Exception
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 is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?()A、 SQL statements that are part of the AWR baseline onlyB、 SQL statements based on the AWR top SQL identificationC、 SQL statements that are part of the available SQL Tuning Set (STS) onlyD、 SQL statements that are available in the cursor cache and executed by a user other than SYS
You want to make use of the object features available in the database for the form module you are developing. Which three statements about object types are true? ()A、An object type is a user-defined composite data type. B、The attributes of an object type can be those of other object types. C、A PL/SQL table of records is an example of a nested object type. D、An object type must be declared as a type before the actual object itself can be declared.
Which of the following describes an aspect of the SVC for XIV offering?()A、SVC software that comes integrated in an XIV system B、SVC option that includes all functions of SVC at a 'per TB' charge C、SVC option that introduces a 'per enclosure' charge metric for all functions of SVC D、separate license available for XIV/SVC customers who need FlashCopy and Metro Mirror/Global Mirror functions
多选题Which four are valid Oracle constraint types? ()ACASCADEBUNIQUECNONUNIQUEDCHECKEPRIMARY KEYFCONSTANTGNOT NULL
多选题Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems?()AADR diagnostic filesBall the optimizer statisticsCinitialization parameter settingsDPL/SQL functions,procedures,and packagesEthe table and index definitions and actual data
单选题Which of the following Internet connection types would have the MOST available bandwidth andhighest transmission speed?()ADSLBDial-upCCableDSatellite
多选题Which three functions are performed by the SQL Tuning Advisor?()ABuilding and implementing SQL profilesBRecommending the optimization of materialized viewsCChecking query objects for missing and stale statisticsDRecommending bitmap, function-based, and B-tree indexesERecommending the restructuring of SQL queries that are using bad plans
单选题Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? ()ASQL statements that are part of the AWR baseline only BSQL statements based on the AWR top SQL identificationCSQL statements that are part of the available SQL Tuning Set (STS) only DSQL statements that are available in the cursor cache and executed by a user other than SYS
多选题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 four types of object can be thrown using the throw statement?()AErrorBEventCObjectDExceptionEThrowableFRuntime Exception
单选题Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?()A SQL statements that are part of the AWR baseline onlyB SQL statements based on the AWR top SQL identificationC SQL statements that are part of the available SQL Tuning Set (STS) onlyD SQL statements that are available in the cursor cache and executed by a user other than SYS
多选题Which three functions are performed by the SQL Tuning Advisor?()ABuilding the SQL profileBRecommending optimization of materialized viewsCChecking query objects for missing and stale statisticsDRecommending bitmap, function-based, and B-tree indexesERecommending restructuring SQL queries that are using bad plans
多选题You want to make use of the object features available in the database for the form module you are developing. Which three statements about object types are true? ()AAn object type is a user-defined composite data type.BThe attributes of an object type can be those of other object types.CA PL/SQL table of records is an example of a nested object type.DAn object type must be declared as a type before the actual object itself can be declared.
多选题Which four are attributes of single row functions? ()Acannot be nestedBmanipulate data itemsCact on each row returnedDreturn one result per rowEaccept only one argument and return only one valueFaccept arguments which can be a column or an expression
多选题Which four types of objects can be thrown using the throw statement?()AErrorBEventCObjectDExceptionEThrowableFRuntimeException
单选题Which of the following connector types is commonly identified by two rows of pins with four in onerow and five in the other?()ADB-9BRJ-45CSCDBNC