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.

Which structure is the hierarchical model based on?

  Tree

  Graph

  Linked List

  None of these

  Half-n-half Clue
 

2.

In the hierarchical database, the _______ can be located using the hashing function.

  child nodes

  primary key

  root

  None of these

  Half-n-half Clue
 

3.

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
 

4.

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
 

5.

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.

  reference

  foreign

  primary

  Half-n-half Clue
 

6.

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

  True

  False

 

7.

What is the set of attributes that collectively identify an entity in an entity set known as?

  Super Key

  Foreign Key

  Unique Key

  None of these

  Half-n-half Clue
 


 
7 more pages in DBMS Training & SQL Tutorial


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