Database Management System Assignment
Assignment- A
Q1. What are the disadvantages of flat-file system?
Q 2: What are different database constraints?
Q 3 What is the difference between internal & external schema?
Q 4 What are the characteristics of data in the database?
Q 5 What are the views? How are they useful?
Q 6 What is the difference between Union & Set Intersection Operation.
Q 7 Explain the DBMS architecture in detail?
Q 8 What is ER model? Draw ER diagram for a Hospital Management System.
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
Assignment- C
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
a. Database administrator
b. DP Manager
c. DB Manager
d. 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