WorksheetsDatabase administration and storage worksheet questions
Total questions: 42
Worksheet time: 21mins
What characterizes the Tower of Hanoi backup scheme?
Hanoi encryption
Tower queries
No tower
Uses exponential rotation for efficiency
In big data, Apache Airflow is used for what purpose?
Data deletion
Manual data loading
Encryption only
Automating data pipelines and workflows
What is a transaction log backup used for?
Backing up indexes
Encrypting transactions
Backing up the entire database
Capturing changes in the log for point-in-time recovery
What is a quiesce point?
Point encryption
No point
Quiesce queries
Consistent state for backup
In DBMS, what does the restore command do?
Applies backups to recover data
Restore encryption
No restore
Command queries
Automated archiving accomplishes what?
Manual archiving
No archiving
Archiving deletion
Moves old data
What is data archiving?
No archiving
Active data
Archiving encryption
Moving inactive data to long-term storage
What is multi-level security (MLS) in DBMS?
Supporting data with different security classifications in one database
Encryption levels
No security
Single-level only
Which storage medium has the lowest access latency?
Solid-State Drive (SSD)
Magnetic tape
Hard Disk Drive (HDD)
RAM
What is a common DBMS security vulnerability?
Weak passwords and default credentials
Strong encryption
Regular audits
Least privilege
Database forensics involves what activity?
Optimizing forensics
Deleting evidence
Investigating security incidents through logs and artifacts
Forcing data entry
Which of the following is NOT a type of database user?
Database administrators (DBA)
Application programmers
Hardware engineers
End users
What is a B-tree index commonly used for?
Fixed-height structures
Hash-based lookups only
Sequential access only
Balanced, multi-level indexing for efficient searches, inserts, and deletes
Homomorphic encryption allows:
Decrypting all data
Computations on encrypted data without decryption
Only storage
No computations
Write-Ahead Logging (WAL) ensures:
Logs deleted
Changes logged before written to disk
Data compressed
Backups ignored
Docker for DB automation:
Manual docker
Docker deletion
No docker
Containerizes DBs for portability
OLTP stands for:
Online Transaction Processing
Operational Language for Transactions
Offline Data Processing
Online Logical Transaction Protocol
RAID 1 provides:
Striping with parity
Block-level parity
Disk mirroring for fault tolerance
No redundancy
Entity integrity ensures:
Primary keys are not null
Foreign keys match primary keys
Data is encrypted
No duplicate rows
GitHub Actions for DB CI:
No actions
Manual actions
Actions deletion
Runs workflows for DB
What is a cursor in SQL?
A table
An index
A pointer to traverse result sets
A trigger
What is a 'heap file' in file organization?
Records appended in no particular order
Records clustered by index
Records stored in sorted order
Records accessed via hash functions
In sequential file organization, records are:
Hashed to buckets
Sorted by a key field
Stored randomly
Accessed via pointers
Shingled Magnetic Recording (SMR) is used in:
High-capacity HDDs with overlapping tracks
Optical disks
SSDs
RAM
In DBMS, what is a watermark?
A threshold indicating the highest allocated block in a segment (high-water mark)
Water encryption
A transaction isolation level
A backup snapshot label
What is the principle of least privilege in DBMS security?
Encrypting all data
Giving users all possible permissions
Allowing anonymous access
Granting only the minimum permissions needed for tasks
What is aggregation in ER model?
Normalizing data
Deleting entities
Treating a relationship as an entity
Combining multiple databases
In LSM-trees (Log-Structured Merge-trees), data is:
Hashed to buckets
Stored in sorted runs merged periodically
Striped across disks
Organized in B-trees
A secondary index is typically:
Sparse and clustered
Stored on tape
Dense and built on non-ordering attributes (thường là Dense)
Used for primary keys only
Automated query optimization:
Manual optimization
Optimization deletion
Uses cost-based optimizers
No optimization
A clustered index:
Is non-unique
Allows duplicates
Is separate from data
Sorts and stores data rows in order
What is cardinality in ER models?
The size of the database
The number of attributes in an entity
The mapping ratio between entities in a relationship (e.g., one-to-many)
The number of tables
Block-level backups copy:
No blocks
Blocks encrypted
Files only
Changed blocks for efficiency
What is a trigger in DBMS?
A user role
A data type
A stored procedure executed automatically on events
A query optimizer
Offsite backups protect against:
Software bugs only
No protection
Onsite only
Site-wide disasters like fires
Multi-tier backups use:
Tier queries
Combination of disk, tape, cloud for layers
No tiers
Single tier
Big data automation with Spark:
Manual spark
No spark
Spark deletion
Automates distributed processing
What is a join in SQL?
Deleting tables
Backing up data
Combining rows from two or more tables based on related columns
Creating indexes
Database views can enhance security by:
Allowing full table access
Automatically encrypting data
Providing restricted, customized subsets of data
Deleting sensitive records
Terraform for DB provisioning:
Defines DB as code
Manual terraform
Terraform deletion
No terraform
Blockchain in DBMS security provides:
Centralized control
Mutable data
No security
Immutable, decentralized ledgers for tamper-proof records
In ER modeling, a weak entity:
Depends on a strong entity for identification
Has its own primary key
Is independent of relationships
Cannot have attributes
