WorksheetsDatabase Concepts Quiz
Total questions: 59
Worksheet time: 52mins
What is the main purpose of a data model?
To program data
To organize and structure data
To create hardware
To analyze data
Which is not a type of data model?
Flat
Hierarchical
Neural
Star Schema
Normalization reduces:
Data redundancy
System speed
Storage space
Data hierarchy
An index is a:
Copy of a database table in sorted form
Table of contents
Program file
Backup file
A clustered index organizes data by:
Random order
Search key field
Alphabetical order
Last modified date
Sparse indexes:
Contain entries for every search key
Use pointers for groups of records
Duplicate records
Sort data by multiple fields
The goal of data security is to ensure:
Faster systems
Privacy and protection
Network stability
Cost reduction
Encryption scrambles data using:
Algorithms
Hardware locks
Manual coding
Default passwords
Which is not a type of security control?
Auditing
Authentication
Data redundancy
Access control
ARIES recovery works in how many phases?
2
3
4
1
A checkpoint in databases is used for:
Backups
Faster recovery
User authentication
Disk formatting
Media recovery deals with:
Fixing CPUs
Repairing storage disks
Debugging software
Resetting user accounts
Which of the following is an example of a standard data model?
ISO 10303
UML
JSON
XML
What defines the relationship between entities in a database?
Index
Cardinality
Schema
Normal form
A composite primary key consists of:
Multiple tables
Multiple fields
Multiple rows
A single unique field
The 3rd normal form eliminates:
All redundancy
Transitive dependencies
Foreign keys
Data relationships
Which of the following is automatically created with a primary key?
Dense index
Clustered index
Secondary index
Sparse index
A dense index contains:
Entries for every search key value
Only unique entries
Backup data
Sorted pages
A composite search key is used to:
Retrieve specific records with multiple conditions
Access system logs
Encrypt data fields
Create duplicate indexes
A unique index uses:
Redundant keys
Composite keys
Candidate keys
Foreign keys
The main purpose of a secondary index is to:
Sort tables
Access data using non-key fields
Backup data
Perform encryption
The practice of copying and archiving data is known as:
Encryption
Backup
Authentication
Integrity control
Which of the following is a password control feature?
Encryption algorithm
Logging changes
Restricted access
Audit trail
Authentication uses:
Security protocols only
Logins, passwords, or biometric methods
Data redundancy methods
Encryption keys only
A firewall is used to:
Encrypt files
Prevent unauthorized network access
Backup data
Reduce file size
Which of the following is not a major threat to data security?
Malware
System errors
Data indexing
Human error
Write-ahead logging ensures:
Changes are written to the log before being applied
Logs are deleted after changes are applied
Transactions are grouped for efficiency
Only committed data is logged
The undo phase in ARIES:
Rolls back uncommitted transactions
Commits changes
Restarts the system
Deletes temporary files
Checkpointing involves:
Resetting the database
Writing modified buffers to disk periodically
Erasing unused logs
Creating index tables
RAID systems are primarily used for:
Database normalization
Disk redundancy and reliability
Network configuration
Memory optimization
What is the first step in cleaning computer hardware?
Use a vacuum cleaner
Shut down the system
Spray cleaning liquid directly on the components
Disconnect all cables
Which tool should not be used to clean computer hardware?
Microfiber cloth
Vacuum cleaner
Paper towels
Foam swabs
Overheating of hardware is mainly caused by:
Dust and dirt
Software bugs
Improper indexing
Frequent shutdowns
Defragmentation is performed to:
Remove viruses
Reorganize fragmented files
Create backups
Install new programs
A UPS is used to:
Prevent overheating
Provide power backup
Maintain internet security
Increase processor speed
Which is not a tool for hardware cleaning?
Cotton swabs
Compressed air
Cleaning liquid
Encryption software
Preventive software maintenance involves:
Fixing errors after they occur
Anticipating and preventing potential issues
Backing up files
Updating system logs
Which of the following is not a type of software maintenance?
Corrective
Adaptive
Transformative
Perfective
A system scan helps to:
Increase speed
Detect and remove malware
Reorganize disk space
Perform backups
Registry cleaning is essential for:
Database backups
Optimizing system performance
Securing user accounts
Creating indexes
Temporary files should be deleted to:
Increase speed
Enhance user security
Update the system
Perform defragmentation
A database administrator is responsible for:
Writing user applications
Monitoring and maintaining databases
Designing hardware systems
Managing user workstations
Which control ensures only authorized users access the system?
Auditing
Access control
Backups
Logging
Encryption can be decrypted only by:
Password authentication
A matching encryption key
A security administrator
A secondary password
Which of the following is a physical method of securing data?
Firewall
Locks on server rooms
Anti-virus software
Cloud backup
Media recovery primarily uses:
Temporary logs
Archive copies and logs
Manual user entries
Debugging scripts
What does "atomicity" ensure in database transactions?
Transactions are divided into sub-processes
All operations are executed or none are
Data is encrypted before processing
Logs are written only after completion
The Write-Ahead Log protocol ensures:
Logs are written after applying changes
Logs are written before applying changes
Backup files are updated regularly
Temporary data is deleted
Adaptive maintenance is needed when:
Errors occur in a program
Environmental conditions change
Programs need user feedback
Data is being backed up
Preventive maintenance aims to:
Address current software issues
Prevent future problems
Adapt to hardware changes
Improve data recovery speed
Define normalization and explain its importance in databases.
Differentiate between primary and secondary indexes with examples.
Explain the significance of data backups in database security.
Describe the differences between dense and sparse indexes.
What are the steps involved in cleaning computer hardware?
Compare ARIES and checkpointing as crash recovery methods.
Define data models and explain their types.
Discuss the difference between clustered and unclustered indexes.
Explain the ARIES crash recovery concept.
