Font size
WorksheetsQuiz 2 - Midterm
Total questions: 50
Worksheet time: 25mins
Which of the following is the main function of a database?
Stored
Sorted
Organized
Queried
Which of the following is advantages of database?
Databases can manage large amounts of data efficiently
Databases make information sharing possible
Databases promote data integrity
Databases are expensive and need time to set-up.
Which of the following is the function of database?
Populate the database by creating records
Allow users to extract subsets of data from the database
Output the data in a meaningful and presentable format
Database can be used to process unstructured data.
Database management system (DBMS) allows users to ____________________________.
create a computerized database
add, modify and delete data
sort and retrieve data
create forms and reports from the data
Which of the following is the characteristics of valuable information
Accurate
Verifiable
Timely
Accessible
(a) compares data with a set of rules or values to find out if the data is correct.
Which of the following is the features of database as compared to file processing system
Programs and users share data
Have data redundancy
Improve data integrity
Reduce development time
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 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 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.
What is a database?
A software package used to store information
Something that has a list
A spreadsheet
A table of data
What is an advanage of a database?
You can input information
Its different to Excel
It saves files
Can search through and find information quickly
Short text, date, long text and number are all examples of what?
Data types
Headings
Fields
Records
What is a primary key?
A field
A record
Two fields
A unique reference
In DBMS, Primary key field has some obligations to create some relation between tables
data have to be unique
data have to be a text
to be same with foreign key field
no empty records
to be different from foreign key field
4. Why do relational databases use primary keys and foreign keys?
A. To create a database
B. To create physical relationships
C. To create logical relationships
D. All of the above
Which of these are advantages of Spreadsheets?
Formulas can be used to calculate totals
Data can be sorted on a specific field
Validation can be set on fields to minimise input errors
Worksheets can be used to separate different sets of data in a workbook
Which are these are advantages of Databases?
Data can be filtered or queried to find relevant results
Reports can be generated to show the results of queries
What-if investigations can be carried out
Columns and rows can be locked to maintain data integrity
According to the presentation, opportunities for which of the following areas are expected to increase in the next few years?
Business information technology
Operations management
Human resources management
Administrative support
