Font size
WorksheetsWeek 1 - Topic 1 SECP3623-02
Total questions: 20
Worksheet time: 7mins
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 (a) .
The function of DML (Data Manipulation Language) includes:
Defining schema
Creating tables
Querying and modifying data
Enforcing user roles
Which of the following is an example of DDL statement?
INSERT INTO
SELECT * FROM
CREATE TABLE
UPDATE
Which user is mainly responsible for defining access control policies in DBMS?
Application Developer
Database Administrator
End User
System Analyst
Which database type best handles large volumes of unstructured social media data?
Hierarchical DB
Relational DB
NoSQL DB
Network DB
(a) data is organized in rows and columns.
Which statement about foreign keys is TRUE?
Can reference non-existing records
Used to link tables ensuring referential integrity
Can duplicate primary key values
Must be unique
What does the “data recovery” function of DBMS handle?
Backup and restore from system failure
Prevent SQL injection
Auto-encrypt sensitive data
Handle schema changes
Which modern trend allows horizontal scalability and distributed data storage?
File-based storage
Cloud databases
Relational databases
Local flat files
A (a) key uniquely identifies each record in a table.
A database that stores JSON documents is called a (a) database.
A (a) database allows horizontal scalability and cloud storage.
