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
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 100%
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 100%
A tree-like structure of datas
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
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 100%
Functional dependency
Concurrency control
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 100%
secondary key
Which model operates at the lowest level of abstraction?
Select correct option:
conceptual
internal
external
physical 100%
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
Data Redundancy Means
Select correct option:
Security of data
Duplication of data 100%Management of data
Recovery of data
