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. Which of the following converts the ER model into relational form?

Data mining

Conceptual modeling

Database normalization

Logical design

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

Planning

Physical

Logical

Conceptual

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

An alternate candidate key

A user-chosen key

A composite key

A system-generated unique key

4. What is a derived attribute?

A primary key

An attribute copied from another table

An attribute dependent on calculation

A non-existing attribute

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

Delete duplicates

Reduce memory

Backup data

Improve query performance

6. Which one is not a rule of normalization?

Eliminate duplicate columns

Eliminate transitive dependencies

Remove repeating groups

Keep all foreign keys as primary

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

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

9. In ER diagrams, what do diamonds represent?

Tables

Fields

Relationships

Attributes

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

Many-to-one

Unary

One-to-many

None

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

Data consistency

Reduced anomalies

Higher storage cost due to duplication

Faster access

12. What is a weak entity?

A deleted record

A temporary table

An entity that depends on another for identification

An entity that doesn't store data

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

Conceptual design

Prototyping

Physical implementation

Logical design

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

Complicated queries

Better data integrity

Slower performance

Increased redundancy

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

16. Which of the following is a strong entity?

An entity without a primary key

An entity that exists independently

A derived attribute

An entity without attributes

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

To increase redundancy

To create views

To reduce database size

To eliminate data duplication

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

Primary key

Super key

Domain

Foreign key

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

ER Diagram

PowerPoint

Notepad

MS Word

20. What is a composite attribute?

An attribute that links multiple databases

An attribute made of multiple sub-parts

An attribute that stores numbers only

An attribute with a default value

21. What does the logical design phase involve?

Formatting text

Converting ER diagrams into tables

Physical data storage

Creating user interfaces

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

Conceptual modeling

Normalization

UI/UX design

Schema creation

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

One record relates to one only

All records are duplicates

Data is encrypted

One record relates to multiple, and vice versa

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

Venn diagram

Flowchart

ERD (Entity Relationship Diagram)

Gantt chart

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

Redundant data

Normalized data

Proper indexing

Foreign key constraints

Page 2 of 2

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

Attribute

Foreign key

Index

Column

27. In which phase is data volume estimation considered?

Physical

Implementation

Logical

Conceptual

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

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

Relationship

Entity

Table

Domain

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

Normalization

Data modeling

Query optimization

Authorization

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

Normalization

Creating tables

Indexing

Requirements analysis

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

Proper indexing

High redundancy

Clear primary keys

Well-structured tables

33. What is included in the physical design phase?

Writing procedures

User permission settings

Hardware specifications and indexing

Table creation only

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

Oval

Diamond

Rectangle

Triangle

35. Which design step involves mapping entities to tables?

Physical design

Front-end design

Requirements gathering

Logical design

36. What is denormalization?

Reducing primary keys

Repeating data intentionally for performance

Creating more relationships

Converting forms to HTML

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

Partial key

Primary key

Surrogate key

Unique key

38. Which relationship degree involves three entities?

Unary

Ternary

Primary

Binary

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

Dashed line

Double oval

Rectangle

Triangle

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

Primary key

Foreign key

Composite key

Index

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

Second Normal Form

Fourth Normal Form

Third Normal Form

First Normal Form

42. In database design, what is an entity?

A storage device

A SQL query

A real-world object or concept

A database administrator

43. Which step comes after logical design?

Physical design

Conceptual design

Requirements gathering

Report generation

44. What is a functional dependency?

When one attribute determines another

When two tables are unrelated

When data is split into parts

When all attributes are primary keys

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

To create reports

To write SQL queries

To sort the records

To design the high-level structure of the database

46. What does data integrity ensure?

System speed

Hardware compatibility

Data backup

Accuracy and consistency of data

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

A conceptual model

A software application

A fully working database system

A logical schema

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

Candidate key

Alternate key

Foreign key

Super key

49. Which type of database model uses hierarchical relationships?

Relational model

Network model

Object-oriented model

Hierarchical model

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

UET Lahore Combined Entry Test 2025 ECAT Schedule…
UET Lahore, Taxila ECAT Chemistry Entry Test Online…
NED-Karachi ECAT Maths Entry Test Online Preparation
UET Lahore, Taxila ECAT Physics Entry Test Online…
NED-Karachi ECAT Physics Entry Test Online Preparation
NED-Karachi ECAT Chemistry Entry Test Online Preparation
Mehran University Sindh ECAT Physics Entry Test…
NUST Rawalpindi ECAT Chemistry Entry Test Preparation Online

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

Related:

You Might Also Like

Mustansar Khan

Leave a Reply Cancel reply