0

databases Online Quiz - 215

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

select the valid Definition Languages in DBMS:

  1. Data Definition Language

  2. View Definition Language

  3. Query Definition Language

  4. Storage Definition Language


Correct Option: A,B,D

Low-level instruction generated by compiler are executed by DDL Interpreter.(True/False)

  1. True

  2. False


Correct Option: B

Which one of the following does not help to maintain referential integrity?

  1. Unique constraints

  2. Primary keys

  3. Cascading actions

  4. Foreign keys


Correct Option: A

When is the authorization check on DB2 objects done?

  1. at BIND time

  2. at RUN time

  3. at Execution time

  4. at End time


Correct Option: B

What is a synonym?

  1. A View of a table

  2. an alternate name for a table

  3. A Secondary table

  4. A Primary table


Correct Option: A,B

What is index cardinality?

  1. Number of distinct values a column contain

  2. Number of distinct values a column or columns contain

  3. Number of distinct values a row contain

  4. Number of distinct values a row or rows contain


Correct Option: A,B

What is filter factor?

  1. One divided by the number of distinct values of a column.

  2. Zero divided by the number of distinct values of a column.

  3. Zero divided by the number of distinct values of a row.

  4. One divided by the number of distinct values of a Rrow.


Correct Option: A

What is referential integrity?

  1. The relation of the primary key of a base table with foreign key of the reference table is known as referential integriety.

  2. The relation of the secondary key of a base table with foreign key of the reference table is known as referential integriety.

  3. The relation of the primary key of a secondary table with foreign key of the reference table is known as referential integriety.

  4. The relation of the primary key of a base table with index key of the reference table is known as referential integriety.


Correct Option: A

What is FREEPAGE and PCTFREE in TABLESPACE creation?

  1. PCTFREE: percentage of each page to be left free and FREEPAGE: Number of pages to be loaded with data between each free page.

  2. PCTFREE: percentage of each page to be loaded with data and FREEPAGE: Number of pages to be loaded with data between each free page.

  3. PCTFREE: percentage of each page to be left free and FREEPAGE: Number of pages to be left free with data between each loaded page.

  4. PCTFREE: percentage of each page to be loaded with data between each free page and FREEPAGE: Number of pages to be left free.


Correct Option: A

What are the 4 environments which can access DB2?

  1. TSO and CICS

  2. IMS and BATCH

  3. TSO, CICS, IMS and DB2

  4. TSO, CICS, IMS and VSAM


Correct Option: A,B

When will you chose to run RUNSTATS?

  1. After a load

  2. After mass updates

  3. After a deletes

  4. After a inserts


Correct Option: A,B,C,D

Each PL/SQL block can have its own exception section

  1. True

  2. False


Correct Option: A

PL/SQL Exception message consists of

  1. Type of Exception

  2. Finally block

  3. An Error Code

  4. A message


Correct Option: A,C,D

Types of PL/SQL exceptions are

  1. Named System Exceptions

  2. Unnamed System Exceptions

  3. Implicit Exceptions

  4. Explicit Exceptions

  5. User-defined Exceptions


Correct Option: A,B,E

Named system exceptions are:

  1. Not Declared explicitly

  2. Raised implicitly when a predefined Oracle error occurs

  3. caught by referencing the standard name within an exception-handling routine

  4. All of the above

  5. None of the above


Correct Option: D

To handle the exception explicity, they must be declared using Pragma EXCEPTION_INIT

  1. True

  2. False


Correct Option: A

When you declare your own exception, you must ____ it explicitly

  1. DECLARE

  2. RAISE

  3. PRAGMA

  4. INITIATE


Correct Option: B
  1. Hardware failures

  2. Design faults

  3. Coding mistakes

  4. None of the above

  5. All of the above


Correct Option: E
  1. internal, explicitly

  2. internal, implicitly

  3. user-defined, explicitly

  4. user-defined, implicitly


Correct Option: B
- Hide questions