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 of the following is not a benefit of good database design?

Reduced anomalies

Higher storage cost due to duplication

Faster access

Data consistency

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

Super key

Foreign key

Candidate key

Alternate key

3. What does data integrity ensure?

Data backup

Hardware compatibility

System speed

Accuracy and consistency of data

4. What does the logical design phase involve?

Physical data storage

Converting ER diagrams into tables

Creating user interfaces

Formatting text

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

Conceptual design

Physical implementation

Prototyping

Logical design

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

PowerPoint

ER Diagram

MS Word

Notepad

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

To eliminate data duplication

To increase redundancy

To create views

To reduce database size

8. Which of the following is a strong entity?

A derived attribute

An entity without attributes

An entity that exists independently

An entity without a primary key

9. Which relationship degree involves three entities?

Ternary

Binary

Primary

Unary

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

Conceptual modeling

Data mining

Logical design

Database normalization

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

Proper indexing

Foreign key constraints

Normalized data

Redundant data

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

Many-to-one

Unary

One-to-many

None

13. In which phase is data volume estimation considered?

Physical

Implementation

Conceptual

Logical

14. Which design step involves mapping entities to tables?

Logical design

Front-end design

Requirements gathering

Physical design

15. What is denormalization?

Creating more relationships

Repeating data intentionally for performance

Reducing primary keys

Converting forms to HTML

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

A fully working database system

A logical schema

A software application

A conceptual model

17. Which one is not a rule of normalization?

Remove repeating groups

Eliminate duplicate columns

Eliminate transitive dependencies

Keep all foreign keys as primary

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

One record relates to one only

Data is encrypted

All records are duplicates

One record relates to multiple, and vice versa

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

Diamond

Rectangle

Oval

Triangle

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

Better data integrity

Increased redundancy

Complicated queries

Slower performance

21. What is included in the physical design phase?

Writing procedures

Table creation only

Hardware specifications and indexing

User permission settings

22. What does cardinality refer to in database design?

The number of attributes

The size of the database

The number of entities in a relationship

The number of columns

23. What is a derived attribute?

An attribute copied from another table

An attribute dependent on calculation

A primary key

A non-existing attribute

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

Physical

Planning

Conceptual

Logical

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

To sort the records

To design the high-level structure of the database

To write SQL queries

To create reports

Page 2 of 2

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

Normalization

Authorization

Data modeling

Query optimization

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

Flowchart

ERD (Entity Relationship Diagram)

Venn diagram

Gantt chart

28. What is a composite attribute?

An attribute with a default value

An attribute made of multiple sub-parts

An attribute that stores numbers only

An attribute that links multiple databases

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

Entity

Domain

Relationship

Table

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

Dashed line

Rectangle

Double oval

Triangle

31. Which step comes after logical design?

Physical design

Requirements gathering

Conceptual design

Report generation

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

In both tables

In the parent table

In neither table

In the child table

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

Eliminate foreign keys

Remove transitive dependencies

Remove all repeating groups

Use only primary keys

34. In ER diagrams, what do diamonds represent?

Tables

Relationships

Attributes

Fields

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

Improve query performance

Backup data

Delete duplicates

Reduce memory

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

Foreign key

Column

Attribute

Index

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

Partial key

Surrogate key

Unique key

Primary key

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

An alternate candidate key

A user-chosen key

A system-generated unique key

A composite key

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

Well-structured tables

High redundancy

Proper indexing

Clear primary keys

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

Index

Primary key

Foreign key

Composite key

41. What is a functional dependency?

When all attributes are primary keys

When two tables are unrelated

When data is split into parts

When one attribute determines another

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

Creating tables

Indexing

Requirements analysis

Normalization

43. In database design, what is an entity?

A storage device

A database administrator

A real-world object or concept

A SQL query

44. What is a candidate key?

One of the possible choices for primary key

A duplicate key

A key that can never be used

A key used only for foreign relationships

45. What is a weak entity?

An entity that depends on another for identification

A temporary table

A deleted record

An entity that doesn't store data

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

Normalization

Conceptual modeling

UI/UX design

Schema creation

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

Third Normal Form

First Normal Form

Fourth Normal Form

Second Normal Form

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

Primary key

Domain

Foreign key

Super key

49. Which type of database model uses hierarchical relationships?

Network model

Object-oriented model

Relational model

Hierarchical model

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... Career After 12th Class In Pakistan...

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...
Career After 12th Class In Pakistan For Girls
Short courses after Matric FA FSc Ics I.com for All Students in P...

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