Quiz
DBMS - Intro
This quiz has question types that open in the usual player.
Questions in this quiz (19)
1[blank_start]File-based systems[blank_end] is a collection of application programs that perform services for the end users (e.g. reports).
- AFile-based systems
2[blank_start]Database[blank_end] is a shared collection of logically related data (and a description of this data), designed to meet the information needs of an organization.
- ADatabase
3[blank_start]System catalog[blank_end] or [blank_start]metadata[blank_end] provides description of data to enable program–data independence.
- Ametadata
- BSystem catalog
4[blank_start]Database Management System[blank_end] is a software system that enables users to define, create, maintain, and control access to the database.
- ADatabase Management System
5[blank_start]Data definition language[blank_end] permits specification of data types, structures and any data constraints.
- AData definition language
6[blank_start]Data manipulation language[blank_end] is a general enquiry facility (query language) of the data.
- AData manipulation language
7Check the correct statements about Views
- Aallows each user to have his or her own view of the database.
- Bessentially some subset of the database.
- Ca concurrency control system
- Dinteracts with database by issuing an appropriate request (SQL statement) to the DBMS.
8Components of DBMS Environment
- AHardware
- BData
- CUsers
- DAdministrator
- ESoftware
9[blank_start]Procedures[blank_end]
Instructions and rules that should be applied to the design and use of the database and DBMS.- AProcedures
10[blank_start]Data[blank_end]
Used by the organization and a description of this data called the schema.- AData
11[blank_start]Modeling Language[blank_end], a component of DBMS, defines the schema
- AModeling Language
12[blank_start]Data Structure[blank_end], a component of DBMS, deal with large amounts of data stored.
- AData Structure
13[blank_start]Database Query Language[blank_end], a component of DBMS, allows user to interact with, analyze, and update depending on user permissions/privileges
- ADatabase Query Language
14[blank_start]External Level[blank_end]
Provides user's view- AExternal Level
15[blank_start]Logical Data Independence[blank_end], a data independence, changes on conceptual schema without affecting the external schema
- ALogical Data Independence
16[blank_start]Physical Data Independence[blank_end], a data independence, changes on internal schema without affecting the external schema.
- APhysical Data Independence
17[blank_start]Database design[blank_end] refers to the activities that focus on the design of the database structure that will be used to store and manage end-user data.
- ADatabase design
18[blank_start]Data Model[blank_end]
An abstraction of a more complex real-world object or event- AData Model
19[blank_start]Hierarchical[blank_end]
Tree-like structure
Entities has one to two immediate neighbors – parent/child, superior/subordinate
A child element can be related to only one parent- AHierarchical
Information
- Description
- Introduction to Database
- Author
- M Rosario
- Language
- English
- Views
- 1
- Tags
- Rating
- No ratings yet Rate this quiz