Database Concepts - Module 6 Quiz, Final - Database Concepts, Module 8 Quiz - Database Concepts, Module 7 Quiz - Database Concepts, Database Concepts - Module 6 Quiz, computer, SQL Chapter 2, Database Concepts - Module 6 Quiz
In SQL for Oracle and for SQL Server, the ____ symbol is used as a wildcard to represent any collection of characters.
%
SQL was developed in the mid-____.
1970's
Variable names in PL/SQL must start with a letter and can contain letters, dollar signs, underscores, and number signs, but cannot exceed _____.
30 characters
How many tables make up the KimTay database?
5
nonkey
A ____ column is a column that is not part of the primary key.
False
A determinant is any column (or collection of columns) that determines another table.
column
A field is another term for a(n) ____.
False
A programmer interviews users, examines existing and proposed documents, and examines organizational policies to determine exactly the type of data needs the database must support
tuple
A record is another term for a(n) ____.
False
A relation is essentially a three-dimensional table.
first normal form
A relation is in ____ if it does not contain any repeating groups.
relations
A relational database is a collection of ________.
Entities
A relationship is an association between _______.
False
A table is in third normal form if it is in second normal form and no nonkey column is dependent on only a portion of the primary key.
REPEATING
A table's design should be as simple as possible; you should restrict each position in a table to a single entry by not allowing multiple entries (called a(n) _____ group) in an individual location in the table.
False
A tabular database is a collection of tables.
Which statement about views is correct?
A view can join two or more tables and/or involve statistics.
All of the above (attribute, field, column)
A(n) ____ is a characteristic or property of an entity.
tuple
A(n) ____ is another name for a record or a row.
relationship
A(n) ____ is the association between entities.
NONKEY
A(n) _____ column is a column that is not part of the primary key.
ENTITY
A(n) ______ is a person, place, object, event, or idea for which you want to store and process data.
RELATIONSHIP
A(n) ________ is the association between entities.
In Oracle, to add a specific number of months to a date, use the _____.
ADD_MONTHS function
If you precede the subquery by the ____ operator, the condition is true only if it satisfies all values produced by the subquery.
ALL
Which privilege should be granted to users who are authorized to change a table's structure?
ALTER
If you precede the subquery by the ____ operator, the condition is true only if it satisfies any value (one or more) produced by the subquery.
ANY
A condition is true if it satisfies any value (one or more) produced by a subquery that is preceded by the _____.
ANY operator
The CREATE VIEW command includes the words CREATE VIEW, followed by the name of the view, the word ____, and then a query.
AS
Why have Social Security numbers traditionally been used as primary keys for database tables that store personal data on individual people?
All other columns in such a table are functionally dependent on the Social Security number column.
What happens if you run a DELETE command that does not contain a WHERE clause?
All rows will be deleted from the table.
True
An unnormalized relation is a relation that contains repeating groups.
dependency
Any column (or collection of columns) that determines another column is called a(n) ____.
To display all the rows and columns in a table, type the word SELECT, followed by a(n) ____, followed by the word FROM and then the name of the table containing the data you want to view.
Asterick
one-to-many
At Premiere Products, there is a ____ relationship between sales reps and customers.
The default transaction mode in Oracle, which commits each action query as soon as the user executes the query, is _____.
Autocommit
The ____ operator is inclusive, meaning that a value equal to either end would be selected.
BETWEEN
The ____ operator specifies a range of values in a condition.
BETWEEN
True
Because there is a one-to-many relationship between sales reps and customers n the Premiere Products database, One sales rep can be associated with zero, one, or more customers.
Use the ____ data type for columns that contain letters and special characters and for columns containing numbers that will not be used in calculations.
CHAR
Once you have verified that the update you made is correct, you can make the update permanent by using the _____.
COMMIT command
When you use the ____ function, you can use the asterisk (*) to represent any column.
COUNT
The ____ command defines a table's structure by listing its columns, data types, and column lengths.
CREATE TABLE
Which command can you use to create a new table using data in an existing table?
CREATE TABLE
Which command do you use to write a procedure that should be executed automatically when a certain database operation is performed?
CREATE TRIGGER
To ensure the uniqueness of values in a nonprimary key column, you can create an index using the _____.
CREATE UNIQUE INDEX command
What function can you use to obtain today's date in MySQL?
CURDATE()
The product of two tables is formally called the _____.
Cartesian product
A field is another term for a(n) ____.
Column
False
Columns are sometimes called tuples.
If Mack wants to display the number of days between two dates, such as the current date and an invoice date from a table, which function can he use in his MySQL query to accomplish this?
DATEDIFF()
In Oracle, which table contains information about the columns within tables?
DBA_TAB_COLUMNS
In Oracle, dates have the format ____.
DD-MON-YY
Which of the following statements can you add to a stored procedure to provide meaningful feedback to a user who attempts to execute the procedure with an argument that is invalid because it is missing from the table column being queried?
DECLARE EXIT HANDLER FOR NOT FOUND
What command is used to delete rows from the database?
DELETE
Which SQL command do you use to remove an entire row from a table?
DELETE
Which is the correct sequence of elements in a command to remove rows from a MySQL table?
DELETE FROM, table name, WHERE clause with a condition
When you execute a stored procedure to retrieve a single row with embedded SQL, you need MySQL to treat several statements ending in a semicolon as if they were a single statement. What keyword do you use to tell MySQL to use a different character to signal the end of a statement in this situation?
DELIMITER
In Oracle, use the ____________________ command to list all columns in a table and their properties.
DESCRIBE
Which command is used to display the structure of a table in MySQL?
DESCRIBE
Which of the following commands deletes an index?
DROP INDEX
To delete an entire table, use the ____ command and then re-create the table.
DROP TABLE
Which command(s) can you use to delete an entire table and its data?
DROP TABLE
Which of the following is a valid SQL command?
DROP TABLE LEVEL1_CUSTOMER;
The process of determining the particular tables and columns that will comprise a database is known as ____.
Database design
Any column (or collection of columns) that determines another column is called a(n) ____.
Determinant
For any column whose data type is CHAR, values must be enclosed in ____.
Double Quotation Marks
Which command is used to call a procedure in SQL Server?
EXEC
True
Each column in a table of a relational database should have a distinct name.
A(n) ____________________ is a person, place, thing, or event for which you want to store and process data.
Entity
When you use a cursor in a procedure, what command advances the cursor to the next row in the set of rows retrieved by the query and places the contents of the row in the indicated variables?
FETCH
Which function can you use in Oracle, MySQL, and SQL Server to truncate everything to the right of the decimal point?
FLOOR
All SELECT statements require a WHERE clause.
False
Applying the function ROUND(PRICE,0) to the price 24.95 results in 24.
False
In Oracle, the data type STRING(n) stores a character string n characters long.
False
In SQL Server, you use the & symbol to concatenate columns.
False
In SQL, you cannot enter an apostrophe into a column whose type is character (CHAR).
False
In a SELECT statement, the FROM clause and the WHERE clause (when used) must appear on separate lines.
False
Instead of including every column in the SELECT clause, you can use an ampersand (&) to indicate that you want to include all columns.
False
The COUNT function only applies to columns with numeric values.
False
The DATE_ADD function has one argument.
False
The DROP TABLE command creates an empty table.
False
The issues involved in updating data within base tables through a view are the same regardless of the type of view.
False
To permanently remove both a table and its data, you must execute both a DROP TABLE command and a DELETE command.
False
Using SQL, you can increase the length of an existing table column but you cannot decrease the length of a column.
False
You can create and maintain an index on any row in any table.
False
You can use the APPEND command to add additional rows to tables.
False
You cannot assign names to computed columns.
False
You cannot use functions in WHERE clauses.
False
A primary key always comprises a single column.
False
You can join three tables together but not four tables.
False
A(n) ____ is a property of an entity.
Field, Attribute, Common
A relation is in ____________________ normal form if it does not contain any repeating groups.
First
A relation is in ____ if it does not contain any repeating groups.
First Normal Form
In a relational database, column B is ____________________ on another column A, if at any point in time a value for A determines a single value for B.
Functionally Dependent
In SQL Server, you can obtain today's date using the _____.
GETDATE() function
Which command will allow user Thompson to remove rows from the CUSTOMER table?
GRANT DELETE ON CUSTOMER TO THOMPSON;
The ____ clause lets you group data on a particular column.
GROUP BY
Which clause lets you group data on a particular column?
GROUP BY
The ____ clause is used to restrict the groups that will be included in a query result.
HAVING
You can use the ____ operator followed by a collection of values to provide a concise way of phrasing certain conditions.
IN
To retrieve data from multiple tables in a query, you can use a subquery containing the _____.
IN operator
The ____________________ command adds rows to a table.
INSERT
Which command should Josephine use if she would like to add a new row to the BMI table in MySQL?
INSERT INTO BMI VALUES ('Emily', 'Cross', 66, 115);
James has created a new MySQL table called FAVORITES and would like to populate it with data from the existing CANDY table. Which command can he use to add data for rows with a rating of seven or more?
INSERT INTO FAVORITES (SELECT ID, NAME, PRICE, RATING FROM CANDY WHERE (RATING > 7));
To add data from an existing table to a new table, use a SELECT command in a(n) _____.
INSERT command
The ____ data type is used to store integers.
INT
The ____ operator finds rows that do not contain a null value in the specified column.
IS NOT NULL
Which operator finds rows that do not contain a null value in the specified column?
IS NOT NULL
What happens if Samantha, whose view of the database contains only a portion of the rows and columns of the base table, attempts to add a row to the table through her view?
If Samantha's INSERT command succeeds, the new row will contain several null values.
second
If the primary key of a table contains only a single column, the table is automatically in _____ normal form.
Which statement about triggers is correct?
In SQL Server, you create triggers using T-SQL.
True
In a relation, all values in a column are values of the same attribute.
immaterial
In a relation, the order of the rows and columns is ____________________
row, record, tuple
In a relational database each ____ should be unique.
functionally dependent
In a relational database, column B is ______ on another column A, it at any point in time a value for A determines a single value for B.
True
In a relational database, relationships are implemented by having common columns in two or more tables.
False
In a relational database, two columns can be identical
rectangles
In an entity-relationship (E-R) diagram, ____ are used to represent an entity.
lines
In an entity-relationship (E-R) diagram, one-to-many relationships between entities are drawn as ____ .
RELATIONSHIPS
In one style of entity-relationship (E-R) diagrams, diamonds are used to describe _____.
third normal form
In this text, Boyce-Codd normal form is the same as ____.
Which general guideline for naming identifiers should you follow when creating a database and adding objects to it?
Include letters, numbers, and/or underscores.
____ is one of the categories of update anomalies.
Inconsistent data
Which of the following joins compares the tables in the FROM clause and lists only those rows that satisfy the condition in the WHERE clause?
Inner
The ____ operator uses one or more wildcard characters to test for a pattern match.
LIKE
In MySQL, Oracle, and SQL server, you can display a value in lowercase letters using the _____.
LOWER function
In an entity-relationship (E-R) diagram, one-to-many relationships between entities are drawn as ____.
Lines
Which clause can you use with the ALTER TABLE command to change a column that currently rejects null values so that it will accept null values?
MODIFY
Martine's database administrator has set up a view for her so that she can access the information she needs from the database. What will happen when new columns Martine does not need to see are added to the base tables used for Martine's view?
Martine can continue to use her view as usual.
To indicate columns that cannot contain null values, use the ____________________ clause in a CREATE TABLE statement.
NOT NULL
Changing a value in a table column to null is prohibited if, when you created the table, you specified _____.
NOT NULL for the column
A ____ column is a column that is not part of the primary key.
Nonkey
A(n) ____________________ column is a column that is not part of the primary key.
Nonkey
False
Normalization is done before creating the database design
You use the ____ clause to list data in a specific order.
ORDER BY
Which MySQL clause used with the query SELECT* FROM PACKAGE would be the most likely to yield the following results?
ORDER BY PRICE DESC, PACKAGE_NAME
Which of the following is the primary key of the ORDER_LINE (ORDER_NUM, ITEM_NUM, NUM_ORDERED, QUOTED_PRICE) table?
ORDER_NUM and ITEM_NUM
In a relation, the ____________________ of the rows and columns is immaterial.
Order
StayWell stores information about the facilities where student residents live in the _____ table.
PROPERTY
There is a commonly accepted shorthand representation to show the structure of a relational database: After the name of the table, all the columns in the table are listed within a set of ____.
Paranthasis
To qualify a column name, precede the name of the column with the name of the table, followed by a(n) ____.
Period(.)
Which of the following symbols is used to qualify column names?
Period(.)
How do you use data from certain columns of an existing table to populate a new table with a matching structure?
Place a SELECT command within an INSERT command.
The ____________________ key of a table (relation) is the column or collection of columns that uniquely identifies a given row in that table.
Primary
SQL is Structured ____________________ Language.
QUERY
When you write a column in the format CUSTOMER.REP_NUM, you say that you ____________________ the column name.
Qualify
The general form for assigning a foreign key is ADD FOREIGN KEY, the column name(s) of the foreign key, the ____ clause, and then the table name and column that the foreign key must match.
REFERENCES
Percy is promoted and is no longer responsible for making updates to several database tables. Which command should Percy's database administrator use to prevent Percy from making future updates?
REVOKE
If you have not run the COMMIT command, you can reverse all updates made during the current work session by executing the _____.
ROLLBACK command
Which of the following commands executes a rollback?
ROLLBACK;
In Oracle, SQL Server, and MySQL, you can round a numeric value to a desired number of decimal places using the _____.
ROUND function
To remove extra spaces to the right of a value after concatenating two or more columns, use the _____.
RTRIM function
In a relational database each ____ should be unique.
Record, Row, Tuple
In an entity-relationship (E-R) diagram, ____ are used to represent an entity.
Rectangles
____ is the duplication of data.
Redundamcy
A relational database is a collection of ____________________.
Relations
A(n) ____ is the association between entities.
Relationship
A(n) ____________________ is the association between entities.
Relationship
A record is another term for a(n) ____.
Row
A(n) ____ clause can include statistics calculated for only the groups or columns whose values are identical for each row in a group.
SELECT
To view the data in a table, you use the ____________________ command.
SELECT
Which privilege can be granted to allow a user to retrieve data?
SELECT
Which MySQL command displays all tables associated with the database ELPATRON?
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE (TABLE_SCHEMA = 'ELPATRON');
The basic form of the SQL SELECT command is ____.
SELECT-FROM-WHERE
Information about the services requested by StayWell residents is stored in the _____ table.
SERVICE_REQUEST
The ____ function calculates a total of the values in a column.
SUM
A ____ file is a text file with a .sql extension that contains SQL commands.
Script
When a script file contains more than one command, each command must end with a(n) ____.
Semicolon
You indicate the end of a command by typing a ____.
Semicolon
What is the original name of SQL?
Sequel
Which statement regarding primary keys is true?
Some tables include more than one column that can be used as a primary key.
You create an alias by typing the name of the table, pressing the ____, and then typing the name of the alias.
Spacebar
Which of the following is a valid name for a table?
TBL_1
Which of the following is a valid name for a table?
TBL_1
What happens once the following command is executed? ALTER TABLE ORDERS ADD FOREIGN KEY (CLIENT_ID) REFERENCES CLIENT (CLIENT_ID);
The DBMS will reject updates to the ORDERS table with CLIENT_ID values missing from the CLIENT table.
PRIMARY
The _______ key of a table (relation) is the column or collection of columns that uniquely identifies a given row in that table.
True
The definition for a primary key really defines a candidate key as well
Which statement describing relations is false?
The entries in a relation may be single- or double-valued.
updates
The four categories of update anomalies are additions, deletions, inconsistent data, and ______.
database design
The process of determining the particular tables and columns that will comprise a database is known as ____.
True
The statement "A sales rep's pay class functionally determines his or her pay rate" means that if you know the pay class, you also know the pay rate.
parentheses
There is a commonly accepted shorthand representation to show the structure of a relational database: After the name of the table, all the columns in the table are listed within a set of ____.
How does the procedure for adding rows to an existing MySQL table compare to that for populating a new table that has just been created?
They are identical.
In this text, Boyce-Codd normal form is the same as ____.
Third Normal Form
Dropping a table also deletes any data that you entered into the table.
True
In Oracle, the date, November 12, 2015 would be stored as '12-NOV-2015'.
True
In general, SQL is case-sensitive.
True
It is possible to place one query inside another.
True
It is possible to use both a WHERE clause and a HAVING clause in a SELECT statement.
True
Preceding a condition by the NOT operator reverses the truth of the original condition.
True
Table names cannot contain spaces.
True
The DISTINCT operator is useful when used in conjunction with the COUNT function.
True
The Oracle Database 11 g Express edition allows you to save a command so you can use it again without retyping it.
True
The WHERE clause is used to retrieve rows that satisfy some condition.
True
The data type DECIMAL(5,2) represents a number with three places to the left and two places to the right of the decimal.
True
The data type indicates the type of data that a column can contain.
True
To create a table, type the command DESCRIBE TABLE followed by the name of the table to be created and then by the names and data types of the columns that will comprise the table.
True
Views furnish a certain amount of security; if users are accessing the database through a view, they cannot access any data that is not included in the view.
True
When adding rows to character columns, make sure you enclose the values in single quotation marks.
True
When the OR operator connects simple conditions, the compound condition will be true whenever any one of the simple conditions is true.
True
When users create, alter, or drop tables or create or drop indexes, the DBMS updates the system catalog automatically.
True
When you connect two or more simple conditions with the AND operator, each condition must be listed on a separate line.
True
When you need to complete tasks that are beyond the capabilities of SQL, you need to use a procedural language.
True
You can use the existing value in a column and a calculation to update a value.
True
Each column in a table of a relational database should have a distinct name.
True
In a relational database, relationships are implemented by having common columns in two or more tables.
True
It is permissible to qualify all column names in a query.
True
One reason for using an alias is simplicity.
True
One reason for using an alias is when you are joining a table to itself.
True
To ensure that query results are listed in a desired order, use the ORDER BY clause.
True
You can indicate a table's primary key by underlining the column or collection of columns that comprises the primary key for each table in the database.
True
You can join tables by using a condition in the WHERE clause.
True
You must join tables by finding rows in the two tables that have identical values in matching columns.
True
A(n) ____________________ is another name for a record or a row.
Tuple
Which command can you use to change rows for which a specific condition is true?
UPDATE
Barney learns that the phone number for his friend Lacey in his ADDRESS_BOOK table has been disconnected; thus, her number is now unknown to him. Which SQL statement should Barney use to update the table so as to reflect this unknown value?
UPDATE ADDRESS_BOOK SET PHONE_NO = NULL WHERE (NAME = 'Lacey');
Which is the correct sequence of elements for a SQL command that will change a value in an existing table row?
UPDATE, table name, SET, column name, equal sign, new value
Which function displays a value in uppercase letters in Oracle and SQL Server?
UPPER
____ can occur when there is a column in a table that is dependent on only a portion of the primary key.
Update Anomolies
The ____ data type stores only the actual character string.
VARCHAR
You can join tables by using a condition in the ____ clause.
WHERE
Which WHERE clause can you use with a SELECT statement to perform a case-insensitive search for rows containing the first name Marco?
WHERE UPPER(FIRST_NAME) = 'MARCO'
qualify
When you write a column in the format CUSTOMER.REP_NUM, you say that you _____ the column name
Order_num and Part_num
Which of the following is the primary key of the ORDER_LINE (ORDER_NUM, PART_NUM, NUM_ORDERED, QUOTED_PRICE) table?
(.)
Which of the following symbols is used to qualify column names?
The ____ wildcard symbol represents any individual character.
_
update anomalies
____ can occur when there is a column in a table that is dependent on only a portion of the primary key.
inconsistent data
____ is one of the categories of update anomalies.
redundancy
____ is the duplication of data.
concatenation
____ is the formal term for combining two or more columns to form a primary key.
BOYCE-CODD NORMAL FORM (BCNF)
________ is another name given to third normal form in this text.
The purpose of creating databases indexes is to _____.
avoid searching through every row in a table with every query
When creating a stored procedure to retrieve a single row with embedded SQL, you must place the procedural code _____.
between the BEGIN and END commands
An index _____.
can be essential to the retrieval performance of very large database
Displaying a full name in query results when the first and last names are stored in separate columns in the database table is a typical use case for _____.
concatenation
When a subquery involves a table listed in the outer query, the subquery is called a(n) _____.
correlated subquery
The system catalog is also called the _____.
data dictionary
In a business organization, the person or entire group of people charged with managing the database is known as the _____.
database administrator
The ____ of two tables is the set of all rows that are in the first table but that are not in the second table.
difference
Adding a ORDER BY UNIT_PRICE clause to a SQL query will _____.
display the results in ascending order by UNIT_PRICE
What does this SQL command accomplish? ALTER TABLE PRODUCTS ADD CHECK (SIZE IN ('S', 'M', 'L', 'XL', 'XXL'));
establishes legal values for the SIZE column
Patty begins entering an order into her DBMS using SQL, but soon discovers she cannot complete the order entry process owing to missing data. What should she do to follow best practices related to transactions?
execute the ROLLBACK command
The invoice line in a KimTay invoice contains a total, which is usually called a(n) _____.
extension
A trigger is executed _____.
in response to a command such as INSERT, UPDATE, or DELETE
A MySQL command to change a value within a table to null _____.
incorporates the UPDATE and SET commands and a WHERE clause
In a ____, all rows from the table on the left (the table listed first in the query) will be included regardless of whether they match rows from the table on the right (the table listed second in the query).
left inner join
What does the following SQL query do? SELECT INVOICE_NUM FROM INVOICE_LINE WHERE PROD_CODE IN (SELECT PROD_CODE FROM PRODUCTS WHERE (PROD_TYPE = 'Cupcake'));
lists the invoice numbers for invoices containing line items with a "Cupcake" product type
When you specify a foreign key, the table referenced by the foreign key is the _____.
parent
When renaming columns for a view, you include the new column names in _____ following the name of the view.
parentheses
A database can be readily updated through a view when that view is derived from joining two base tables on a shared _____.
primary key
The types of constraints supported in SQL are ____.
primary keys, foreign keys, and legal values
The duplication of data is formally called _____.
redundancy
MySQL procedures without error handling _____.
return unclear results when used with invalid arguments
In a ____, all rows from the table on the right will be included regardless of whether they match rows from the table on the left.
right outter join
A text file with a .sql extension that contains SQL commands is a _____.
script file
When a script file contains more than one command, each command must end with a(n) _____.
semicolon
Views can contain only the columns required by a given user. What two advantages are conferred by this aspect of views?
simplicity and security
Adding rows to a view is most troublesome for the view user when that view contains _____.
statistics calculated from base tables
What do you need to know to complete the FIRST step in the process of creating a new table using data from an existing table, called CANDY, in MySQL?
the columns from CANDY that you want to include and their characteristics
What does the error code 1172 stand for?
too many rows
A logical unit of work, often conceptualized as a sequence of steps that accomplish a single task, is called a _____.
transaction
A procedure that is executed automatically in response to an associated database operation is called a _____.
trigger
A query is a question represented in a way that the DBMS can understand.
true
The HAVING clause is used to restrict groups that are included in a query result.
true
When joining tables, it is always necessary to qualify a column name.
true
An owner number in the OWNER table in the StayWell database consists of _____ uppercase letters followed by a three-digit number.
two
Suppose you have a table with a primary key composed of two columns. When another column in this table is dependent on only one of the two columns in the primary key, this poses a risk for _____.
update anomalies
A stored procedure that includes an UPDATE command between the BEGIN and END commands is known as a(n) _____.
update procedure
How do you add a specific number of days to a date in MySQL?
use an expression with a plus (+) operator such as "+ 14"
A program's or an individual user's picture of the database is called a(n) _____.
view