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. In database design, what is an entity?

A storage device

A SQL query

A real-world object or concept

A database administrator

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

Physical implementation

Logical design

Prototyping

Conceptual design

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

A composite key

An alternate candidate key

A system-generated unique key

A user-chosen key

4. What does data integrity ensure?

Data backup

Hardware compatibility

Accuracy and consistency of data

System speed

5. What is a composite attribute?

An attribute that stores numbers only

An attribute that links multiple databases

An attribute made of multiple sub-parts

An attribute with a default value

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

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

Index

Attribute

Foreign key

Column

8. What is denormalization?

Creating more relationships

Reducing primary keys

Converting forms to HTML

Repeating data intentionally for performance

9. Which design step involves mapping entities to tables?

Front-end design

Physical design

Logical design

Requirements gathering

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

In the child table

In both tables

In neither table

In the parent table

11. Which type of database model uses hierarchical relationships?

Relational model

Network model

Hierarchical model

Object-oriented model

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

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

All records are duplicates

Data is encrypted

One record relates to multiple, and vice versa

One record relates to one only

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

Triangle

Oval

Diamond

Rectangle

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

Indexing

Normalization

Creating tables

Requirements analysis

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

Faster access

Reduced anomalies

Data consistency

Higher storage cost due to duplication

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

Redundant data

Normalized data

Foreign key constraints

Proper indexing

18. In which phase is data volume estimation considered?

Logical

Conceptual

Implementation

Physical

19. What is included in the physical design phase?

User permission settings

Writing procedures

Hardware specifications and indexing

Table creation only

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

Triangle

Double oval

Rectangle

Dashed line

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

Primary key

Domain

Foreign key

Super key

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

Increased redundancy

Complicated queries

Slower performance

Better data integrity

23. Which one is not a rule of normalization?

Eliminate transitive dependencies

Remove repeating groups

Keep all foreign keys as primary

Eliminate duplicate columns

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

Flowchart

ERD (Entity Relationship Diagram)

Venn diagram

Gantt chart

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

Reduce memory

Backup data

Delete duplicates

Improve query performance

Page 2 of 2

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

To design the high-level structure of the database

To sort the records

To write SQL queries

To create reports

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

Remove transitive dependencies

Use only primary keys

Eliminate foreign keys

Remove all repeating groups

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

Domain

Entity

Relationship

Table

29. What does the logical design phase involve?

Physical data storage

Creating user interfaces

Formatting text

Converting ER diagrams into tables

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

Unique key

Partial key

Primary key

Surrogate key

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

Database normalization

Data mining

Conceptual modeling

Logical design

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

Fourth Normal Form

Second Normal Form

Third Normal Form

First Normal Form

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

Logical

Conceptual

Planning

Physical

34. Which relationship degree involves three entities?

Ternary

Binary

Primary

Unary

35. What is a candidate key?

A key used only for foreign relationships

A key that can never be used

One of the possible choices for primary key

A duplicate key

36. What is a derived attribute?

An attribute copied from another table

An attribute dependent on calculation

A primary key

A non-existing attribute

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

A software application

A logical schema

A fully working database system

A conceptual model

38. In ER diagrams, what do diamonds represent?

Attributes

Relationships

Fields

Tables

39. What is a weak entity?

A deleted record

A temporary table

An entity that doesn't store data

An entity that depends on another for identification

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

Primary key

Composite key

Index

Foreign key

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

Conceptual modeling

Normalization

UI/UX design

Schema creation

42. Which of the following is a strong entity?

An entity without attributes

An entity that exists independently

An entity without a primary key

A derived attribute

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

Normalization

Data modeling

Authorization

Query optimization

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

Many-to-one

None

Unary

One-to-many

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

To eliminate data duplication

To create views

To increase redundancy

To reduce database size

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

MS Word

Notepad

PowerPoint

ER Diagram

47. Which step comes after logical design?

Physical design

Conceptual design

Report generation

Requirements gathering

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

High redundancy

Well-structured tables

Clear primary keys

Proper indexing

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

Candidate key

Foreign key

Super key

Alternate key

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

UET Peshawar Entry Test 2025 Registration Online ETEA Test D...
ECAT Statistics Test Set 17
ECAT Statistics Test Set 16
ECAT Statistics Test Set 15
ECAT Statistics Test Set 14
ECAT Statistics Test Set 13
ECAT Statistics Test Set 12
ECAT Statistics Test Set 11
ECAT Statistics Test Set 10
ECAT Statistics Test Set 9

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 Mathematics Permutations Combinations and Probability Online Test

ECAT English Analogies Test Online

ECAT Statistics Test Set 5

ECAT English Spotting Errors 3 Online Test Preparation

ECAT Chemistry Electrochemistry Online Test

ECAT Physics Current Electricity Online Test

Leave a Reply Cancel reply