Database Knowledge Assessment

What does DBMS stand for?

• Data Base Management System

• Data Base Memory System

• Digital Base Management System

• Data Backup Management System

• Digital Backup Memory System

Which of the following is not a type of database?

• Relational Database

• Object-Oriented Database

• NoSQL Database

• Algorithmic Database

• Hierarchical Database

What is the role of a Primary Key in a database?

• Link different tables together

• Uniquely identify data in a table

• Determine the order of data display

• Store duplicate values

• Prevent data deletion

What is the meaning of SQL?

• System Query Language

• Structured Question Language

• Structured Query Language

• System Question Language

• Systematic Query Language

What is the purpose of Normalization in a database?

• Increase the speed of data retrieval

• Reduce data redundancy

• Increase storage space

• Prevent data loss

• Enhance data security

What does ACID stand for in a database system?

• Atomicity, Consistency, Isolation, Durability

• Availability, Consistency, Integration, Distribution

• Accuracy, Completeness, Integrity, Dependency

• Atomicity, Completeness, Isolation, Distribution

• Accuracy, Consistency, Integration, Durability

Which of the following is not a type of JOIN in a database?

• INNER JOIN

• LEFT JOIN

• RIGHT JOIN

• FULL JOIN

• MIDDLE JOIN

What is the purpose of creating an Index in a database?

Which of the following is not a type of JOIN in a database?

• INNER JOIN

• LEFT JOIN

• RIGHT JOIN

• FULL JOIN

• MIDDLE JOIN

What is the benefit of creating an Index in a database?

• Reduce storage space

• Increase search speed

• Prevent accidental data deletion

• Enhance data security

• Reduce data redundancy