Home/Computer/Computer Database Design Process Test Online

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 represents a relationship between two entities?

Index

Column

Attribute

Foreign key

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

Partial key

Surrogate key

Unique key

Primary key

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

Authorization

Data modeling

Query optimization

Normalization

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

PowerPoint

Notepad

MS Word

ER Diagram

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

Proper indexing

Foreign key constraints

Normalized data

Redundant data

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

Schema creation

Conceptual modeling

Normalization

UI/UX design

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

A user-chosen key

A composite key

An alternate candidate key

A system-generated unique key

8. Which step comes after logical design?

Conceptual design

Physical design

Report generation

Requirements gathering

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

Increased redundancy

Slower performance

Complicated queries

Better data integrity

10. What is denormalization?

Repeating data intentionally for performance

Converting forms to HTML

Reducing primary keys

Creating more relationships

11. Which relationship degree involves three entities?

Ternary

Primary

Binary

Unary

12. In which phase is data volume estimation considered?

Physical

Implementation

Logical

Conceptual

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

First Normal Form

Third Normal Form

Second Normal Form

Fourth Normal Form

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

Physical implementation

Logical design

Conceptual design

Prototyping

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

Many-to-one

One-to-many

None

Unary

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

Entity

Relationship

Domain

Table

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

High redundancy

Clear primary keys

Well-structured tables

Proper indexing

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

Conceptual modeling

Database normalization

Data mining

Logical design

19. What is a candidate key?

A key that can never be used

A duplicate key

One of the possible choices for primary key

A key used only for foreign relationships

20. What is a functional dependency?

When two tables are unrelated

When one attribute determines another

When data is split into parts

When all attributes are primary keys

21. What does cardinality refer to in database design?

The number of entities in a relationship

The number of columns

The size of the database

The number of attributes

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

Rectangle

Dashed line

Triangle

Double oval

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

To increase redundancy

To eliminate data duplication

To create views

To reduce database size

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

Alternate key

Candidate key

Super key

Foreign key

25. What is a derived attribute?

An attribute dependent on calculation

A non-existing attribute

An attribute copied from another table

A primary key

Page 2 of 2

26. What is included in the physical design phase?

Writing procedures

User permission settings

Hardware specifications and indexing

Table creation only

27. In database design, what is an entity?

A database administrator

A storage device

A real-world object or concept

A SQL query

28. 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

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

In both tables

In the parent table

In the child table

In neither table

30. Which type of database model uses hierarchical relationships?

Network model

Hierarchical model

Object-oriented model

Relational model

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

Foreign key

Domain

Super key

Primary key

32. What is a composite attribute?

An attribute made of multiple sub-parts

An attribute that links multiple databases

An attribute with a default value

An attribute that stores numbers only

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

Triangle

Diamond

Oval

Rectangle

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

A conceptual model

A software application

A fully working database system

A logical schema

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

Remove all repeating groups

Remove transitive dependencies

Use only primary keys

Eliminate foreign keys

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

Normalization

Indexing

Creating tables

Requirements analysis

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

Venn diagram

Flowchart

Gantt chart

ERD (Entity Relationship Diagram)

38. What does data integrity ensure?

Data backup

Hardware compatibility

Accuracy and consistency of data

System speed

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

Backup data

Reduce memory

Improve query performance

Delete duplicates

40. Which design step involves mapping entities to tables?

Requirements gathering

Front-end design

Logical design

Physical design

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

To design the high-level structure of the database

To create reports

To write SQL queries

To sort the records

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

All records are duplicates

One record relates to one only

Data is encrypted

One record relates to multiple, and vice versa

43. What does the logical design phase involve?

Physical data storage

Creating user interfaces

Converting ER diagrams into tables

Formatting text

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

Reduced anomalies

Faster access

Data consistency

Higher storage cost due to duplication

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

Logical

Physical

Planning

Conceptual

46. Which of the following is a strong entity?

An entity that exists independently

An entity without attributes

An entity without a primary key

A derived attribute

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

Composite key

Index

Foreign key

Primary key

48. Which one is not a rule of normalization?

Keep all foreign keys as primary

Remove repeating groups

Eliminate transitive dependencies

Eliminate duplicate columns

49. In ER diagrams, what do diamonds represent?

Tables

Fields

Attributes

Relationships

You Can Learn and Gain more Knowledge through our Online Quiz and Testing system Just Search your desired Preparation subject at Gotest.

Introduction to Computers Online Test
Computer File Handling in “C” Test Online
Computer Functions in “C” Test Online
Computer Loop Constructs Test Online
Computer Decision Constructs Test Online
Computer Input Output Test Online
Computer Elements of “C” Test Online
Computer Getting Started with “C” Test Online
Computer Microsoft Access-Forms and Reports Test Online
Computer Table and Query Test Online

Mustansar KhanLast Updated: October 15, 2025

Computer Database Design Process Test Online

Important Database Design Process Question and Answer

Database Design Process Practice Test Online With Explanation

Uncategorized

Related Posts

Mustansar Khan

Leave a Reply Cancel reply