Home/ECAT/ECAT Computer Science Basics Concepts and Terminology of Databases Test Online

ECAT Computer Science Basics Concepts and Terminology of Databases Test Online

Mustansar KhanLast Updated: May 1, 2025

ECAT Computer Science Basics Concepts and Terminology of Databases Test

ECAT Computer Science Chapter 12 Basics Concepts and Terminology of Databases 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 Basics Concepts and Terminology of Databases Test Online MCQs

Please wait...

Page 1 of 2

Uncategorized

1. What is the full form of RDBMS?

Real Data Backup and Management System

Relational Database Management System

Random Data Management Software

Registered Data-Based Model Software

2. Which of the following defines rules for data in a table?

Join

Constraint

Function

Alias

3. Which of the following is a popular database management system (DBMS)?

Microsoft Excel

MS Paint

Adobe Reader

Oracle

4. What is a database index used for?

Backing up data

Increasing search speed

Storing records

Encrypting data

5. What does ERD stand for?

Entry Record Document

Entity Relational Design

Extended Relational Data

Entity Relationship Diagram

6. Which SQL clause is used to limit the number of records returned?

SIZE

MAX

RANGE

LIMIT

7. What does NULL represent in a database?

A false value

A missing or unknown value

A zero value

An empty space

8. What does the term schema refer to in databases?

A structure of tables and relationships

A data entry form

A backup of data

A report format

9. Which constraint ensures that a column cannot have NULL values?

DEFAULT

CHECK

UNIQUE

NOT NULL

10. What is a view in SQL?

A primary key

A stored procedure

A virtual table created from a SELECT query

A physical table

11. Which SQL clause groups rows with the same values?

ORDER BY

GROUP BY

WHERE

SELECT

12. Which SQL command is used to change existing records?

DELETE

UPDATE

SELECT

INSERT

13. Which operator is used in SQL for pattern matching?

COMPARE

14. What is a field in a database?

A collection of tables

A data file

A group of records

A single piece of data in a record

15. Which SQL command is used to remove a table completely?

DROP

DELETE

REMOVE

TRUNCATE

16. What is data integrity in databases?

Sorting tables

Combining data

Encrypting the data

Ensuring data remains accurate and consistent

17. Which command is used to retrieve data from a database?

UPDATE

DELETE

SELECT

INSERT

18. What is data redundancy?

Encrypting data

Repeating the same data unnecessarily

Compressing data

Losing data

19. What is a foreign key?

A duplicate of a primary key

A key used in multiple databases

A field that links one table to another

A field that stores user passwords

20. Which command is used to remove records from a table?

DELETE

DROP

REMOVE

SELECT

21. Which of the following is not a type of DBMS?

Spreadsheet

Relational

Hierarchical

Network

22. Which keyword is used to define a new table in SQL?

BUILD TABLE

NEW TABLE

MAKE TABLE

CREATE TABLE

23. Which key ensures uniqueness for each record in a table?

Secondary key

Primary key

Composite key

Foreign key

24. Which clause is used to filter records in SQL?

WHERE

SELECT

FROM

ORDER BY

25. Which SQL keyword is used to sort the result set?

ORDER BY

WHERE

GROUP BY

FILTER

Page 2 of 2

26. What is a record in a database?

A column of data

A row representing one entry

A table of values

A file format

27. What does DBMS stand for?

Data Business Modeling Software

Database Management System

Database Managing Software

Data Backup Management System

28. What is the default sort order in SQL?

Random

Descending

Alphabetical

Ascending

29. In relational databases, a table is also called a:

Attribute

Relation

Column

Row

30. Which SQL keyword is used to combine results from two queries?

JOIN

CONNECT

COMBINE

UNION

31. Which of the following is used to store and manage data in a structured format?

Database

Operating system

Browser

Spreadsheet

32. Which command is used to modify the structure of a table?

UPDATE

ALTER

MODIFY

REPAIR

33. Which function returns the number of rows in a table?

AVG()

SUM()

TOTAL()

COUNT()

34. Which clause is used with GROUP BY to filter groups?

ORDER

WHERE

SELECT

HAVING

35. What is the result of a JOIN operation?

Combining rows from multiple tables based on a related column

Encrypting values

Deletion of a record

Insertion of a row

36. What is the purpose of normalization?

To duplicate data

To convert data to audio format

To reduce redundancy and improve data integrity

To slow down database queries

37. What is a primary key?

A duplicated field

A field that uniquely identifies a record

A field used only for sorting

A field that allows null values

38. What is an attribute in a database?

A set of tables

A unique row

A duplicate record

A data field or column

39. Which one is not an SQL data type?

DISPLAY

TEXT

VARCHAR

DATE

40. Which SQL clause is used to rename a column or table?

LABEL

RENAME

CHANGE

41. What is a composite key?

A single key used across tables

A foreign key

A duplicated primary key

A key made of multiple columns

42. Which SQL statement is used to add new records?

SELECT

INSERT

DELETE

UPDATE

43. Which of these is a relational database?

MySQL

Google

Gmail

Windows

44. What does SQL stand for?

Server Query Language

Structured Query Language

Structured Quick Language

Simplified Query Language

45. Which of the following is a NoSQL database?

MongoDB

MySQL

Oracle

PostgreSQL

46. Which SQL command is used to remove duplicate rows from results?

GROUP BY

FILTER

UNIQUE

DISTINCT

47. Which SQL statement is used to create a new database?

MAKE DATABASE

CREATE DATABASE

NEW DATABASE

BUILD DATABASE

48. Which command is used to grant user permissions in SQL?

ALLOW

GRANT

GIVE

49. Which is the correct order of SQL execution?

SELECT → WHERE → FROM

SELECT → FROM → WHERE

FROM → WHERE → SELECT

FROM → SELECT → WHERE

50. What is the difference between DELETE and TRUNCATE in SQL?

DELETE removes records one by one, TRUNCATE removes all instantly

TRUNCATE allows WHERE clause

DELETE is faster

DELETE removes structure, TRUNCATE removes records

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

UET Lahore, Taxila ECAT Chemistry Entry Test Online…
UET Lahore Combined Entry Test 2025 ECAT Schedule…
NED-Karachi ECAT Physics Entry Test Online Preparation
UET Lahore, Taxila ECAT Physics Entry Test Online…
NED-Karachi ECAT Maths 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 Basics Concepts and Terminology of Databases Test Online

ECAT Computer Science Basics Concepts and Terminology of Databases Test

ECAT Computer Science Chapter 12 Basics Concepts and Terminology of Databases Online Test

ECAT Basics Concepts and Terminology of Databases Test Online MCQs

Uncategorized

Related:

You Might Also Like

Mustansar Khan

Leave a Reply Cancel reply