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 a one-to-many relationship, where is the foreign key placed?

In both tables

In neither table

In the child table

In the parent table

2. Which relationship degree involves three entities?

Binary

Primary

Ternary

Unary

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

Attribute

Index

Foreign key

Column

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

High redundancy

Proper indexing

Clear primary keys

Well-structured tables

5. What is included in the physical design phase?

User permission settings

Hardware specifications and indexing

Table creation only

Writing procedures

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

Requirements analysis

Creating tables

Indexing

Normalization

7. What is a composite attribute?

An attribute that links multiple databases

An attribute made of multiple sub-parts

An attribute with a default value

An attribute that stores numbers only

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

Physical implementation

Prototyping

Logical design

Conceptual design

9. What is denormalization?

Repeating data intentionally for performance

Reducing primary keys

Converting forms to HTML

Creating more relationships

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

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

Reduce memory

Delete duplicates

Backup data

Improve query performance

12. What is a derived attribute?

An attribute dependent on calculation

An attribute copied from another table

A non-existing attribute

A primary key

13. What is a weak entity?

An entity that depends on another for identification

A temporary table

An entity that doesn't store data

A deleted record

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

Faster access

Data consistency

Higher storage cost due to duplication

Reduced anomalies

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

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

A composite key

A user-chosen key

An alternate candidate key

A system-generated unique key

17. In database design, what is an entity?

A storage device

A database administrator

A SQL query

A real-world object or concept

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

Venn diagram

ERD (Entity Relationship Diagram)

Flowchart

Gantt chart

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

Triangle

Dashed line

Double oval

Rectangle

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

Notepad

PowerPoint

ER Diagram

MS Word

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

To eliminate data duplication

To reduce database size

To create views

To increase redundancy

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

Third Normal Form

Fourth Normal Form

Second Normal Form

First Normal Form

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

Normalized data

Redundant data

Proper indexing

Foreign key constraints

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

To design the high-level structure of the database

To create reports

To sort the records

To write SQL queries

25. What does the logical design phase involve?

Physical data storage

Formatting text

Converting ER diagrams into tables

Creating user interfaces

Page 2 of 2

26. What does cardinality refer to in database design?

The size of the database

The number of attributes

The number of columns

The number of entities in a relationship

27. Which design step involves mapping entities to tables?

Front-end design

Logical design

Requirements gathering

Physical design

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

Super key

Foreign key

Domain

Primary key

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

Database normalization

Logical design

Data mining

Conceptual modeling

30. Which type of database model uses hierarchical relationships?

Network model

Hierarchical model

Object-oriented model

Relational model

31. Which one is not a rule of normalization?

Eliminate transitive dependencies

Remove repeating groups

Keep all foreign keys as primary

Eliminate duplicate columns

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

One record relates to multiple, and vice versa

All records are duplicates

One record relates to one only

Data is encrypted

33. Which of the following is a strong entity?

An entity without a primary key

A derived attribute

An entity without attributes

An entity that exists independently

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

Normalization

Query optimization

Data modeling

Authorization

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

Conceptual modeling

UI/UX design

Schema creation

Normalization

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

Candidate key

Alternate key

Super key

Foreign key

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

A software application

A fully working database system

A logical schema

A conceptual model

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

Partial key

Unique key

Surrogate key

Primary key

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

Complicated queries

Better data integrity

Increased redundancy

Slower performance

40. In ER diagrams, what do diamonds represent?

Tables

Fields

Attributes

Relationships

41. What does data integrity ensure?

Hardware compatibility

System speed

Data backup

Accuracy and consistency of data

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

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

Many-to-one

Unary

None

One-to-many

44. Which step comes after logical design?

Report generation

Conceptual design

Physical design

Requirements gathering

45. In which phase is data volume estimation considered?

Implementation

Physical

Logical

Conceptual

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

Physical

Planning

Logical

Conceptual

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

Domain

Entity

Relationship

Table

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

Index

Composite key

Primary key

Foreign key

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

Diamond

Rectangle

Triangle

Oval

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 Physics Nuclear Physics Test Online

ECAT Computer Science Microsoft Access-Forms and Reports Test Online

NED-Karachi ECAT Maths Entry Test Online Preparation

ECAT Statistics Test Set 7

ECAT Statistics Test Set 13

ECAT Computer Science Data Basics Test Online

Leave a Reply Cancel reply