Week 1 - Topic 1 SECP3623-02

Which statement best defines a database?

• Set of unrelated files

• Self-describing collection of integrated records

• A storage of raw unlinked data

• A spreadsheet with multiple sheets

Which of the following is NOT a function of a DBMS?

• Data manipulation

• Data definition

• Data encryption

• Hardware management

What does a self-describing database mean?

• It stores user manuals

• It documents itself externally

• Metadata is stored within the database

• It has no need for data dictionary

In relational databases, relationships are implemented through:

• Triggers

• Views

• Stored procedures

• Joins using primary and foreign keys

Which of the following correctly differentiates relational and non-relational databases?

• Relational: flexible schema / Non-relational: fixed schema

• Relational: table-based / Non-relational: document or key-value based

• Both use identical schema

• Both only handle unstructured data

Which of the following is a superkey?

• A single attribute uniquely identifying a record

• Minimal set of attributes that uniquely identify a record

• Any combination of attributes that uniquely identify a record

• A non-unique identifier used for indexing

Which constraint ensures entity integrity?

• Primary key constraint

• Unique constraint

• Foreign key constraint

• Check constraint

Which of the following is always a candidate key?

• Foreign key

• Superkey with no redundant attribute

• Composite key

• Index key

The process of reducing data redundancy is called ______.

The function of DML (Data Manipulation Language) includes:

• Defining schema

• Creating tables

• Querying and modifying data

• Enforcing user roles