Tag: technology

Questions Related to technology

Which of the following SQL functions can operate on any datatype?

  1. to_char

  2. max

  3. cube

  4. rollup


Correct Option: B
Explanation:

To answer this question, the user needs to have knowledge of SQL functions.

A. to_char: This function is used to convert a number or date to a string. It cannot operate on any datatype.

B. max: This function returns the maximum value in a set of values. It can operate on any datatype.

C. cube: This function is used to generate a result set that represents the subtotals and grand totals of the selected columns. It cannot operate on any datatype.

D. rollup: This function is used to generate a result set that represents the subtotals of the selected columns. It cannot operate on any datatype.

Therefore, the correct answer is:

The Answer is: B. max

  1. Primary key access

  2. Full table scan

  3. Access via unique index

  4. Table access by ROWID


Correct Option: D
  1. -128 to 127

  2. (-2 power 8 )-1 to 2 power 8

  3. -255 to 256

  4. depends on the particular implementation of the Java Virtual machine


Correct Option: A

What is the default behaviour of OUT parameter mode in PL/SQL

  1. By value

  2. By reference

  3. By type

  4. none of the above


Correct Option: A
  1. Real abstarct clusters

  2. Real application cursors

  3. Real application clusters

  4. none of the above


Correct Option: C