Font size
WorksheetsDatabase LEC - Special Exam
Total questions: 20
Worksheet time: 12mins
Collection of application programs that perform services for the end users (e.g. reports)
Data
Database
File based system
Manual filing system
Manual filing system works well while number of items to be stored is small.
True
False
A database approach that refers to general enquiry facility (query language) of the data.
DDL
DML
DBMS
DBTG
The following are several reasons for the creation of the three-level architecture except.
●
Each user should be able to access same data but have a different customized view of data
Users should need to know physical database storage details
DBA should be able to change database storage structures without affecting user’s view
Internal structure of database should be unaffected by changes to physical aspects of storage
A type of three-level architecture that describes the part of database that is relevant to a particular user
External level
Conceptual level
Internal level
Components of DBMS environment that refers to the instructions and rules that should be applied to the design and use of the database and DBMS.
Hardware
Software
Data
Procedures
The acronym CODASYL stands for
Conference on Database Systems Languages
Conference on Data Systems Languages
Conference on Data Storage Languages
Conference on Database Storage Languages
A (a) software system that enables users to define, create, maintain and control access to the database
A (a) is a shared collection of logically related data and a description of data.
The DBMS is responsible for mapping between these three types of schema.
True
False
It refers to the collection of records, which are connected to one another through links.
Database
Relational database
Network database
Hierarchical database
It is define as the one of the levels closest to the users.
(a)
It refers to the collection of the conceptual tools for describing data, data relationships, and data semantics and data consistency constraints.
object-based
record-based
data model
schema
It refers to an attribute or field that serve as a unique identifier for a particular record or tuple within a relation.
(a)
It refers to information stored in the database at a given point in time.
schema
instance
sub-schema
DML
It refers to the part of the database systems that identifies all the system’s physical devices.
Hardware
Software
Peopleware
It refers to the part of the database systems composed of a collection of programs used by computers within the database.
(a)
It refers to the database model that is concerned in the logical nature of data representation.
Data model
Database model
Conceptual model
A level of architecture that is the one closest to physical storage.
(a)
A model that is based on the mathematical concept of a relation, which is physically represented as a table.
Relational
Database
Data
Network
