Tag: databases

Questions Related to databases

Instead of Cursor what can be used to perform row by row operation there by increasing performance?
technology databases

  1. Corelated Subquery

  2. Index

  3. TOP()

  4. None

Show answer
Correct Option: A

How many clustered and non clustered indexex exists for single table
technology databases

  1. 1,10

  2. 10,10

  3. 1,249

  4. 249,1

Show answer
Correct Option: C

Which one of them is not an String Function?

technology databases

  1. SOUNDEX

  2. DIFFERENCE

  3. GROUPING

  4. SUBSTRING

Show answer
Correct Option: C

What is the function which is used to check whether the value is a numeric value or not?

technology databases

  1. Select isnumeric('Test Text')

  2. Select numeric('Test Text')

  3. Both of the above

  4. none of the above

Show answer
Correct Option: A

What operator performs pattern matching?
technology databases

  1. &

  2. LIKE

  3. %

  4. NONE

Show answer
Correct Option: B

Deterministic functions are?

technology databases

  1. Functions always return the same result any time they are called with a specific set of input values.

  2. Functions may return different results each time they are called with a specific set of input values

  3. None

  4. Both of Them

Show answer
Correct Option: A

SQL_VARIEANT datatype column can be any datatype except?
technology databases

  1. TEXT

  2. IMAGE

  3. FLOAT

  4. 1) and 2)

Show answer
Correct Option: D

What is the maximum number of columns per select statement allowed in SQL 2005?

technology databases

  1. 1024

  2. 4096

  3. 512

  4. 2048

Show answer
Correct Option: B

Can we insert data into a view?

technology databases

  1. True

  2. False

Show answer
Correct Option: A

Identify two factors that you consider for compiling a PL/SQL program unit for interpreted mode?

technology databases

  1. PL/SQL program needs to be recompiled frequently.

  2. /SQL program that spends most of the time executing SQL

  3. PL/SQL program , which performs computation-intensive procedural operations and is recompiled rarely

  4. PL/SQL program , which is called frequently with the same parameter values by multiple sessions and is recompiled rarely.

Show answer
Correct Option: A,B