0

databases Online Quiz - 202

Description: databases Online Quiz - 202
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Which of the following tool can be used to schedule work for DB2?

  1. Task Center

  2. Command Center

  3. Health Center

  4. Control Center


Correct Option: A

If you use the CREATE DATABASE statement on an existing database, all data in the datafiles will be lost

  1. True

  2. False


Correct Option: A

In Oracle, BLOBs have full transactional support

  1. True

  2. False


Correct Option: A

ALL scalar functions in Oracle return null when given a null argument.

  1. True

  2. False


Correct Option: B

Analytic functions compute an aggregate value based on a group of rows and return a single row for each group.

  1. True

  2. False


Correct Option: B
  1. Adjusting DAta BAse System

  2. Adaptable DAta BAse System

  3. Altering DAta BAse System

  4. Amending DAta BAse System


Correct Option: B
  1. Inverted List Model

  2. Relational Model

  3. Hierarchical Model

  4. Object Oriented Model


Correct Option: A

MPM is expanded as

  1. Multi Processing Mode

  2. Mega Processing Monitor

  3. Multi Processing Monitor

  4. Mega Processing Mode


Correct Option: A

Each record present in the ADABAS file is uniquely identified by :

  1. RABN

  2. ISN

  3. FIN

  4. MIN


Correct Option: B

When you want to locate a particular record in the adabas file and if you have value of the full key use :

  1. READ

  2. FIND

  3. GET

  4. PUT


Correct Option: B

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: A

A database trigger does not apply to data loaded before the definition of the trigger

  1. True

  2. False


Correct Option: A
- Hide questions