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

Which Oracle access method is the fastest way for Oracle to retrieve a single row?

  1. Primary key access

  2. Access via unique index

  3. Table access by ROWID

  4. Full table scan


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

What is the command used to encrypt a PL/SQL application

  1. ENCRYPT

  2. DECRYPT

  3. WRAP

  4. UNWRAP


Correct Option: C

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 can be used in a SELECT statement to obtain search criteria for the SELECT statement?

  1. HAVING clause

  2. ORDER BY clause

  3. Subquery

  4. GROUP BY clause


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

Which datatypes are alphanumeric?

  1. Number

  2. Blob

  3. Char

  4. Raw


Correct Option: C
  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

What tasks are you able to perform within a PL/SQL block?

  1. DELETE

  2. CREATE

  3. UPDATE

  4. ALTER


Correct Option: A,C

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