Correct : C. improve the quality of data entered for a specific property
2. Establishing limits on allowable property values, and specifying a set of acceptable, predefined options that can be assigned to a property are examples of:
Correct : B. data integrity constraints
3. Which of the following can be addressed by enforcing a referential integrity constraint?
Correct : C. information on the customer must be known before anything can be sold to that customer
4. is a special type of integrity constraint that relates two relations & maintains consistency across the relations.
Correct : B. referential integrity constraints
5. Which one of the following uniquely identifies the elements in the relation?
Correct : B. primary key
6. Drop Table cannot be used to drop a table referenced by a constraint.
Correct : D. foreign key
7. is preferred method for enforcing data integrity
Correct : A. constraints
8. The entity relationship set is represented in E-R diagram as
Correct : D. diamond
9. The Rectangles divided into two parts represents
Correct : A. entity set
10. We indicate roles in E-R diagrams by labeling the lines that connect to
Correct : D. diamond, rectangle
11. An entity set that does not have sufficient attributes to form a primary key is termed a
Correct : C. weak entity set
12. For a weak entity set to be meaningful, it must be associated with another entity set, called the
Correct : A. identifying set
13. Weak entity set is represented as
Correct : C. double diamond
14. If you were collecting and storing information about your music collection, an album would be considered a(n)
Correct : B. entity
15. What term is used to refer to a specific record in your music database; for instance; information stored about a specific album?
Correct : B. instance
16. Which one of the following can be treated as a primary key in teaches relation?
Correct : A. id
17. The primary key in the section relation is
Correct : C. both course_id and sec_id
18. The relation with primary key can be created using
19. How can the values in the relation teaches be deleted?
Correct : B. delete from teaches;
20. In the above teaches relation ” Select * from teaches where Year = ‘2010’” displays how many rows?
Correct : A. 2
21. The relation changes can be got back using command
Correct : A. flashback
22. Let us consider phone_number ,which can take single or several values . Treating phone_numberas an permits instructors to have several phone numbers (including zero) associated with them.
Correct : A. entity
23. The total participation by entities is represented in E-R diagram as
Correct : B. double line
24. Given the basic ER and relational models, which of the following is INCORRECT?
Correct : C. in a row of a relational table, an attribute can have more than one value
25. Which of the following indicates the maximum number of entities that can be involved in a relationship?
Correct : B. maximum cardinality
26. In E-R diagram generalization is represented by
Correct : D. triangle
27. What is a relationship called when it is maintained between two entities?
Correct : B. binary
28. Which of the following is a low level operator?
Correct : D. directory
29. Key to represent relationship between tables is called
Correct : C. foreign key
30. A window into a portion of a database is
Correct : B. view
31. A primary key is combined with a foreign key creates
Correct : A. parent-child relation ship between the tables that connect them
32. The entity set person is classified as student and employee. This process is called
Correct : B. specialization
33. Which relationship is used to represent a specialization entity?
Correct : A. isa
34. The refinement from an initial entity set into successive levels of entity subgroupings represents a design process in which distinctions are made explicit.
Correct : C. top-down
35. There are similarities between the instructor entity set and the secretary entity set in the sense that they have several attributes that are conceptually the same across the two entity sets: namely, the identifier, name, and salary attributes. This process is called
Correct : C. generalization
36. If an entity set is a lower-level entity set in more than one ISA relationship, then the entity set has
Correct : D. multiple inheritance
37. A constraint requires that an entity belong to no more than one lower- level entity set.
Correct : A. disjointness
38. Consider the employee work-team example, and assume that certain employees participate in more than one work team. A given employee may therefore appear in more than one of the team entity sets that are lower level entity sets of employee. Thus, the generalization is
Correct : A. overlapping
39. The completeness constraint may be one of the following: Total generalization or specialization, Partial generalization or specialization. Which is the default?
Correct : B. partial
40. Functional dependencies are a generalization of
Correct : A. key dependencies
41. Which of the following is another name for a weak entity?
Correct : A. child
42. Which is the main relation which is used in the university database which is referenced by all other relation of the university?
Correct : C. department
43. The department relation has the an entry budget whose type has to be replaced by
Correct : C. numeric (12,2)
44. In the above DDL command the foreign key entries are got by using the keyword
Correct : A. references
45. Identify the error in the section relation
Correct : A. no error
46. Which of the following can be used as a primary key entry of the instructor relation.
Correct : C. id
47. In the section relation which of the following is used as a foreign key?
Correct : A. course_id
48. To replace the relation section with some other relation the initial step to be carried out is
Correct : B. drop section;
49. Select distinct Dept_name from instructor ; How many row(s) are displayed ?
Correct : A. 4
50. Which function is used to find the count of distinct departments?
Correct : A. dist
51. Which function is used to identify the title with Least scope?
Correct : A. min(credits)
52. A domain is if elements of the domain are considered to be indivisible units.
Correct : A. atomic
53. Identify the composite attributes
Correct : D. none of the mentioned
54. Which one is based on multi-valued dependency:
Correct : D. fourth
55. If a relation is in BCNF, then it is also in
Correct : D. all of the mentioned
56. If every non-key attribute is functionally dependent primary key, then the relation will be in
Correct : B. second normal form
57. The term for information that describes what type of data is available in a database is:
Correct : D. metadata
58. A data type that creates unique numbers for key columns in Microsoft Access is:
Correct : A. autonumber
59. A dependency exist between two columns when
Correct : A. together they constitute a composite key for the table
60. In the normal form, a composite attribute is converted to individual attributes.
Correct : A. first
61. A table on the many side of a one to many or many to many relationship must:
Correct : D. have a composite key
62. Tables in second normal form (2NF):
Correct : A. eliminate all hidden dependencies
63. Functional Dependencies are the types of constraints that are based on
Correct : A. key
64. Which is a bottom-up approach to database design that design by examining the relationship between attributes:
Correct : C. normalization
65. A relation is in if an attribute of a composite key is dependent on an attribute of other composite key.
Correct : B. 3nf
66. What are the desirable properties of a decomposition
Correct : B. dependency preservation
67. R (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition?
Correct : D. a->bcd
68. The algorithm that takes a set of dependencies and adds one schema at a time, instead of decomposing the initial schema repeatedly is
Correct : C. 3nf synthesis algorithm
69. Which normal form is considered adequate for normal relational database design?
Correct : D. 3nf
70. Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations is
Correct : B. more than zero but less than that of an equivalent 3nf decomposition
71. Which of the normal form is based on multivalued dependencies?
Correct : D. fourth
72. Which forms has a relation that possesses data about an individual entity?
Correct : C. 4nf
73. If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources.
Correct : D. both a many-to-many relationship set and a multivalued attribute of an entity set
74. Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set?
Correct : A. a many-to-many relationship set
75. Fifth Normal form is concerned with
Correct : C. join dependency
76. In 2NF
Correct : C. no partial fds exist
77. can help us detect poor E- R design.
Correct : D. functional dependencies
78. Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set.
Correct : A. a many-to-many relationship set
79. In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set.
Correct : B. a multivalued attribute of an entity set
80. What is the best way to represent the attributes in a large database?
Correct : B. concatenation
81. Designers use which of the following to tune the performance of systems to support time-critical operations?
Correct : A. denormalization
82. Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only functional dependencies are from dept name to the other attributes. This relation is in
Correct : B. bcnf
83. Thus a of course data gives the values of all attributes, such as title and department, of all courses at a particular point in time.
Correct : B. snapshot
84. Representations such as the in the dept year relation, with one column for each value of an attribute, are called they are widely used in spreadsheets and reports and in data analysis tools.
Correct : A. cross-tabs
85. An approach to website design with the emphasis on converting visitors to outcomes required by the owner is referred to as:
Correct : B. persuasion
86. A method of modelling and describing user tasks for an interactive application is referred to as:
Correct : C. use case
87. Information architecture influences:
Correct : B. site structure
88. Also known as schematics, a way of illustrating the layout of an individual webpage is a:
Correct : A. wireframe
89. A graphical or text depiction of the relationship between different groups of content on a website is referred to as a:
Correct : C. sitemap
90. Blueprints are intended to:
Correct : C. indicate the structure of a site during site design and as a user feature
91. Storyboards are intended to:
Correct : D. prototype typical customer journeys or click streams through a website
92. Which of the following occupies boot record of hard and floppy disks and activated during computer startup?
Correct : B. boot sector virus
93. A graphical or text depiction of the relationship between different groups of content on a website is a:
Correct : C. site map
94. Which of the following is a valid uniform resource locator?
Correct : A. http://www.acm.org/sigmod
95. HTTP defines two ways in which values entered by a user at the browser can be sent to the Web server. The method encodes the values as part of the URL.
Correct : B. get
96. A is a program running on the server machine, which accepts requests from a Web browser and sends back results in the form of HTML documents.
Correct : C. web server
97. The application program typically communicates with a database server, through or other protocols, in order to get or store data.
Correct : C. all of the mentioned
98. This extra information is usually maintained in the form of a at the client.
Correct : A. cookie
99. Which of the following is not true about HTML ?