CIST 1220 SQL Final Exam Study Guide/CIST 1220 Final Exam Review Packet Guide fall 2022.

CIST 1220 SQL Final Exam Study Guide/CIST 1220 Final
Exam Review Packet Guide fall 2022.
Which of the following terms refers to a group of related records?a. character
b. database
c. file
d. field
c. File
Which of the following is used to uniquely identify each record?
a. primary key
b. row
c. partial dependency
d. account number
a. Primary Key
Which of the following is used to create and maintain the physical database?
a. Database Management System (DBMS)
b. Data mining
c. Systems Development Life Cycle (SDLC)
d. E-R Model
a.
Database Management System (DBMS)
Which of the following committees are responsible for establishing SQL
guidelines?
a. ANSI and ASCII
b. OSI and ASCII
c. IEEE and OSI
d. ANSI and ISO
d. ANSI and ISO
Which of the following is an example of an attribute?
a. a person's hair color
b. the people who live in a particular town
c. the patients in a doctor's office
d. vendors
a. a person's hair color
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?
a. composite primary key
b. foreign key
c. duplicate key
d. distinct key
b. Foreign Key
What represents a characteristic or attribute that is being collected about an
entity?
a. record
b. row

,c. field
d. both a and b
c. Field
The multi-step process used when creating a new system is referred to as
a. E-R Modeling
b. the Systems Development Life Cycle
c. data mining
d. SQL
b. the Systems Development Life Cycle
In which step of the Systems Development Life Cycle (SDLC) are the logical and
physical components defined?
a. systems implementation and review
b. systems design
c. systems analysis
d. systems recovery
b. systems design
In which step of the Systems Development Life Cycle (SDLC) is the solution to
the identified problem determined and understood?
a. systems design
b. systems analysis
c. systems investigation
d. systems implementation and review
b. Systems analysis
Data in first normal form (1NF) does not contain which of the following?
a. repeating groups
b. both a and b
c. partial dependencies
d. primary key
a. Repeating Groups
Data in second normal form (2NF) may contain which of the following?
a. both a and b
b. repeating groups
c. partial dependencies
d. transitive dependencies
d. Transitive Dependencies
What is added to a relational database to eliminate many-to-many relationships?
a. secondary entity
b. primary entity
c. bridging table
d. transitive dependency
c. Bridging Table
Two tables can be linked or joined together through a common field.
True
False
True

,Data mining refers to
a. selling data to other organizations
b. analyzing data already stored in a database
c. discovering new data to include in the database
d. all of the above
b. Analyzing data the already stored in the database
If entity A in Figure 2 represents customers and entity B represents automobiles,
which of the following statements is correct?
a. Each customer can own many cars and each car can be owned by many
customers.
b. Each customer can only own one car, but each car can be owned by many
customers.
c. Each customer can own many cars, but each car can be owned by only one
customer.
d. Each customer can only own one car and each car can only be owned by one
customer.
c. Each customer can own many cars, but each car can be owned by only one
customer.
A ____ is a storage structure designed to hold a collection of data.
a. database
b. column
c. table
d. row
a. database
A ____ is a group of interrelated files.
a. field
b. database
c. record
d. character
b. database
A DBMS includes which of the following capabilities?
a. multiuser access
b. data dictionary
c. security
d. all of the above
d. all of the above
What is used to indicate the end of an SQL statement?
a. *
b. :
c. /
d. ;
d. ;
Which of the following commands is used to issue a query?
a. SELECT
b. QUER

, c. QUESTION
d. FROM
a. SELECT
To indicate which database table contains the data to be selected by a query, the
table name should be listed in the ____ clause.
a. SELECT
b. HAVING
c. WHERE
d. FROM
c. FROM
Which of the following is a mandatory clause in a SELECT statement?
a. both a and b are mandatory
b. HAVING
c. FROM
d. WHERE
c. FROM
Which of the following symbols represents all the columns contained in a table?
a. ^
b. /
c. *
d. ;
c. *
Which of the following commands can be used to view the structure of a table?
a. DESCRIBE
b. SELECT
c. CONCATENATION
d. none of the above
a. DESCRIBE
Which of the following statements is correct?
a. Character columns are listed first in the output, followed by numeric columns.
b. The columns will be listed in the results in the same order they are listed in the
SELECT clause of the SELECT statement.
c. The columns will be listed in the results in the same order they are stored in
the database table.
d. Numeric columns are listed first in the output, followed by character columns.
b. The columns will be listed in the results in the same order they are listed in the
SELECT clause of the SELECT statement.
If a column alias contains a blank space, it must be enclosed in ____.
a. percent signs (% %)
b. double quotation marks (" ")
c. asterisks ( )
d. single quotation marks (' ')
b. Double Quotation Marks (" ")
A column alias must be contained within double quotation marks (" ") if it
contains which of the following?
a. blank spaces