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 command is used to remove records from a table?

DROP

SELECT

REMOVE

DELETE

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

BUILD DATABASE

NEW DATABASE

MAKE DATABASE

CREATE DATABASE

3. What is a composite key?

A foreign key

A duplicated primary key

A key made of multiple columns

A single key used across tables

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

COMBINE

JOIN

UNION

CONNECT

5. What is the default sort order in SQL?

Random

Ascending

Alphabetical

Descending

6. Which of these is a relational database?

Gmail

MySQL

Windows

Google

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

Database

Operating system

Spreadsheet

Browser

8. What is an attribute in a database?

A data field or column

A unique row

A set of tables

A duplicate record

9. What does DBMS stand for?

Database Managing Software

Database Management System

Data Backup Management System

Data Business Modeling Software

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

MAKE TABLE

BUILD TABLE

CREATE TABLE

NEW TABLE

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

FILTER

WHERE

GROUP BY

ORDER BY

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

Relation

Row

Column

Attribute

13. What is the full form of RDBMS?

Registered Data-Based Model Software

Relational Database Management System

Real Data Backup and Management System

Random Data Management Software

14. What is the result of a JOIN operation?

Insertion of a row

Combining rows from multiple tables based on a related column

Deletion of a record

Encrypting values

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

REMOVE

TRUNCATE

DELETE

DROP

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

LABEL

RENAME

CHANGE

17. What does ERD stand for?

Extended Relational Data

Entity Relationship Diagram

Entry Record Document

Entity Relational Design

18. What is a foreign key?

A key used in multiple databases

A duplicate of a primary key

A field that stores user passwords

A field that links one table to another

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

TRUNCATE allows WHERE clause

DELETE is faster

DELETE removes records one by one, TRUNCATE removes all instantly

DELETE removes structure, TRUNCATE removes records

20. Which is the correct order of SQL execution?

FROM → WHERE → SELECT

SELECT → FROM → WHERE

FROM → SELECT → WHERE

SELECT → WHERE → FROM

21. What is a database index used for?

Increasing search speed

Storing records

Encrypting data

Backing up data

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

ORDER BY

WHERE

SELECT

FROM

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

UPDATE

DELETE

SELECT

INSERT

24. What is the purpose of normalization?

To reduce redundancy and improve data integrity

To slow down database queries

To duplicate data

To convert data to audio format

25. What does SQL stand for?

Simplified Query Language

Server Query Language

Structured Query Language

Structured Quick Language

Page 2 of 2

26. What is data redundancy?

Encrypting data

Compressing data

Repeating the same data unnecessarily

Losing data

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

GROUP BY

SELECT

ORDER BY

WHERE

28. Which of the following is a NoSQL database?

MySQL

PostgreSQL

MongoDB

Oracle

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

Primary key

Secondary key

Foreign key

Composite key

30. What is a field in a database?

A single piece of data in a record

A data file

A collection of tables

A group of records

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

LIMIT

SIZE

MAX

RANGE

32. What is a view in SQL?

A physical table

A stored procedure

A virtual table created from a SELECT query

A primary key

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

TOTAL()

SUM()

AVG()

COUNT()

34. What is data integrity in databases?

Ensuring data remains accurate and consistent

Encrypting the data

Combining data

Sorting tables

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

A data entry form

A structure of tables and relationships

A backup of data

A report format

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

Function

Join

Constraint

Alias

37. What is a primary key?

A field that uniquely identifies a record

A duplicated field

A field used only for sorting

A field that allows null values

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

GROUP BY

DISTINCT

UNIQUE

FILTER

39. What is a record in a database?

A column of data

A file format

A row representing one entry

A table of values

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

Oracle

Microsoft Excel

Adobe Reader

MS Paint

41. Which one is not an SQL data type?

DISPLAY

TEXT

DATE

VARCHAR

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

ORDER

HAVING

SELECT

WHERE

43. What does NULL represent in a database?

An empty space

A false value

A zero value

A missing or unknown value

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

CHECK

DEFAULT

NOT NULL

UNIQUE

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

MODIFY

ALTER

UPDATE

REPAIR

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

COMPARE

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

ALLOW

GRANT

GIVE

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

SELECT

INSERT

UPDATE

DELETE

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

INSERT

SELECT

UPDATE

DELETE

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

Hierarchical

Spreadsheet

Network

Relational

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

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 Statistics Test Set 16

NUST-Rawalpindi ECAT English Entry Test Preparation Online

ECAT Computer Science Word Processing Test Online

Mehran University Sindh ECAT English Entry Test Online Preparation

ECAT Computer Arithmetic And Number System Test Online

ECAT Computer Science Data Communications Test Online

Leave a Reply Cancel reply