WorksheetsDatabase Quiz (Certmaster 5.1 - 5.3)
Total questions: 20
Worksheet time: 10mins
Name
Class
Date
1.
Microsoft SQL Server is an example of what?
a)
RDBMS
b)
Relational database
c)
Query/report builder
d)
Database server
2.
What is a database?
a)
A database is a software program that is used to show better ways to access data.
b)
A database is a collection of bits of random information stored together on a computer.
c)
A database is a collection of related data organized in a structured manner for easier access.
d)
A database is any individual basic piece of data that an organization considers valuable.
3.
Why might a table called “Students” in a relational database have twelve rows?
a)
There are twelve students.
b)
Twelve pieces of data are stored for each student.
c)
A relational table must have a minimum of twelve rows.
d)
Rows in a table are added in multiples of twelve.
4.
When processing large numbers of transactions, how does processing speed compare between databases and flat file systems?
a)
The speed of processing transactions is the same whether the data is stored in a flat file or a database.
b)
Flat files’ processing speeds are much faster than database processing speeds.
c)
Database processing speeds are much faster than flat file speeds.
d)
Flat file processing speeds are faster than database processing speeds if the computer’s processor is slower than average.
5.
Which of the following actions is most likely associated with database use?
a)
Querying
b)
Printing
c)
File Sharing
d)
Creating Diagrams
6.
What is the relationship between queries and reports?
a)
A query produces output on the screen and a report produces output on the printer.
b)
A report filters the data values to provide only the needed data and a query retrieves it.
c)
A query selects and retrieves the correct data, whereas a report formats and summarizes the output.
d)
“Report” and “query” are really two terms for the same thing.
7.
What term is defined as the ability of a database to increase in size as more information is added to it without increasing costs at the same rate?
a)
Persistence
b)
Scalability
c)
Import
d)
Relational
8.
The output of a query in a relational database is most likely used to generate:
a)
scalability
b)
storage
c)
a schema.
d)
a report.
9.
What is the purpose of a schema?
a)
It is used only by the programmer for documentation.
b)
It contains data values used for queries.
c)
It describes the structure of a database.
d)
It displays business rules that dictate how a database will be used.
10.
In a relational database, what best describes the relationship between a primary key and a foreign key?
a)
The primary key is in one table and it is matched to the foreign key in a secondary table.
b)
The foreign key and primary key are in the same table. The foreign key is used as the backup key in case the primary key is compromised.
c)
Both foreign and primary keys are used to uniquely identify each row in a table.
d)
Primary keys are used to uniquely identify each row in a table, whereas the foreign key is used only for searching and sorting.
11.
A field in a relational table corresponds to which part of a spreadsheet?
a)
A row
b)
A cell
c)
A worksheet
d)
A column
12.
A database administrator is considering adding a primary key to enforce unique rows, defining a format for a phone number, and adding a rule so that a user must enter a date prior to today. What is the administrator adding to the database?
a)
Constraints
b)
Foreign keys
c)
Schemas
d)
Permissions
13.
You are designing a “Customer” table in a relational database. Which of the following fields would be the best candidate for a primary key?
a)
CustomerAddress
b)
CustomerNumber
c)
CustomerBirthdate
d)
CustomerLastName
14.
Adding a new relational database, table, or index is a function of which Data Definition Language (DDL) command?
a)
INSERT
b)
CREATE
c)
UPDATE
d)
ALTER
15.
What is a true statement about Data Definition Language (DDL)?
a)
It is the group of SQL commands that can add and update data in the tables in a database.
b)
It does not exist outside of SQL, and is only used to manipulate a relational database.
c)
It comprises SQL commands that can add to or modify the structure of a database.
d)
DDL commands can only include other DDL commands.
16.
What is the difference between the DELETE and DROP commands in SQL?
a)
DELETE deletes rows from a table, whereas DROP eliminates the entire table.
b)
DROP eliminates rows from a table, whereas DELETE eliminates the entire table.
c)
DELETE deletes rows from a table, whereas DROP eliminates columns.
d)
DELETE deletes data from rows in a table, whereas DROP deletes rows from the schema.
17.
What is the SQL UPDATE command used for?
a)
To add or delete a table from a schema
b)
To add security updates to a database
c)
To change the field name in a table
d)
To change the value in one or more fields in a table
18.
Within a database, which of the following would be the best access method to use to display a subset of a table?
a)
INSERT
b)
SELECT
c)
DROP
d)
UPDATE
19.
What is the purpose of the SQL INSERT command?
a)
It inserts a new field into a table.
b)
It adds a primary key to a table.
c)
It adds a new record/row to a table in a database.
d)
It inserts a new table into a database.
20.
Which of the following categories describes SQL commands used to extract information from a database?
a)
DDL
b)
DDR
c)
DLL
d)
DML
100 %
