Tag: databases

Questions Related to databases

Limitation for level of nesting in a PL/SQL program
technology databases

  1. 10

  2. 32

  3. 23

  4. No limitations

Show answer
Correct Option: B

Limitation for level of blocks in a PL/SQL program
technology databases

  1. 125

  2. No limitation

  3. 255

  4. 55

Show answer
Correct Option: C

Does PL/SQL supports executing operating system commands?
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which command is used to write information to an output buffer?
technology databases

  1. SET OUTPUT ON

  2. SET BUFFEROUTPUT ON

  3. SET SERVEROUTPUT ON

  4. SET SCREEN ON

Show answer
Correct Option: C

Command used to import the data from flat files?
technology databases

  1. imp

  2. sqlloader

  3. sqlldr

  4. exp

Show answer
Correct Option: C

Whether SQL has unloader facility to unload the data?

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Can SQL loader handle EBCDIC data?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

SQL loader can load images, sound clips and documents

technology databases

  1. True

  2. False

Show answer
Correct Option: A

Which are the commands used to improve the performance of loader
technology databases

  1. direct=true

  2. command

  3. indexes

  4. constraints

  5. running multiple load jobs

  6. fast=true

Show answer
Correct Option: A,C,D,E

Which are all true in loading multi-line records?
technology databases

  1. Specifying carriage return statement in control file

  2. Position based loading

  3. Sperators as comments in the source file

  4. Carriage return

Show answer
Correct Option: A,B,D