Which two are character manipulation functions? （）A、TRIMB、REPLACEC、TRUNCD、TO_DATEE、MODF、CASE
Which two are character manipulation functions? （）
- A、TRIM
- B、REPLACE
- C、TRUNC
- D、TO_DATE
- E、MOD
- F、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
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?AStory readings and discussions.BOsmosis.CTaking every opportunity to teach character.DRoleplay.
多选题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?AStory readings and discussions.BOsmosis.CTaking every opportunity to teach character.DRole 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？ （）ASQL*PlusBOracle NetCTwo-Task Common （TTC）DOracle 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.Acomprehensive, and went on for two weeks, which length madeBcomprehensive and since they went on for two weeks, that madeCcomprehensive and, since they went on for two weeks, to makeDcomprehensive and went on for two weeks, which madeEcomprehensive and, by going on for two weeks, it made