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.

SYSTEM2000 is an example of _______ database.

  relational

  network

  hierarchical

  object - oriented

  Half-n-half Clue
 

2.

The candidate keys that are not selected as the Primary key are known as _______.

  alternate keys

  super key

  foreign key

  secondary key

  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.

In the Relational Model, the number of columns 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

  divisible

  indivisible

  distinct

  Half-n-half Clue
 

6.

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

  foreign

  reference

  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
-