FDS Final Activity

What does DBMS stand for?

• Data Building Management System

• Database Management System

• Digital Business Management Software

• Dynamic Backup Management System

In a relational database, what is a primary key?

• A key used for accessing data in another table

• A key used to uniquely identify each record in a table

• A key used for encryption purposes

• A key used for sorting records in a table

What is SQL?

• Structured Query Language

• Simple Query Language

• Systematic Query Logic

• Standardized Query Language

Which SQL command is used to retrieve data from a database?

• INSERT

• SELECT

• UPDATE

• DELETE

What is normalization in DBMS?

• The process of reducing redundancy and dependency by dividing a large table into smaller tables and defining relationships between them

• The process of adding redundancy to improve data integrity

• The process of encrypting sensitive data in the database

• The process of optimizing database queries for faster performance

What is a foreign key in a relational database?

• A key that uniquely identifies each record in a table

• A key used for encrypting sensitive data

• A key used for sorting records in a table

• A key that establishes a relationship between two tables

1. Which of the following is not a function of a Database Administrator (DBA)?

• Database design

• Database security

• Database development

• Database marketing

13. Which of the following is NOT a valid data type in SQL?

• Float

• Boolean

• Date

• String

21. What is Data Manipulation Language (DML) in the context of a database?

• A language used to define the structure of a database

• A language used for managing database security

• A language used for querying and modifying data in a database

• A language used for optimizing database performance

22. Which of the following SQL statements is an example of a DML statement?

• CREATE TABLE

• GRANT

• SELECT

• ALTER TABLE