26. The process of dividing a database into two or more separate databases is called:
A) Partitioning
B) Replication
C) Sharding
D) Clustering
Answer: C
27. Which SQL function is used to calculate the total sum of values in a column?
A) TOTAL()
B) SUM()
C) COUNT()
D) AVG()
Answer: B
28. Which type of database is optimized for read-heavy workloads and high availability?
A) OLAP database
B) OLTP database
C) NoSQL database
D) In-memory database
Answer: C
29. A database transaction must have the properties of:
A) Consistency and atomicity
B) Isolation and reliability
C) Atomicity and durability
D) Isolation and consistency
Answer: C
30. Which SQL command is used to create a new database?
A) CREATE DATABASE
B) NEW DATABASE
C) ADD DATABASE
D) MAKE DATABASE
Answer: A
