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. Which constraint ensures that a column cannot have NULL values?

NOT NULL

CHECK

UNIQUE

DEFAULT

2. What is a field in a database?

A data file

A single piece of data in a record

A group of records

A collection of tables

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

COUNT()

TOTAL()

AVG()

SUM()

4. What is a view in SQL?

A primary key

A virtual table created from a SELECT query

A physical table

A stored procedure

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

DELETE is faster

DELETE removes records one by one, TRUNCATE removes all instantly

DELETE removes structure, TRUNCATE removes records

TRUNCATE allows WHERE clause

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

DELETE

DROP

SELECT

REMOVE

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

WHERE

SELECT

FROM

ORDER BY

8. What is the purpose of normalization?

To convert data to audio format

To slow down database queries

To reduce redundancy and improve data integrity

To duplicate data

9. What is data redundancy?

Encrypting data

Compressing data

Repeating the same data unnecessarily

Losing data

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

GRANT

GIVE

ALLOW

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

BUILD TABLE

MAKE TABLE

CREATE TABLE

NEW TABLE

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

Composite key

Primary key

Foreign key

Secondary key

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

Browser

Spreadsheet

Database

Operating system

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

UNION

CONNECT

JOIN

COMBINE

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

MODIFY

REPAIR

ALTER

UPDATE

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

DROP

DELETE

REMOVE

TRUNCATE

17. What does SQL stand for?

Structured Query Language

Simplified Query Language

Structured Quick Language

Server Query Language

18. What is an attribute in a database?

A unique row

A set of tables

A data field or column

A duplicate record

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

GROUP BY

WHERE

FILTER

ORDER BY

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

Alias

Constraint

Join

Function

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

COMPARE

22. What is a composite key?

A key made of multiple columns

A single key used across tables

A foreign key

A duplicated primary key

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

Network

Spreadsheet

Relational

Hierarchical

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

WHERE

ORDER

HAVING

SELECT

25. What is a primary key?

A field that uniquely identifies a record

A field that allows null values

A duplicated field

A field used only for sorting

Page 2 of 2

26. Which of the following is a NoSQL database?

PostgreSQL

MySQL

MongoDB

Oracle

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

ORDER BY

SELECT

GROUP BY

WHERE

28. Which of these is a relational database?

Google

Gmail

Windows

MySQL

29. What is a database index used for?

Encrypting data

Backing up data

Storing records

Increasing search speed

30. What is the full form of RDBMS?

Random Data Management Software

Relational Database Management System

Real Data Backup and Management System

Registered Data-Based Model Software

31. What is a record in a database?

A column of data

A table of values

A row representing one entry

A file format

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

A report format

A structure of tables and relationships

A backup of data

A data entry form

33. What is the default sort order in SQL?

Ascending

Random

Descending

Alphabetical

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

Oracle

Adobe Reader

MS Paint

Microsoft Excel

35. What does NULL represent in a database?

A zero value

A false value

A missing or unknown value

An empty space

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

DELETE

INSERT

SELECT

UPDATE

37. Which one is not an SQL data type?

TEXT

VARCHAR

DATE

DISPLAY

38. What is a foreign key?

A duplicate of a primary key

A field that stores user passwords

A key used in multiple databases

A field that links one table to another

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

SELECT

DELETE

INSERT

UPDATE

40. What is the result of a JOIN operation?

Insertion of a row

Deletion of a record

Encrypting values

Combining rows from multiple tables based on a related column

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

LIMIT

MAX

SIZE

RANGE

42. What does ERD stand for?

Entity Relationship Diagram

Entity Relational Design

Entry Record Document

Extended Relational Data

43. Which is the correct order of SQL execution?

FROM → SELECT → WHERE

SELECT → WHERE → FROM

SELECT → FROM → WHERE

FROM → WHERE → SELECT

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

UPDATE

DELETE

SELECT

INSERT

45. What is data integrity in databases?

Ensuring data remains accurate and consistent

Combining data

Encrypting the data

Sorting tables

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

BUILD DATABASE

MAKE DATABASE

CREATE DATABASE

NEW DATABASE

47. What does DBMS stand for?

Database Managing Software

Data Business Modeling Software

Data Backup Management System

Database Management System

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

Relation

Column

Attribute

Row

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

DISTINCT

UNIQUE

FILTER

GROUP BY

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

LABEL

CHANGE

RENAME

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

You Might Also Like

Mustansar Khan

Leave a Reply Cancel reply