Computer Basic Concepts and Terminology of Databases Test Online

Mustansar KhanLast Updated: October 15, 2025

Important Basics Concepts and Terminology of Databases Question and Answer

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

Basics Concepts and Terminology of Databases Practice Test Online With Explanation

Please wait...

Page 1 of 2

Uncategorized

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

CREATE TABLE

MAKE TABLE

NEW TABLE

BUILD TABLE

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

INSERT

DELETE

SELECT

UPDATE

3. What does ERD stand for?

Entry Record Document

Entity Relationship Diagram

Entity Relational Design

Extended Relational Data

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

ORDER BY

GROUP BY

SELECT

WHERE

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

Foreign key

Secondary key

Composite key

Primary key

6. Which one is not an SQL data type?

VARCHAR

DISPLAY

DATE

TEXT

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

CHANGE

LABEL

RENAME

8. What is a field in a database?

A data file

A collection of tables

A group of records

A single piece of data in a record

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

RANGE

SIZE

LIMIT

MAX

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

TOTAL()

AVG()

COUNT()

SUM()

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

Network

Relational

Hierarchical

Spreadsheet

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

ORDER BY

FILTER

GROUP BY

WHERE

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

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

UNIQUE

CHECK

NOT NULL

DEFAULT

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

Relation

Column

Row

Attribute

16. What is a view in SQL?

A physical table

A stored procedure

A primary key

A virtual table created from a SELECT query

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

NEW DATABASE

CREATE DATABASE

BUILD DATABASE

MAKE DATABASE

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

A report format

A data entry form

A structure of tables and relationships

A backup of data

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

COMPARE

20. What is data redundancy?

Losing data

Encrypting data

Compressing data

Repeating the same data unnecessarily

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

SELECT

INSERT

UPDATE

DELETE

22. What is a foreign key?

A field that stores user passwords

A duplicate of a primary key

A field that links one table to another

A key used in multiple databases

23. What is the full form of RDBMS?

Relational Database Management System

Real Data Backup and Management System

Registered Data-Based Model Software

Random Data Management Software

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

DROP

REMOVE

DELETE

SELECT

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

Join

Alias

Function

Constraint

Page 2 of 2

26. What is a database index used for?

Storing records

Encrypting data

Backing up data

Increasing search speed

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

Microsoft Excel

Oracle

MS Paint

Adobe Reader

28. What does DBMS stand for?

Database Managing Software

Database Management System

Data Backup Management System

Data Business Modeling Software

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

HAVING

SELECT

ORDER

WHERE

30. What is a composite key?

A key made of multiple columns

A foreign key

A duplicated primary key

A single key used across tables

31. What is a primary key?

A field that uniquely identifies a record

A field used only for sorting

A duplicated field

A field that allows null values

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

INSERT

SELECT

DELETE

UPDATE

33. What does NULL represent in a database?

A missing or unknown value

A zero value

A false value

An empty space

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

Operating system

Browser

Database

Spreadsheet

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

FILTER

DISTINCT

UNIQUE

GROUP BY

36. What is the default sort order in SQL?

Random

Alphabetical

Descending

Ascending

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

JOIN

UNION

COMBINE

CONNECT

38. Which of these is a relational database?

Google

MySQL

Gmail

Windows

39. What does SQL stand for?

Server Query Language

Structured Query Language

Structured Quick Language

Simplified Query Language

40. What is data integrity in databases?

Ensuring data remains accurate and consistent

Combining data

Encrypting the data

Sorting tables

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

FROM

WHERE

ORDER BY

SELECT

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

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

GRANT

GIVE

ALLOW

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

ALTER

REPAIR

MODIFY

UPDATE

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

TRUNCATE

REMOVE

DELETE

DROP

46. What is an attribute in a database?

A duplicate record

A unique row

A data field or column

A set of tables

47. Which is the correct order of SQL execution?

SELECT → WHERE → FROM

FROM → SELECT → WHERE

FROM → WHERE → SELECT

SELECT → FROM → WHERE

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

49. Which of the following is a NoSQL database?

Oracle

MySQL

PostgreSQL

MongoDB

50. What is a record in a database?

A table of values

A row representing one entry

A column of data

A file format

Can't find what you're looking for? Search below:

Latest Updates

Computer Files Extensions Types and Meanings Test 2 Online
Computer Abbreviation Test 1 Online
Computer Fundamentals of Internet Test Online
PHP Mcqs Test Online
Computer Basic of Information Technology Test Online
Computer Fortran Online Test
Computer MS Excel Shortcuts Keys Test 3 Online
Database Management System (DBMS) Test Online

Mustansar KhanLast Updated: October 15, 2025

Important Basics Concepts and Terminology of Databases Question and Answer

Basics Concepts and Terminology of Databases Practice Test Online With Explanation

Uncategorized

Latest Updates

Mustansar Khan

Leave a Reply Cancel reply