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?

Random Data Management Software

Relational Database Management System

Real Data Backup and Management System

Registered Data-Based Model Software

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

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

Column

Attribute

Row

Relation

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

JOIN

CONNECT

UNION

COMBINE

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

DELETE

UPDATE

INSERT

SELECT

6. What is an attribute in a database?

A data field or column

A unique row

A set of tables

A duplicate record

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

CREATE DATABASE

NEW DATABASE

BUILD DATABASE

MAKE DATABASE

8. What is data integrity in databases?

Ensuring data remains accurate and consistent

Combining data

Sorting tables

Encrypting the data

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

REMOVE

DELETE

TRUNCATE

DROP

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

DROP

SELECT

REMOVE

DELETE

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

ORDER BY

GROUP BY

SELECT

WHERE

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

SELECT

DELETE

UPDATE

INSERT

13. What does SQL stand for?

Simplified Query Language

Structured Quick Language

Server Query Language

Structured Query Language

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

LIMIT

RANGE

SIZE

MAX

15. What is a record in a database?

A table of values

A column of data

A file format

A row representing one entry

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

DELETE removes records one by one, TRUNCATE removes all instantly

DELETE is faster

TRUNCATE allows WHERE clause

DELETE removes structure, TRUNCATE removes records

17. What is the purpose of normalization?

To reduce redundancy and improve data integrity

To duplicate data

To convert data to audio format

To slow down database queries

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

Composite key

Primary key

Foreign key

Secondary key

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

ORDER BY

FROM

SELECT

WHERE

20. What is the result of a JOIN operation?

Deletion of a record

Insertion of a row

Combining rows from multiple tables based on a related column

Encrypting values

21. What does DBMS stand for?

Data Business Modeling Software

Database Managing Software

Database Management System

Data Backup Management System

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

UNIQUE

GROUP BY

FILTER

DISTINCT

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

24. What is a view in SQL?

A virtual table created from a SELECT query

A stored procedure

A primary key

A physical table

25. What is a composite key?

A duplicated primary key

A key made of multiple columns

A single key used across tables

A foreign key

Page 2 of 2

26. What is a field in a database?

A single piece of data in a record

A collection of tables

A group of records

A data file

27. What is a database index used for?

Encrypting data

Storing records

Backing up data

Increasing search speed

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

LABEL

RENAME

CHANGE

29. Which of the following is a NoSQL database?

Oracle

MongoDB

PostgreSQL

MySQL

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

Oracle

Adobe Reader

Microsoft Excel

MS Paint

31. What is data redundancy?

Losing data

Encrypting data

Compressing data

Repeating the same data unnecessarily

32. Which one is not an SQL data type?

DATE

TEXT

DISPLAY

VARCHAR

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

Relational

Spreadsheet

Network

Hierarchical

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

CREATE TABLE

MAKE TABLE

NEW TABLE

BUILD TABLE

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

GIVE

ALLOW

GRANT

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

DEFAULT

NOT NULL

UNIQUE

CHECK

37. Which of these is a relational database?

MySQL

Windows

Gmail

Google

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

COMPARE

39. What is the default sort order in SQL?

Alphabetical

Random

Descending

Ascending

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

COUNT()

AVG()

TOTAL()

SUM()

41. What is a primary key?

A duplicated field

A field that uniquely identifies a record

A field that allows null values

A field used only for sorting

42. What does ERD stand for?

Extended Relational Data

Entry Record Document

Entity Relational Design

Entity Relationship Diagram

43. Which is the correct order of SQL execution?

SELECT → FROM → WHERE

SELECT → WHERE → FROM

FROM → SELECT → WHERE

FROM → WHERE → SELECT

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

MODIFY

REPAIR

UPDATE

ALTER

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

Join

Function

Constraint

Alias

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

WHERE

HAVING

SELECT

ORDER

47. What does NULL represent in a database?

A missing or unknown value

A false value

A zero value

An empty space

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

INSERT

DELETE

UPDATE

SELECT

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

FILTER

GROUP BY

WHERE

ORDER BY

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

Browser

Spreadsheet

Operating system

Database

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

NED-Karachi ECAT English Entry Test Online Preparation

ECAT Mathematics Inverse Trigonometric Functions Online Test

ECAT Mathematics Functions and Limits Online Test

ECAT Chemistry Thermochemistry Online Test

ECAT Chemistry Environmental Chemistry Test Online

ECAT Physics Electronics MCQS Online Test

Leave a Reply Cancel reply