The University of Texas

CS 327e Fall 2002 Quiz 1

Date: 2002-11-18 Duration: 15 minutes

Total: 100 points, 10 questions. Each question is weighted equally, and is worth 10 points.

The correct answer is shown in BOLD.

NAME: ______________________________________ LAST 4 DIGITS SSN: ________________

1) Application programs are often written by companies that use them, but the DBMS is almost always licensed as a commercial product.

a) TRUE b) FALSE

2) The DBMS is used to create the database itself but not to create the underlying tables.

a) TRUE b) FALSE

3) Outer Joins can be used to ensure that all rows from a table appear in the result.

a) TRUE b) FALSE

4) SELECT statement results can be sorted using the GROUP BY command.

a) TRUE b) FALSE

5) A weak entity is one whose existence depends on another entity.

a) TRUE b) FALSE

6) To represent the 1:N relationship between 2 tables, we place the PK of the parent in the child.

a) TRUE b) FALSE

7) Concurrency control, Security, and Reliability are 3 of the major concerns of a DBA.

a) TRUE b) FALSE

8) Deadlock: When 2 transactions (txns) are each waiting on a resource that the other txn holds.

a) TRUE b) FALSE

9) A view is a virtual table representing a subset of columns and/or rows from one or more base tables or views.

a) TRUE b) FALSE

10) The main objective of database design is to model the real world.

a) TRUE b) FALSE