Database Management System NEW

 

Database Management System 
Part A

Q1. What are the disadvantages of flat-file system?
Ans: 

Q 2: What are different database constraints?
Ans: 
Q 3 What is the difference between internal & external schema?
Ans 
Q 4 What are the characteristics of data in the database?
Ans 

Q 5 What are the views? How are they useful?
Ans:

Q 6 What is the difference between Union & Set Intersection Operation.
Ans: 

Q 7 Explain the DBMS architecture in detail?
Ans
                         
Q 8 What is ER model? Draw ER diagram for a Hospital Management System.
Ans

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. 

ANS-

b) Mention all your assumptions to justify your answer

Ans.

1. Where is a single element of data stored?    Solve by www.solvezone.in
 
Options    
Field    
Record    
Table    
All of the above

2. Which is true about the primary key?    
 
Options    
Every table should have a 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

3. A foreign key:       
 
Options    
has nothing to do with the primary key.    
has different values than the primary key    
is found in tables that don’t have a primary key    
is related to the primary key of a different table

4. Which is not a program that can create a database?    
 
Options    
Access    
MySQL    
Oracle    
All of the above can be used to create a database    

5. The normalization process is:    
 
Options    
used to remove redundant data    
used to make the storage of data more efficient    
not recommended for most databases    
Both 1 and 2

6. Which clause is required in an SQL query for getting information from a database?    
 
Options    
JOIN    
ON    
ORDER BY    
SELECT

7. How many fields can be specified in the SELECT clause?     
 
Options    
0    
1    
2    
As many as needed

8. Which is the symbol for selecting all the fields in a table?    
 
Options    
@    
#    
^    
*

9. The WHERE clause is used to restrict the number of ____ retrieved by an SQL statement.    
 
Options    
fields    
records    
tables    
Both 1 and 2    

10. Which property of the database must the connection object contain?    
 
Options    
Location    
Type    
Query    
Both 1 and 2

11. Database management systems are used to    
 
Options    
eliminate data redundancy    
establish relationships among records in different files    
manage file access    
none of above

12. Ascending order of data hierarchy is    
 
Options    
bit->byte->record->field->file->database    
bit->byte->field->record->file->database    
byte->bit->field->record->file->database    
byte->bit->field->file->record->database

13. The diagrams which are used to distribute files, libraries and tables across topology of hardware are called    
 
Options    
deployment diagrams    
use case diagrams    
sequence diagrams    
collaboration diagrams

14. Rows of a relation are called    
 
Options    
tuples    
a relation row    
a data structure    
an entity

15. Given an attribute x, another attribute y is dependent on it, if for a given x    
 
Options    
there are many y values    
there is only one value of y    
there is one or more y values    
there is none or one y value    

16. By redundancy in a file based system we mean that    
 
Options    
unnecessary data is stored    
same data is duplicated in many files    
data is unavailable    
files have redundant data

17. Data integrity in a file based system may be lost because    
 
Options    
the same variable may have different values in different files (b) (c) (d)    
files are duplicated    
unnecessary data is stored in files    
redundant data is stored in files

18. Which command is used to set a link between two database files    
 
Options    
JOIN    
UPDATE    
BROWSE    
SET RELATION

19. Data item characteristics that are important in data management include    
 
Options    
punctuation    
language    
spelling    
width

20. Fragmentation of a file system    
 
Options    
Can always be prevented    
occurs only is file is not used properly    
Can be temporarily removed by compaction    
None of above    

21. Administrative supervision of database activities is responsibility of    
 
Options    
Database administrator    
DP Manager    
DB Manager    
None of above    

22. By data security in DBMS we mean    
 
Options    
preventing access to data    
allowing access to data only to authorized users    
preventing changing data    
introducing integrity constraints    

23. A check pointing system is needed    
 
Options    
to ensure system security    
to recover from transient faults    
to ensure system privacy    
to ensure system integrity

24. Which is a type of DBMS software    
 
Options    
utilities    
query language    
report writer    
All of above

25. The candidate key is that you choose to identify each row uniquely is called    
 
Options    
Alternate Key    
Primary Key    
Foreign Key    
None of the above

26. …... is used to determine whether of a table contains duplicate rows.    
 
Options    
Unique predicate    
Like Predicate    
Null predicate    
In predicate

27. To eliminate duplicate rows ……………… is used    
 
Options    
NODUPLICATE    
ELIMINATE    
DISTINCT    
None of these

28. DCL stands for    
 
Options    
Data Control Language    
Data Console Language    
Data Console Level    
Data Control Level

29. ……… is the process of organizing data into related tables.    
 
Options    
Normalization    
Generalization    
Specialization    
None of the above

30. A ………… Does not have a distinguishing attribute if its own and mostly are dependent entities, which are part of some another entity.    
 
Options    
Weak entity    
Strong entity    
Non attributes entity    
Dependent entity

31. ……… is preferred method for enforcing data integrity    
 
Options    
Constraints    
Stored Procedure    
Triggers    
Cursors

32. The number of tuples in a relation is called its ………….    
 
Options    
Degree    
Cardinality    
Rows    
Columns    

33. Which two files are used during operation of the DBMS?    
 
Options    
Query languages and utilities    
DML and query language    
Data dictionary and transaction log    
Data dictionary and query language

34. The way a particular application views the data from the database that the application uses is a
     
 
Options    
module    
relational model    
schema    
sub schema    

35. The relational model feature is that there    
 
Options    
is no need for primary key data    
is much more data independence than some other database models    
are explicit relationships among records    
are tables with many dimensions

36. The database schema is written in    
 
Options    
HLL    
DML    
DDL    
DCL

37. Which of the following are the properties of entities?    
 
Options    
Groups    
Table    
Attributes    
Switchboards    

38. The number of attributes in a relation is called its ………    
 
Options    
Cardinality    
Degree    
Columns    
Rows

39. Which are the two ways in which entities can participate in a relationship?    
 
Options    
Passive and active    
Total and partial    
Simple and Complex    
All of the above

40. …..defines the structure of a relation which consists of a fixed set of attribute-domain pairs.    
 
Options    
Instance    
Schema    
Program    
Super Key