NEW
Font size
WorksheetsDBMS Basic quiz
Total questions: 30
Worksheet time: 15mins
Which one of the following refers to the copies of the same data (or information) occupying the memory space at multiple places.
Data Repository
Data Inconsistency
Data Mining
Data Redundancy
Which one of the following refers to the "data about data"?
Directory Sub Data Warehouse Meta Data
Sub Data
Warehouse
Meta Data
Which of the following refers to the level of data abstraction that describes exactly how the data actually stored?
Conceptual Level
physical Level
File Level
Logical Level
In general, a file is basically a collection of all related______.
Rows & Columns
Fields
Database
Records
Rows of a relation are known as the _______.
Degree
Tuples
Entity
All of the above
In a relation database, every tuples divided into the fields are known as the______.
Queries
Domains
Relations
All of the above
In the relational table, which of the following can also be represented by the term "attribute"?
Entity
Row
Column
Both B &C
The database management system can be considered as the collection of ______ that enables us to create and maintain the database.
Translators
Programs
Keys
Language activity
Which of the following refers collection of the information stored in a database at a specific time?
Independence
Instance of the database
Schema
Data domain
The term "Data independence" refers to____
Data is defined separately and not included in the programs
Programs are not dependent on the logical attributes of the data
Programs are not dependent on the physical attributes of the data
Both B & C
Which one of the following refers to the total view of the database content?
Conceptual view
Physical view
Internal view
External view
In the relation model, the relation are generally termed as ________
Tuples
Attributes
Rows
Tables
Which of the following levels is considered as the level closed to the end-users?
Internal Level
External Level
Conceptual Level
Physical Level
Which one of the following is commonly used to define the overall design of the database?
Application program
Data definition language
Schema
Source code
In Hierarchical model records are organized as
Graph.
List.
Links.
Tree.
A logical schema is ??
is the entire database.
is a standard way of organising information into accessible parts.
describes how data is actually stored on disk.
None of the above
Related fields in a database are grouped to form a
data file.
data record.
menu.
bank.
A subschema expresses
the logical view.
the physical view.
the external view.
all of the above.
An advantage of the database management approach is
data is dependent on programs.
data redundancy increases.
data is integrated and can be accessed by multiple programs.
none of the above.
The overall description of a database is called______.
Data integrity
Data manipulation
Database schema
Data definition
A top-to-bottom relationship among the items in a database is established by a
Hierarchical schema
Network schema
Relational Schema
None of the above
Data is represented in a graph ,child node may have two parent node ,concept comes under which model ?
Network model
Hierarchical Model
Relational Model
Objet oriented model
Data is stored in the form two dimensional table is
Relational Model
ER -Model
Object oriented model
Netwok model
Design of the database changes frequently is
schema
instances
fields
records
The raw facts and it is stored is called as
Data
information
knowledge
fields
The query processing is done at ------------ level
Conceptual schema
internal schema
external schema
subchema
Actual data is stored on the disk is called as
internal schema (physical schema)
Conceptual schema (logical schema)
External schema (view schema)
none of the above
part of DB is viewed by interested users in ?
External schema (View schema)(user level)
Conceptual schema
internal schema(physical schema)
None of the above
Those who actually use and control the database content,???
Actors on the scene
workers behind the scene
DBMS system designers
None of the above
Those who use the database frequently ???
Casual users
parametric users (Naïve users)
sophisticated user
End users
