CS 2203 Exam Questions With Complete Solutions
a "thing" which has either a real physical existence (e.g. a car or
a student) or a conceptual existence (e.g. a course) Correct
Answers An Entity
A candidate key cannot also be the primary key of a relation.
Select one:
True
False Correct Answers FALSE
A characteristic of data, a real-world data feature modeled in the
database is called: Correct Answers attribute
a coherent set of similar objects that we want to store data on
(e.g. STUDENT, COURSE, CAR) Correct Answers An Entity
Type
A foreign key is an attribute in one relation whose values match
those of a primary key in another relation.
Select one:
True
False Correct Answers True
A formal description of all the database relations and all of the
relationships existing between them is called a database schema.
Select one:
True
False Correct Answers TRUE
,A given relation is known to be in third normal form. Select the
statement which can be inferred from this: Correct Answers
Each non-key attribute is determined by the primary key
A lack of normalisation can lead to which one of the following
problems Correct Answers Insertion Problems
a particular occurance of an entity (e.g. Tom Osman is an
instance of the entity STUDENT) Correct Answers An
Instance
A physical view represents how the users view the data. Correct
Answers FALSE
A physical view represents how the users view the data. Correct
Answers FALSE
A relational database query normally returns many rows of data.
But an application program usually deals with one row at a time.
Which of the following is used to bridge this gap allowing the
program to deal with on row at a time. Correct Answers
Cursor
A set of atomic values that are all of the same type is called:
Correct Answers domain
A timetable database is required for a University Department.
Each taught event is part of a module, each event will have
exactly one member of staff associated and several individual
students. Each event takes place in a single weekly time slot.
Each time slot has a day of the week and a time of day
, associated.Each of the weekly time slots is exactly one hour
long, however we wish to represent the fact that some events
take more than one hour. Which of the following does not
represent a possible solution. Correct Answers A one-to-many
relation between Events and Time-Slots is established
A timetable database is required for a University Department.
Each taught event is part of a module, each event will have
exactly one member of staff associated and several individual
students. Each event takes place in a single weekly time slot.
Each time slot has a day of the week and a time of day
associated.Each of the weekly time slots is exactly one hour
long, however we wish to represent the fact that some events
take more than one hour. Which of the following does not
represent a possible solution. Correct Answers A one-to-many
relation between Events and Time-Slots is established
A tuple is an ordered set of values that describe data
characteristics at one moment in time. An informal term for
tuple is: Correct Answers record
A UNION query is which of the following? Correct Answers
Combines the output from multiple queries and must include the
same number of columns.
A UNION query is which of the following? Correct Answers
Combines the output from multiple queries and must include the
same number of columns.
A unique KEY field
Select one:
a "thing" which has either a real physical existence (e.g. a car or
a student) or a conceptual existence (e.g. a course) Correct
Answers An Entity
A candidate key cannot also be the primary key of a relation.
Select one:
True
False Correct Answers FALSE
A characteristic of data, a real-world data feature modeled in the
database is called: Correct Answers attribute
a coherent set of similar objects that we want to store data on
(e.g. STUDENT, COURSE, CAR) Correct Answers An Entity
Type
A foreign key is an attribute in one relation whose values match
those of a primary key in another relation.
Select one:
True
False Correct Answers True
A formal description of all the database relations and all of the
relationships existing between them is called a database schema.
Select one:
True
False Correct Answers TRUE
,A given relation is known to be in third normal form. Select the
statement which can be inferred from this: Correct Answers
Each non-key attribute is determined by the primary key
A lack of normalisation can lead to which one of the following
problems Correct Answers Insertion Problems
a particular occurance of an entity (e.g. Tom Osman is an
instance of the entity STUDENT) Correct Answers An
Instance
A physical view represents how the users view the data. Correct
Answers FALSE
A physical view represents how the users view the data. Correct
Answers FALSE
A relational database query normally returns many rows of data.
But an application program usually deals with one row at a time.
Which of the following is used to bridge this gap allowing the
program to deal with on row at a time. Correct Answers
Cursor
A set of atomic values that are all of the same type is called:
Correct Answers domain
A timetable database is required for a University Department.
Each taught event is part of a module, each event will have
exactly one member of staff associated and several individual
students. Each event takes place in a single weekly time slot.
Each time slot has a day of the week and a time of day
, associated.Each of the weekly time slots is exactly one hour
long, however we wish to represent the fact that some events
take more than one hour. Which of the following does not
represent a possible solution. Correct Answers A one-to-many
relation between Events and Time-Slots is established
A timetable database is required for a University Department.
Each taught event is part of a module, each event will have
exactly one member of staff associated and several individual
students. Each event takes place in a single weekly time slot.
Each time slot has a day of the week and a time of day
associated.Each of the weekly time slots is exactly one hour
long, however we wish to represent the fact that some events
take more than one hour. Which of the following does not
represent a possible solution. Correct Answers A one-to-many
relation between Events and Time-Slots is established
A tuple is an ordered set of values that describe data
characteristics at one moment in time. An informal term for
tuple is: Correct Answers record
A UNION query is which of the following? Correct Answers
Combines the output from multiple queries and must include the
same number of columns.
A UNION query is which of the following? Correct Answers
Combines the output from multiple queries and must include the
same number of columns.
A unique KEY field
Select one:
