-
Combining the contents of two or more columns is known as projection.
False
-
Transitive dependency can only exist if the data is uniquely identified by a composite primary key.
False
-
The optional keyword AS can be used to indicate that the subsequent string of characters is a column alias.
True
-
A string literal must be enclosed in double quotation marks.
False
-
A one-to-many relationship means that an occurrence of a specific entity can only exist once in each table.
False
-
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
-
An entity is represented by a column in the Entity-Relationship Model.
False
-
A field in the logical design of a database corresponds to a row in the physical table of a relational database.
False
-
The SELECT command can be used to display the structure of a database table.
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 collection of fields is a file.
False
-
A record in the logical design of a database corresponds to a row in the physical table of a relational database.
True
-
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
-
The ALL option can be used in the SELECT clause to indicate that all columns should be retrieved.
False
-
The following types of relationships can be included in an Entity-Relationship Model: one-to-one, one-to-many, many-to-many.
True
-
Column headings may be truncated in the results of a SELECT statement.
True
-
In a(n) SELECT statement, keywords, table names, and column names are not case sensitive.
True
-
The majority of operations performed on a typical database table utilize the SELECT statement.
True
-
Choosing specific columns to be displayed by a SELECT statement is known as projection.
True
-
Two tables can be linked or joined together through a common field.
True
-
A database is a physical storage device for data.
False
-
A foreign key uniquely identifies each row in a table.
False
-
When listing more than one column name in the SELECT clause of a SELECT statement, the column names must be separated by semicolons.
False
-
A double backslash () is used to indicate concatenation in a SELECT statement.
False
-
Which of the following is used to create and maintain the physical database?
C. Database Management System (DBMS)
-
The ____ for a SQL statement gives the basic structure, or rules, required to execute the statement.
B. sequence
-
In which step of the Systems Development Life Cycle (SDLC) is the system actually used by the end-user on a regular basis?
C. systems deployment
-
What is the correct answer for the arithmetic expression 9+2*3-2 using the order of operations employed by Oracle 12c when solving equations?
A. 13
-
Combining the contents of two or more columns is known as ____.
A. concatenation
-
Which of the following can lead to partial dependencies?
A. composite primary key
-
A DBMS includes which of the following capabilities?
D. all of the above
-
Which of the following does not contain repeating groups, but has a primary key and possibly partial dependencies?
D. first normal form (1NF)
-
Which of the following are case sensitive in Oracle 12c?
A. 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?
A. field
-
What is used to indicate the end of an SQL statement?
B. /
-
Partial dependency exists if what conditions exist?
D. a column is dependent only on a portion of a composite primary key
-
Data mining refers to ____.
B. analyzing data already stored in a database
-
A(n) ____ has a predefined meaning in Oracle 12c.
A. statement
-
In an E-R Model a person, place, or thing with characteristics to be stored in the database are referred to as?
D. entity
-
Which of the following committees are responsible for establishing SQL guidelines?
A. ANSI and ISO
-
If uncontrolled, what can lead to data anomalies?
B. data redundancy
|
|
