Grade 12 Quizzes , Questions & Answers

Recent Grade 12 Quizzes

This Database Caching Basics Quiz tests your understanding of caching strategies used to improve database performance. Learn how caches store frequently accessed data, reduce query times, and decrease database load. Designed for...

Questions: 15 | Attempts: 10 | Last updated: May 1, 2026

Sample Question
What is the primary purpose of a cache in a database system?

To permanently store all database records

To temporarily store frequently accessed data for faster retrieval

To encrypt sensitive information

To replace the main database entirely

Horizontal Partitioning Basics Quiz

This Horizontal Partitioning Basics Quiz assesses your understanding of how databases distribute data across multiple servers. You'll explore key concepts like range-based and hash-based partitioning, sharding strategies, and the...

Questions: 15 | Attempts: 15 | Last updated: May 1, 2026

Sample Question
What is horizontal partitioning?

Dividing rows of data across multiple servers based on a partition key

Dividing columns of a table into separate tables

Creating backup copies of an entire database

Splitting a single server into multiple virtual machines

Database Partitioning Basics Quiz

This Database Partitioning Basics Quiz evaluates your understanding of how databases distribute data across multiple servers and storage systems. Learn key concepts like horizontal and vertical partitioning, sharding strategies,...

Questions: 15 | Attempts: 10 | Last updated: May 1, 2026

Sample Question
What is database partitioning?

Dividing a database into smaller, independent subsets of data

Creating backup copies of the entire database

Encrypting sensitive database records

Compressing database files to save storage space

Clustered Index Basics Quiz

This Clustered Index Basics Quiz evaluates your understanding of how databases organize and retrieve data efficiently. Learn the core concepts of clustered indexes, including their structure, benefits, and role in query...

Questions: 15 | Attempts: 10 | Last updated: May 1, 2026

Sample Question
What is a clustered index?

An index that sorts and stores table rows physically in the index order

An index that groups multiple unrelated tables together

An index that randomly arranges data for faster access

An index that only stores column names without data

Transaction Log Basics Quiz

This Transaction Log Basics Quiz evaluates your understanding of how databases use transaction logs for data recovery and system reliability. You'll explore log structures, write-ahead logging, recovery protocols, and the role of...

Questions: 15 | Attempts: 10 | Last updated: May 1, 2026

Sample Question
What is the primary purpose of a transaction log in a database system?

To record all changes made by transactions for recovery purposes

To display user activity on the database

To monitor network traffic

To store user passwords

Read Committed Isolation Quiz

This Read Committed Isolation Quiz tests your understanding of one of the most widely used database isolation levels. Learn how Read Committed prevents dirty reads while allowing other anomalies, and explore its trade-offs...

Questions: 15 | Attempts: 14 | Last updated: May 1, 2026

Sample Question
What is the primary characteristic of Read Committed isolation level?

Allows dirty reads and phantom reads

Prevents dirty reads but allows non-repeatable reads

Provides full serializability

Locks all rows for the entire transaction

Transaction Isolation Basics Quiz

Test your understanding of transaction isolation in databases with this Transaction Isolation Basics Quiz. Learn how isolation levels prevent data conflicts and ensure data consistency across concurrent transactions. This quiz...

Questions: 15 | Attempts: 10 | Last updated: May 1, 2026

Sample Question
What is a transaction in a database?

A single database operation

A sequence of operations treated as one atomic unit

A permanent change to the database

A backup of the database

Database Isolation Basics Quiz

This Database Isolation Basics Quiz tests your understanding of isolation levels and their role in maintaining data consistency. Learn how databases prevent conflicts between concurrent transactions and why isolation matters in...

Questions: 15 | Attempts: 12 | Last updated: May 1, 2026

Sample Question
What does the 'I' in ACID stand for?

Integrity

Isolation

Index

Input

SQL GRANT Statement Quiz

This SQL GRANT Statement Quiz tests your understanding of Data Control Language (DCL) and how to manage database permissions. Learn to grant and revoke user privileges, control access to database objects, and implement security...

Questions: 15 | Attempts: 12 | Last updated: May 1, 2026

Sample Question
Which SQL statement is used to give permissions to a user on a database object?

GRANT

PERMIT

ALLOW

AUTHORIZE

SQL DCL Basics Quiz

This SQL DCL Basics Quiz evaluates your understanding of Data Control Language commands that manage user permissions and access in databases. You'll test your knowledge of GRANT, REVOKE, and related security concepts essential...

Questions: 16 | Attempts: 11 | Last updated: May 1, 2026

Sample Question
What does DCL stand for in SQL?

Data Control Language

Database Constraint Logic

Data Compilation Layer

Dynamic Connection Link

« Previous 1...85 86 87 888990 91 92 93...385 Next »