Database Design and Development
Quizzes
Contents
Topic-1.......................................................................................................................................2
Topic-2A.....................................................................................................................................3
Topic-2B.....................................................................................................................................4
Topic-3.......................................................................................................................................6
Topic-6.......................................................................................................................................7
Topic-8&9..................................................................................................................................8
1
Topic-1
No
Questions Answers
.
1. The database environment has all of the following
Separate files
components except:
2.
The property/properties of a database is/are: All of the above
3. Involves modelling
Conceptual design
independent of the DBMS
4. The first step in designing high level conceptual data
Requirement analysis
model is
5. In the commercial database management system, the
Implementation data model
relational database model is also known as
6. An attribute that uniquely
A primary key is which of the following?
identifies each row
7. The following are components of a database except
Reports
__________.
8. An on-line commercial site such as Amazon.com is E-commerce database
an example of a(n) _______. application
9.
A database design may be based on existing data. True
10. In a database management system, data files are the
True
files that store the database information.
2
Topic-2A
No
Questions Answers
.
1. In a database design, gathering the data needs of the
First stage
prospective database users, comes at the stage?
2. A relationship line may have a associated minimum
Cardinalities
and maximum
3. When an entity in set A is associated with at most one
One-to-one
entity in set B, the cardinality is of type
4. The attributes that can be divided into subparts, are
Composite attributes
known as
5. In an entity relationship model, an association among
Relationship
several entities is known as
6. The conceptual-design phase output results in the
Entity-relationship diagram
creation of
7.
An entity is represented by a set of Attributes
8. Which one of the following attribute can be taken as a
Id
primary key?
An attribute in a relation is a foreign key if the
9.
__________ key from one relation is used as an Primary
attribute in that relation.
10. Both a and b
The primary key must be
(Non-Null, Unique)
3
Topic-2B
No
Questions Answers
.
1. Which forms simplifies and ensures that there are
Normalization
minimal data aggregates and repetitive groups:
2. In relational model terminology, the table is
Relation
considered as
An attribute in a relation is a foreign key if the
3.
________ key from one relation is used as an Primary
attribute in that relation.
4. Which one of the following attribute can be taken as a
ID
primary key?
5.
The primary key is selected from the: Candidate keys
6.
The format or data type must be specified for Domain
The functional dependency R to S means that the
7.
value of S can be determined when we are given a True
value of R.
8. The key which specifies that two different tuples
Super key
cannot have the same value is classified as
9. In a relation schema, each of key of schema having
Candidate key
more than one key is classified as
Every time attribute A appears, it is matched with
10.
same value of attribute B, but not the same value of A -> B
attribute C. therefore, it is true that:
11. A functional dependency is a relationship between or
True
among attributes.
12.
Minimal super keys are called Candidate keys
13. A row of table in relational model terminology is
Tuple
classified as
4
14. Which of the following cannot be taken as a primary Street
key?
When the foreign key refers to a tuple which does not
15.
exists in subjected relation then the constraint Referential integrity
violated is
Which is a bottom-up approach to database design
16.
that design by examining the relationship between Normalization
attributes:
All of the above
17. The value of an attribute in a table may be NULL (The value is not known/
because, The value does not exist/
The value is not applicable)
18. When the primary key is null of the new tuple then
Entity integrity constraint
the constraint violated is
All of above
19. The basic operations that can be performed on (Modification/
relations are Insertion/
Deletion)
20. In a relation, the columns are sometimes called
True
“attributes.”
5
Topic-3
No
Questions Answers
.
1. Conceptual design is the second stage of database
False
design.
2.
A primary key may be null. False
3. Normalization is a formal process for deciding which
True
attributes should be grouped together in a relation.
4. Well-structured relations encourage anomalies of
False
data.
5.
Weak entities do not get mapped into a relation. False
6.
Relations are: Two-dimensional tables
7. Each relation has a unique
A relation has which of the following properties?
name
8. When mapping a regular entity into a relation which
One relation is created
of the following is true?
9. If no multivalued attributes exist in a relation, then
First normal form
the relation is in what normal form?
If no multivalued attributes exist and partial
10.
dependencies exist in a relation, then the relation is in Second normal form
what normal form?
6
Topic-6
No
Questions Answers
.
1. What type of joins needed when you wish to include
Outer join
rows that do not have matching values?
2. Which join refers to join records from the write in the
Right outer join
left table are included in the result set:
3. A ___________ is a query that retrieves rows form
Join
more than one table or view.
Which of the following statement is TRUE about Retrieves both matched and
4.
FULL OUTER JOIN created on two tables Table1 unmatched rows of Table1
and Table2? and Table2
5. Which of the following functions are not performed
All of the mentioned
by ‘ALTER’ clause?
6. Which of the following functions are not performed
All of the mentioned
by ‘ALTER’ clause?
7.
‘INSERT’ is same as ‘UPDATE’? Yes
8. Which statement is used for updating existing
UPDATE
information in the table?
Understanding the primary key and foreign key
9.
relationship is not important to join on the correct False
columns.
10. You can drop OUTER keyword and just say LEFT
True
JOIN or RIGHT JOIN or FULL JOIN.
7
Topic-8&9
No
Questions Answers
.
A _______ is a special kind of a store procedure that
1.
executes in response to certain action on the table like Triggers
insertion, deletion or updation of data.
2.
Point out the correct statement. All of the mentioned
3.
Constraints can be applied on ___________. All of the mentioned
4. Which of the constraint can be enforced one per
Primary key constraint
table?
5.
What is the purpose of the index in sql server? All of the mentioned
A view is a virtual table
6.
What is a view? which results of executing a
pre-compiled query
Revoke update on employee
7. Which of the following statement is used to remove
from Amir
the privilege from the user Amir?
8.
Which of the following is not an integrity constraint? Identical
9. Foreign key is the one in which the __________ of
Primary key
one relation is referenced in another relation.
Which of the following is used to delete the entries in
10.
the referenced table when the tuple is deleted in Delete cascade
course table?
