Computer Database Design Process Test Online

Mustansar KhanLast Updated: October 15, 2025

Important Database Design Process Question and Answer

Total Questions:	50
Time Allowed:	25 Minutes
Total Marks:	50
How to Attempt Test:	Please choose the right Option in MCQ-type question.
Test Helpful For:	ECAT Entry Test Computer Online Test Interview Questions about Computer All Universities Entrance Test Recruitments Tests

Database Design Process Practice Test Online With Explanation

Please wait...

Page 1 of 2

Uncategorized

1. Which type of database model uses hierarchical relationships?

Network model

Object-oriented model

Relational model

Hierarchical model

2. Which of the following design issues should be avoided in a good database?

High redundancy

Well-structured tables

Proper indexing

Clear primary keys

3. What is a many-to-many relationship?

All records are duplicates

One record relates to multiple, and vice versa

One record relates to one only

Data is encrypted

4. What is the goal of normalization in database design?

To reduce database size

To create views

To increase redundancy

To eliminate data duplication

5. Which one is not a rule of normalization?

Eliminate transitive dependencies

Remove repeating groups

Eliminate duplicate columns

Keep all foreign keys as primary

6. Which of the following terms describes the process of defining access controls?

Authorization

Normalization

Data modeling

Query optimization

7. Which of the following converts the ER model into relational form?

Conceptual modeling

Data mining

Logical design

Database normalization

8. Which step comes after logical design?

Conceptual design

Physical design

Requirements gathering

Report generation

9. Which of the following is the first step in the database design process?

Normalization

Indexing

Requirements analysis

Creating tables

10. Which relationship degree involves three entities?

Binary

Unary

Ternary

Primary

11. Which of the following terms means "an attribute that uniquely identifies an entity"?

Primary key

Super key

Foreign key

Domain

12. In a one-to-many relationship, where is the foreign key placed?

In the child table

In both tables

In the parent table

In neither table

13. Which of the following is not a database design activity?

Conceptual modeling

Normalization

Schema creation

UI/UX design

14. Which of the following ensures uniqueness of each record in a table?

Composite key

Index

Primary key

Foreign key

15. Which term refers to all possible values an attribute can take?

Relationship

Table

Domain

Entity

16. Which is used to uniquely identify a weak entity?

Unique key

Partial key

Surrogate key

Primary key

17. Which of the following is not a benefit of good database design?

Reduced anomalies

Data consistency

Higher storage cost due to duplication

Faster access

18. Which tool is commonly used in database design to model relationships?

MS Word

Notepad

PowerPoint

ER Diagram

19. Which of the following best defines a surrogate key?

A composite key

A system-generated unique key

An alternate candidate key

A user-chosen key

20. What is the purpose of conceptual design in databases?

To create reports

To write SQL queries

To design the high-level structure of the database

To sort the records

21. What does data integrity ensure?

System speed

Accuracy and consistency of data

Data backup

Hardware compatibility

22. Which of the following can lead to update anomalies?

Normalized data

Foreign key constraints

Redundant data

Proper indexing

23. In which phase is data volume estimation considered?

Logical

Physical

Implementation

Conceptual

24. Which key can contain extra attributes but still uniquely identifies a record?

Foreign key

Super key

Alternate key

Candidate key

25. What is a candidate key?

A duplicate key

One of the possible choices for primary key

A key used only for foreign relationships

A key that can never be used

Page 2 of 2

26. What is a composite attribute?

An attribute made of multiple sub-parts

An attribute that links multiple databases

An attribute that stores numbers only

An attribute with a default value

27. Which phase involves testing the database design with sample data?

Physical implementation

Logical design

Prototyping

Conceptual design

28. Which design step involves mapping entities to tables?

Front-end design

Requirements gathering

Physical design

Logical design

29. Which of the following is a key advantage of normalization?

Better data integrity

Increased redundancy

Complicated queries

Slower performance

30. In ER diagrams, what do diamonds represent?

Relationships

Fields

Tables

Attributes

31. In database design, what is an entity?

A SQL query

A storage device

A real-world object or concept

A database administrator

32. Which of the following represents a multi-valued attribute in an ERD?

Dashed line

Double oval

Triangle

Rectangle

33. What is the main purpose of indexing in physical design?

Improve query performance

Delete duplicates

Reduce memory

Backup data

34. What does cardinality refer to in database design?

The number of attributes

The number of entities in a relationship

The size of the database

The number of columns

35. Which type of relationship does not require a foreign key?

None

Many-to-one

Unary

One-to-many

36. Which design phase involves choosing data types for each attribute?

Physical

Planning

Logical

Conceptual

37. What is the final outcome of the database design process?

A logical schema

A software application

A fully working database system

A conceptual model

38. In ER diagrams, what symbol represents an entity?

Oval

Triangle

Rectangle

Diamond

39. What is included in the physical design phase?

User permission settings

Table creation only

Hardware specifications and indexing

Writing procedures

40. What is a derived attribute?

A primary key

An attribute copied from another table

An attribute dependent on calculation

A non-existing attribute

41. Which of the following represents a relationship between two entities?

Column

Attribute

Index

Foreign key

42. Which diagram is typically used during the conceptual design phase?

Venn diagram

Gantt chart

ERD (Entity Relationship Diagram)

Flowchart

43. What is a weak entity?

A deleted record

An entity that doesn't store data

An entity that depends on another for identification

A temporary table

44. What is denormalization?

Converting forms to HTML

Repeating data intentionally for performance

Reducing primary keys

Creating more relationships

45. Which of the following is used to eliminate transitive dependency in normalization?

Third Normal Form

First Normal Form

Fourth Normal Form

Second Normal Form

46. What does the logical design phase involve?

Physical data storage

Converting ER diagrams into tables

Formatting text

Creating user interfaces

47. Which of the following is a strong entity?

A derived attribute

An entity that exists independently

An entity without a primary key

An entity without attributes

48. Which of the following is a 1NF (First Normal Form) rule?

Eliminate foreign keys

Remove all repeating groups

Use only primary keys

Remove transitive dependencies

49. What is a functional dependency?

When data is split into parts

When one attribute determines another

When two tables are unrelated

When all attributes are primary keys

More Related Resources

Best Computer Courses List in Pakis... NTS NAT & GAT Computer Science... NADRA Juvenile Card Apply Online Fe... PPSC Syllabus for Computer Science ... 12th Class Computer Chapter 13 Crea... 12th Class Computer Chapter 12 Usin... KPK 11th Class Computer Chapter 1 O... FBISE 9th Class Computer Chapter 1 ... KPK 9th Class Computer Chapter 1 Fu... Virtual University of Pakistan Admi...

Can't find what you're looking for? Search below:

Latest Updates

Best Computer Courses List in Pakistan
NTS NAT & GAT Computer Science MCQs (Solved Past Papers)
NADRA Juvenile Card Apply Online Fees Processing
PPSC Syllabus for Computer Science Lecturer 2026 Sample Test Patt...
Virtual University of Pakistan Admission 2026 Apply Online Last D...
Career After 12th Class In Pakistan For Girls

Mustansar KhanLast Updated: October 15, 2025

Important Database Design Process Question and Answer

Database Design Process Practice Test Online With Explanation

Uncategorized

More Related Resources

Latest Updates

Mustansar Khan

Leave a Reply Cancel reply