Database and Cryptography Quiz

Which type of DBMS is best for handling large, complex relationships?

• Hierarchical

• Network

• Relational

• Object-oriented

Which SQL clause is used to remove duplicate records from a result set?

• REMOVE

• DISTINCT

• UNIQUE

• LIMIT

Which of the following is NOT a NoSQL database?

• MongoDB

• Firebase

• PostgreSQL

• Cassandra

What is normalization in databases used for?

• Storing duplicate data

• Reducing redundancy

• Increasing redundancy

• Making queries faster

Which SQL command is used to change an existing record?

• UPDATE

• MODIFY

• CHANGE

• REPLACE

Which normal form eliminates transitive dependencies?

• 1NF

• 2NF

• 3NF

• 4NF

Which of the following is an example of a primary key?

• Email

• Name

• Address

• Password

A foreign key in a database is used to:

• Uniquely identify a record

• Connect two tables

• Speed up searches

• Encrypt data

What does ACID stand for in database transactions?

• Atomicity, Consistency, Isolation, Durability

• Availability, Consistency, Integrity, Design

• Accuracy, Clarity, Integration, Durability

• Atomicity, Clarity, Indexing, Duplication

Which of the following is a database management language?

• C++

• Python

• SQL

• HTML