DD & DP Final Exam Review
Pig's Ear
A Recursive Relationship is represented on an ERD by a/an:
Attributes, Relationships
A UID can be made up from.....
The Primary Key
A barrred Relationship will result in a Foreign Key column that also is part of:
Exclusivity
Arcs are used to visually represent _________ between two or more relationships in an ERD.
Heirarchical
Cascading UIDs are a feature often found in what type of Relationship?
Division and multiplication operations are handled before subtraction and addition operations.
How are arithmetic expressions handled?
CUBE
If you want to include subtotals and grand totals for all columns mentioned in a GROUP BY clause, you should use which of the following extensions to the GROUP BY clause?
Ranges of dates, Ranges of numbers
Nonequijoins are normally used with....
WHERE
The _______ clause can be added to a SELECT statement to return a subset of the data.
DROP TABLE
The previous administrator created a table named CONTACTS, which contains outdated data. You want to remove the table and its data from the database. Which statement should you issue?
Tables
The transformation from an ER diagram to a physical design involves changing terminology. Entities in the ER diagram become __________ :
ONCE; LAST
To control the order of rows returned using SET operators, the ORDER BY clause is used ______ and is placed in the _____ SELECT statement of the query.
Intersection table
To resolve a many to many relationship in a physical model you create a(n) ___________________?
CORRELATED SUBQUERY
When creating a report of all employees earning more than the average salary for their department, a __________ ____________ can be used to first calculate the average salary of each department, and then compare the salary for each employee to the average salary of that employeeﾒs department.
Normalization
When data is stored in more than one place in a database, the database violates the rules of ___________.
When the same column name appears in more than one table of the query
When must column names be prefixed by table names in join syntax?
LENGTH
Which character manipulation function always returns a numerical value?
SELECT
Which clause specifies one or more columns to be returned by the query?
ORDER BY
Which clause would you include in a SELECT statement to sort the rows returned by the LAST_NAME column?
LIKE
Which comparison operator searches for a specified character pattern?
TIMESTAMP
Which datatype should be used to store time with fractions of seconds?
A column alias
Which elements cannot be included in a WHERE clause?
NULLIF
Which function compares two expressions?
CASE
Which is a conditional expression used in SQL?
Columns with the same names must have the same precision and datatype.
Which is true about a natural join?
To exclude rows before dividing them into groups using the GROUP BY clause, you should use a WHERE clause.
Which is true about the GROUP BY clause?
Outer join
Which type of join returns rows from one table that have NO direct match in the other table?
Employee ID, Social Security Number
Which would be suitable UIDs for the entity EMPLOYEE:
one
You can only insert _____ row at a time using an INSERT statement with a VALUES clause?
SUM
You need to compute the total salary amount for all employees in department 10. Which group function will you use?
Natural join
You need to join two tables that have two columns with the same name, datatype, and precision. Which type of join would you create to join the tables on both of the columns?
The WHERE clause
You need to update the expiration date, but only for products manufactured before June 30th . In which clause of the UPDATE statement will you specify this condition?
SET UNUSED
You should use the _________ when you need a quick way of dropping a column.
produce subtotal values
You use ROLLUP to:
