DB Data Modeling Mcqs

Our collections of Multiple choice questions and answers focuses on study of Data Modeling . These questions are chosen from a collection of most authoritative and best reference books on DBMS. Our aim is to prepare an individual for competitive exams like NTS | GAT | ECAT | Data Warehouse jobs | Data Mining | DB administration jobs | Nadra Jobs | Software House and Data Base and Web Developer jobs | University and College entrance exams and various tests and job interviews. One should practice our Mcqs to assimilate Data Modeling comprehensively.

  1. Home
  2. »
  3. Computer Science Mcqs
  4. »
  5. DBMS Mcqs
  6. »
  7. Data Modeling Mcqs

Computer MCQS

Sciences MCQS

1.
Type of diagram in which operations are specified on objects is considered as

Functional diagrams

Class diagrams

Attribute diagrams

Entity diagrams

Answer Discus (0)

2.
Considering binary relationships, possible cardinality ratios are

One : one

1 : N

M : N

All of above

Answer Discus (0)

3.
Attributes that can be arranged into hierarchy are called

Composite attributes

Atomic attributes

Derived attributes

Simple attributes

Answer Discus (0)

4.
Set of all entities having same attributes is classified as

Entity type

Attribute type

Function type

Hierarchy type

Answer Discus (0)

5.
Set of values which specifies which values are to be assigned to individual entities is considered as

Domain of values

Composition of values

Attribution of values

Derivation of values

Answer Discus (0)

6.
Type of attributes that can be divided into smaller parts is classified as

Multivalve attributes

Single valued attributes

Composite attributes

Atomic attributes

Answer Discus (0)

7.
Particular database and set of related programs which helps in implementation of updates and queries is called

Implemented applications

Backup applications

Utility programs

Database application

Answer Discus (0)

8.
Detailed description on entity constraints, entity relationships and entity types is expressed in

Low level schema design

Physical design

Conceptual design

Logical design

Answer Discus (0)

9.
Types of partial constraints are

Total and partial

Intensive and extensive

Minimum and maximum

Floating and string

Answer Discus (0)

10.
Attributes which have only one value for a specific entity are called

Multi-valued attributes

Single valued attributes

Atomic attributes

Diatomic attributes

Answer Discus (0)

11.
Phase in data designing in which access paths and database indexes are specified is classified as

Structural design

Physical design of database

Data model mapping

Logical design

Answer Discus (0)

12.
In programming languages, available data types are

Integer

String

Float and Boolean

All of above

Answer Discus (0)

13.
Kind of constraint which cannot let two entities to have similar values is classified as

Derived constraints

Composite value constraint

Uniqueness constraint

Multi valued constraint

Answer Discus (0)

14.
Data model in which relationships are explained in terms of attributes is classified as

Functional data models

Binary data models

Ternary data models

Extension data model

Answer Discus (0)

15.
First step in designing high level conceptual data model is

Logical design analysis

Conceptual design analysis

Functional requirement analysis

Requirement analysis

Answer Discus (0)

Engineering MCQS

General Subjects MCQS

error: You are not allowed to do so.....
0Shares
0
Scroll to Top