CIS 219 (Oracle PL/SQL) Chapter 1 & 2
Which of the following symbols represents all the columns contained in a table?
*
Which of the following keywords can be included in a SELECT statement to suppress duplicate data?
DISTINCT
Which of the following is a mandatory clause in a SELECT statement?
FROM
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
A field is a basic unit of data also referred to as a record.
False
A one-to-many relationship cannot be included in a relational database.
False
Choosing specific columns to be displayed by a SELECT statement is known as selection.
False
Concatenation refers to combining the results of several SELECT statements into one result.
False
Data redundancy is created through a process known as normalization.
False
Each section of a statement that begins with a keyword is known as a(n) buffer.
False
Tables can be linked or joined together through their primary keys.
False
The SELECT clause identifies the table containing the data to be queried.
False
The following arithmetic operations can be performed in the SELECT clause of a SELECT statement: addition (+), subtraction (-), multiplication (*), division (/), and exponential (^).
False
When listing more than one column name in the SELECT clause of a SELECT statement, the column names must be separated by scmicolons.
False
Which statement best describes the relationship in figure 1?
For every occurrence of A, there can only be one occurrence of B.
Based upon the contents of the PUBLISHER table, which of the following is a valid SQL statement?
SELECT contact, name FROM publisher;
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 structure of the ORDERS table, which of the following SQL statements will return an error message upon execution?
SELECT order#, "order number" FROM orders;
Based upon the structure of the ORDERS table, which of the following is a valid SQL statement?
SELECT order#, orderdate DateOrdered FROM orders;
Which of the following statements is correct?
The columns will be listed in the results in the same order they are listed in the SELECT clause of the SELECT statement.
A bridging table can be used to eliminate a many-to-many relationship in a relational database.
True
A collection of records is a file.
True
A column represents a field in the physical database table.
True
A foreign key appears on the many side of a one-to-many relationship
True
A query is accomplished by issuing a SELECT statement.
True
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
By default, data within a numeric column is right-aligned when it is displayed.
True
Choosing specific columns from a database through a SELECT statement is known as projection.
True
Data mining refers to analyzing historical data stored in a database.
True
Parentheses can be used to override the order of operations in an arithmetic expression.
True
The Systems Development Life Cycle is a series of steps that can be used to guide the development process for a database management system.
True
The following types of relationships can be included in an Entity-Relationship Model: one-to-one, one-to-many, many-to-many.
True
The simplest approach to remove a partial dependeney is to use each portion of the primary key to create separate tables.
True
The syntax for a SQL statement gives the basic structure required to execute the statement.
True
Which of the following is an example of an attribute?
a person's hair color
Which of the following can lead to partial dependencies?
composite primary key
Combining the contents of two or more columns is known as _______ .
concatenation
Analyzing historical sales data stored in a database is commonly referred to as _________.
data mining
A _______ is a storage structure designed to hold a collection of data.
database
A _________ is a group of interrelated files.
database
In an E-R Model a person, place, or thing with characteristics to be stored in the database are referred to as?
entity
Which of the following terms refers to a group of related records?
file
What name is used to denote a common field that exists between two tables, but is also the primary key for one of the tables?
foreign key
Which of the following usually correlates to a primary key in another table?
foreign key
A foreign key is usually found on which side of a relationship?
many
Which of the following is a valid SELECT statement?
none of the above
Based upon the structure of the ORDERS table, the column heading for which column will be truncated in the results?
shipzip
In which step of the Systems Development Life Cycle (SDLC) are the logical and physical components defined?
systems design
If the data has no partial dependencies, repeating groups, or transitive dependencies, and has a composite primary key, the data is in which form?
third normal
