WorksheetsDBMS-CCE 1_B.Sc-4_13-02-25
Total questions: 50
Worksheet time: 25mins
A view of database that appears to an application program is known as:
Schema
Subschema
virtual table
none of the above
A set of objects that share a common structure and a common behavior is called:
Object
Class
Entity
None of these
Tree structures are used to store data in
Network model
Relational model
Hierarchical model
File based system
What is data integrity
It is the data contained in database that is not redundant
It is the data contained in database that is accurate and consistant
It is the data contained in database that is secured
It is the data contained in database that is shared
The level of data abstraction which describes how the data is actually stored is
Conceptual level
Physical level
File level
None of these
Collection of information stored at a particular moment is
View
Schema
Instance
None of the above
A data model is
Used to describe the structure of database
Set of basic operations on the data base
Both a and b
None of these
In a hierarchical database, a hash function is used to locate the
root
collosion
primary key
Duplicate records
The view of the total database content is
Conceptual view
Internal view
External view
Physical view
DML is provided for
Description of the logical structure of the data base
The addition of new structure in the database system
Manipulation and processing of the database
Definition of the physical structure of the database
Architecture of the database can be viewed as
Two levels
Four levels
Three levels
One level
In a relational model, relations are termed as
Tuples
Attributes
Tables
Rows
The database schema is written in
DDL
DML
DCL
HCL
In the architecture of a database system, external level is the
Physical level
Conceptual level
Logical level
View level
In Hierarchical model records are organised as
Graph
Stack
Queue
Tree
A logical schema
is the entire database
is a standard way of organizing information into accessible parts
Describes how data is actually stored
None of these
Related fields in a database are grouped to form a
data file
data record
menu
bank
A relational database developer refer to a record as
an attribute
a tuple
a row
a relation
A relational model feature is that there
is no need for primary key data
is much more data data independence than some other data models
are explicit relationships among records
are tables with many dimensions
A subschema expresses
the logical view
the physical view
the external view
all of these
An advantage of DBMS approach is
data is dependent on programs
data redundancy increases
data is integrated and can be accessed by multiple programs
None of these
A DBMS query language is designed to
support end users who use English-like commands
support in the development of complex applications software
specify the structure of a database
All of the above
The statement in SQL which allows changing the definition of a table is
Alter
Drop
Create
Select
DBA Stands for
Data base application
Data base administrator
Database Access
Data bank Administrator
Which of the following are the properties of entities
Groups
Tables
Attributes
Tuples
Which of the design is both software and hardware dependent
Logical
Physical
Conceptual
None of these
A schema describes
Record relationship
Data elements
Record and files
All of the above
manager salary details are hidden from the employee, this is
Conceptual level data hiding
Physical Level data hiding
External level data hiding
none of these
Data are
Row facts and figures
electronic representation of facts
data entry
information
A computer file contains several records.What does each record contains
Bytes
Words
Fields
Database
Relational database design makes data retrieval difficult.
True
False
Which one is not a user type in DBMS.
End User
DBA
Application Programmers
Tester
There are ___________ levels of Data Independence
1
2
3
4
The relational model was designed by the IBM research scientist and mathematician, Dr. __________________
E. F. Codd
Dennis Ritch
jucks berg
anni Besent
Sets of related data.
Tables
Forms
Queries
Reports
Data resulting from questions you ask of one or more tables.
Tables
Forms
Queries
Reports
The following are the file extensions you will use the most when developing Access databases except?
.accdb
.xls
.mdb
.mde
SQL stands for?
Structured Query Language
System Query Language
Syntax Query Language
Simple Query Language
A situation where multiple tables can contain related data that is linked by a common field
Queries
Relationship
Input Mask
Lookup Field
The following are the types of relationship except?
One-to-One
Many-to-Many
One-to-Many
One-to-Two
It specifies the kind of data a field can contain and how the field is used.
Data type
Primary key
Field name
Properties
Which of the following is an example of a DBMS
SQL
Microsoft Office
PHP
Oracle
A database management system (DBMS) is a collection of programs that enables users to
create a database
manipulate a database
both create and manipulate a database
for storing data only
The database and DBMS software together is called a ________________
Database system
Data Model
Application Program
System software
The Oracle environment of database is called as ___________
Database Schema
Database Instances
Data Structure
All of the Mentioned
for the following two entities which one is the correct option CUTOMER/ORDER
one to one
one to many
many to one
for the following two entities which is appropriate relationship Zoo/Animal
one to one
one to many
many to one
Entity-relationship diagrams is
a tool that graphically shows the collections of entities in a system
a tool that graphically shows the connections among entities in a system
Modification schema of oracle database in one level without affecting the schema in high level is called as _______
Data Migration
Data Isolation
Data Independence
Data Abstraction
Raw data is significant to a business.
True
False
