IS 340 Midterm 1 Study Guide (Chapter 1,2,8,9)

Which of the following is used to create and maintain the physical database? A. Data mining B. Database Management System (DBMS) C. E-R Model D. Systems Development Life Cycle (SDLC)

B. Database Management System (DBMS)

Which of the following terms represents a collection of fields? A. Field B. Record C. Character D. File

B. Record

Which following terms best describes where a group of characters that represents a customer's address would be stored in the logical design? A. Record B. File C. Field D. Database

C. Field

A field in the logical design of a database corresponds to a _______ in the physical database.

Column

A DBMS includes which of the following capabilities? A. Security B. Data Dictionary C. Multi User Access D. All of the Above

D. All of the Above

Which of the following is not a step in the Systems Development Life Cycle (SDLC)? A. Systems Analysis B. Systems Investigation C. Systems Design D. All of the Above are Steps in the SDLC

D. All of the Above are Steps in the SDLC

Which of the following terms refers to a group of related records? A. Database B. Character C. Field D. File

D. File

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

(T/F) A collection of fields is a file.

False

(T/F) A database is a physical storage device for data.

False

(T/F) A double backslash (\\) is used to indicate concatenation in a SELECT statement.

False

(T/F) A field in the logical design of a database corresponds to a row in the physical table of a relational database.

False

(T/F) A field is a basic unit of data also referred to as a record.

False

(T/F) A foreign key uniquely identifies each row in a table.

False

(T/F) A one-to-many relationship cannot be included in a relational database.

False

(T/F) A one-to-many relationship means that an occurance of a specific entity can only exist once in each table.

False

(T/F) A(n) CRBMDS is a software program that can be used to create a relational database and allows you to enter, manipulate, and retrieve data.

False

(T/F) A(n) WHERE statement allows a user to retrieve data from a database table.

False

(T/F) An entity is represented by a column in the Equity-Relationship Model.

False

(T/F) By default, a column alias is displayed in lower case characters in the results.

False

(T/F) Choosing specific columns to be displayed by a SELECT statement is known as selection.

False

(T/F) Concatenation refers to combining the results of several SELECT statements into one result.

False

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

False

(T/F) Data redundancy is created through a process known as normalization.

False

(T/F) Each section of a SQL command that begins with a keyword is known as a statement.

False

(T/F) Each section of a statement that begins with a keyword is known as a(n) buffer.

False

(T/F) If a column name is entered in lower case in the SELECT statement, the data for the column will be displayed in lower case in the results.

False

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

False

(T/F) If you assign a column alias to a column, it must be enclosed in double quotation marks (" ").

False

(T/F) Only one type of relationship can be represented in an Entity-Relationship Model.

False

(T/F) SQL*Plus can only be accessed via an internet interface.

False

(T/F) THe DIST or UNIQ keywords can be used to suppress duplicate data in the results of a SELECT statement.

False

(T/F) Tables can be linked or joined together through their primary keys.

False

(T/F) The DESCRIBE command is used to view data in a table.

False

(T/F) The SELECT clause of the SELECT statement is used to identify which rows are to be retrieved from a specified table.

False

(T/F) The asterisk symbol (*) can be used in a SELECT statement to indicate that all rows in the table should be displayed in the results.

False

(T/F) The columns displayed in the results of a SELECT statement will be in the same order as they are stored in the database table.

False

(T/F) The following arithmetic operations can be performed in the SELECT clause of a SELECT statement: addition (+), subtraction (-), multiplication (*), division (/), and exponential (^).

False

(T/F) Transitive dependency can only exist if the data is uniquely identified by a composite primary key.

False

A record in the logical design of a database corresponds to a ________ in the physical database.

Row

In which step of the Systems Development Life Cycle (SDLC) is the solution to the identified problem determined and understood?

Systems Analysis

In which step of the Systems Development Life Cycle (SDLC) are the logical and physical components defined?

Systems Design

In which step of the Systems Development Life Cycle (SDLC) is the system actually used by the end-user on a regular basis?

Systems deployment

(T/F) A bridging table can be used to eliminate a many-to-many relationship in a relational database.

True

(T/F) A character is a basic unit of data and can consist of a number, letter, or special symbol.

True

(T/F) A clause is a section within a SQL statement that begins with a keyword.

True

(T/F) A collection of records is a file.

True

(T/F) A column represents a field in the physical database table.

True

(T/F) A foreign key appears on the many side of a one-to-many relationship.

True

(T/F) A many-to-many relationship cannot exist in a relational database.

True

(T/F) A query can be executed in the SQL*Plus tool.

True

(T/F) A query is accomplished by issuing a SELECT statement.

True

(T/F) A record in the logical design of a database corresponds to a row in the physical table of a relational database.

True

(T/F) A script file containing SQL statements can be executed from SQL*Plus

True

(T/F) An 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

(T/F) Choosing specific columns to be displayed by a SELECT statement is known as projection.

True

(T/F) Column headings may be truncated in the results of a SELECT statement.

True

(T/F) Data mining refers to analyzing historical data stored in a database.

True

(T/F) If multiple column names are listed in the SELECT clause of a SELECT statement, the columns must be separated by a comma (,).

True

(T/F) Parentheses can be used to override the order of operations in an arithmetic expression.

True

(T/F) Partial dependency can only exist if the data is uniquely identified by a composite primary key.

True

(T/F) Partial dependency means that at least one of the data values is dependent on only a portion of the primary key.

True

(T/F) SQL*Plus is an Oracle tool used to enter and edit SQL statements.

True

(T/F) Structured Query Language (SQL) is generally used to interact with a database.

True

(T/F) THe simplest approach to remove a partial dependency is to use each portion of the primary key to create seperate tables.

True

(T/F) 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

(T/F) The following types of relationships can be included in an Entity-Relationship Model: one-to-one, one-to-many, many-to-many.

True

(T/F) The majority of operations performed on a typical database utilize the SELECT statement.

True

(T/F) The occurrence of data anomalies would indicate an unnormalized database design.

True

(T/F) The optional keyword AS can be used to indicate that the subsequent string of characters is a column alias.

True

(T/F) The syntax for a SQL statement gives the basic structure required to execute the statement.

True

(T/F) Two tables can be linked or joined together through a common field.

True

(T/F) When a user asks the database a question, the user is issuing a query.

True

The multi-step process used when creating a new system is referred to as ______.

the Systems Development Life Cycle

Which of the following terms is considered the basic unit of data in a database? A. Character B. Field C. Record D. File

A. Character

Which statement best describes the one-to-one relationship? A. For every occurence of A, there can only be one occurrence of B. B. For every occurrence of A, there can be multiple occurrences of B. C. There can be multiple occurrences of A and B. D. For every occurrence of B, there can be multiple occurrences of A.

A. For every occurence of A, there can only be one occurrence of B.