Tag: databases

Questions Related to databases

  1. concat

  2. initcap

  3. round

  4. length


Correct Option: C
Explanation:

To answer this question, the user needs to know what string functions are and be familiar with some commonly used string functions.

String functions are functions that operate on a string and return a modified string or information about the string. Some examples of string functions include substring, upper/lower case, length, concat, and trim.

Now, let's go through each option and determine which one is not a string function:

A. concat: This is a string function that concatenates two or more strings together.

B. initcap: This is a string function that capitalizes the first letter of each word in a string.

C. round: This is not a string function. It is a mathematical function that rounds a number to a specified number of decimal places.

D. length: This is a string function that returns the length of a string.

Therefore, the answer is:

The Answer is: C

  1. selects all the rows from the table having the column_xyz value starting with the word oracle

  2. selects all the rows from the table having the column_xyz value ending with the word oracle

  3. selects all the rows from the table having the column_xyz value containing the word oracle

  4. selects all the rows from the table having the column_xyz value not containing the word oracle


Correct Option: C
  1. abs(-123.456)

  2. trunc(123.456,2)

  3. round(123.456,2)

  4. avg(1,2,3,4,5)


Correct Option: C
  1. '14-mar-2002'

  2. '13-mar-2001'

  3. '20-mar-2001'

  4. '14-apr-2001'


Correct Option: C
  1. removes the time component from a date_time value

  2. removes the date component from a date_time value

  3. removes the day component from a date_time value

  4. removes the year component from a date_time value


Correct Option: A
  1. to_date(string,format)

  2. to_char(date,format)

  3. to_date(date,format)

  4. to_number(string,format)


Correct Option: B
  1. % processor time >80

  2. % processor time <80

  3. Processor queue length>2

  4. Batch request/sec

  5. sql compilation./sec

  6. sql recompilation/sec


Correct Option: B,D,E,F
  1. network

  2. relational

  3. hierarchical

  4. object-oriented


Correct Option: C