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

Within a single SQL statement, Oracle will increment the sequence only twice for each row.

  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

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

The result of concatenating two character strings is always a VARCHAR2 character string.

  1. True

  2. False


Correct Option: B

You use comments in a SQL statement to pass hints to the Oracle optimizer

  1. True

  2. False


Correct Option: A

ADABAS is a powerful and a flexible database management system. It derives its name from :

  1. Adjusting DAta BAse System

  2. Adaptable DAta BAse System

  3. Altering DAta BAse System

  4. Amending DAta BAse System


Correct Option: B

ADABAS has built its architecture on :

  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

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

Declare fvar number := null; svar number := 5 Begin goto <<>> if fvar is null then <<>> svar := svar + 5 end if;end;

  1. Error

  2. 10

  3. 5

  4. None of the above


Correct Option: A
- Hide questions