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 is the final outcome of the database design process?

A software application

A fully working database system

A logical schema

A conceptual model

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

To eliminate data duplication

To reduce database size

To create views

To increase redundancy

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

Venn diagram

Gantt chart

ERD (Entity Relationship Diagram)

Flowchart

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

Primary key

Super key

Domain

Foreign key

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

UI/UX design

Normalization

Schema creation

Conceptual modeling

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

Data consistency

Higher storage cost due to duplication

Faster access

Reduced anomalies

7. What is a composite attribute?

An attribute made of multiple sub-parts

An attribute with a default value

An attribute that stores numbers only

An attribute that links multiple databases

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

Partial key

Surrogate key

Primary key

Unique key

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

Normalized data

Foreign key constraints

Proper indexing

Redundant data

10. Which of the following is a strong entity?

An entity without a primary key

A derived attribute

An entity that exists independently

An entity without attributes

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

Attribute

Column

Foreign key

Index

12. What is included in the physical design phase?

Table creation only

Writing procedures

Hardware specifications and indexing

User permission settings

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

Unary

Many-to-one

None

One-to-many

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

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

In the parent table

In both tables

In the child table

In neither table

16. What is denormalization?

Repeating data intentionally for performance

Creating more relationships

Converting forms to HTML

Reducing primary keys

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

Fourth Normal Form

Third Normal Form

First Normal Form

Second Normal Form

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

Primary key

Foreign key

Index

Composite key

19. Which type of database model uses hierarchical relationships?

Object-oriented model

Network model

Relational model

Hierarchical model

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

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

To design the high-level structure of the database

To write SQL queries

To create reports

To sort the records

22. In database design, what is an entity?

A storage device

A SQL query

A real-world object or concept

A database administrator

23. Which design step involves mapping entities to tables?

Logical design

Physical design

Front-end design

Requirements gathering

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

Entity

Table

Domain

Relationship

25. Which one is not a rule of normalization?

Eliminate duplicate columns

Eliminate transitive dependencies

Remove repeating groups

Keep all foreign keys as primary

Page 2 of 2

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

Rectangle

Triangle

Oval

Diamond

27. What does the logical design phase involve?

Formatting text

Creating user interfaces

Converting ER diagrams into tables

Physical data storage

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

Complicated queries

Increased redundancy

Better data integrity

Slower performance

29. In ER diagrams, what do diamonds represent?

Tables

Fields

Relationships

Attributes

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

Indexing

Requirements analysis

Normalization

Creating tables

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

Super key

Foreign key

Candidate key

Alternate key

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

PowerPoint

ER Diagram

MS Word

Notepad

33. Which relationship degree involves three entities?

Ternary

Binary

Unary

Primary

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

Data is encrypted

One record relates to one only

One record relates to multiple, and vice versa

All records are duplicates

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

High redundancy

Proper indexing

Well-structured tables

Clear primary keys

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

Use only primary keys

Remove transitive dependencies

Eliminate foreign keys

Remove all repeating groups

37. What is a candidate key?

A key that can never be used

A duplicate key

A key used only for foreign relationships

One of the possible choices for primary key

38. Which step comes after logical design?

Requirements gathering

Report generation

Physical design

Conceptual design

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

Conceptual modeling

Logical design

Database normalization

Data mining

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

Delete duplicates

Backup data

Improve query performance

Reduce memory

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

Physical implementation

Conceptual design

Logical design

Prototyping

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

Logical

Planning

Physical

Conceptual

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

44. What does data integrity ensure?

Hardware compatibility

Data backup

Accuracy and consistency of data

System speed

45. In which phase is data volume estimation considered?

Implementation

Physical

Logical

Conceptual

46. What is a derived attribute?

An attribute dependent on calculation

A non-existing attribute

A primary key

An attribute copied from another table

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

Dashed line

Rectangle

Triangle

Double oval

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

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

Data modeling

Query optimization

Normalization

Authorization

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