Quiz on SGBD - Sistema Gerenciador de Banco de Dados

What does SGBD stand for?

• Sistema de Gerenciamento de Banco de Dispositivos

• Sistema Gerenciador de Banco de Dados

• Sistema de Gerenciamento de Banco de Documentos

• Sistema de Gerenciamento de Backup de Dados

What is the main purpose of a SGBD?

• To design websites

• To create new programming languages

• To develop mobile applications

• To manage large groups of information

What is the role of DDL in a SGBD architecture?

• Provide security restrictions

• Manipulate the structure of the database

• Define new tables and associated elements

• Interact with data within tables

What is the advantage of using a SGBD?

• Increase in human effort for development

• Reduction of redundancy and inconsistency of information

• Limited access to data

• Isolation of users from database details

What is the purpose of the Data Dictionary in a SGBD architecture?

• Describe the meaning, origin, and usage of data

• Provide security restrictions

• Create new tables

• Interact with data within tables

Which command is part of DML in a SGBD architecture?

• DROP

• ALTER

• CREATE

• INSERT

What does the Conceptual Level in a SGBD architecture describe?

• Total description of the database structure without data details

• Physical storage structure of the database

• Data manipulation commands

• Data dictionary details

What is the main goal of a SGBD?

• Provide high level of data abstraction

• Limit data access to applications

• Increase data redundancy

• Isolate users from internal database details

Which command is NOT part of DML in a SGBD architecture?

• UPDATE

• CREATE

• INSERT

• DELETE

What is the function of DML in a SGBD architecture?

• Provide security restrictions

• Manipulate the structure of the database

• Define new tables and associated elements

• Interact with data within tables