База данных Вопросы

Who is responsible for designing and managing the database?

• Database Administrator

• Network Technician

• Security Service

• End User

Which of the following is not an example of a DBMS?

• MySQL

• Python

• Oracle

• PostgreSQL

What does the Data Definition Language (DDL) do?

• Defines the database schema

• Encrypts user passwords

• Creates data backups

• Creates user interfaces

What is stored in the data dictionary?

• User credentials

• Backup logs

• Metadata about the database structure

• Application source code

What uniquely identifies each record in a relational table?

• Foreign key

• Attribute

• Primary key

• Index

What is DML?

• Design Language for Display

• Data Manipulation Language

• Database Migration Layer

• Device Management Logic

Which of the following is a commercial DML?

• Relational calculus

• SQL

• Assembler

• DDL

What does DCL mean?

• Direct Code Compiler

• Data Control Language

• Distributed Connection Level

• Domain Constraint Logic

Which command is used in DCL to grant access?

• DENY

• ADD

• GRANT

• INSERT

Which command removes a user's access in DCL?

• DELETE

• DELETE

• REVOKE

• DENY