1.Relational calculus is a
1.Procedural language
2.Non-procedural language
3.data definition language
4.high level language
2.In an E-R diagram attributes are represtented by
1.rectangle
2.square
3.ellipse
4.triangle
3.In case of entity integrity , the primary key may be
1.not null
2.null
3.both null & not null
4.any value
4.a collection of data designed to be used by different people is called a/an
1.organization
2.database
3.relationship
4.schema
5.Which of the following is the oldest database model
1.relational
2.hierarchical
3.physical
4.network
6.which of the following schemas does define a view or views of the database for particular users
1.Internal schema
2.conceptual schema
3.physical schema
4.External schema
7.the relationship between DEPARTMENT and EMPLOYEE is a
1.one-to-one relationship
2.one-to-many relationship
3.many-to-many relationship
4.many-to-one relationship
8.An entity is
1.a collection of items in an application
2.a distinct real world item in an application
3.an inanimate object in an application
4.a data structure
9.Pick entities from the following:
(i) vendor
(ii) student
(iii) attends
(iv) km/hour
1.i,ii,iii
2.i,ii,iv
3.i and ii
4.iii and iv
10. A relationship is
1.an item in an application
2.a meaningful dependency between entities
3.a collection of related entities
4.related data
11. pick the relationship from the following
1.a classroom
2.teacher
3.attends
4.cost per dozen
12. pick the meaningful relationship between entities
1.vendor supplies goods
2.vendor talks with customers
3.vendor complains to vendor
4.vendor asks prices
13. The entity set is a
1.collection of different entities
2.collection of related entities
3.set of entities
4.collection of similar entities
14. pick entity set from the following
1.all vendors supplying to an organization
2.vendors and organizations they supply
3.vendors and transporters
4.a vendor supplying to many organizations
15.Attributes are
(i) properties of relationship
(ii) attributed to entities
(iii) properties of members of an entity set
1.i
2.i and ii
3.i and iii
4.iii
16.The attributes of relationship teaches in teacher teaches course should be
1.teacher code, teacher name, dept, phone no
2.course no, course name, semester offered, credits
3.teacher code, course no, semester no
4.teacher code, course no, teacher name, dept, phone no
17.The expansion of E-R diagram is
1.Entity-Relationship diagram
2.Entity-Relative diagram
3.Entity-Relation diagram
4.Entity-Rationalized diagram
18.In an E-R diagram entities are represented by
1.circles
2.rectangles
3.diamond shaped box
4.ellipse
19.In an E-R diagram relationship is represented by
20. Entities are identified from the word statement of a problem by
1.picking words which are adjectives
2.picking words which are nouns
3.picking words which are verbs
4.picking words which are pronouns
21.Relationships are identified from the word statement of a problem by
22.One entity may be
1.related to only one other entity
2.related to itself
3.related to only two other entities
4.related to many other entities
23.By relation cardinality we mean
1.number of items in a relationship
2.number of relationship in which an entity can appear
3.number of items in an entity
4.number of entity sets which may be related to a given entity
24. If an entity appears in only one relationship then it is
1.a 1:1 relationship
2.a 1:N relationship
3.a N:1 relationship
4.a N:M relationship
25. If an entity appears in N relationship then it is
26.If an entity appears in not more thatn 5 relationships then it is a
2.a 1:5 relationship
3.a 5:1 relationship
4.a 5:5 relationship
27. A pilot can fly three types of planes and a plane can be piloted by any qualified
pilot. The pilot-plane type relationship is
1.a N:3 relationship
2.a 3:N relationship
3.a 1:3 relationship
4.a 3:1 relationship
28. A student can take not more than 5 subjects in a semester. The number of
students allowed in a subject in a semester is not more than 40. The student
- subject relationship is
1.5:40
2.40:5
3.N:5
4.40:M
29. A relation is
1.an entity
2.a relationship
3.members of a relationship set
4.members of an entity set or a relationship set
30. Rows of a relation are called
1.tuples
2.a relation row
3.a data structure
4.an entity
31.Normalization is a process of restructuring a relation to
1.minimize duplication of data in a database
2.maximize duplication of data to ensure reliability
3.make it of uniform size
4.allow addition of data
32.Normalization of database is essential to
(i) avoid accidental deletion of required data when some data is deleted
(ii) eliminate inconsistencies when a data item is modified in the database
(iii) allows storage of data in a computer’s disk
(iv) use a database management system
1.i and iii
3.ii and iii
4.ii and iv
33.A relation is said to be in 1NF if
1.there is no duplication of data
2.there are no composite attributes
3.there are only a few composite attributes
4.all attributes are of uniform type
34. A relation is said to be in BCNF when
1.it has overlapping composite keys
2.it has no composite keys
3.it has no multivalued dependencies
4.it has no overlapping composite keys which have related attributes
moh
moh
ReplyDelete