Slide2:
Problem 1:
Which of these statements is true:
A Database is a model of structures of Reality
A Database Management System is a collection of software that supports the definition and use of a Database
A Database is a means of communicating about, analyzing and managing the part of Reality it models
All of the above Problem 3:
A Database Management System always provides support for
Persistent data storage, multiple user access, security, backup, recovery, data independence
Real-time query response
Data mining, data warehousing
All of the above Problem 2:
A Database Management System supports the following interfaces:
Data Definition Language and Data Manipulation Language
Data Import Language and Data Export Language
XML and XSL
None of the above
Problem 4:
The Entity-Relationship Data Model is for
Database schema design
Database application design
Database implementation
All of the above GT#__________________ Name____________________________________________________ CS4400 - QUIZ 1 - Summer 2005 PERSON SSN Problem 5:
A) For each value of SSN there is at most one instance of PERSON
B) For each instance of PERSON there is at most one value of SSN
C) Instances of PERSON are determined as a function of values of SSN
D) All of the above PERSON HEIGHT Problem 6:
A) For each value of HEIGHT there is at most one instance of PERSON
B) For each instance of PERSON there is at most one value of HEIGHT
C) Instances of PERSON are determined as a function of values of HEIGHT
D) All of the above PERSON COLLEGE
DEGREE Problem 7:
A) For each value of COLLEGEDEGREE there is at most one instance of PERSON
B) For each instance of PERSON there is at most one value of COLLEGEDEGREE
C) For each instance of PERSON there may be multiple values of COLLEGEDEGREE
D) All of the above
Slide3:
PERSON NAME Problem 8:
A) Each value of NAME is composed from a value from FIRSTNAME and a value from LASTNAME
B) NAME is a multi-valued attribute
C) Values of NAME are determined as a function of values from LASTNAME
D) None of the above LAST
NAME FIRST
NAME COMPANY TAXID Problem 9:
A) Incorrect syntax
B) TAXID has a multi-valued entity types
C) For each value of TAXID there is at most one instance of PERSON or COMPANY
D) For each value of TAXID there is at most one instance of PERSON and COMPANY PERSON PERSON Problem 10:
A) Each instance of DOG is related to multiple instances of PERSON
B) Each instance of PERSON is related to zero, one or many instances of DOG
C) Each instance of OWNS relates one instance of PERSON and many instances of DOG
D) None of the above DOG OWNS 1 N Problem 11:
If there are two instances of PERSON and 3 instances of DOG, then how many instances of OWNS are there?
A) Min 0, max 3
B) Min 0, max 6
C) Min 2, max 3
D) Min 2, max 6 PERSON Problem 12:
A) Each instance of DOG may participate in one instances of OWNS
B) Each instance of PERSON is related to zero or one instance of DOG
C) Each instance of OWNS relates one instance of PERSON and one instance of DOG
D) All of the above DOG OWNS 1 1 Problem 13:
With 2 instances of PERSON and 3 instances of DOG, how many instances of OWNS are there?
A) Min 0, max 6
B) Min 1, max 1
C) Min 1, max 2
D) Min 0, max 2
Slide4:
1 PERSON Problem 14:
A) Each instance of PERSON must participate in one instance of OWNS
B) Each instance of PERSON is related to zero or one instance of DOG
C) Each instance of DOG must participate in one instance of OWNS
D) None of the above DOG OWNS 1 Problem 15:
With 2 instances of PERSON and 3 instances of DOG, how many instances of OWNS are there?
A) Min 2, max 2
B) Min 2, max 3
C) Min 0, max 3
D) Min 0, max 6 PERSON Problem 16:
A) Each instance of PERSON must be related to many instances of OWNS
B) Each instance of PERSON must be related to many instances of DOG
C) Each instance of R relates N instances of PERSON and M instances of DOG
D) Each instance of PERSON is related to zero, one or many instances of DOG DOG OWNS N M Problem 17:
With 2 instances of PERSON and 3 instances of DOG, how many instances of OWNS are there?
A) Min 3, max 6
B) Min 0, max 6
C) Min 0, max 3
D) Min 2, max 6 Problem 18:
A) Attribute BEGINDATE can be moved to PERSON
B) Attribute BEGINDATE can be moved to DOG
C) Attribute BEGINDATE cannot be moved
D) Incorrect syntax PERSON DOG OWNS 1 N BEGIN
DATE Problem 19:
A) Attribute BEGINDATE can be moved to PERSON
B) Attribute BEGINDATE can be moved to DOG
C) Attribute ABEGINDATE cannot be moved
D) Incorrect syntax PERSON DOG OWNS N M BEGIN
DATE
Slide5:
Problem 20:
A) The identifier for DOG is (SSN, DOGNAME)
B) DOG is a weak entity type
C) DOG’s participation in OWNS is mandatory
D)All of the above 1 N PERSON DOG OWNS DOGNAME SSN PERSON FEMALE MALE DRAFT
STATUS MAIDEN
NAME SSN d Problem 22:
A) The identifier for MALE is SSN
B) PERSON is a disjointed entity type
C) PERSON’s participation in the is-a relationship is mandatory
D) PERSON inherits all the attributes of MALE and FEMALE Problem 23:
A) MALE inherits attribute SSN
B) MALE and FEMALE are disjoint
C) Instances of MALE and FEMALE are also instances of PERSON
D) All of the above OWNER COMPANY PERSON SSN TAXID NAME Problem 24:
A) An instance of OWNER is either an instance of PERSON or COMPANY
B) All instances of PERSON and COMPANY are instances of OWNER
C) PERSON and COMPANY inherit NAME
D)All of the above Problem 21:
If there are 10 DOGs, then what is the minimal number of PERSONs
A) 0
B) 1
C) 10
D)None of the above Problem 25:
With 2 instances of PERSON and 3 instances of COMPANY, how many OWNERs are there?
A) Min 0, max 5
B) 2
C) 3
D)5
Slide6:
Summer 2005 Quiz1 Key
1-D,
2-A,
3-A,
4-A,
5-D
6-B,
7-C,
8-A,
9-A,
10-B
11-A,
12-D,
13-D,
14-A,
15-A
16-D,
17-B,
18-B,
19-C,
20-D
21-B,
22-A,
23-D,
24-A,
25-A