Home/Computer/Computer Basic Concepts and Terminology of Databases Test Online

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?

UNIQUE

CHECK

DEFAULT

NOT NULL

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

LIMIT

MAX

RANGE

SIZE

3. Which one is not an SQL data type?

DISPLAY

VARCHAR

TEXT

DATE

4. What is an attribute in a database?

A set of tables

A duplicate record

A unique row

A data field or column

5. Which is the correct order of SQL execution?

FROM → SELECT → WHERE

SELECT → FROM → WHERE

SELECT → WHERE → FROM

FROM → WHERE → SELECT

6. What is data integrity in databases?

Encrypting the data

Ensuring data remains accurate and consistent

Combining data

Sorting tables

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

DROP

REMOVE

TRUNCATE

DELETE

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

INSERT

UPDATE

DELETE

SELECT

9. What does SQL stand for?

Simplified Query Language

Structured Quick Language

Server Query Language

Structured Query Language

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

INSERT

DELETE

SELECT

UPDATE

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

Relational

Hierarchical

Spreadsheet

Network

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

Function

Join

Alias

Constraint

13. What is the purpose of normalization?

To convert data to audio format

To slow down database queries

To duplicate data

To reduce redundancy and improve data integrity

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

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

Spreadsheet

Operating system

Browser

Database

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

17. What does DBMS stand for?

Database Management System

Data Backup Management System

Database Managing Software

Data Business Modeling Software

18. What is data redundancy?

Repeating the same data unnecessarily

Losing data

Compressing data

Encrypting data

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

MAKE DATABASE

CREATE DATABASE

BUILD DATABASE

NEW DATABASE

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

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

DISTINCT

FILTER

UNIQUE

GROUP BY

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

Microsoft Excel

MS Paint

Adobe Reader

Oracle

23. What is a view in SQL?

A virtual table created from a SELECT query

A stored procedure

A physical table

A primary key

24. What is a database index used for?

Increasing search speed

Encrypting data

Storing records

Backing up data

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

BUILD TABLE

CREATE TABLE

MAKE TABLE

NEW TABLE

Page 2 of 2

26. What is a foreign key?

A field that stores user passwords

A duplicate of a primary key

A key used in multiple databases

A field that links one table to another

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

Attribute

Column

Row

Relation

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

SELECT

FROM

WHERE

ORDER BY

29. Which of these is a relational database?

Windows

Gmail

MySQL

Google

30. What is a field in a database?

A single piece of data in a record

A collection of tables

A data file

A group of records

31. What is a composite key?

A single key used across tables

A key made of multiple columns

A duplicated primary key

A foreign key

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

DROP

DELETE

REMOVE

SELECT

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

WHERE

ORDER BY

SELECT

GROUP BY

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

Primary key

Secondary key

Composite key

Foreign key

35. What does ERD stand for?

Entry Record Document

Entity Relational Design

Entity Relationship Diagram

Extended Relational Data

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

RENAME

CHANGE

LABEL

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

UPDATE

ALTER

REPAIR

MODIFY

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

39. What is a record in a database?

A row representing one entry

A table of values

A file format

A column of data

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

SELECT

ORDER

HAVING

WHERE

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

COMPARE

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

TOTAL()

AVG()

SUM()

COUNT()

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

INSERT

DELETE

SELECT

UPDATE

44. What is the default sort order in SQL?

Descending

Alphabetical

Ascending

Random

45. Which of the following is a NoSQL database?

PostgreSQL

MySQL

MongoDB

Oracle

46. What is the result of a JOIN operation?

Insertion of a row

Deletion of a record

Combining rows from multiple tables based on a related column

Encrypting values

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

ORDER BY

GROUP BY

WHERE

FILTER

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

ALLOW

GRANT

GIVE

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

CONNECT

COMBINE

UNION

JOIN

50. What does NULL represent in a database?

A missing or unknown value

A zero value

A false value

An empty space

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

Introduction to Computers Online Test
Computer File Handling in “C” Test Online
Computer Functions in “C” Test Online
Computer Loop Constructs Test Online
Computer Decision Constructs Test Online
Computer Input Output Test Online
Computer Elements of “C” Test Online
Computer Getting Started with “C” Test Online
Computer Microsoft Access-Forms and Reports Test Online
Computer Table and Query Test Online

Mustansar KhanLast Updated: October 15, 2025

Computer Basic Concepts and Terminology of Databases Test Online

Important Basics Concepts and Terminology of Databases Question and Answer

Basics Concepts and Terminology of Databases Practice Test Online With Explanation

Uncategorized

Related Posts

Mustansar Khan

Leave a Reply Cancel reply