Font size
WorksheetsTECH Database ALL
Total questions: 81
Worksheet time: 41mins
Which feature of a database ensures that only authorized users can access the data?
Recovery
Scalability
Security
Centralized access
Which type of data is best stored in a relational database?
Random data
Structured data
Semi-structured data
Non-structured data
What is a query in a database?
A column in a table
A row in a table
A request for data
A type of report
What does a conceptual data model focus on?
Network configurations
Hardware details
High-level ideas
Specific database management systems
What type of database works best with semi-structured data?
Key/value pair database
Hierarchical database
Flat file database
Relational database
Why are databases better for concurrent use compared to spreadsheets?
Spreadsheets are only for single users.
Spreadsheets cannot store words.
Databases are cheaper.
Databases allow many users to access data simultaneously.
What is a key-value database?
A type of file system
A type of non-relational database
A type of spreadsheet
A type of relational database
What does a NOT NULL constraint do?
Ensures a field must have a value
Changes the format of a field
Deletes records with null values
Allows fields to be left blank
What does NoSQL stand for?
New SQL
No SQL Allowed
Non-Structured Query Language
Not Only SQL
What is XML used for in databases?
To create websites
To delete data
To give structure to non-structured data
To encrypt data
What is a database schema?
A type of data storage device
A programming language
A type of software
The architecture of how a database is structured and organized
What do we call the vertical columns in a database?
Fields
Rows
Records
Tables
What is the purpose of data modeling?
To help programmers and others understand the complex flow of data within an organization
To create new programming languages
To manage network security
To design hardware components
Which type of database is best for organizing semi-structured and unstructured data?
Text File
Spreadsheet
Non-relational Database
Relational Database
What type of data falls between organized and unorganized?
Structured data
Random data
Non-structured data
Semi-structured data
What can the value in a key-value pair be?
Only dates
Only numbers
Any type of data
Only words
What is another term for rows in a database?
Tables
Columns
Records
Fields
What type of relationship has one record with a primary key associated with multiple records in other tables with foreign keys?
One-to-one relationship
One-to-many relationship
Many-to-one relationship
Many-to-many relationship
What is a flat file system?
Another name for a spreadsheet.
A way to store images.
A type of database.
A method to back up data.
Which type of data model is the simplest?
Conceptual Data Model
Relational Data Model
Physical Data Model
Logical Data Model
What does a key in a key-value database represent?
A type of data
A unique identifier
A column
A table
What is the purpose of forms in a database?
To reduce data entry errors
To create new tables
To change database settings
To delete records
Why are constraints important in a database?
They prevent data inconsistency.
They make the database run faster.
They allow fields to be left blank.
They allow for more tables to be created.
What is a foreign key?
A primary key from another table
A key that is used to unlock a database
A key that can be left blank
A key that is always the same as the primary key
What type of data is divided into clear, separate categories?
Structured data
Semi-structured data
Non-structured data
Random data
What is one reason organizations prefer databases over spreadsheets?
Databases can generate colorful graphs.
Databases can handle more data points efficiently.
Spreadsheets are only for financial reports.
Spreadsheets are harder to understand.
Which type of data model includes primary keys and foreign keys?
Logical Data Model
Schema Model
Conceptual Data Model
Physical Data Model
Which type of database allows users to access it over the Internet?
Intranet database
Local database
Offline database
Online database
What is the best way to enter large amounts of data into a database?
Typing it in manually
Printing and scanning the information
Using a word processor
Importing it from other sources
In a one-to-one relationship, how many records in one table are associated with records in another table?
One record in one table is associated with only one record in another table
Multiple records in one table are associated with one record in another table
Multiple records in one table are associated with multiple records in another table
One record in one table is associated with multiple records in another table
What does scalability in a database mean?
The ability to store physical items
The process of adding more physical hard drives for data storage
The ability to handle a large amount of data efficiently
The ability to access social media
What does forced data entry mean in the context of databases?
Controlling and validating the information users enter.
Forcing users to enter data quickly.
Forcing users to back up their data.
Forcing users to use specific software.
Which of the following can be a primary key?
First name
Favorite color
Last name
Phone number
What does a relationship in a database do?
Connects two entities
Stores data
Deletes data
Creates a new database
What is a database?
A highly organized, multi-table digital storage system
A social media platform
A place to store physical items
A type of computer game
What is a report in a database?
A row in a table
A column in a table
A summary of data
A type of query
What is the main purpose of a physical data model?
To manage software updates
To design user interfaces
To show how to set up a database using a specific database management system
To create a high-level view of data
How does a document database store data?
In rows and columns
In word documents
In spreadsheets
In flexible documents
What is one advantage of databases in terms of data recovery?
Databases are easier to delete.
Databases are always online.
Databases back up information within seconds.
Databases never lose data.
What is a primary key in a database?
A type of data that can be left blank
A value that can change over time
A unique identifier for each record
A common name shared by multiple records
What type of files can a document database store?
Only video files
Many different types of files
Only text files
Only image files
What is a relational database?
A database that stores data in a single table.
A database that only stores text data.
A database that keeps data in several connected tables.
A database that does not use tables at all.
What is the primary key in a relational database?
A field that uniquely identifies each record.
A field that stores the largest number.
A field that is always empty.
A field that contains duplicate values.
What data formats are commonly used in document databases?
CSV and TXT
HTML and CSS
JSON and XML
DOC and PDF
What does cloud storage mean in the context of databases?
Storing data online, managed by a cloud provider
Storing data offline
Storing data on local servers
Storing data on an intranet
What is non-structured data?
Data that is always numerical
Data that fits neatly into rows and columns
Data that doesn't have a clear order or pattern
Data that is always textual
What is a key benefit of using offline databases?
They are accessible from anywhere.
They are managed by cloud providers.
They offer 99.9% availability.
They reduce the risk of cyber attacks.
Why are key-value databases useful for tasks that need quick data access?
They use complex data models
They cannot grow quickly
They are difficult to understand
They have a flexible structure
What is one advantage of local databases?
They offer 99.9% availability
They can be accessed faster
They are managed by cloud providers
They reduce the risk of cyber attacks
Which of the following correctly defines a field?
A request for data from the database
A summary of data
A collection of related fields in a row
A single piece of information in a database
What does RDBMS stand for?
Real-time Database Management System
Relational Database Management System
Relational Data Monitoring System
Random Data Management System
Why are databases important for businesses?
They allow businesses to make smart choices and plan for the future.
They help in organizing physical files.
They provide a list of all installed software.
They only work in the cloud.
Which of the following correctly defines a database record?
A single piece of information in a database
A column in a table
A summary of data
A collection of related fields in a row
What is a document database?
A type of non-relational database
A type of relational database
A type of spreadsheet
A type of word processor
The UPDATE SQL clause can _____________
update only one row at a time
update more than one row at a time
delete more than one row at a time
delete only one row at a time
What would the SQL query pictured do?
Find all the men
Find all of the female writers
Find all of Elgar's friends
Find all the male writers
Find all the fish
Which SQL statement is used to insert new data in a database?
ADD RECORD
INSERT INTO
INSERT NEW
ADD NEW
Joe would like to change/manipulate all the records in a customers table. Which type of data language would he use?
Data Definition Language
Data
Data Manipulation Language
Operational
John is looking to alter the schema of the database. Which data language would he most likely use?
Data Defined Language
DML
Analytical
Operational
There are several table relationships when creating databases. The example of one building to several classrooms is known as?
One-to-One
One-to-Many
Many-to-Many
No Relationship
Marty, a database administrator, has added a foreign key to a table in a database. Which of the following describes the purpose of a foreign key?
To allow the storage of unstructured data.
For one table to reference records in another table.
To provide a way to distinguish records within a table.
For one database to reference another database.
A business wants to set up a database to store customer and order information. They have decided to use a relational database. Which of the following is the main benefit of using a relational database?
The data can be organized into separate tables that are related to each other.
The data can be stored as unstructured data.
The data can be saved as a flat file.
The data is stored as a single file for quick retrieval.
A database administrator is setting up a new table that will contain customer information. The fields include name, address, company, phone, email, and customer ID. The administrator is using the customer ID to uniquely identify each customer record. Which of the following BEST describes the customer ID field?
Public key
Foreign key
Primary key
Private key
Which of the following should NOT be used as a primary key in a table?
First name
Username
Social Security number
Employee ID
What data formats are commonly used in document databases?
CSV and TXT
DOC and PDF
JSON and XML
HTML and CSS
What is non-structured data?
Data that fits neatly into rows and columns
Data that doesn't have a clear order or pattern
Data that is always numerical
Data that is always textual
Why are key-value databases useful for tasks that need quick data access?
They use complex data models
They have a flexible structure
They are difficult to understand
They cannot grow quickly
What can the value in a key-value pair be?
Only numbers
Only words
Any type of data
Only dates
Which of the following correctly defines a database record?
A single piece of information in a database
A collection of related fields in a row
A column in a table
A summary of data
What is one reason organizations prefer databases over spreadsheets?
Databases can generate colorful graphs
Databases can handle more data points efficiently
Spreadsheets are harder to understand.
Spreadsheets are only for financial reports
What does scalability in a database mean?
The ability to store physical items
The ability to handle a large amount of data efficiently
The process of adding more physical hard drives for data storage
The ability to access social media
In a database where each employee is assigned to one project, and each project can have multiple employees, which database design option would apply?
The Project table has a primary key of ProjectID and a foreign key of EmployeeID. The Employee table has a primary key of EmployeeID.
The Project table has a primary key of ProjectID. The Employee table has a primary key of EmployeeID and a foreign key of ProjectID.
The Project table has a primary key of ProjectID. The Employee table has a primary key of EmployeeID and a foreign key of EmployeeID.
The Project table has a primary key of ProjectID and a foreign key of EmployeeID. The Employee table has a primary key of ProjectID.
Adding a new relational database, table, or index is a function of which Data Definition Language (DDL) command?
CREATE
INSERT
UPDATE
ALTER
How is a key/value pair database different from a relational database?
In a relational database, all attributes of a record are defined up front, and each record has all of the same attributes as the other records. In a key/value pair database, objects and their properties are stored, but each object doesn’t have to have all of the properties.
A relational database uses primary and foreign keys to establish relationships among tables. A key/value pair database uses a pair of primary keys, but no foreign keys to join tables
A relational database can contain data about many subjects/themes, with each theme (customer, invoice, product, etc.) having its own table. In a key/value pair database, data for only two themes can be included
Both types of databases have formal structures to link the different data objects and files. But searches and queries are not used with key/value pair databases.
What is the purpose of a foreign key in a database?
To uniquely identify each record in a table
To establish a relationship between two tables
To speed up database queries
To store large amounts of text data
Which of the following is a characteristic of a non-relational database?
Data is always encrypted
Data is stored in tables with rows and columns
Data is stored in a flexible, schema-less format
Data is stored in a single table
What is the role of an index in a database?
To improve the speed of data retrieval operations
To ensure data consistency
To provide a backup of the database
To store images and videos
