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

DEFAULT

UNIQUE

CHECK

NOT NULL

2. What does NULL represent in a database?

A false value

A missing or unknown value

An empty space

A zero value

3. What does DBMS stand for?

Data Backup Management System

Data Business Modeling Software

Database Managing Software

Database Management System

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

REMOVE

DROP

DELETE

SELECT

5. What is a view in SQL?

A physical table

A primary key

A stored procedure

A virtual table created from a SELECT query

6. What is data integrity in databases?

Combining data

Encrypting the data

Ensuring data remains accurate and consistent

Sorting tables

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

Database

Operating system

Browser

Spreadsheet

8. What does ERD stand for?

Extended Relational Data

Entry Record Document

Entity Relationship Diagram

Entity Relational Design

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

CONNECT

JOIN

COMBINE

UNION

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

SELECT

INSERT

UPDATE

DELETE

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

Alias

Constraint

Function

Join

12. What is a database index used for?

Backing up data

Encrypting data

Increasing search speed

Storing records

13. What is a record in a database?

A table of values

A column of data

A file format

A row representing one entry

14. What is a field in a database?

A data file

A collection of tables

A single piece of data in a record

A group of records

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

Secondary key

Foreign key

Primary key

Composite key

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

ALTER

UPDATE

REPAIR

MODIFY

17. Which of these is a relational database?

Gmail

MySQL

Windows

Google

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

DELETE removes structure, TRUNCATE removes records

TRUNCATE allows WHERE clause

DELETE removes records one by one, TRUNCATE removes all instantly

DELETE is faster

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

SELECT

FROM

WHERE

ORDER BY

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

COUNT()

SUM()

TOTAL()

AVG()

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

BUILD DATABASE

NEW DATABASE

CREATE DATABASE

MAKE DATABASE

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

CREATE TABLE

NEW TABLE

MAKE TABLE

BUILD TABLE

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

MAX

RANGE

SIZE

LIMIT

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

DELETE

TRUNCATE

REMOVE

DROP

25. What is the purpose of normalization?

To convert data to audio format

To reduce redundancy and improve data integrity

To slow down database queries

To duplicate data

Page 2 of 2

26. What is a foreign key?

A key used in multiple databases

A field that stores user passwords

A field that links one table to another

A duplicate of a primary key

27. What is a primary key?

A field that allows null values

A field that uniquely identifies a record

A field used only for sorting

A duplicated field

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

A report format

A structure of tables and relationships

A data entry form

A backup of data

29. What is the default sort order in SQL?

Ascending

Descending

Random

Alphabetical

30. Which one is not an SQL data type?

VARCHAR

DATE

TEXT

DISPLAY

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

GRANT

GIVE

ALLOW

32. What is the full form of RDBMS?

Registered Data-Based Model Software

Real Data Backup and Management System

Relational Database Management System

Random Data Management Software

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

GROUP BY

WHERE

ORDER BY

SELECT

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

Relational

Spreadsheet

Network

Hierarchical

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

SELECT

WHERE

ORDER

HAVING

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

UNIQUE

DISTINCT

FILTER

GROUP BY

37. What is a composite key?

A foreign key

A key made of multiple columns

A single key used across tables

A duplicated primary key

38. What is data redundancy?

Repeating the same data unnecessarily

Encrypting data

Compressing data

Losing data

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

Column

Row

Attribute

Relation

40. What is an attribute in a database?

A data field or column

A unique row

A set of tables

A duplicate record

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

COMPARE

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

Adobe Reader

Oracle

MS Paint

Microsoft Excel

43. Which of the following is a NoSQL database?

MongoDB

MySQL

Oracle

PostgreSQL

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

INSERT

SELECT

UPDATE

DELETE

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

INSERT

DELETE

UPDATE

SELECT

46. What is the result of a JOIN operation?

Encrypting values

Insertion of a row

Combining rows from multiple tables based on a related column

Deletion of a record

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

CHANGE

RENAME

LABEL

48. What does SQL stand for?

Simplified Query Language

Structured Quick Language

Server Query Language

Structured Query Language

49. Which is the correct order of SQL execution?

FROM → WHERE → SELECT

FROM → SELECT → WHERE

SELECT → FROM → WHERE

SELECT → WHERE → FROM

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

ORDER BY

WHERE

FILTER

GROUP BY

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

Latest Updates

Autodesk 3ds Max Test Online
Computer Security Copyright and the Law Test Online
Important Shortcuts Keys of Computer Keyboard Test Online
MS Windows OS Test Online
Adobe Photoshop Test Online
Google History Test Online
MS PowerPoint Shortcuts Keys Test 2 Online
Computer Information Networks 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