Question # 1 of 10 ( Start time: 11:17:22 AM ) Total Marks: 1
Controlling redundancy in a database management system DOES NOT help to
Select correct option:
avoid duplication
avoid unnecessary wastage of storage space
avoid unauthorised access to data
avoid inconsistency among data
Quiz Start Time: 11:17 AM Time Left 43
sec(s)
Question # 2 of 10 ( Start time: 11:18:38 AM ) Total Marks: 1
User rights information is stored in
Select correct option:
Physical database
Catalog
Logical database
Buffer
Quiz Start Time: 11:17 AM Time Left 38
sec(s)
Question # 3 of 10 ( Start time: 11:20:08 AM ) Total Marks: 1
Which levels are mostly used for Detailed DFD?
Select correct option:
Level-0, Level-1
Level-1, Level-2
Level-2, Level-3
Level-3, Level-4
Quiz Start Time: 11:17 AM Time Left 76
sec(s)
Question # 4 of 10 ( Start time: 11:21:13 AM ) Total Marks: 1
Within a table, each primary key value ____.
Select correct option:
is a minimal superkey
is always the first field in each table
must be numeric
must be unique
Quiz Start Time: 11:17 AM Time Left 68
sec(s)
Question # 5 of 10 ( Start time: 11:21:45 AM ) Total Marks: 1
A primary key is an attribute (or set of attributes) that has been chosen for an entity, whose values are used to uniquely identify a particular instance of an entity. True or false?
Select correct option:
True
False
Partially True
None of the given
Quiz Start Time: 11:17 AM Time Left 54
sec(s)
Question # 6 of 10 ( Start time: 11:22:28 AM ) Total Marks: 1
Who is responsible for authorizing access to the database, for coordinating and monitoring its use?
Select correct option:
Database Designer
Database Administrator
End User
Application Programmer
Quiz Start Time: 11:17 AM Time Left 52
sec(s)
Question # 8 of 10 ( Start time: 11:24:50 AM ) Total Marks: 1
Incase of Context-level Diagram, the system is represented by
Select correct option:
One process atleast
Two processes atleast
One process only
Any number of processes
Quiz Start Time: 11:17 AM Time Left 77
sec(s)
Question # 9 of 10 ( Start time: 11:25:39 AM ) Total Marks: 1
In a three-level DBMS architecture, the ______ level interacts directly with the users.
Select correct option:
external
conceptual
internal
physical
Quiz Start Time: 11:17 AM Time Left 68
sec(s)
Question # 10 of 10 ( Start time: 11:26:04 AM ) Total Marks: 1
Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss?
Select correct option:
User accessible catalog
Data processing
Recovery service
Authorization service
Quiz Start Time: 11:27 AM Time Left 60
sec(s)
Question # 1 of 10 ( Start time: 11:27:14 AM ) Total Marks: 1
Which of the following describes a database system?
Select correct option:
A collection of stored operational data used by the application system of some particular enterprise
A shared collection of logically related data (and a description of this data) designed to meet the information needs of an organisation
A collection of stored data organised in such a way that all user requirements are satisfied by the database. In general there is only one copy of each item of data although there may be controlled repetition of some data.
All of the above
Quiz Start Time: 11:27 AM Time Left 18
sec(s)
Question # 2 of 10 ( Start time: 11:27:53 AM ) Total Marks: 1
Which of the following is INCORRECT statement concerning the database design process?
Select correct option:
During requirements collection and analysis phase, one can gather the data requirements of database users.
By referring to a high level data model, it is possible to understand the data requirements of the users, entity types, relationships and constraints.
Transformation of the high level data model into the implementation data model is called logical design or data model mapping.
During the logical design phase of internal storage structures, access paths and file organization for the database files are specified.
Quiz Start Time: 11:27 AM Time Left 70
sec(s)
Question # 3 of 10 ( Start time: 11:29:11 AM ) Total Marks: 1
User rights information is stored in
Select correct option:
Physical database
Catalog
Logical database
Buffer
Quiz Start Time: 11:27 AM Time Left 76
sec(s)
Question # 4 of 10 ( Start time: 11:30:04 AM ) Total Marks: 1
The Entity Relation Model models
Select correct option:
Entities, Relationships and Processes
Entities and Relationships
Relationships
Entities
Quiz Start Time: 11:27 AM Time Left 31
sec(s)
Question # 6 of 10 ( Start time: 11:30:35 AM ) Total Marks: 1
Which of the following is NOT a component of a DFD?
Select correct option:
Dataflow
Datastore
External entities
Relationship between external entities
Quiz Start Time: 11:27 AM Time Left 44
sec(s)
Question # 7 of 10 ( Start time: 11:31:48 AM ) Total Marks: 1
Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of
Select correct option:
Physical data independence
Logical data independence
Functional dependency
Concurrency control
Quiz Start Time: 11:27 AM Time Left 77
sec(s)
Question # 8 of 10 ( Start time: 11:32:45 AM ) Total Marks: 1
Incase of Context-level Diagram, the system is represented by
Select correct option:
One process atleast
Two processes atleast
One process only
Any number of processes
Quiz Start Time: 11:27 AM Time Left 23
sec(s)
Question # 9 of 10 ( Start time: 11:33:11 AM ) Total Marks: 1
An instance is
Select correct option:
a particular occurance of an entity
a special type of relation
an attribute of an entity
any particular entity
Quiz Start Time: 11:27 AM Time Left 71
sec(s)
Question # 10 of 10 ( Start time: 11:34:22 AM ) Total Marks: 1
A________is used to maintain a connection between the users of the database system.
Select correct option:
mail server
file server
client-server
none of the given
