Database Management System

Assignment - A
1. A well-maintained relational DBMS has a high level of data integrity. What features of a relational DBMS contribute towards this level of integrity?

2. (a) Explain the various functions of RDBMS? Name the different categories of RDBMS users and how they are different from each other.

(b) RDBMS has become most popular Database System worldwide? Justify your answer with suitable example.
3. Explain different integrity constrains supported by RDBMS and ORDBMS with suitable examples.
4. Process of normalization is the integral part of designing a database. Justify this statement with suitable database design.
5. Differentiate among on any three of the following giving suitable examples:-

6. Write SQL statements to create a table from existing table. What are the advantages of creating a table from existing table?

7. What do you mean by ‘view’? What are its different types? Differentiate between updatable and non-updatable ‘view’ with suitable examples. Also give proper syntax for creating ‘view’.

8. Explain the difference between the Drop & Delete, Commit & Rollback and Alter & Update with suitable examples.

Assignment B
Case Detail:  

A Librarian of a central university has hired a database designer to maintain information about its members, books and other related details i.e.  Issue and return of books, reservation, fine calculation and usage of books.

1. Suggest a suitable database design to maintain above mentioned data keeping in mind the redundancy and consistency of data. 

b) Mention all your assumptions to justify your answer

c) What is Database? Explain Database Design.
Assignment C
Question 1
Where is a single element of data stored?
Record 
All of the above 
Table 
Field 
 
Question 2
Which is true about the primary key?
A primary key exclusively identifies each row in a table 
A primary key can be made of multiple fields 
All of the above 
Every table should have a primary key 
 
Question 3
A foreign key:
has nothing to do with the primary key. 
has different values than the primary key 
is related to the primary key of a different table 
is found in tables that don t have a primary key 
 
Question 4
Which is not a program that can create a database?
All of the above can be used to create a database 
Access 
Oracle 
MySQL 
 
Question 5
The normalization process is:
Both 1 and 2 
used to remove redundant data 
used to make the storage of data more efficient 
not recommended for most databases 
 
Question 6
Which clause is required in an SQL query for getting information from a database?
ON 
ORDER BY 
JOIN 
SELECT 
 
Question 7
How many fields can be specified in the SELECT clause?
As many as needed 
0 
1 
2 
 
Question 8
Which is the symbol for selecting all the fields in a table?
# 
^ 
* 
@ 
 
Question 9
The WHERE clause is used to restrict the number of ____ retrieved by an SQL statement.
records 
fields 
tables 
Both 1 and 2 
 
Question 10
Which property of the database must the connection object contain?
Query 
Type 
Both 1 and 2 
Location 
 
Question 11
Database management systems are used to
eliminate data redundancy 
none of above 
manage file access 
establish relationships among records in different files 
 
Question 12
Ascending order of data hierarchy is
bit->byte->field->record->file->database (Wrong Ans)
bit->byte->record->field->file->database (Wrong Ans) 
byte->bit->field->file->record->database 
byte->bit->field->record->file->database (Wrong Ans)
 
Question 13
"The diagrams which are used to distribute files, libraries and tables across topology of hardware are called"
use case diagrams 
collaboration diagrams 
deployment diagrams 
sequence diagrams 
 
Question 14
Rows of a relation are called
tuples 
an entity 
a relation row 
a data structure 
 
Question 15
"Given an attribute x, another attribute y is dependent on it, if for a given x"
there is one or more y values 
there is none or one y value 
there is only one value of y 
there are many y values 
 
Question 16
By redundancy in a file based system we mean that
unnecessary data is stored 
files have redundant data 
same data is duplicated in many files 
data is unavailable 
 
Question 17
0.75 / 0.75 pts
Data integrity in a file based system may be lost because
files are duplicated 
unnecessary data is stored in files 
the same variable may have different values in different files (b) (c) (d) 
redundant data is stored in files 
 
Question 18
Which command is used to set a link between two database files
JOIN 
BROWSE 
SET RELATION 
UPDATE 

Question 19
Data item characteristics that are important in data management include
width 
punctuation 
language 
spelling 
 
Question 20
Fragmentation of a file system
Can be temporarily removed by compaction 
Can always be prevented 
None of above 
occurs only is file is not used properly 
 
Question 21
Administrative supervision of database activities is responsibility of
DP Manager 
DB Manager 
None of above 
Database administrator 
 
Question 22
By data security in DBMS we mean
preventing changing data 
introducing integrity constraints 
preventing access to data 
allowing access to data only to authorized users 
 
Question 23
A check pointing system is needed
to ensure system privacy 
to ensure system security 
to recover from transient faults 
to ensure system integrity 
 
Question 24
Which is a type of DBMS software
All of above 
report writer 
query language 
utilities 

Question 25
The candidate key is that you choose to identify each row uniquely is called
Foreign Key 
Alternate Key 
None of the above 
Primary Key 
 
Question 26
... is used to determine whether of a table contains duplicate rows.
Unique predicate 
Null predicate 
Like Predicate 
In predicate 
 
Question 27
To eliminate duplicate rows is used
ELIMINATE 
DISTINCT 
None of these 
NODUPLICATE 
 
Question 28
DCL stands for
Data Console Language 
Data Control Language 
Data Control Level 
Data Console Level 
 
Question 29
is the process of organizing data into related tables.
None of the above 
Generalization 
Normalization 
Specialization 
 
Question 30
"A Does not have a distinguishing attribute if its own and mostly are dependent entities, which are part of some another entity."
Strong entity 
Weak entity 
Non attributes entity 
Dependent entity 
 
Question 31
is preferred method for enforcing data integrity
Cursors 
Constraints 
Stored Procedure 
Triggers 
 
Question 32
The number of tuples in a relation is called its.
Cardinality 
Columns 
Degree 
Rows 
 
Question 33
Which two files are used during operation of the DBMS?
Query languages and utilities 
DML and query language 
Data dictionary and query language 
Data dictionary and transaction log 
 
Question 34
The way a particular application views the data from the database that the application uses is a
sub schema 
schema 
module 
relational model 

Question 35
The relational model feature is that there
are tables with many dimensions 
is no need for primary key data 
are explicit relationships among records 
is much more data independence than some other database models 
 
Question 36
The database schema is written in
DDL 
DML 
DCL 
HLL 
 
Question 37
Which of the following are the properties of entities?
Switchboards 
Groups 
Attributes 
Table 
 
Question 38
The number of attributes in a relation is called its
Columns 
Cardinality 
Rows 
Degree 
 
Question 39
Which are the two ways in which entities can participate in a relationship?
All of the above 
Passive and active 
Simple and Complex 
Total and partial 
 
Question 40
..defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
Program 
Super Key 
Schema 
Instance