Syvum Home Page

Home > Quiz Games > Information Technology & Computer Programming > DBMS Training & SQL Tutorial >

DBMS Training & SQL Tutorial : Data Models


Answer the following multiple-choice questions about data models used in Database Management.

Formats Info Page/Theory Quiz Review
Multiple choice

Your Performance  

1.

If a column or a set of columns of Table A correspond to a primary key of another Table B, then these set of columns in Table A are known as a _______ key.

  primary

  reference

  foreign

  Half-n-half Clue
 

2.

Which structure is the hierarchical model based on?

  Tree

  Graph

  Linked List

  None of these

  Half-n-half Clue
 

3.

What is the minimum subset of the super key that can be used to uniquely identify an entity in an entity set known as?

  Candidate Key

  Foreign Key

  Unique Key

  None of these

  Half-n-half Clue
 

4.

In the Network data model, relationship between records is implemented using _______.

  keys

  pointers

  parent-child relationship

  None of these

  Half-n-half Clue
 

5.

As compared to the Relational & Network Model, searching for data is very easy in Hierarchical Model.

  True

  False

 

6.

Which of the following are true with respect to Network model?
a) Implementing relationship between records is very complex
b) It is very useful in representing many-to-many relationships
c) Searching for a particular record is very easy

  a,b

  b,c

  a,c

  a,b,c

  Half-n-half Clue
 

7.

For a database to be considered as full-fledged RDBMS, it has to comply with at least _______ out of the 12 Codd's rules.

  1

  6

  9

  10

  Half-n-half Clue
 


 
7 more pages in DBMS Training & SQL Tutorial


Contact Info © 1999-2020 Syvum Technologies Inc. Privacy Policy Disclaimer and Copyright
Previous
-
Next
-