Term
Without a databade most applications would be useless. |
|
Definition
|
|
Term
A database management system (DBMS) provides an end-user interface with the database. |
|
Definition
|
|
Term
A DBMS delegate the task of ensuring data integrity to the operating system. |
|
Definition
|
|
Term
A DBMS manages multiple users' access to the database. |
|
Definition
|
|
Term
An attribute is also called a relation. |
|
Definition
|
|
Term
A collection of columns referring to one item is called a row or tuple. |
|
Definition
|
|
Term
Indexes do not require additional storage space in the database. |
|
Definition
|
|
Term
The information stored in a database is kept in natural or sequential order. |
|
Definition
|
|
Term
From a database design point of view, first nomal form is better than second normal form. |
|
Definition
|
|
Term
You could define a database table based on unnormalized tables, but redundancies and dependencies can cause problems when the table is in use. |
|
Definition
|
|
Term
A determinant is also called a composite key. |
|
Definition
|
|
Term
A column is functionally dependent on another column if for each value of the first column, there is only one value for the second column. |
|
Definition
|
|
Term
The third normal form creates columns that are independent of the primary key. |
|
Definition
|
|
Term
The main rules in database design are the second and third normal forms. |
|
Definition
|
|
Term
A one-to-many relationship is the most common relationship. |
|
Definition
|
|
Term
One-to-one relationships are very common. |
|
Definition
|
|
Term
The RETURN BY clause enables you to change how data is returned from the SELECT statement. |
|
Definition
|
|
Term
There are many SQL commands for maintaining, defining, and administering the data in a database. |
|
Definition
|
|
Term
SQL deals with only the data you want to see. |
|
Definition
|
|
Term
SQL commands may not be lowercase. |
|
Definition
|
|
Term
Every column must be initialized with data. |
|
Definition
|
|
Term
The order of the fields in the SELECT statement doesn't have to match that of the defined table structure. |
|
Definition
|
|
Term
The MORE clause in a SQL SELECT statement specifies additional criteria for retrieving data from a table. |
|
Definition
|
|
Term
In relation to refining searches, the keyword AND indicates that all criteria must be met. |
|
Definition
|
|
Term
By default, the SELECT statement returns data in no particular order. |
|
Definition
|
|
Term
Data that has been organized and logically related to allow access, retrival, and use of that data is called a ___. |
|
Definition
|
|
Term
A special language known as ___ is used to query or extract information from databases. |
|
Definition
Structured Query Language |
|
|
Term
___ was one of the computer scientists at IBM creating a theoretical model for designing data structures. |
|
Definition
|
|
Term
A DBMS helps manage date and extract information from a database by using a(n) ___ language. |
|
Definition
|
|
Term
A ___ or entity is arranged into rows or columns much like a spreadsheet. |
|
Definition
|
|
Term
The set of possible values for each column is called the ___ of that column. |
|
Definition
|
|
Term
A(n) ___ is a special type of file that occupies its own space and specifies one or more columns that determine how information stored in a table can be accessed more efficiently. |
|
Definition
|
|
Term
When the columns are used to determine the sort order of information, they are called sort ___. |
|
Definition
|
|
Term
The set of rules that dictates how databases are designed is called ___. |
|
Definition
|
|
Term
To put the table into the ___ normal form, any columns containing two values need to be separated into two rows. |
|
Definition
|
|
Term
A ___ key is simply a column or combination of columns that uniquely identifies a row within a table. |
|
Definition
|
|
Term
A(n) ___ key is a primary key made up of more than one column. |
|
Definition
|
|
Term
Placing a table into second normal form eliminates ___ of data. |
|
Definition
|
|
Term
A(n) ___ dependency exists when one column is dependent on another column that isn't the primary key. |
|
Definition
|
|
Term
A(n) ___ defines how one table (entity) works with or relates to another. |
|
Definition
|
|
Term
A(n) ___ key is a column in one table that relates to the primary key in another. |
|
Definition
|
|
Term
A visual representation of how all the tables or entities interact and relate to each other in a database is called a(n) ____ relationship model. |
|
Definition
|
|
Term
___ shows the numeric occurences between entities in an ER model. |
|
Definition
|
|
Term
Which of the following is a valid SQL command for constructing a table? |
|
Definition
|
|
Term
The keyword ___ indicates that data is not required for a specified column. |
|
Definition
|
|
Term
SQL statements are closed with a(n) ___. |
|
Definition
|
|
Term
The ___ statement is used to add new rows of data to a table. |
|
Definition
|
|
Term
The ___ statement is the most commonly used SQL statement. |
|
Definition
|
|
Term
If you want to arrange the data more meaningfully when using the SELECT statement, you can specify the ___ column names. |
|
Definition
|
|
Term
If you want data returned in descending order, you simply place the keyword ___ next to the column in the ORDER BY clause. |
|
Definition
|
|