WorksheetsDatabase DIT
Total questions: 23
Worksheet time: 12mins
Which of the following is a way for programmers and others to make sense of complex business flows?
Microsoft Access
Data modeling
Primary keys
Database management system
Which of the following is found in one or more columns of data and contains a unique identifier for the row?
Attribute
Relationship
Primary key
Foreign key
Which data model focuses on high-level concepts?
Operational
Physical
Logical
Conceptual
Which data type uses historical data to make decisions in the present?
Operational
Logical
Conceptual
Analytical
Which type of analytical data can help you make investment decisions?
Market
Machine
Sensor
Transactional
What is the general term for software that creates and manages databases?
DBMS
Microsoft Access
Tables
MySQL
Which database object is essentially questions that we can ask the database?
Reports
Forms
Tables
Queries
Which of the following makes it easier for users to enter data into their tables?
Queries
Tables
Reports
Forms
Which of the following DBMS programs is open source?
SQL Server
MySQL
Oracle Database
Microsoft Access
Which of the following database objects provides a summary of data?
Queries
Forms
Tables
Reports
Formatted summary of information from a database
Table
Query
Form
Report
User friendly interface for adding to or retrieving information from a database
Table
Form
Query
Report
Scores raw data in a relational database
Form
Table
Query
Report
Retrieves specific information from a database. Can also be used to update, edit, and delete information.
Report
Table
Form
Query
Which of the following should not be used as a primary key in a table?
Employee ID
First name
Username
Social Security number
In a relational database table, columns are better known as ________________.
Records
Categories
Instances
Fields
A value that's used to identify a record from a linked table is called a ________________.
Foreign Key
Linked Key
Primary Key
Borrowed Key
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?
Private key
Foreign key
Public key
Primary key
Edward, a database user, would like to gather some specific information from a database and then manipulate the data in a spreadsheet. Edward then wants to save that information in a file format that will be used by another application. Which of the following database features would work BEST to accomplish this?
Table
Report
Form
Query
Which of the following database features would provide a formatted, easy-to-read listing of the results of a query?
Record
Form
SQL command
Report
A NOT NULL __________ is a rule that prevents certain fields in a database from being left blank.
scalability
schema
query builder
constraint
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 saved as a flat file.
The data can be stored as unstructured data.
The data can be organized into separate tables that are related to each other.
The data is stored as a single file for quick retrieval.
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?
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.
To allow the storage of unstructured data.
