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

相似考题

1.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

2.By default, which character indicates the UNIX shell prompt?()A. #B. >C. $D. %

3.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

4.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 two are character manipula”相关问题

第1题：

By default, which character indicates the UNIX shell prompt?（）
- A、#
- B、>
- C、$
- D、%
正确答案:D
第2题：

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
正确答案:C,D
第3题：

Which two tasks can you perform using only the TO_CHAR function? （）
- A、convert 10 to 'TEN'
- B、convert '10' to 10
- C、convert 10 to '10'
- D、convert 'TEN' to 10
- E、convert a date to a character expression
- F、convert a character expression to a date
正确答案:C,E
第4题：

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*Plus
- B、Oracle Net
- C、Two-Task Common （TTC）
- D、Oracle Protocol Support （OPS）
正确答案:C
第5题：

Which two tasks can your perform by using the TO_CHAR function? （）
- A、Convert 10 to 'TEN'
- B、Convert '10' to 10
- C、Convert '10' to '10'
- D、Convert 'TEN' to 10
- E、Convert a date to a character expression
- F、Convert a character expression to a date
正确答案:C,E
第6题：

单选题
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.

正确答案： D
解析：
细节理解题。此题问的是塑造孩子性格的过程中所采取的方式不包括哪一项。浏览全文可以看出，只有A项“故事阅读和讨论没有提到”文中没有提到。所以选择A项。文中第二段提到“Of course there will always be learning by osmosis”，与B项相符。文中第四段开头提到“Our role as educators is also to look for opportunities to help…”，与C项相符。文中第三段提到“Allowing children to role play a situation”，与D项相符。
第7题：

多选题
For which two actions can you use the TO_DATE function? （）
A
convert any date literal to a date
B
convert any numeric literal to a date
C
convert any date to a character literal
D
format 'January 10 1999' for input
E
format '10-JAN-99' to 'January 10 1999'

正确答案： A,D
解析：暂无解析
第8题：

多选题
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 B
B
A must be Unicode
C
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 set
E
The encoded values in A must match the encoded values in B for all numeric and alphabetic character

正确答案： A,B
解析：暂无解析
第9题：

多选题
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.

正确答案： B,A
解析：暂无解析
第10题：

多选题
Which two tasks can your perform by using the TO_CHAR function? （）
A
Convert 10 to 'TEN'
B
Convert '10' to 10
C
Convert '10' to '10'
D
Convert 'TEN' to 10
E
Convert a date to a character expression
F
Convert a character expression to a date

正确答案： B,A
解析：暂无解析
第11题：

单选题
By default, which character indicates the UNIX shell prompt?（）
A
#
B
>
C
$
D
%

正确答案： D
解析：暂无解析
第12题：

多选题
Which two are character manipulation functions? （）
A
TRIM
B
REPLACE
C
TRUNC
D
TO_DATE
E
MOD
F
CASE

正确答案： F,A
解析：暂无解析
第13题：

Which two are character manipulation functions? （）
- A、TRIM
- B、REPLACE
- C、TRUNC
- D、TO_DATE
- E、MOD
- F、CASE
正确答案:A,B
第14题：

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 JOINS
- B、Memory usage when working with the data
- C、Character set mapping index hash size
- D、Disk usage when storing data
正确答案:B,C,D
第15题：

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 A
- C、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.
正确答案:C,E
第16题：

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 B
- B、A must be Unicode
- C、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 set
- E、The encoded values in A must match the encoded values in B for all numeric and alphabetic characters in B
正确答案:A,C
第17题：

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.
正确答案:A,D,E,G
第18题：

多选题
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

正确答案： C,D
解析：暂无解析
第19题：

单选题
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.

正确答案： A
解析：
第20题：

多选题
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 B
B
A must be Unicode
C
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 set
E
The encoded values in A must match the encoded values in B for all numeric and alphabetic characters in B

正确答案： E,C
解析：暂无解析
第21题：

多选题
Which two tasks can you perform using only the TO_CHAR function? （）
A
convert 10 to 'TEN'
B
convert '10' to 10
C
convert 10 to '10'
D
convert 'TEN' to 10
E
convert a date to a character expression
F
convert a character expression to a date

正确答案： E,C
解析：暂无解析
第22题：

单选题
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*Plus
B
Oracle Net
C
Two-Task Common （TTC）
D
Oracle Protocol Support （OPS）

正确答案： D
解析：暂无解析
第23题：

多选题
Which two statements are true regarding working with dates?（）
A
The default internal storage of dates is in the numeric format
B
The default internal storage of dates is in the character format
C
The RR date format automatically calculates the century from the SYSDATE function and does not allow the user to enter the century
D
The RR date format automatically calculates the century from the SYSDATE function but allows the user to enter the century if required

正确答案： C,D
解析：暂无解析
第24题：

单选题
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 made
B
comprehensive and since they went on for two weeks, that made
C
comprehensive and, since they went on for two weeks, to make
D
comprehensive and went on for two weeks, which made
E
comprehensive and, by going on for two weeks, it made

正确答案： B
解析：
原句中“which”的使用不正确。D项表意最清晰。E项中的“it”指代模糊。C项语法上不正确。

niusouti.com

Which two are character manipulation functions? （）A、TRIMB、REPLACEC、TRUNCD、TO_DATEE、MODF、CASE

题目

相似考题

更多“Which two are character manipula”相关问题

相关内容