Intro to SQL Final Exam Study Guide
What type of relationship exists between this pair of related entities?
BOOK and BOOK COPY (books have copies) Correct Answer: one-to-many
Storing the same data in more than one place is called ____. Correct Answer: redundancy
Customers, cars, and parts are examples of: Correct Answer: entities
An association between entities is known as a ____. Correct Answer: relationship
A visual way to represent a database is with a ____. Correct Answer: entry-relationship diagram
Popular ____ include Access, Oracle, DB2, MySQL, and SQL Server. Correct Answer: DBMSs
(Data Base Management Systems)
A person's name, birthday, and social security number are all examples of: Correct Answer:
attributes
________ are established between entities in a well-structured database so that the desired
information can be retrieved. Correct Answer: Relationships
____ are screen objects used to maintain, view, and print data from a database. Correct Answer:
Forms
An integrity constraint is a rule that ____. Correct Answer: data must follow in the database
____ is the prevention of unauthorized access to the database. Correct Answer: Security
A person, place, an object , an event or concept about which the organization wishes to maintain
data is called a: Correct Answer: Entity
A ____ is a characteristic or property of an entity. Correct Answer: Attribute
The ____ of an entity become the columns in the database table. Correct Answer: attributes
A database has ____ if the data in it satisfies all established integrity constraints. Correct
Answer: Integrity
________ is a property that lets you change the structure of the database without requiring you to
change the programs that access the database Correct Answer: Data independence
When duplicate column names exist in a database and you need to indicate the column to which
you are referring, ____. Correct Answer: write both the table name and the column name,
separated by a period
, Count, Sum, Avg, Max, and Min are a few of the built-in statistics or ____ functions that can be
used in a query. Correct Answer: Aggregate
The ____ key of a table is the column or collection of columns that uniquely identifies a given
row in that table. Correct Answer: Primary
Based on the statement below, which of the following is the primary key?
Part (PartNum, Description, OnHand, Class, Warehouse, Price) Correct Answer: PartNum
The basic form of an SQL retrieval command is ____. Correct Answer: SELECT-FROM-
WHERE
When used after the word SELECT, the ____ symbol indicates that you want to include all fields
in the query results in the order in which you described them to the DBMS when you created the
table. Correct Answer: *
Customer ( CustomerNum, CustomerName, Street, City, State, Zip, Balance, CreditLimit,
RepNum )
Based on the code above, list the number, name, credit limit, and balance for all customers with
credit limits that exceed their balances. Correct Answer: SELECT CustomerNum,
CustomerName, CreditLimit, Balance FROM Customer WHERE CreditLimit>Balance;
To use a wildcard, include the _________ operator in the WHERE clause, Correct Answer:
LIKE
The IN operator can be used instead of the OR operator in phrasing certain conditions. Correct
Answer: True
Redundancy wastes space because you are storing the same data in more than one place. Correct
Answer: True
CHAR data types are numbers without decimal points. Correct Answer: True
In a relation, the order of the rows is important. Correct Answer: True
In a SELECT statement, the WHERE clause is mandatory. Correct Answer: False
The separation of the data description from programs is referred to as Correct Answer: data
Independence
data type stores integers, but uses less space than INTEGER. Correct Answer: SMALLINT
What type of relationship exists between this pair of related entities?
BOOK and BOOK COPY (books have copies) Correct Answer: one-to-many
Storing the same data in more than one place is called ____. Correct Answer: redundancy
Customers, cars, and parts are examples of: Correct Answer: entities
An association between entities is known as a ____. Correct Answer: relationship
A visual way to represent a database is with a ____. Correct Answer: entry-relationship diagram
Popular ____ include Access, Oracle, DB2, MySQL, and SQL Server. Correct Answer: DBMSs
(Data Base Management Systems)
A person's name, birthday, and social security number are all examples of: Correct Answer:
attributes
________ are established between entities in a well-structured database so that the desired
information can be retrieved. Correct Answer: Relationships
____ are screen objects used to maintain, view, and print data from a database. Correct Answer:
Forms
An integrity constraint is a rule that ____. Correct Answer: data must follow in the database
____ is the prevention of unauthorized access to the database. Correct Answer: Security
A person, place, an object , an event or concept about which the organization wishes to maintain
data is called a: Correct Answer: Entity
A ____ is a characteristic or property of an entity. Correct Answer: Attribute
The ____ of an entity become the columns in the database table. Correct Answer: attributes
A database has ____ if the data in it satisfies all established integrity constraints. Correct
Answer: Integrity
________ is a property that lets you change the structure of the database without requiring you to
change the programs that access the database Correct Answer: Data independence
When duplicate column names exist in a database and you need to indicate the column to which
you are referring, ____. Correct Answer: write both the table name and the column name,
separated by a period
, Count, Sum, Avg, Max, and Min are a few of the built-in statistics or ____ functions that can be
used in a query. Correct Answer: Aggregate
The ____ key of a table is the column or collection of columns that uniquely identifies a given
row in that table. Correct Answer: Primary
Based on the statement below, which of the following is the primary key?
Part (PartNum, Description, OnHand, Class, Warehouse, Price) Correct Answer: PartNum
The basic form of an SQL retrieval command is ____. Correct Answer: SELECT-FROM-
WHERE
When used after the word SELECT, the ____ symbol indicates that you want to include all fields
in the query results in the order in which you described them to the DBMS when you created the
table. Correct Answer: *
Customer ( CustomerNum, CustomerName, Street, City, State, Zip, Balance, CreditLimit,
RepNum )
Based on the code above, list the number, name, credit limit, and balance for all customers with
credit limits that exceed their balances. Correct Answer: SELECT CustomerNum,
CustomerName, CreditLimit, Balance FROM Customer WHERE CreditLimit>Balance;
To use a wildcard, include the _________ operator in the WHERE clause, Correct Answer:
LIKE
The IN operator can be used instead of the OR operator in phrasing certain conditions. Correct
Answer: True
Redundancy wastes space because you are storing the same data in more than one place. Correct
Answer: True
CHAR data types are numbers without decimal points. Correct Answer: True
In a relation, the order of the rows is important. Correct Answer: True
In a SELECT statement, the WHERE clause is mandatory. Correct Answer: False
The separation of the data description from programs is referred to as Correct Answer: data
Independence
data type stores integers, but uses less space than INTEGER. Correct Answer: SMALLINT
