CS403 Quiz No.1

On Wed, Nov 14, 2012 at 1:23 PM, Umair Saulat <saulat.umair@gmail.com> wrote:

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

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.

 

 

 

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

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

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

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

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

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

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

 

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

 

--
-- 
For Virtual University of Pakistan Study Material Sharing, Discussion, etc, Come and join us at http://4e542a34.linkbucks.com
You received this message because you are subscribed to the Google
Groups "Virtual Position" group.
To post to this group, send email to virtualposition@googlegroups.com
For more options, visit this group at
http://004bbb67.any.gs