How to Win
Pages: 14
Student ID Number:
____________________
Questions: 45
UNIVERSITY OF TASMANIA
SAMPLE
EXAMINATIONS FOR DEGREES AND DIPLOMAS
May 2012
KXO131
Data Management
AIEN-SOU
Shanghai, China
Examiners:
Matthew Springer
Toby Peng
Time Allowed: THREE (3) hours
Instructions:
This examination paper consists of THREE (3) sections with a total of 180 marks available. * Attempt ALL questions in section A. * The answers to Section A should be written on the sheets provided at the back of this examination paper. * Attempt ALL questions in Section B. * The answers to Section B should be written in your answer book. * Attempt TWO (2) questions in Section C. * The answers to Section C should be written in your answer book.
Section A
Subsection A.1
TRUE/FALSE
Nominate whether each of the following statements is true or false by writing either T (for True) or F (for False) on the answer sheet at the end of this paper.
Each question is worth 1 mark. (1) True or False? Data that is created within an application session and discarded at the end of the session is called persistent data. (2) True or False? A file is the common denominator of storage. (3) True or False? A business rule may be represented in an ER diagram using mandatory/optional symbols. (4) True or False? Duplicate tuples are allowed in a relation. (5) True or False? If there is only one candidate key for a relation, then the candidate key automatically becomes the primary key. (6) True or False? The primary key referenced by a foreign key must be in a different relation from the foreign key. (7) True or False? A RDBMS (relational database management system) manages metadata. (8) True or False? In XML, <!-- doc A --> is a document type declaration. (9) True or False? An XML document may be valid but not well formed. (1) True or False? The datatype specified for a column is
Student ID Number:
____________________
Questions: 45
UNIVERSITY OF TASMANIA
SAMPLE
EXAMINATIONS FOR DEGREES AND DIPLOMAS
May 2012
KXO131
Data Management
AIEN-SOU
Shanghai, China
Examiners:
Matthew Springer
Toby Peng
Time Allowed: THREE (3) hours
Instructions:
This examination paper consists of THREE (3) sections with a total of 180 marks available. * Attempt ALL questions in section A. * The answers to Section A should be written on the sheets provided at the back of this examination paper. * Attempt ALL questions in Section B. * The answers to Section B should be written in your answer book. * Attempt TWO (2) questions in Section C. * The answers to Section C should be written in your answer book.
Section A
Subsection A.1
TRUE/FALSE
Nominate whether each of the following statements is true or false by writing either T (for True) or F (for False) on the answer sheet at the end of this paper.
Each question is worth 1 mark. (1) True or False? Data that is created within an application session and discarded at the end of the session is called persistent data. (2) True or False? A file is the common denominator of storage. (3) True or False? A business rule may be represented in an ER diagram using mandatory/optional symbols. (4) True or False? Duplicate tuples are allowed in a relation. (5) True or False? If there is only one candidate key for a relation, then the candidate key automatically becomes the primary key. (6) True or False? The primary key referenced by a foreign key must be in a different relation from the foreign key. (7) True or False? A RDBMS (relational database management system) manages metadata. (8) True or False? In XML, <!-- doc A --> is a document type declaration. (9) True or False? An XML document may be valid but not well formed. (1) True or False? The datatype specified for a column is