Tag: databases

Questions Related to databases

Is the database and DBMS software together is called as Database system?

technology databases

  1. True

  2. False

Show answer
Correct Option: A

which of the following are the advantages of DBMS? (Select 2)

technology databases

  1. Redundancy is controlled

  2. graphical and statistical capabilities

  3. proprietary formats may limit arichival quality of data

  4. Providing multiple user interfaces

Show answer
Correct Option: A,D

Is any modification in logical level should not affect the view level?
technology databases

  1. True

  2. False

Show answer
Correct Option: B

select the valid Definition Languages in DBMS:
technology databases

  1. Data Definition Language

  2. View Definition Language

  3. Query Definition Language

  4. Storage Definition Language

Show answer
Correct Option: A,B,D

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

  1. True

  2. False

Show answer
Correct Option: B

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

  1. Unique constraints

  2. Primary keys

  3. Cascading actions

  4. Foreign keys

Show answer
Correct Option: A

When is the authorization check on DB2 objects done?
technology databases

  1. at BIND time

  2. at RUN time

  3. at Execution time

  4. at End time

Show answer
Correct Option: B

What is a synonym?
technology databases

  1. A View of a table

  2. an alternate name for a table

  3. A Secondary table

  4. A Primary table

Show answer
Correct Option: A,B

What is index cardinality?
technology databases

  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

Show answer
Correct Option: A,B

What is filter factor?
technology databases

  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.

Show answer
Correct Option: A