Wednesday, September 21, 2011

Question Bank of DBMS



Q.1    An entity is
(a) a collection of items in an application
(b) a distinct real world item in an application
(c) an inanimate object in an application
(d) a data structure
Q.2    A relationship is
(a) an item in an application
(b) a meaningful dependency between entities
(c) a collection of related entities
(d) related data
Q.3    The entity set is a
(a) set of entities
(b) collection of different entities
(c) collection of related entities
(d) collection of similar entities
Q.4    Attributes are
(i) properties of relationship
(ii) attributed to entities
(iii) properties of members of an entity set
(a) i (b) i and ii
(c) i and iii (d) iii


Q.5    The expansion of E-R diagram is
(a) Entity-Relationship diagram
(b) Entity-Relative diagram
(c) Entity-Relation diagram
(d) Entity-Rationalized diagram
Q.6    In an E-R diagram entities are represented by
(a) circles
(b) rectangles
(c) diamond shaped box
(d) ellipse
Q.7    In an E-R diagram relationship is represented by
(a) circles
(b) rectangles
(c) diamond shaped box
(d) ellipse
Q.8   Entities are identified from the word statement of a problem by
(a) picking words which are adjectives
(b) picking words which are nouns
(c) picking words which are verbs
(d) picking words which are pronouns
Q.9    Relationships are identified from the word statement of a problem by
(a) picking words which are adjectives
(b) picking words which are nouns
(c) picking words which are verbs
(d) picking words which are pronouns
Q.10    One entity may be
(a) related to only one other entity
(b) related to itself
(c) related to only two other entities
(d) related to many other entities
Q.11    By relation cardinality we mean
(a) number of items in a relationship
(b) number of relationships in which an entity can appear
(c) number of items in an entity
(d) number of entity sets which may be related to a given entity
Q.12    If an entity appears in only one relationship then it is
(a) a 1:1 relationship
(b) a 1:N relationship
(c) a N:1 relationship
(d) a N:M relationship
Q.13   If an entity appears in N relationships then it is
(a) a 1:1 relationship
(b) a 1:N relationship
(c) a N:1 relationship
(d) a N:M relationship
Q.14    A relation is
(a) an entity
(b) a relationship
(c) members of a relationship set
(d) members of an entity set or a relationship set


Q.15    Rows of a relation are called
(a) tuples
(b) a relation row
(c) a data structure
(d) an entity
Q.16    A database is a
(a) collection of files
(b) collection of inputs and outputs of application
(c) collection of related data necessary to manage an organization
(d) data resource of an organization
Q.17    A database models data so that it is
(a) appropriate for application
(b) independent of application program
(c) optimized for most frequent applications
(d) optimized for all applications
Q.18    A database should be designed to allow providing
(a) different views of portions of data requested by an application
(b) data only to selected applications as decided by an organization
(c) a uniform view of data to all applications
(d) data to all applications
Q.19    The abbreviation DBMS stands for
(a) Data Base Manipulation System
(b) Data Bank Manipulating System
(c) Data Base Management System
(d) Data Bank Management System
Q.20    A DBMS is
(a) another name for database system
(b) independent of a database
(c) dependent on application programs
(d) is a set of procedures which manage a database
Q.21    A DBMS
(a) is a set of procedures
(b) manages a database
(c) is a set of procedures to manage a database to provide data as required by
applications
(d) provides data to applications
Q.22    One of the main objectives of a DBMS is to
(a) Create a database for an organization
(b) Facilitate sharing of a database by current and future applications
(c) Allow sharing application programs
(d) Replace file based systems
Q.23    Database is
(a) an important resource of an organization
(b) not relevant to existing programs
(c) not relevant for future programs
(d) not as good as files as there is redundancy
Q.24    By data independence we mean application programs
(a) do not need data
(b) may be developed independent of data
(c) may be developed without knowing the organization of data
(d) may be developed with independent data


