데이터베이스 시스템 퀴즈

What is the purpose of a database system?

• Data storage

• Data analysis

• Data visualization

• Data transmission

What are the basic components of a relational database?

• Server

• Cloud

• File

• Table

What is the command to insert data in SQL?

• SELECT

• DELETE

• INSERT

• UPDATE

What database design principle does the Boyce-Codd Normal Form correspond to?

• Integrity constraints

• Normalization

• Data manipulation

• Data modeling

What are the pitfalls to avoid in relational database design?

• Data redundancy

• Denormalization

• Normalization

• Data integrity

What is the primary key in a relational database?

• A database table

• A unique identifier for a record

• A foreign key reference

• A type of data

Which SQL command is used to update existing records?

• INSERT

• UPDATE

• ALTER

• SELECT

What does SQL stand for?

• Standard Query Language

• Sequential Query Language

• Structured Query Language

• Simple Query Language

What is a foreign key in a relational database?

• A command in SQL

• A type of data

• A reference to a primary key in another table

• A unique identifier for a record

Which SQL command is used to delete records from a table?

• DROP

• REMOVE

• TRUNCATE

• DELETE