Online Quiz Attempt – Play & Test Your Knowledge

Quizzes on DBMS Fundamentals

Read questions carefully before answering

Back to quizzes Help

⏱ 00:00

Dashboard
My Profile
Quiz Attempt
Logout

Question 1

1 / 10

Which of the following is NOT a characteristic of a relational DBMS?

Data integrity enforcement Physical data independence Procedural data manipulation Consistent data storage

Question 2

2 / 10

What does ACID stand for in the context of database transactions?

Atomicity, Consistency, Isolation, Durability Accessibility, Correctness, Integrity, Dependability Authorization, Control, Inheritance, Delegation Availability, Capacity, Interoperability, Distribution

Question 3

3 / 10

Which SQL command is used to modify the structure of an existing table?

UPDATE ALTER MODIFY CHANGE

Question 4

4 / 10

What is the purpose of normalization in database design?

To improve query performance by reducing data redundancy To complicate data retrieval processes To decrease storage space by increasing redundancy To encrypt the database for security

Question 5

5 / 10

What is a 'view' in a database?

A physical table stored on disk A virtual table derived from one or more base tables A security mechanism to prevent unauthorized access A backup copy of the database

Question 6

6 / 10

Which type of database key uniquely identifies each record in a table and cannot contain NULL values?

Foreign Key Composite Key Primary Key Candidate Key

Question 7

7 / 10

What is the main function of a database index?

To enforce data integrity constraints To speed up data retrieval operations To encrypt data during transmission To compress the database size

Question 8

8 / 10

Which concurrency control technique involves placing locks on data items to prevent conflicting access?

Timestamp ordering Two-phase locking Optimistic concurrency control Multi-version concurrency control

Question 9

9 / 10

What is the purpose of the 'GROUP BY' clause in SQL?

To filter rows based on a condition To sort the result set To aggregate rows based on similar values in one or more columns To join two or more tables

Question 10

10 / 10

Which of the following is an example of a NoSQL database?

MySQL PostgreSQL Oracle MongoDB

Total Questions : 10

Answered Marked Not Visited

Instructions: Navigation between questions is allowed. Only selected answers will be saved.

💾 All answers are auto-saved • Do not refresh or close the page