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 SQL clause is used to rename a column or table?

CHANGE

RENAME

LABEL

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

SELECT

DROP

REMOVE

DELETE

3. What does NULL represent in a database?

A missing or unknown value

A zero value

An empty space

A false value

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

DELETE

INSERT

SELECT

UPDATE

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

WHERE

ORDER

SELECT

HAVING

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

Foreign key

Secondary key

Composite key

Primary key

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

BUILD DATABASE

CREATE DATABASE

MAKE DATABASE

NEW DATABASE

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

NEW TABLE

MAKE TABLE

CREATE TABLE

BUILD TABLE

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

ORDER BY

FILTER

GROUP BY

WHERE

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

SELECT

WHERE

FROM

ORDER BY

11. What is a composite key?

A key made of multiple columns

A foreign key

A single key used across tables

A duplicated primary key

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

TRUNCATE allows WHERE clause

DELETE removes records one by one, TRUNCATE removes all instantly

DELETE removes structure, TRUNCATE removes records

DELETE is faster

13. What is the purpose of normalization?

To reduce redundancy and improve data integrity

To convert data to audio format

To duplicate data

To slow down database queries

14. Which is the correct order of SQL execution?

FROM → WHERE → SELECT

SELECT → FROM → WHERE

SELECT → WHERE → FROM

FROM → SELECT → WHERE

15. What is the default sort order in SQL?

Alphabetical

Random

Descending

Ascending

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

MAX

RANGE

LIMIT

SIZE

17. Which of the following is a NoSQL database?

PostgreSQL

MySQL

MongoDB

Oracle

18. Which of these is a relational database?

Google

Gmail

Windows

MySQL

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

ALTER

REPAIR

UPDATE

MODIFY

20. Which one is not an SQL data type?

DISPLAY

VARCHAR

DATE

TEXT

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

COMPARE

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

SELECT

UPDATE

INSERT

DELETE

23. What is a field in a database?

A collection of tables

A single piece of data in a record

A group of records

A data file

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

Adobe Reader

Microsoft Excel

Oracle

MS Paint

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

AVG()

SUM()

TOTAL()

COUNT()

Page 2 of 2

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

Spreadsheet

Relational

Network

Hierarchical

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

GIVE

GRANT

ALLOW

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

Relation

Attribute

Column

Row

29. What is a view in SQL?

A virtual table created from a SELECT query

A primary key

A stored procedure

A physical table

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

CHECK

DEFAULT

NOT NULL

UNIQUE

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

UPDATE

DELETE

SELECT

INSERT

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

Browser

Operating system

Spreadsheet

Database

33. What is an attribute in a database?

A data field or column

A unique row

A duplicate record

A set of tables

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

DROP

REMOVE

TRUNCATE

DELETE

35. What is a record in a database?

A file format

A row representing one entry

A column of data

A table of values

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

COMBINE

CONNECT

UNION

JOIN

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

SELECT

ORDER BY

GROUP BY

WHERE

38. What does SQL stand for?

Simplified Query Language

Server Query Language

Structured Quick Language

Structured Query Language

39. What does ERD stand for?

Entity Relationship Diagram

Entity Relational Design

Entry Record Document

Extended Relational Data

40. What is the full form of RDBMS?

Registered Data-Based Model Software

Real Data Backup and Management System

Random Data Management Software

Relational Database Management System

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

DISTINCT

FILTER

UNIQUE

GROUP BY

42. What is a database index used for?

Encrypting data

Backing up data

Increasing search speed

Storing records

43. What is the result of a JOIN operation?

Encrypting values

Deletion of a record

Insertion of a row

Combining rows from multiple tables based on a related column

44. What does DBMS stand for?

Database Managing Software

Data Backup Management System

Database Management System

Data Business Modeling Software

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

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

Constraint

Join

Alias

Function

47. What is a foreign key?

A field that stores user passwords

A key used in multiple databases

A duplicate of a primary key

A field that links one table to another

48. What is a primary key?

A field that uniquely identifies a record

A field that allows null values

A field used only for sorting

A duplicated field

49. What is data redundancy?

Repeating the same data unnecessarily

Compressing data

Losing data

Encrypting data

50. What is data integrity in databases?

Ensuring data remains accurate and consistent

Combining data

Encrypting the data

Sorting tables

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

ECAT Introduction to Computers Online Test
ECAT Physics Optical Instruments 1 Test Online
ECAT Computer File Handling in “C” Test Online
ECAT Computer Functions in “C” Test Online
ECAT Computer Loop Constructs Test Online
ECAT Computer Decision Constructs Test Online
ECAT Computer Input Output Test Online
ECAT Computer Elements of “C” Test Online
ECAT Computer Getting Started with “C” Test Online
ECAT Computer Science Microsoft Access-Forms and Reports Tes...

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

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

Your Related

ECAT English Antonyms 7 Online Test

ECAT Physics Current Electricity Online Test

ECAT Computer Science Security Copyright and the Law Test Online

ECAT English Vocabulary 8 Online Test

ECAT Computer Science Database Design Process Test Online

UET Lahore, Taxila ECAT Maths Entry Test Online Preparation

Leave a Reply Cancel reply