*
**CS-403- Database Management System***
*Quiz No.1 Dated 14-12-2012*
Within a table, each primary key value *__*.*
*Select correct option:
is a minimal super key
is always the first field in each table
must be numeric
*must be unique*
Reign Key is
Select correct option:
*A field in a table that matches a key field in another table
*A field in a table that contains data that is also contained elsewhere in
another table
A field in a table that has the same name as a key field in another table
Which of the following might be represented with a single-valued attribute?
Select correct option:
*person's phone number (Please Check)
*car's color
employee's educational background
*computer's processor speed *
Which of the following constraints enforces entity integrity?
Select correct option:
*PRIMARY KEY*
FOREIGN KEY
CHECK
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
Data about data is database
Select correct option:
*True
*False
Partially True
None of the Above
Which one of the following is NOT a characteristic of meta data?
Select correct option:
Data about data
*Describes a data dictionary*
Self-describing
Includes user data
The most widely used conceptual model is the *__* model.
Select correct option:
implementation
*ER
*Object Oriented
internal
Which model operates at the lowest level of abstraction?
Select correct option:
conceptual
internal
external
*physical*
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
Data inconsistency leads to a number of problems such as
Select correct option:
*loss of information and incorrect results
*less secure data
redundant data
Slow database development
Which of the following constraints enforces entity integrity?
Select correct option:
*PRIMARY KEY
*FOREIGN KEY
CHECK
NOT NULL
A relational database system is based on the concept(s) of:
Select correct option:
A network of data records
Nested tables
*Tables, rows and columns
*A tree-like structure of data
Which of the following is NOT a component of a DFD?
Select correct option:
Dataflow
Datastore
*External entities
*Relationship between external entities
Question # 6 of 10 ( Start time: 08:51:30 PM ) Total Marks: 1
A candidate key that does not have a null value and is selected to uniquely
identify all other attribute values in any given row is called a *__*.
Select correct option:
superkey
candidate key
*primary key
*secondary key
Which of the following is correct regarding Dataflow diagram?
Select correct option:
Single DFD is required to represent a system
Created at increasing levels of detail
The dataflow must be bidirectional
*Used to represent the relationships among the external entities*
The most widely used conceptual model is the *__* model.
Select correct option:
implementation
*ER
*Object Oriented
internal
Data about data is metadata
Select correct option:
*True
*False
Data Redundancy Means
Select correct option:
Security of data
*Duplication of data
*Management of data
Recovery of data
Data inconsistency leads to a number of problems such as
Select correct option:
*loss of information and incorrect results
*less secure data
redundant data
Slow database development
most widely used conceptual model is the *__* model.
Select correct option:
implementation
*ER *
Object Oriented
internal
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
In an ERD, the focus is on the *__* and the relationships between them.
Select correct option:
*attributes
*entities
keys
indexes
An entity type is
defined when the database is actually constructed
a specific type such as an integer, text, date, logical etc
*User rights information is stored in
*Select correct option:
Physical database
*Catalog
*Logical database
Buffer
Which of the following might be represented with a multivalued attribute?
Select correct option:
person's name
*class location (Not Confirm)
*bank account balance
book title
Which of the following is correct regarding Dataflow diagram?
Select correct option:
*Single DFD is required to represent a system
*Created at increasing levels of detail
The dataflow must be bidirectional
Used to represent the relationships among the external entities
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 (Please
Check)
Logical data independence (Please Check)
*Functional dependency
Concurrency control
A relational database system is based on the concept(s) of:
Select correct option:
A network of data records
Nested tables
*Tables, rows and columns
*A tree-like structure of data
A relational database is
Select correct option:
*one that consists of two or more tables*
a database that is able to process tables, queries, forms, reports and
macros
one that consists of two or more tables that are joined in some way
the same as a flat file database
<http://groups.google.com/group/vuZs>
Which one of the following is NOT a characteristic of meta data?
Select correct option:
Data about data
Describes a data dictionary
Self-describing
*Includes user data*
An entity type is
defined when the database is actually constructed
specific type such as an integer, text, date, logical etc
*coherent set of similar objects that we want to store data on (e.g.
STUDENT, COURSE, CAR)*
defined by the database designer
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.
<http://groups.google.com/group/vuZs>
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
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
A Foreign Key is
Select correct option:
*A field in a table that matches a key field in another table*
A field in a table that contains data that is also contained elsewhere in
another table
A field in a table that has the same name as a key field in another table
A field in a table that has the same name as a key field in another table
Question # 10 of 10 ( Start time: 05:15:08 PM ) Total M a r k s: 1
Which model operates at the lowest level of abstraction?
Select correct option:
conceptual
internal
external
*physical*
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*
Question # 3 of 10 ( Start time: 11:20:08 AM ) Total M a r k s: 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
<http://groups.google.com/group/vuZs>
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
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
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
<http://groups.google.com/group/vuZs>
Question # 8 of 10 ( Start time: 11:24:50 AM ) Total M a r k s: 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
User rights information is stored in
Select correct option:
Physical database
*Catalog*
Logical database
Buffer
<http://groups.google.com/group/vuZs>
The Entity Relation Model models
Select correct option:
Entities, Relationships and Processes
*Entities and Relationships*
Relationships
Entities
Which of the following is NOT a component of a DFD?
Select correct option:
Dataflow
Datastore
External entities
*Relationship between external entities*
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
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
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?
*True*
False
Partially True
None of the given
incase of Context-level Diagram, the system is represented by
One process atleast
Two processes atleast
*One process only*
Any number of processes
Data about data is database
*True*
False
Partially True
None of the Above
A software package designed to store and manage databases
Database
*DBMS*
Data model
Data
<http://groups.google.com/group/vuZs>
Which model operates at the lowest level of abstraction?
conceptual
internal
external
*physical*
Data about data is database
*True*
False
Partially True
None of the Above
A table can be logically connected to another table by defining a ____.
hyperlink
*common attribute*
primary key
superkey
Which of the following is INCORRECT statement concerning the database
design process?
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.
Which of the following is correct regarding Dataflow diagram?
Single DFD is required to represent a system
Created at increasing levels of detail
The dataflow must be bidirectional
*Used to represent the relationships among the external entities*
A collection of concepts that can be used to describe the structure of a
database
Database
DBMS
*Data model*
Data
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
<http://groups.google.com/group/vuZs>
A software package designed to store and manage databases
Select correct option:
Database
DBMS
*Data model*
Data
The main software package that supports a database management approach is
called
Select correct option:
Data Dictionary
Report Generator
*Database Management System*
Distributed database
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
The ER model is meant to
Select correct option:
replace relational design
be close to a users perception of the data
enable low level descriptions of data
*enable detailed descriptions of data query processing*
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
A relational database system is based on the concept(s) of:
Select correct option:
A network of data records
Nested tables
*Tables, rows and columns*
A tree-like structure of datas <http://groups.google.com/group/vuZs>
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
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
A description on a particular collection of data using the given data model
Select correct option:
Database
Relation
*Schema*
None
Which of the following functions are NOT performed by a database
administrator?
Select correct option:
*Planning, designing and implementing database systems*
Establishing standards and procedures for database systems
Communicating with database users
Allocation of storage locations and data structures
A collection of concepts that can be used to describe the structure of a
database
Select correct option:
Database
DBMS
*Data model*
Data <http://groups.google.com/group/vuZs>
A candidate key that does not have a null value and is selected to uniquely
identify all other attribute values in any given row is called a *__*.
Select correct option:
super key
candidate key
*primary key*
secondary key
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
|
|
CS403 First Quiz At 14-11-2012.doc
83K
Download
|
