Database Management Systems
Questions 331 to 340
What are “Raw” facts such as
telephone number, birth date, sales value etc are called?
(a) Record (b) Data (c)
File (d)
Field (e) Information
|
|
Which of the following models is
concerned with what is represented in the database, rather than how it is
represented?
(a)
Conceptual
model (b)
View
model
(c) Physical
model
(d)
External
model (e)
Implementation
model.
|
|
Which of the following is not a component of storage manager?
(a)
Authorization
and integrity manager (b)
Transaction
manager
(c)
File
manager (d)
Buffer
manager
(e) Query
evaluation engine.
|
|
Which of the following specifies
that an entity can be a member of only one subtype at a time?
(a)
Removal (b)
Exclusion (c) Disjoint (d)
Inclusion
(e) Overlapping.
|
|
For the following diagram, which
answer is true?
(a) Each employee can supervise 1 to many
employees
(b) Each employee can manage many departments
(c) Each employee works in one department
(d) Both (a) and (b) above
(e) Both (a) and (c) above.
|
|
Which of the following is the
relationship between two instances of a single or same entity type?
(a)
Binary (b) Tertiary (c) Primary (d) Ternary (e) Unary.
|
|
On which of the following options
the Hierarchical database model is based?
(a) Tree structure (b)
Graph structure
(c)
Relational model (d)
Physical model
(e)
Linear lists.
|
|
Which of the following options
depicts the organization of data in a relational database?
(a)
A collection of records (b)
A collection of common fields
(c)
Elements (d)
Tables (e)
Objects.
|
|
Which of the following relational
operations yields all values from selected attributes?
(a)
Difference (b) Product (c) Select (d) Project (e) Join.
|
|
Consider the relation pt_works(emp_name, branch_name,
salary):
Which
of the following is the correct
relational algebra expression for finding the maximum salary for part-time
employees at each branch?
(a) branch_name g max(salary) (b) branch_name
g max(salary) (pt_works)
(c) g max (salary) (pt_works) (d) branch_name g sum(salary) (pt_works)
(e) branch_name G max(salary) (pt_works).
|
Answers
Answer : (b)
Reason
: “Raw” facts are called data.
|
|
Answer : (a)
Reason
: Conceptual model is
concerned with the logical details(what is represented ) of the database.
|
|
Answer : (e)
Reason
: Query evaluation is not a
part of the strorage manager.It is a pat of the query processor.
|
|
Answer : (c)
Reason
: Disjoint rule is a
constraint of specialiazation.
|
|
Answer : (e)
Reason
: Both a and c are correct.
|
|
Answer : (e)
Reason
: A relationship between the instances
of a single entity type is called a unary relationship.
|
|
Answer : (a)
Reason
: The Hierarchical database model is
based on tree structure.
|
|
Answer : (d)
Reason
: In a relational database
data is organized as tables.
|
|
Answer : (c)
Reason
: A Relational operator that yields
all values from selected attributes is known as a select operator.
|
|
Answer : (b)
Reason : brach_name
g max(salary) (pt_works)
is the correct syntax.
|
great for revision
ReplyDelete