网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Which two are character manipulation functions? （）
- A、TRIM
- B、REPLACE
- C、TRUNC
- D、TO_DATE
- E、MOD
- F、CASE
参考答案
更多 “Which two are character manipulation functions? （）A、TRIMB、REPLACEC、TRUNCD、TO_DATEE、MODF、CASE” 相关考题
考题
Given two different character sets (A and B), which of the following must be true for A to be considered a strict superset of B?()
A. A must contain all of the characters defined in BB. A must be UnicodeC. The encoded values in A must match the encoded values in B for all characters defined in BD. A must be a multibyte character setE. The encoded values in A must match the encoded values in B for all numeric and alphabetic characters in B
考题
Which two statements are true regarding the default behavior of the ORDER BY clause? ()
A.Null values are left out of the sort.B.Character values are displayed from Z to AC.Date values are displayed with the earliest value first.D.Null values are displayed last for descending sequences.E.Numeric values are displayed with the lowest values first.
考题
Given two different character sets （A and B）， which of the following must be true for A to be considered a strict superset of B？（）A、 A must contain all of the characters defined in BB、 A must be UnicodeC、 The encoded values in A must match the encoded values in B for all characters defined in B D、 A must be a multibyte character setE、 The encoded values in A must match the encoded values in B for all numeric and alphabetic character
考题
Which two are character manipulation functions? （）A、TRIMB、REPLACEC、TRUNCD、TO_DATEE、MODF、CASE
考题
When a database administrator chooses the dimensions for an MDC table, which two characteristics should beconsidered?（）A、the query transaction rate B、numeric data versus character data C、extent size D、the cardinality of the candidate columns E、prefetch size
考题
In a design situation, there are multiple character sets that can properly encode your data. Which three should influence your choice of character set?（）A、Syntax when writing queries involving JOINSB、Memory usage when working with the dataC、Character set mapping index hash sizeD、Disk usage when storing data
考题
Which two tasks can you perform using only the TO_CHAR function? （）A、convert 10 to 'TEN'B、convert '10' to 10C、convert 10 to '10'D、convert 'TEN' to 10E、convert a date to a character expressionF、convert a character expression to a date
考题
Which two statements are true regarding the default behavior of the ORDER BY clause? （）A、Null values are left out of the sort.B、Character values are displayed from Z to AC、Date values are displayed with the earliest value first.D、Null values are displayed last for descending sequences.E、Numeric values are displayed with the lowest values first.
考题
Which component of the Oracle networking architecture provides character set and data type conversion between different character sets on the client and server？ （）A、SQL*PlusB、Oracle NetC、Two-Task Common （TTC）D、Oracle Protocol Support （OPS）
考题
Given two different character sets (A and B), which of the following must be true for A to be considered a strict superset of B?（）A、A must contain all of the characters defined in BB、A must be UnicodeC、The encoded values in A must match the encoded values in B for all characters defined in BD、A must be a multibyte character setE、The encoded values in A must match the encoded values in B for all numeric and alphabetic characters in B
考题
Which two tasks can your perform by using the TO_CHAR function? （）A、Convert 10 to 'TEN'B、Convert '10' to 10C、Convert '10' to '10'D、Convert 'TEN' to 10E、Convert a date to a character expressionF、Convert a character expression to a date
考题
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 or trailing characters (or both) from a character string.F、NVL compares two expressions and returns null if they are equal, or the first expression if they are not equal.G、NULLIF compares two expressions and returns null if they are equal, or the first expression if they are not equal.
考题
单选题Which of the following is NOT mentioned in the passage as a way to build character in children?A
Story readings and discussions.B
Osmosis.C
Taking every opportunity to teach character.D
Roleplay.
考题
多选题When a database administrator chooses the dimensions for an MDC table, which two characteristics should beconsidered?（）Athe query transaction rateBnumeric data versus character dataCextent sizeDthe cardinality of the candidate columnsEprefetch size
考题
多选题For which two actions can you use the TO_DATE function? （）Aconvert any date literal to a dateBconvert any numeric literal to a dateCconvert any date to a character literalDformat 'January 10 1999' for inputEformat '10-JAN-99' to 'January 10 1999'
考题
单选题Which of the following is NOT mentioned in the passage as a way to build character in children?A
Story readings and discussions.B
Osmosis.C
Taking every opportunity to teach character.D
Role play.
考题
多选题Given two different character sets （A and B）， which of the following must be true for A to be considered a strict superset of B？（）AA must contain all of the characters defined in BBA must be UnicodeCThe encoded values in A must match the encoded values in B for all characters defined in BDA must be a multibyte character setEThe encoded values in A must match the encoded values in B for all numeric and alphabetic character
考题
多选题Given two different character sets (A and B), which of the following must be true for A to be considered a strict superset of B?（）AA must contain all of the characters defined in BBA must be UnicodeCThe encoded values in A must match the encoded values in B for all characters defined in BDA must be a multibyte character setEThe encoded values in A must match the encoded values in B for all numeric and alphabetic characters in B
考题
多选题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 or trailing characters (or both) from a character string.FNVL compares two expressions and returns null if they are equal, or the first expression if they are not equal.GNULLIF compares two expressions and returns null if they are equal, or the first expression if they are not equal.
考题
多选题Which two tasks can you perform using only the TO_CHAR function? （）Aconvert 10 to 'TEN'Bconvert '10' to 10Cconvert 10 to '10'Dconvert 'TEN' to 10Econvert a date to a character expressionFconvert a character expression to a date
考题
多选题Which two tasks can your perform by using the TO_CHAR function? （）AConvert 10 to 'TEN'BConvert '10' to 10CConvert '10' to '10'DConvert 'TEN' to 10EConvert a date to a character expressionFConvert a character expression to a date
考题
单选题Which component of the Oracle networking architecture provides character set and data type conversion between different character sets on the client and server？ （）A
SQL*PlusB
Oracle NetC
Two-Task Common （TTC）D
Oracle Protocol Support （OPS）
考题
多选题Which two statements are true regarding working with dates?（）AThe default internal storage of dates is in the numeric formatBThe default internal storage of dates is in the character formatCThe RR date format automatically calculates the century from the SYSDATE function and does not allow the user to enter the centuryDThe RR date format automatically calculates the century from the SYSDATE function but allows the user to enter the century if required
考题
单选题Final exams were incredibly comprehensive, and went on for two weeks, which length made it seem as if they would never end.A
comprehensive, and went on for two weeks, which length madeB
comprehensive and since they went on for two weeks, that madeC
comprehensive and, since they went on for two weeks, to makeD
comprehensive and went on for two weeks, which madeE
comprehensive and, by going on for two weeks, it made
热门标签
最新试卷
