Unit 4 Test
A join in which each row in one table is matched to every row in a second table is called a(n) ________ join.
***NOT RIGHT OUTER***
Which of the following statments are TRUE about NULLS?
-A null value is unknown
Database reliability includes:
-processing data without error
Which SQL keyword is used to separate two conditions when both must be true for the rows(records) to be selected?
AND
Which SQL keyword is used to separate two conditions where both must be true for the rows(records) to be selected?
AND
Which aggregate function is used to count rows?
COUNT(*)
A join in which each row in one table is matched to every row in a second table is called a(n) _____join.
CROSS
Which of the following cannot be done using the CONSTRAINT phrase?
Create a second (candidate) primary key
Which of the following cannot be done using the CONSTRAINT phase?
Create a second(candidate) primary key
Which SQL keyword is used to remove one or more rows (records) from a table?
DELETE
Which SQL keyword is used to remove one or more rows(records) from a table?
DELETE
Which SQL Keyword/phrase is used to eliminate duplicate rows in the results of a SQL SELECT query?
DISTINCT
Which of the following keywords is used in most SELECT statements?
FROM
Which of the following keywords is used in most SELECT statments?
FROM
Because database structures are stored in system tables, the use of data dictionaries is uncommon.
False
Free databases rarely have limits on hardware utilization, like RAM or number of processors.
False
Inner Joins are limited to joining just two tables. If you need to join three or more tables, a different type of JOIN is required.
False
It is common for free database management systems to support features like failover.
False
It is possible to use HAVING without GROUP BY.
False
Subqueries can do everything JOINs can do and some things a JOIN cannot do.
False
Using alias names for columns using aggregate functions does nothing to improve the output and are therefore frowned upon because of the extra processing time required to execute the query.
False
Which SQL keyword is used to apply conditions to restrict groups that appear in the results of a SELECT query that uses GROUP BY?
HAVING
A(n) ________ join returns the selected columns for all the rows in chosen tables that have a related row in the joined table.
Inner
Which of the following statements is FALSE regarding the LIKE statement?
LIKE is most often used with numeric data
Which of the following statements is FALSE regarding the like statement?
Like is most often used with numeric data
Which aggregate function would you use to display the birth date of the oldest employee?
MIN
Which keyword is used to select a record if the column/field value meets any of the criteria listed?
OR
Which of the following key phrases is used with SELECT to sort a result set?
ORDER BY
Which of the following statements is FALSE about primary keys?
Primary keys must be a single attribute.
Which aggregate function is used to total numeric columns (fields)?
SUM
Which aggregate function is used to total numeric columns(fields)?
SUM
1411Server.TutorCenter.dbo.Tutor.TutorKey is a valid example of a fully qualified name.
True
Any column that is not part of an aggregate function must be included in a GROUP BY clause.
True
Data types determine what kind of data can be stored in a table field.
True
It is possible to use DISTINCT with aggregate functions.
True
It is possible to use GROUP BY without HAVING.
True
Joins allow the user to reunite elements that have been split into a single result set.
True
Open source databases, like MySQL, are good choices for Web-based applications.
True
1411Server.TutorCenter.dbo.Tutor.TutorKey, what is the name of the database?
TutorCenter
In this qualified name , 1411Server.TutorCenter.dbo.Tutor.TutorKey, what is the name of the database?
TutorCenter
Which SQL keyword is used to modify one or more rows (records) from a table? DELETE
UPDATE
Which SQL keyword is used to modify one or more rows(records) from a table?
UPDATE
Which SQL keyword is used to apply conditions to restrict groups that appear in the results of a SELECT query that uses GROUP BY?
WHERE
Which SQL keyword is used to apply conditions to restrict records that are included in the results of a SELECT query?
WHERE
A(n) _____ is a substitute name for a column or table.
alias
The process of confirming a user is who he or she caims to be is called.
authentication
The processes of granting permissions to authenticated users is called
authorization
Enormous structured and unstructured data sets are referred to as______
big data
Any action that a database takes, creating objects, adding rows, modifying data, and removing data are all examples of ______.
database transactions
A plan to recover data and amintain availability after any kind of disaster is called a(n)__________
disaster recovery plan
Which SQL keyword is used to apply conditions to restrict records that are included in the results of a SELECT query?
distinct
It is possible to use HAVING without GROUP BY
false
T/F: Because database structures are stored in system tables, the use of data dictionaries is uncommon.
false
T/F: Free databases rarely have limits on hardware utilization, like RAM or number of processors
false
T/F: Inner joins are limited to joined just two tables. If you need to join three or more tables, a different type of JOIN is required.
false
T/F: It is common for free database management systems to support features like failover.
false
T/F: Subqueries can do everthing JOINS can do and some things a JOIN cannot do.
false
Using alias names for columns using aggregate functions does nothing to improve the output and are therefore frowned upon because of the extra processing time required to execute the query.
false
A(n) ______join returns the selected columns for all the rows in chosen tables that have a related row in the joined table.
inner
A _____ is an action granted to a user
permission
Rules for how to do some activity are called______.
policies
Step-by-step instructions for accomplishing a task are referred to as_____________-
procedures.
To avoid an ambiguous reference in an SQL statement, it is recommended that you use a ________.
quailified name
To avoid an ambiguous reference in an SQL statement, it is recommended that you use a:
qualified name
A ____ is a colletion of related permissions.
role
Which SQL keyword/phrase is used to eliminate duplicate rows in the results of a SQL SELECT query?
sort
One or more SQL statements grouped to be executed together is called a _______
stored procedure
Any column that is not part of an aggregate function must be included in a GROUP BY clause.
true
It is possible to use DISTINCT with aggregate functions.
true
T/F: 1411Server.TutorCenter.dbo.Tutor.TutorKey is an example of a fully qualified name.
true
T/F: Data types determine what kind of data can be stored in a table field.
true
T/F: It is possible to use GROUP BY without HAVING
true
T/F: Joins allow the user to reuite elements that have been split into a single result set.
true
T/F: Open source databases, like MySQL, are good choices for Web-based applications.
true
A stored query or filter that reflects a user's view of the data is called a _____.
view
Which SQL keyword is used to apply conditions to restrict records that are included in the results of a SELECT query?
where