Q.25    Data independence allows
(i) no changes in application programs
(ii) change in database without affecting application programs
(iii) hardware to be changed without affecting application programs
(iv) system software to be changed without affecting application programs
(a) i, ii (b) ii, iii
(c) ii, iii, iv (d) i, ii, iv
Q.26    Data independence allows
(a) sharing the same database by several applications
(b) extensive modification of applications
(c) no data sharing between applications
(d) elimination of several application programs
Q.27    Among objectives of DBMS are ensuring
(i) data integrity
(ii) data redundancy
(iii) data security
(iv) easy data retrieval
(a) i, ii (b) i, iii
(c) i, iii, iv (d) i, ii, iii
Q.28    DBMS
(a) does not allow replication of data
(b) allows controlled replication of data if it improves performance
(c) does not allow common data to be duplicated
(d) does not allow replication as it adversely affects reliability
Q.29    DBMS must implement management controls to
(i) control access rights to users
(ii) implement audit trail when changes are made
(iii) allow data to be used extensively in the organization
(iv) duplicate databases
(a) i, ii (b) ii, iii
(c) iii, iv (d) i, iv
Q.30    An E-R modelling for given application leads to
(a) conceptual data model
(b) logical data model
(c) external data model
(d) internal data model
Q.31    A conceptual data model is converted using a Relational Data Base
Management System to a
(a) logical data model
(b) external data model
(c) internal data model
(d) an entity-relation data model
Q.32    A subset of logical data model accessed by programmers is called a
(a) conceptual data model
(b) external data model
(c) internal data model
(d) an entity-relation data model


Q.33    When a logical model is mapped into a physical storage such as a disk store the
resultant data model is known as
(a) conceptual data model
(b) external data model
(c) internal data model
(d) disk data model
Q.34    A DBMS has the following components
(i) a data definition language
(ii) a query language
(iii) a security system
(iv) audit trail
(a) i, ii (b) i, ii, iii
(c) i, ii, iii, iv (d) i, ii, iv
Q.35    A check pointing system is needed
(a) to ensure system security
(b) to recover from transient faults
(c) to ensure system privacy
(d) to ensure system integrity
Q.36    A database administrator
(a) administers data in an organization
(b) controls all inputs and all outputs of programs
(c) is controller of data resources of an organization
(d) controls all data entry operators
Q.37    The responsibilities of a database administrator includes
(i) maintenance of data dictionary
(ii) ensuring security of database
(iii) ensuring privacy and integrity of data
(iv) obtain an E-R model
(a) i, ii (b) i, ii, iii
(c) i, ii, iii, iv (d) ii, iii, iv
Q.38    Access right to a database is controlled by
(a) top management
(b) system designer
(c) system analyst
(d) database administrator
Q.39    The sequence followed in designing a DBMS are
(a) physical model _ conceptual model _ logical model
(b) logical model _ physical model _ conceptual model
(c) conceptual model _ logical model _ physical model
(d) conceptual model _ physical model _ logical model
Q.40    Designing physical model of DBMS requires information on
(i) data volume
(ii) frequency of access to data
(iii) programming language used
(iv) secondary memory characteristics
(a) i, ii (b) i, ii, iii
(c) i, ii, iii, iv (d) i, ii, iv


Q.41    A good database design
(i) caters primarily to current needs
(ii) caters to current and future needs as organizations grow
(iii) has to be modified when hardware is upgraded
(iv) ensures data security
(a) i, ii (b) i, ii, iii
(c) ii, iv (d) iii, iv
Q.42    A good database design
(i) is expandable with growth and changes in organization
(ii) easy to change when software changes
(iii) ensures data integrity
(iv) allows access to only authorized users
(a) i, ii (b) ii, iii
(c) i, ii, iii, iv (d) i, ii, iii


Q.1          Define the following terms-                                                                                                                
                (i) DataBase          (ii) Entity                (iii) Attribute        
(iv) Relationship   (v) Cardinality
Q.2          Explain in brief with an example –                                                                                                   
                (i) Schema              (ii) Data Model      (iii)  Primary Key (iv) Foreign Key
Q.3          Construct an E-R Diagram that models Books written by an Author and published by a Publisher. Assume the attributes for entities and underline the primary key for each entity.                               
Q.4          Construct an ER model for a car insurance company whose customer own one or more cars each. Each car has associated with it zero to any number of recorded accidents.
Q.5          Construct an ER model for a hospital with a set of patients and a set of medical doctor. A log of the various tests and examinations conducted for each patients is also maintained.
Q.6          Draw an ER diagram for a customer and account with an attribute attached to a relationship set Depositor.
Q.7          Draw an ER diagram of the registration process of a student in a particular course.
Q.8          What is Data?
Q.9          What is Database?
Q.10        What is Database Management System?
Q.11        What is DDL?
Q.12        What is DML?
Q.13        What is the difference between DDL & DML?
Q.14        What are the differences between file system and database system?
Q.15        What are the advantages and disadvantages of DBMS?
Q.16        Explain different types of data models?
Q.17        Describe the three-schema architecture.
Q.18        What is the difference between logical and physical data independence?
Q.19        What is Key?
Q.20        What is super Key?
Q.21       What is candidate Key?
Q.22       What is primary Key?
Q.23        What is Foreign Key?

1 comment:

Note: Only a member of this blog may post a comment.