COP4710Midterm
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| What is a database? | show 🗑
|
||||
| show | Tables
🗑
|
||||
| The word "Relational" refers to __________, while a "Relation" is a __________. | show 🗑
|
||||
| Physical data independence means | show 🗑
|
||||
| show | Candidate keys
🗑
|
||||
| show | Primary Key
🗑
|
||||
| Rows in a relational table need not be unique; there can be duplicate rows in a tabl | show 🗑
|
||||
| "Tuple" is the mathematical name that is analogous to a | show 🗑
|
||||
| show | Conceptual, Physical
🗑
|
||||
| Which of the following is not part of Peter Chen's Entity Relationship model? | show 🗑
|
||||
| show | child
🗑
|
||||
| An ID-Dependent Entity is | show 🗑
|
||||
| "One-to-one", "one-to-many", and "many-to-many" (or 1:1, 1:M, and M:M) are examples of | show 🗑
|
||||
| A table in a database is equivalent to a(n) _____ in an ER Diagram, and a row or tuple is equivalent to a(n) _____. | show 🗑
|
||||
| All ID-dependent entities are weak, but not all weak entities are ID-dependent | show 🗑
|
||||
| An advantage in expressing a data model as an ER diagram is that ER diagrams are very uniform in their notation and all database designers use identical standards in producing ER diagrams. | show 🗑
|
||||
| show | The minimum cardinality of a relationship is one or more
🗑
|
||||
| show | True
🗑
|
||||
| show | False
🗑
|
||||
| show | An Identifier or Key that is made up of more than one attribute.
🗑
|
||||
| A mandatory participation constraint (meaning there is a required participation between one entity and another) always indicates that an entity is weak. | show 🗑
|
||||
| show | SELECT FirstName FROM Employee
🗑
|
||||
| In SQL, how do you select all the columns from a table named "Employee"? | show 🗑
|
||||
| show | SELECT * FROM Employee WHERE FirstName = 'John'
🗑
|
||||
| What SQL statement is used to return only different values from a table, eliminating duplicates? | show 🗑
|
||||
| show | SELECT * FROM Employee ORDER BY FirstName DESC
🗑
|
||||
| In SQL, how do you list all the rows of the Employee table and Dependent table that match on the EmployeeId attribute? | show 🗑
|
||||
| What query would we use to select all the employees from the Employee table whose first name is the same as his last name? | show 🗑
|
||||
| show | The INNER JOIN returns only the rows in which the join attributes match, and the LEFT JOIN returns all of the rows of the left table, along with the rows of the right table in which the join attributes match.
🗑
|
||||
| In SQL, how do you add a new row to the table named 'Employee'? | show 🗑
|
||||
| In SQL, how do you change the value of an attribute in an existing row? | show 🗑
|
||||
| In SQL, how do you delete a row from a table? | show 🗑
|
||||
| show | CREATE
ALTER
DROP
🗑
|
||||
| The primary purpose of the Subtype/Supertype relationship is to | show 🗑
|
||||
| To implement a Many-to-Many relationship in a relational database, you do this: | show 🗑
|
||||
| The relational model does not directly support many-to-many relationships. | show 🗑
|
||||
| show | has the identifier (key) of another entity as part of its own identifier.
🗑
|
||||
| show | many-to-many, intersection
🗑
|
||||
| show | False
🗑
|
||||
| show | Multivalued attribute pattern
🗑
|
||||
| show | assuring that the connections between tables remain valid
🗑
|
||||
| Aggregate functions work with | show 🗑
|
||||
| show | individual rows, groups
🗑
|
||||
| WHERE and HAVING are similar because both are | show 🗑
|
||||
| show | the outer query reads a row from a table
🗑
|
||||
| If a SQL statement contains a GROUP BY clause, then the SELECT clause can contain onl | show 🗑
|
||||
| show | True
🗑
|
||||
| A subquery can appear in a SQL statement wherever a _____ can appear. | show 🗑
|
||||
| show | join
🗑
|
||||
| Referential Integrity means | show 🗑
|
||||
| show | Deleting a row in a parent table automatically deletes any corresponding rows linked by a foreign key in the child table, thereby preventing orphans.
🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Created by:
ohmsy