Final Exam AIT – Administrator in Training Comprehensive Long-Term Care Administration Review Guide

Final Exam AIT – Administrator in Training Comprehensive Long-Term Care Administration
Review Guide



Structured Query Language (SQL) is generally used to interact with a database. - ✔✔True



A field is a basic unit of data also referred to as a record. - ✔✔False



A field in the logical design of a database corresponds to a row in the physical table of a
relational database. - ✔✔False



Tables can be linked or joined together through their primary keys. - ✔✔False



Data is in second normal form (2NF) if it contains no repeating groups and has a primary key to
uniquely identify each record. - ✔✔False



A record in the logical design of a database corresponds to a row in the physical table of a
relational database. - ✔✔True



The occurrence of data anomalies would indicate an unnormalized database design. - ✔✔True



Two tables can be linked or joined together through a common field. - ✔✔True



A column represents a field in the physical database table. - ✔✔True



A one-to-many relationship means that an occurrence of a specific entity can only exist once in
each table. - ✔✔False

,The following types of relationships can be included in an Entity-Relationship Model: one-to-
one, one-to-many, many-to-many. - ✔✔True



If a primary key has been identified for the data, then the data is considered to be in first
normal form (1NF). - ✔✔False



A clause is a section within a SQL statement that begins with a keyword. - ✔✔True



Insignificant zeros *are* displayed for numeric columns by default to show two decimal places. -
✔✔False



*Parentheses* can be used to override the order of operations in an arithmetic expression. -
✔✔True



A string literal must be enclosed in *double* quotation marks. - ✔✔False



Each clause of a SELECT statement *must* be entered on a new line in SQL*Plus. - ✔✔False



A user can indicate that all columns of a table should be displayed in the results of a SELECT
statement by including an asterisk (*) in the SELECT clause. - ✔✔True



The SELECT clause of the SELECT statement is used to identify which rows are to be retrieved
from a specified table. - ✔✔False



The use of a column alias in the SELECT clause can be designated by the keyword *ALIAS*. -
✔✔False



If multiple column names are listed in the SELECT clause of a SELECT statement, the columns
must be separated by a comma (,). - ✔✔True

,The *SELECT* command can be used to display the structure of a database table. - ✔✔False



A column heading that is longer than the width of a column will not be truncated for a column
that is defined to store *character* data. - ✔✔False



Choosing specific columns to be displayed by a SELECT statement is known as selection. -
✔✔False



By default, a column alias is displayed in lower case characters in the results. - ✔✔False



Data in third normal form (3NF) contains which of the following? - ✔✔none of the above



Which of the following terms best describes where a group of characters that represents a
customer's address would be stored in the logical design? - ✔✔field



A ____ is a storage structure designed to hold a collection of data. - ✔✔database



Which of the following committees are responsible for establishing SQL guidelines? - ✔✔ANSI
and ISO



Which of the following types of relationships cannot exist in a relational database? - ✔✔many-
to-many



The multi-step process used when creating a new system is referred to as ____. - ✔✔the
Systems Development Life Cycle

, A field in the logical design of a database is represented by what in the physical database? -
✔✔column



Which of the following is used to uniquely identify each record? - ✔✔primary key



Which of the following terms represents a collection of fields? - ✔✔record



The fact that a person can wear different size clothes and that different people can wear the
same size clothes is best characterized as a what type of relationship? - ✔✔one-to-all



If uncontrolled, what can lead to data anomalies? - ✔✔data redundancy



Which of the following may contain transitive dependencies, but not partial dependencies? -
✔✔first normal form (1NF)



A ____ is a group of interrelated files. - ✔✔database



Which of the following is a valid SQL statement? - ✔✔SELECT title, retail-cost FROM books;



Which of the following types of columns will automatically right-align the data when it is
displayed? - ✔✔numeric



If the results of a SELECT statement include more than one column of data, the column names
must be separated in the SELECT clause by which of the following symbols? - ✔✔,



Based upon the contents of the PUBLISHER table, which of the following SQL statements will
execute without returning an error message? - ✔✔SELECT pubid name FROM publisher;