46. The process of removing redundant data from a database is known as:
A) Data Validation
B) Data Normalization
C) Data Cleansing
D) Data Aggregation
47. Which type of database is designed to handle large volumes of read and write operations simultaneously?
A) OLAP database
B) OLTP database
C) NoSQL database
D) In-memory database
48. In a database, a many-to-many relationship is represented using:
A) One table only
B) Two tables and a link table
C) Two tables and a foreign key
D) Three tables and a primary key
49. The process of physically dividing a database into smaller parts for better performance and management is called:
A) Clustering
B) Indexing
C) Sharding
D) Replication
50. Which SQL command is used to retrieve unique records from a database table?
A) DISTINCT
B) UNIQUE
C) DIFFERENT
D) ONLY