WorksheetsDatabase Concepts Quiz
Total questions: 53
Worksheet time: 37mins
What is the smallest unit of data that a user can access?
File
Record
Field
Database
Which of the following best defines information?
Raw facts
Organized and meaningful data
Data stored in a database
A set of unrelated facts
What does DBMS stand for?
Data Backup Management System
Database Management System
Data Block Modeling System
Database Backup Maintenance System
What is the purpose of a primary key in a database?
To allow duplicate records
To uniquely identify each record
To store large amounts of data
To improve data redundancy
Which type of database supports only one user at a time?
Multi-user
Workgroup
Enterprise
Single-user
Which database model represents data in a tree-like structure?
Relational model
Hierarchical model
Object-oriented model
Network model
What is the function of a data dictionary?
To store actual database data
To contain metadata about data files and fields
To serve as a backup database
To provide user access control
What does SQL stand for?
Structured Query Language
System Query Logic
Standard Query Logic
System Query Language
Which of the following is an advantage of using a database over a file processing system?
Increased data redundancy
Less secure data storage
Improved data integrity
Slower data retrieval
What is data redundancy?
Data stored in multiple locations unnecessarily
Data that is missing from a database
Data that has been validated
Data that is structured incorrectly
Which of the following is NOT a database model?
Hierarchical model
Relational model
Tabular model
Object-oriented model
What is Big Data?
Data stored in large physical storage
Large volumes of data beyond traditional processing
Large files stored in an enterprise database
A type of cloud computing
Which of the following is NOT a component of an entity-relationship model?
Entity set
Relationship set
Query set
Attributes
Which of the following is a type of database that supports a large group of users or an entire organization?
Single-user database
Desktop database
Workgroup database
Enterprise database
Which of the following ensures only authorized users can access a database?
Data dictionary
Recovery utility
Access privilege
Backup and log
What is cloud computing?
Storing data in a local drive
A computing model providing shared resources over the internet
A database model for high-performance computing
A method of backing up data
Which of the following describes an object-oriented database?
Stores data in tables with rows and columns
Stores data as objects with attributes and methods
Uses a strict tree structure for data relationships
Uses SQL for data management
What does a database administrator do?
Creates and maintains database security
Designs network infrastructure
Develops programming languages
Manages internet servers
What is the purpose of backup in a database?
To store unused data permanently
To ensure data can be restored after a failure
To duplicate data for faster processing
To validate all database fields
What is data validation?
The process of deleting records
The process of ensuring data accuracy and consistency
The process of creating a new database
The process of encrypting data
Which database model allows many-to-many relationships?
Hierarchical model
Relational model
Network model
Object-oriented model
What is metadata?
Data stored in cloud servers
Data about data
Large volumes of data
A type of data hierarchy
What is an advantage of cloud computing?
Requires local server maintenance
Provides scalable computing resources
Limited access to data
No data backup needed
What is the main purpose of data analytics?
To store data efficiently
To extract insights from raw data
To ensure data redundancy
To replace database management
Which is NOT a characteristic of Big Data?
High volume
High speed
Small size
Complex data structures
A web database is:
A database you access through a web page
A local database stored on a personal computer
A file-based data storage system
A data warehouse system
Which programming language is commonly used for database management?
Python
SQL
Java
HTML
What is a key feature of relational databases?
Tree structure
Object storage
Table-based format
Non-structured data
What does a recovery utility do in a DBMS?
Creates data relationships
Restores a database after failure
Deletes duplicate records
Encrypts data
What does a log in a database store?
Unused records
A list of database changes
SQL queries
User passwords
A (a) is a collection of related records.
(a) is a process of comparing data with rules to ensure accuracy.
SQL stands for _______.
A (a) key uniquely identifies each record in a database table.
The process of extracting meaningful information from raw data is called (a) .
A (a) database model stores data in tables.
Data (a) ensures that only authorized users can access a database.
(a) computing provides shared computing resources over the internet.
The process of restoring a database after a failure is called (a) .
(a) is data that describes other data.
A (a) field is used to uniquely identify records in a database.
A (a) database is accessed through a web page.
A (a) is a copy of an entire database used for recovery.
Data hierarchy consists of fields, (a) , and files.
(a) ensures data is correct before storage.
(a) allows multiple users to access a database at the same time.
A (a) stores information about database fields and their attributes.
(a) is the science of analyzing raw data for insights.
(a) is an extension of the hierarchical model that supports multiple relationships.
In a relational database, data is stored in (a) and columns.
Explain the advantages of database management systems over file-based data storage.
Discuss how cloud computing enhances database performance and security.
Explain how Big Data and Data Analytics impact business decision-making.
