0

databases Online Quiz - 227

Description: databases Online Quiz - 227
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. Primary key access

  2. Access via unique index

  3. Table access by ROWID

  4. Full table scan


Correct Option: C

Which character function can be used to return a specified portion of a character string?

  1. INSTR

  2. SUBSTRING

  3. SUBSTR

  4. POS


Correct Option: C

AUTONOMUS_TRANSACTION is a

  1. Programming technique

  2. Automatically used in all prpgramme

  3. PL/SQL compiler directive

  4. All of the above


Correct Option: C
  1. queeing

  2. piping

  3. Autonomus transaction

  4. Host I/O


Correct Option: B

Which is true for ROWID% data type

  1. Binary data upto 4GB

  2. Character data upto 4 GB

  3. A hexadecimal string representing the unique address of a row in its table

  4. Binary data stored in an external file


Correct Option: C

What database object is used to increase performance for accessing data within a database?

  1. Roles

  2. Sequences

  3. Synonyms

  4. Index


Correct Option: D
  1. exec command

  2. / command

  3. execute command

  4. None of these


Correct Option: B

Where can NOT a subquery be used within a SQL statement that is in a PL/SQL block?

  1. WHERE

  2. FROM

  3. INSERT

  4. UPDATE


Correct Option: B

Which database model allows you to store and execute a PL/SQL program as part of an object?

  1. Hierarchical

  2. Relational

  3. Object Relational

  4. Network


Correct Option: C
- Hide questions