Terms in this set (29)
The rows in a table are called:
In a typical organization, the person or group in charge of the DBMS is called a(n):
The ____ data type is used for large numbers without a decimal point
structured query language
SQL is an abbreviation for:
A field is often referred to as a:
creates a fixed length field of 10 characters
When using SQL to modify fields in a table, specifying a data type of Char(10):
driver license number
Which one of the following is the most likely candidate for the primary key in a table about driver information?
Modern databases contain "self-describing" information about themselves. This information is called:
The maximum number of primary keys in a table is:
a nonkey attribute is determined by only part of the key
A partial dependency exists when:
Screen objects used to enter, maintain, view, and print records from a database are called:
partial and transitive dependencies
Getting a table into third normal form is done by removing all:
The source of data for a(n) _____ control is an expression.
Calculations in a report can be used in any section except:
A ____ is an individual box in a table where a column and a row meet.
identify the database, create each table, identify each field, and save
The sequence to designing an effective data structure are:
self-describing collection of related records
A database is a:
all entries in any column must be of the same kind
Which one of the following is true about a relation?
update student set Advisor = 'Smith';
Given the table STUDENT(StudentID, Name, Advisor), which one of the following SQL statements would be used to change the value of the Advisor field to 'Smith' for all rows in the STUDENT table?
further limit the records that are displayed in the query results
Applying a filter to a query will:
If you want to export a database object to an HTML file with the best possible formatting, you should export a:
In the condition Balance > = 0, the >= are:
retrieve the results not listed in the criteria
Using the word not in a comparison expression would:
select * from customers
Which one of the following SQL Statements will retrieve customer information?
A relational database is a group of related:
Which one of the following sections print headings at the top of each page:
AutoNumber or Identity
The ____ date type is a number automatically generated that produces unique values for each record.
You must create ___ before any of the other database objects
Some developers like to use the ____ property for a field to document its contents such as identifying a field as a primary or foreign key or providing users instructions about entering values into the field.