Home/ECAT/ECAT Computer Science Database Design Process Test Online

ECAT Computer Science Database Design Process Test Online

Mustansar KhanLast Updated: May 1, 2025

ECAT Computer Science Database Design Process Test

ECAT Computer Science Chapter 13 Database Design Process Online Test

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

ECAT Database Design Process Test Online MCQs

Please wait...

Page 1 of 2

Uncategorized

1. What does cardinality refer to in database design?

The number of columns

The number of entities in a relationship

The number of attributes

The size of the database

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

Data consistency

Reduced anomalies

Faster access

Higher storage cost due to duplication

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

Redundant data

Normalized data

Proper indexing

Foreign key constraints

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

Planning

Conceptual

Logical

Physical

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

To write SQL queries

To design the high-level structure of the database

To create reports

To sort the records

6. What is included in the physical design phase?

Hardware specifications and indexing

User permission settings

Writing procedures

Table creation only

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

Unary

Many-to-one

None

One-to-many

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

Better data integrity

Increased redundancy

Complicated queries

Slower performance

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

Domain

Entity

Relationship

Table

10. What does the logical design phase involve?

Physical data storage

Formatting text

Converting ER diagrams into tables

Creating user interfaces

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

Creating tables

Normalization

Indexing

Requirements analysis

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

Dashed line

Triangle

Rectangle

Double oval

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

To create views

To eliminate data duplication

To reduce database size

To increase redundancy

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

Foreign key

Composite key

Primary key

Index

15. What is a derived attribute?

An attribute copied from another table

A primary key

A non-existing attribute

An attribute dependent on calculation

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

A user-chosen key

A system-generated unique key

A composite key

An alternate candidate key

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

In the child table

In neither table

In both tables

In the parent table

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

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

20. In which phase is data volume estimation considered?

Physical

Implementation

Conceptual

Logical

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

Backup data

Delete duplicates

Reduce memory

Improve query performance

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

ER Diagram

Notepad

PowerPoint

MS Word

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

First Normal Form

Fourth Normal Form

Third Normal Form

Second Normal Form

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

Flowchart

Gantt chart

Venn diagram

ERD (Entity Relationship Diagram)

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

Triangle

Rectangle

Oval

Diamond

Page 2 of 2

26. In database design, what is an entity?

A SQL query

A database administrator

A real-world object or concept

A storage device

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

Data modeling

Authorization

Query optimization

Normalization

28. What is a candidate key?

A key used only for foreign relationships

A duplicate key

One of the possible choices for primary key

A key that can never be used

29. Which one is not a rule of normalization?

Keep all foreign keys as primary

Eliminate transitive dependencies

Eliminate duplicate columns

Remove repeating groups

30. Which step comes after logical design?

Conceptual design

Physical design

Requirements gathering

Report generation

31. What is a functional dependency?

When all attributes are primary keys

When data is split into parts

When two tables are unrelated

When one attribute determines another

32. In ER diagrams, what do diamonds represent?

Attributes

Fields

Tables

Relationships

33. What is a composite attribute?

An attribute with a default value

An attribute that stores numbers only

An attribute made of multiple sub-parts

An attribute that links multiple databases

34. Which of the following is a strong entity?

An entity without attributes

A derived attribute

An entity that exists independently

An entity without a primary key

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

High redundancy

Proper indexing

Clear primary keys

Well-structured tables

36. Which type of database model uses hierarchical relationships?

Network model

Hierarchical model

Relational model

Object-oriented model

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

Normalization

Conceptual modeling

Schema creation

UI/UX design

38. What is denormalization?

Creating more relationships

Repeating data intentionally for performance

Reducing primary keys

Converting forms to HTML

39. What does data integrity ensure?

System speed

Hardware compatibility

Accuracy and consistency of data

Data backup

40. Which relationship degree involves three entities?

Binary

Unary

Ternary

Primary

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

Foreign key

Super key

Domain

Primary key

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

Foreign key

Attribute

Index

Column

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

Remove transitive dependencies

Remove all repeating groups

Use only primary keys

Eliminate foreign keys

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

Conceptual design

Logical design

Prototyping

Physical implementation

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

Foreign key

Alternate key

Super key

Candidate key

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

Logical design

Database normalization

Conceptual modeling

Data mining

47. Which design step involves mapping entities to tables?

Physical design

Requirements gathering

Front-end design

Logical design

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

Partial key

Primary key

Surrogate key

Unique key

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

A logical schema

A software application

A conceptual model

A fully working database system

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

ECAT Introduction to Computers Online Test
ECAT Physics Optical Instruments 1 Test Online
ECAT Computer File Handling in “C” Test Online
ECAT Computer Functions in “C” Test Online
ECAT Computer Loop Constructs Test Online
ECAT Computer Decision Constructs Test Online
ECAT Computer Input Output Test Online
ECAT Computer Elements of “C” Test Online
ECAT Computer Getting Started with “C” Test Online
ECAT Computer Science Microsoft Access-Forms and Reports Tes...

Mustansar KhanLast Updated: May 1, 2025

Facebook Twitter Reddit WhatsApp Share via Email Print

ECAT Computer Science Database Design Process Test Online

ECAT Computer Science Database Design Process Test

ECAT Computer Science Chapter 13 Database Design Process Online Test

ECAT Database Design Process Test Online MCQs

Uncategorized

You Might Also Like

Mustansar Khan

Leave a Reply Cancel reply

ECAT Computer Science Database Design Process Test

ECAT Computer Science Chapter 13 Database Design Process Online Test

ECAT Database Design Process Test Online MCQs

Uncategorized

You Might Also Like

Mustansar Khan

Your Related

ECAT English Direct and Indirect Narration Test 2 Online

ECAT English Vocabulary 8 Online Test

ECAT Chemistry Gases 2 Online Test

ECAT Physics Work and Energy Test Online

ECAT Mathematics Inverse Trigonometric Functions Online Test

UET Lahore, Taxila ECAT Maths Entry Test Online Preparation

Leave a Reply Cancel reply