Chapter 8. Database Management System
(+2 Computer Application / Computer Science ,
Text book Questions and Answers)
1. Storing of the same data in different places is called _______.
Ans. Database
2. Address of a particular student is stored in two ways in a school
record; this situation is known as _______.
Ans. Redundancy
3. Unauthorised accessing of data can be prevented from using
______.
Ans. Data security
4. Sharing of data can reduce data redundancy. State whether true
or false?
Ans. False
5. Data redundancy will reduce data consistency. State whether true or false
Ans. True
6. Data about data is called ________.
Ans. Metadata
7. List the name of major components of a database system?
- Hardware
- Software
- Data
- Users
- Procedures
8. Categorize the following components of DBMS environment.
Hard disk, Switch, DBA, Payroll system, End user, railway reservation system
Hard disk --Hardware
Switch ,Payroll system ,Railway reservation system --- Software
DBA,End user ----- User
9. The person who interacts with the database through query
language is called ________
Ans. Database Administrator
10. The billing clerk in a Supermarket is a ________ user.
Ans. Naive user
11. Who provides data security in a database?
Ans.Database Administrator
12. Who changes the structure of a database?
Ans. Application Programmer
13. ________ interacts with the database through the prewritten
application program.
Ans. Naive user
14. Organization of data in terms of rows and columns is called
________.
Ans.Table
15. ________ in a table gives the complete data of a particular
entity.
Ans. Relation
16. Number of rows in a relation is called ________.
Ans. Cardinality
17. Number of ________ in a relation is called degree of the
relation.
Ans. columns
18. In the relational model, data is organised as ________.
Ans. Rows and columns
19. The minimal set of
attributes that uniquely
identifies a row in a
relation is ________
Ans. Candidate key
20. In a table Employee
Emp_code, Pan_no
are the candidate keys.
If Emp_code is taken
as the primary key then
Pan_no is ________ key.
Ans. Alternate key
21. How many primary keys are possible in a relation?
Ans. 1
22. If a key consists of more than one attributes then it is called
Ans. Composite key
23. Who is responsible for managing and controlling the activities associated with the database?
a. Database administrator
b. Programmer
c. Naive user
d. End user
Ans. a
24. In the relational model, cardinality is the
a. number of tuples
b. number of attributes
c. number of tables
d. number of constraints
Ans. a
25. Cartesian product in relational algebra is
a. a Unary operator
b. a Binary operator
c. a Ternary operator
d. not defined
Ans. b
26. Abstraction of the database can be viewed as
a. two levels
b. four levels
c. three levels
d. one level
Ans. c
27. In a relational model, relations are termed as
a. tuples
b. attributes
c. tables
d. rows
Ans. c
28. In the abstraction of a database system the external level is the
a. physical level
b. logical level
c. conceptual level
d. view level
Ans. d
29. Related fields in a database are grouped to form a
a. data file
b. data record
c. menu
d. bank
Ans. b
30. A relational database developer refers to a record as
a. criteria
b. relation
c. tuple
d. attribute
Ans. b
31. An advantage of the database management approach is
a. data is dependent on programs
b. data redundancy increases
c. data is integrated and can be accessed by multiple programs
d. none of the above
Ans. c
32.Data independence means
a. data is defined separately and not included in programs
b. programs are not dependent on the physical attributes of data
c. programs are not dependent on the logical attributes of data
d. both (b) and (c)
Ans. d
33. Key to represent relationship between tables is called
a. primary key
b. candidate Key
c. foreign Key
d. alternate Key
Ans. c
34. Which of the following operations is used if we are interested only in certain columns of a table?
a. PROJECTION
b. SELECTION
c. UNION
d. SELECT
Ans. a
35. Which of the following operations need the participating relations to be union compatible?
a. UNION
b. INTERSECTION
c. SET DIFFERENCE
d. All of the above
Ans. d
36. Which database level is closest to the users?
a. External
b. Internal
c. Physical
d. Conceptual
Ans. a
37. The result of the UNION operation between R1 and R2 is a relation that includes
a. all the tuples of R1
b. all the tuples of R2
c. all the tuples of R1 and R2
d. all the tuples of R1 and R2 which have common columns
Ans. d
38. A file manipulation command that extracts some of the records from a file is called
a. SELECT
b. PROJECT
c. JOIN
d. PRODUCT
Ans. a
39. An instance of relational schema R (A, B, C) has distinct values of A including NULL values. Which one of the following is true?
a. A is a candidate key
b. A is not a candidate key
c. A is a primary Key
d. Both (a) and (c)
Ans.b
40. How many distinct tuples are there in a relation instance with cardinality 22?
a. 22
b. 11
c. 1
d. None
Ans. 22
41. A set of possible data values is called
a. Attribute
b. Degree
c. Tuple
d. Domain
Ans. d
42. Explain the different levels of data abstraction in DBMS?
The database description consists of a structure at each of these three levels of abstraction: the physical level, conceptual level and view level
a. Physical level
The lowest level of abstraction describes how data is actually stored on secondary storage devices such as disks and tapes. The physical level describes complex lowlevel data structures in detail. We must decide what file organisations are to be used to store the relations and create auxiliary data structures, called indexes, to speed up data retrieval operations.
b. Logical level
The next-higher level of abstraction describes what data is stored in the database, and what relationships exist among those data. The logical level thus describes the entire database in terms of a small number of relatively simple structures.Although mplementation of the simple structures at the logical level may involve complex physical-level structures, the user of the logical level does not need to be aware of this complexity. Database administrators, who must decide what information to keep in the database, use the logical level of abstraction. Logical level is also referred as conceptual level.
c. View level
View level is the highest level of database abstraction and is the closest to the users. It is concerned with the way in which individual users view the data. It describes only a part of the entire database. Most of the users of the database are not concerned with all the information that is contained in the database. Instead they need only a part of the database that is relevant to them. This simplifies their interaction with the system.
43. How are schema layers related to the concepts of logical and physical data
Logical data independence refers to the ability to modify a conceptual schema without causing any changes in the schema followed at view (external) level. The logical data independence ensures that the application programs remain the same. It is more difficult to achieve logical data independence than physical data independence because the application programs are heavily dependent on the logical structure of the database.
Physical data independence refers to the ability to modify the schema followed at the physical level without affecting the schema followed at the conceptual level. That is, the application programs remain the same even though the schema at physical level gets modified.
44. What is a database? Describe the advantages and disadvantages of using DBMS.
Database is an organized collection of inter-related data stored together with minimum redundancy, in a manner that makes them accessible for multiple applications
1. Controlling data redundancy: In file management systems, data may be placed in many files. The storing of the same data in multiple locations (may be in the same file or different files) or duplication of data is known as data redundancy. Redundancy leads to higher cost in storage and data access. Database systems do not maintain redundant data, instead all the data is kept at one place in a centralized manner.
2.Data consistency: Data redundancy may lead to data inconsistency; that is, the various copies of the same data show different values in different files. Assume that your class teacher and Principal maintain separate copies of the address list of all students admitted in your class. During periodic address change a few students report to the Principal and a few students report to the changes to the class teacher. After a certain period of time both the address lists become irrelevant and inconsistent since total corrections are not updated in both. By controlling data redundancy, data consistency is obtained.
3.Efficient data access: A DBMS utilises a variety of techniques to store and retrieve data efficiently.
4. Data integrity: Data integrity refers to the overall completeness, accuracy and consistency of data in the database. This can be indicated by an absence of any alteration in data between two updates of a data record. Data integrity is imposed within a database at its design stage through the use of standard rules and procedures. Data integrity can be maintained through the use of error checking and validation routines.
5.Data security: The information inside a database is valuable to any company or organization. Therefore it must be kept secure and private. Data security refers to the protection of data against accidental or intentional disclosure or unauthorized destruction or modification by unauthorized persons.
6. Sharing of data: The data stored in the database can be shared among several users or programs even simultaneously and each may use it for different purposes.
7.Crash recovery: When a system crashes, all or a portion of the data can become unusable. DBMS provides some mechanism to recover data from the crashes. Thus the DBMS protects data from the effects of system failures.
8.Enforcement of standards: With central control of the database, a Database Administrator (DBA) defines and enforces the necessary standards. Standards can be defined for data formats to facilitate exchange of data between systems. Applicable standards might include naming conventions, display formats, report structures, terminology, documentation standards, update procedures, access rules and so on. This facilitates communication and cooperation among various departments, projects and users within the organization
45. What is data independence? Explain the difference between physical and logical data independence.
A database may be viewed through three levels of abstraction, any change in the database structure at a particular level may affect the schema of other levels. The frequent changes made on database should not lead to the redesigning and reimplementation of the database. The ability to modify the schema definition (data structure definition) in one level without affecting the schema definition at the next higher level is called data independence. There are two levels of data independence, physical data independence and logical data independence.
a. Physical data independence: Physical data independence refers to the ability to modify the schema followed at the physical level without affecting the schema followed at the conceptual level. That is, the application programs remain the same even though the schema at physical level gets modified.
b. Logical data independence :Logical data independence refers to the ability to modify a conceptual schema without causing any changes in the schema followed at view (external) level. The logical data independence ensures that the application programs remain the same. It is more difficult to achieve logical data independence than physical data independence because the application programs are heavily dependent on the logical structure of the database.
46. Enforcement of standard is an essential feature of DBMS. How are these standards applicable in a database?
With central control of the database, a Database Administrator (DBA) defines and enforces the necessary standards. Standards can be defined for data formats to facilitate exchange of data between systems. Applicable standards might include naming conventions, display formats, report structures, terminology, documentation standards, update procedures, access rules and so on. This facilitates communication and cooperation among various departments, projects and users within the organization.
47. Cardinality of a table T1 is 10 and of table T2 is 8 and the two relations are union compatible. If the cardinality of result T1∪ T2 is 13, then what is the cardinality of T1∩ T2? Justify your answer.
Ans. T1∪ T2 =T1+T2-T1∩ T2
13= 10+8-T1∩ T2
13=18- T1∩ T2
T1∩ T2=18-13=5
48. Cardinality of a table T1 is 10 and of table T2 is 8 and the two relations are union compatible
a. What will be the maximum possible cardinality of T1∪ T2?
b. What will be the minimum possible cardinality of T1∩ T2?
23. Who is responsible for managing and controlling the activities associated with the database?
a. Database administrator
b. Programmer
c. Naive user
d. End user
Ans. a
24. In the relational model, cardinality is the
a. number of tuples
b. number of attributes
c. number of tables
d. number of constraints
Ans. a
25. Cartesian product in relational algebra is
a. a Unary operator
b. a Binary operator
c. a Ternary operator
d. not defined
Ans. b
26. Abstraction of the database can be viewed as
a. two levels
b. four levels
c. three levels
d. one level
Ans. c
27. In a relational model, relations are termed as
a. tuples
b. attributes
c. tables
d. rows
Ans. c
28. In the abstraction of a database system the external level is the
a. physical level
b. logical level
c. conceptual level
d. view level
Ans. d
29. Related fields in a database are grouped to form a
a. data file
b. data record
c. menu
d. bank
Ans. b
30. A relational database developer refers to a record as
a. criteria
b. relation
c. tuple
d. attribute
Ans. b
31. An advantage of the database management approach is
a. data is dependent on programs
b. data redundancy increases
c. data is integrated and can be accessed by multiple programs
d. none of the above
Ans. c
32.Data independence means
a. data is defined separately and not included in programs
b. programs are not dependent on the physical attributes of data
c. programs are not dependent on the logical attributes of data
d. both (b) and (c)
Ans. d
33. Key to represent relationship between tables is called
a. primary key
b. candidate Key
c. foreign Key
d. alternate Key
Ans. c
34. Which of the following operations is used if we are interested only in certain columns of a table?
a. PROJECTION
b. SELECTION
c. UNION
d. SELECT
Ans. a
35. Which of the following operations need the participating relations to be union compatible?
a. UNION
b. INTERSECTION
c. SET DIFFERENCE
d. All of the above
Ans. d
36. Which database level is closest to the users?
a. External
b. Internal
c. Physical
d. Conceptual
Ans. a
37. The result of the UNION operation between R1 and R2 is a relation that includes
a. all the tuples of R1
b. all the tuples of R2
c. all the tuples of R1 and R2
d. all the tuples of R1 and R2 which have common columns
Ans. d
38. A file manipulation command that extracts some of the records from a file is called
a. SELECT
b. PROJECT
c. JOIN
d. PRODUCT
Ans. a
39. An instance of relational schema R (A, B, C) has distinct values of A including NULL values. Which one of the following is true?
a. A is a candidate key
b. A is not a candidate key
c. A is a primary Key
d. Both (a) and (c)
Ans.b
40. How many distinct tuples are there in a relation instance with cardinality 22?
a. 22
b. 11
c. 1
d. None
Ans. 22
41. A set of possible data values is called
a. Attribute
b. Degree
c. Tuple
d. Domain
Ans. d
42. Explain the different levels of data abstraction in DBMS?
The database description consists of a structure at each of these three levels of abstraction: the physical level, conceptual level and view level
a. Physical level
The lowest level of abstraction describes how data is actually stored on secondary storage devices such as disks and tapes. The physical level describes complex lowlevel data structures in detail. We must decide what file organisations are to be used to store the relations and create auxiliary data structures, called indexes, to speed up data retrieval operations.
b. Logical level
The next-higher level of abstraction describes what data is stored in the database, and what relationships exist among those data. The logical level thus describes the entire database in terms of a small number of relatively simple structures.Although mplementation of the simple structures at the logical level may involve complex physical-level structures, the user of the logical level does not need to be aware of this complexity. Database administrators, who must decide what information to keep in the database, use the logical level of abstraction. Logical level is also referred as conceptual level.
c. View level
View level is the highest level of database abstraction and is the closest to the users. It is concerned with the way in which individual users view the data. It describes only a part of the entire database. Most of the users of the database are not concerned with all the information that is contained in the database. Instead they need only a part of the database that is relevant to them. This simplifies their interaction with the system.
43. How are schema layers related to the concepts of logical and physical data
Logical data independence refers to the ability to modify a conceptual schema without causing any changes in the schema followed at view (external) level. The logical data independence ensures that the application programs remain the same. It is more difficult to achieve logical data independence than physical data independence because the application programs are heavily dependent on the logical structure of the database.
Physical data independence refers to the ability to modify the schema followed at the physical level without affecting the schema followed at the conceptual level. That is, the application programs remain the same even though the schema at physical level gets modified.
44. What is a database? Describe the advantages and disadvantages of using DBMS.
Database is an organized collection of inter-related data stored together with minimum redundancy, in a manner that makes them accessible for multiple applications
1. Controlling data redundancy: In file management systems, data may be placed in many files. The storing of the same data in multiple locations (may be in the same file or different files) or duplication of data is known as data redundancy. Redundancy leads to higher cost in storage and data access. Database systems do not maintain redundant data, instead all the data is kept at one place in a centralized manner.
2.Data consistency: Data redundancy may lead to data inconsistency; that is, the various copies of the same data show different values in different files. Assume that your class teacher and Principal maintain separate copies of the address list of all students admitted in your class. During periodic address change a few students report to the Principal and a few students report to the changes to the class teacher. After a certain period of time both the address lists become irrelevant and inconsistent since total corrections are not updated in both. By controlling data redundancy, data consistency is obtained.
3.Efficient data access: A DBMS utilises a variety of techniques to store and retrieve data efficiently.
4. Data integrity: Data integrity refers to the overall completeness, accuracy and consistency of data in the database. This can be indicated by an absence of any alteration in data between two updates of a data record. Data integrity is imposed within a database at its design stage through the use of standard rules and procedures. Data integrity can be maintained through the use of error checking and validation routines.
5.Data security: The information inside a database is valuable to any company or organization. Therefore it must be kept secure and private. Data security refers to the protection of data against accidental or intentional disclosure or unauthorized destruction or modification by unauthorized persons.
6. Sharing of data: The data stored in the database can be shared among several users or programs even simultaneously and each may use it for different purposes.
7.Crash recovery: When a system crashes, all or a portion of the data can become unusable. DBMS provides some mechanism to recover data from the crashes. Thus the DBMS protects data from the effects of system failures.
8.Enforcement of standards: With central control of the database, a Database Administrator (DBA) defines and enforces the necessary standards. Standards can be defined for data formats to facilitate exchange of data between systems. Applicable standards might include naming conventions, display formats, report structures, terminology, documentation standards, update procedures, access rules and so on. This facilitates communication and cooperation among various departments, projects and users within the organization
45. What is data independence? Explain the difference between physical and logical data independence.
A database may be viewed through three levels of abstraction, any change in the database structure at a particular level may affect the schema of other levels. The frequent changes made on database should not lead to the redesigning and reimplementation of the database. The ability to modify the schema definition (data structure definition) in one level without affecting the schema definition at the next higher level is called data independence. There are two levels of data independence, physical data independence and logical data independence.
a. Physical data independence: Physical data independence refers to the ability to modify the schema followed at the physical level without affecting the schema followed at the conceptual level. That is, the application programs remain the same even though the schema at physical level gets modified.
b. Logical data independence :Logical data independence refers to the ability to modify a conceptual schema without causing any changes in the schema followed at view (external) level. The logical data independence ensures that the application programs remain the same. It is more difficult to achieve logical data independence than physical data independence because the application programs are heavily dependent on the logical structure of the database.
46. Enforcement of standard is an essential feature of DBMS. How are these standards applicable in a database?
With central control of the database, a Database Administrator (DBA) defines and enforces the necessary standards. Standards can be defined for data formats to facilitate exchange of data between systems. Applicable standards might include naming conventions, display formats, report structures, terminology, documentation standards, update procedures, access rules and so on. This facilitates communication and cooperation among various departments, projects and users within the organization.
47. Cardinality of a table T1 is 10 and of table T2 is 8 and the two relations are union compatible. If the cardinality of result T1∪ T2 is 13, then what is the cardinality of T1∩ T2? Justify your answer.
Ans. T1∪ T2 =T1+T2-T1∩ T2
13= 10+8-T1∩ T2
13=18- T1∩ T2
T1∩ T2=18-13=5
48. Cardinality of a table T1 is 10 and of table T2 is 8 and the two relations are union compatible
a. What will be the maximum possible cardinality of T1∪ T2?
b. What will be the minimum possible cardinality of T1∩ T2?
