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;
Which of the following commands can be used to view the structure of a table?
?DESCRIBE
Which of the following is a mandatory clause in a SELECT statement?
?FROM
Based upon the contents of the PUBLISHER table, which of the following is not a valid SQL statement?
?SELECT name, contact FROM publisher/
Based upon the contents of the PUBLISHER table, which of the following SQL statements will display only two columns in the results?
?SELECT contact person, name FROM publisher;
Based upon the contents of the BOOKS table, which of the following SQL statements will display the retail price for two copies of each book currently in inventory?
?SELECT title, retail+retail FROM books;
Based upon the contents of the PUBLISHER table, which of the following SELECT statements will display the publisher's name first in the results?
?none of the above
A column alias must be contained within double quotation marks (" ") if it contains which of the following?
?all of the above
Based upon the contents of the PUBLISHER table, which of the following is a valid SQL statement?
?SELECT * FROM publisher;