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

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

Logical design

Data mining

Conceptual modeling

Database normalization

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

To create reports

To sort the records

To design the high-level structure of the database

To write SQL queries

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

Many-to-one

Unary

One-to-many

None

5. Which step comes after logical design?

Physical design

Requirements gathering

Conceptual design

Report generation

6. In which phase is data volume estimation considered?

Implementation

Conceptual

Physical

Logical

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

Rectangle

Dashed line

Triangle

Double oval

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

An alternate candidate key

A user-chosen key

A system-generated unique key

A composite key

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

Data modeling

Authorization

Normalization

Query optimization

10. What is denormalization?

Repeating data intentionally for performance

Creating more relationships

Converting forms to HTML

Reducing primary keys

11. What is a candidate key?

A key that can never be used

A duplicate key

One of the possible choices for primary key

A key used only for foreign relationships

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

Indexing

Normalization

Requirements analysis

Creating tables

13. What is a functional dependency?

When all attributes are primary keys

When one attribute determines another

When two tables are unrelated

When data is split into parts

14. Which relationship degree involves three entities?

Primary

Unary

Binary

Ternary

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

Candidate key

Alternate key

Super key

Foreign key

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

17. What does data integrity ensure?

Hardware compatibility

System speed

Data backup

Accuracy and consistency of data

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

ER Diagram

PowerPoint

MS Word

Notepad

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

Prototyping

Conceptual design

Logical design

Physical implementation

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

Proper indexing

Redundant data

Foreign key constraints

Normalized data

21. What is a weak entity?

A temporary table

An entity that depends on another for identification

A deleted record

An entity that doesn't store data

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

Unique key

Partial key

Surrogate key

Primary key

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

To reduce database size

To eliminate data duplication

To increase redundancy

To create views

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

A conceptual model

A fully working database system

A software application

A logical schema

25. Which one is not a rule of normalization?

Keep all foreign keys as primary

Remove repeating groups

Eliminate transitive dependencies

Eliminate duplicate columns

Page 2 of 2

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

Attribute

Column

Foreign key

Index

27. Which of the following is a strong entity?

An entity without a primary key

An entity without attributes

A derived attribute

An entity that exists independently

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

Super key

Primary key

Domain

Foreign key

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

UI/UX design

Conceptual modeling

Normalization

Schema creation

30. What is included in the physical design phase?

Hardware specifications and indexing

Table creation only

User permission settings

Writing procedures

31. Which design step involves mapping entities to tables?

Logical design

Front-end design

Requirements gathering

Physical design

32. What is a derived attribute?

An attribute dependent on calculation

A non-existing attribute

An attribute copied from another table

A primary key

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

Faster access

Reduced anomalies

Data consistency

Higher storage cost due to duplication

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

Foreign key

Composite key

Index

Primary key

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

36. In database design, what is an entity?

A real-world object or concept

A storage device

A database administrator

A SQL query

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

Fourth Normal Form

First Normal Form

Third Normal Form

Second Normal Form

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

Proper indexing

Well-structured tables

Clear primary keys

High redundancy

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

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

One record relates to multiple, and vice versa

Data is encrypted

One record relates to one only

All records are duplicates

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

Entity

Table

Relationship

Domain

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

ERD (Entity Relationship Diagram)

Venn diagram

Flowchart

Gantt chart

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

Delete duplicates

Backup data

Reduce memory

Improve query performance

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

Oval

Triangle

Diamond

Rectangle

45. What does the logical design phase involve?

Physical data storage

Creating user interfaces

Converting ER diagrams into tables

Formatting text

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

Slower performance

Complicated queries

Increased redundancy

Better data integrity

47. Which type of database model uses hierarchical relationships?

Object-oriented model

Hierarchical model

Relational model

Network model

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

Conceptual

Logical

Planning

Physical

49. In ER diagrams, what do diamonds represent?

Relationships

Tables

Fields

Attributes

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

Quaid-e-Azam University QAU Nawab Shah ECAT Chemistry Preparation Entry Test Online

ECAT Chemistry Periodic Classification Of Elements & Periodicity Test Online

ECAT Statistics Test Set 11

ECAT Chemistry Basic Concepts Test Online

ECAT Physics Heat and Thermodynamics Online Test

ECAT Mathematics Solution of Trigonometric Functions Online Test

Leave a Reply Cancel reply