CS403 Quiz No.1 Shared by Hifza (Solved)

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:
superkey
candidate key
primary key
secondary key

In case 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