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.

  foreign

  primary

  reference

  Half-n-half Clue
 

2.

SYSTEM2000 is an example of _______ database.

  hierarchical

  network

  object - oriented

  relational

  Half-n-half Clue
 

3.

In the hierarchical model the relationship between records is expressed as _______.

  unique key for each record

  pointers or links

  parent-child

  Half-n-half Clue
 

4.

In the Relational Model, the number of rows in a table is termed as _______.

  cardinality

  degree

  domain

  None of these

  Half-n-half Clue
 

5.

The domain in the relational model is said to be atomic if the elements of the domain consist of _______ units.

  redundant

  indivisible

  divisible

  distinct

  Half-n-half Clue
 

6.

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.

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
 


 
7 more pages in DBMS Training & SQL Tutorial


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