4. DBMS manages the interaction between __________ and database.
Correct : C. End Users
5. Which of the following is not involved in DBMS?
Correct : D. HTML
6. Database is generally __________
Correct : B. User-centered
7. A characteristic of an entity.
Correct : B. Attribute
8. The restrictions placed on the data.
Correct : D. Constraint
9. IMS stands for?
Correct : D. Information Management System
10. A model developed by Hammer and Mc Leod in 1981.
Correct : A. SDM
11. Object=_________+relationships.
Correct : C. entity
12. Duplication of data at several places is called as _______________.
Correct : D. Data Redundance
13. Data Redundancy increases the cost of storing and retrieving data.
Correct : B. True
14. Which of the information is not redundant.
Correct : C. account-no
15. If in redundant file common fields are not matching then it results in _____________.
Correct : A. Data Inconsistency
16. It is difficult to access conventional file system than Database System.
Correct : A. True
17. An ________ is a set of entities of the same type that share the same properties, or
attributes.
Correct : A. Entity set
18. Entity is a _________
Correct : C. Thing in real world
19. The descriptive property possessed by each entity set is _________
Correct : B. Attribute
20. The function that an entity plays in a relationship is called that entity’s _____________
Correct : C. Role
21. The attribute name could be structured as an attribute consisting of first name, middle
initial, and last name. This type of attribute is called
Correct : B. Composite attribute
22. In a relation between the entities the type and condition of the relation should be specified.
That is called as______attribute.
Correct : A. Desciptive
23. _____________ can help us detect poor E-R design.
Correct : D. Functional dependencies
24. 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
25. 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
26. 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
27. Suppose the user finds the usage of room number and phone number in a relational
schema there is confusion.This is reduced by
Correct : A. Unique-role assumption
28. Designers use which of the following to tune the performance of systems to support timecritical operations?
Correct : A. Denormalization
29. In the schema (dept name, size) we have relations total inst 2007, total inst 200Q:8) Which
dependency have lead to this relation ?
Correct : A. Dept name, year->size
30. 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
31. 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
32. 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
33. Data Model is collection of conceptual tools for describing -
Correct : B. All of these
34. Data Models in DBMS are classified into ______ categories.
Correct : C. 5
35. Object based logical model(s) are used to describe data at - [Select Appropriate Option(s)]
Correct : C. Physical Level
36. Which of the following is example of Object based logical model ?
Correct : D. Entity Relationship Model
37. Entity Relationship model consists of collection of basic objects called _________ and
relationship among these objects.
Correct : D. entities
38. Which of the following gives a logical structure of the database graphically?
Correct : A. Entity-relationship diagram
39. Consider a directed line(->) from the relationship set advisor to both entity sets instructor
and student. This indicates _________ cardinality
Correct : B. One to one
40. We indicate roles in E-R diagrams by labeling the lines that connect ___________ to
__________
Correct : D. Diamond, rectangle
41. An entity set that does not have sufficient attributes to form a primary key is termed a
__________
Correct : C. Weak entity set
42. For a weak entity set to be meaningful, it must be associated with another entity set, called
the
Correct : A. Identifying set
43. If you were collecting and storing information about your music collection, an album
would be considered a(n) _____
Correct : B. Entity
44. 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
45. If a piece of data is stored in two places in the database, then
Correct : D. Storage space is wasted & Changing the data in one spot will cause data inconsistency
46. An audit trail ___________
Correct : B. Is the recorded history of operations performed on a file
47. Large collection of files are called ____________
Correct : C. Database
48. Which of the following hardware component is the most important to the operation of a
database management system?
Correct : C. High speed, large capacity disk
49. Which of the following is not true of the traditional approach to information processing
Correct : A. There is common sharing of data among the various applications
50. The information about data in a database is called _______
Correct : A. Metadata
51. A data dictionary is a special file that contains?
Correct : D. All of the mentioned
52. A relational database system needs to maintain data about the relations, such as the
schema of the relations. This is called
Correct : A. Metadata
53. Relational schemas and other metadata about relations are stored in a structure called
the ____________
Correct : D. Data Dictionary
54. ___________ is the collection of memory structures and Oracle background processes
that operates against an Oracle database.
Correct : B. Instance
55. A ________ is a logical grouping of database objects, usually to facilitate security,
performance, or the availability of database objects such as tables and indexes.
Correct : A. Tablespace
56. A tablespace is further broken down into ________
Correct : B. Segments
57. __________ is a contiguous group of blocks allocated for use as part of a table, index,
and so forth.
Correct : C. Extent
58. ________ is the smallest unit of allocation in an Oracle database.
Correct : D. Database Block
59. An Oracle __________ is a set of tables and views that are used as a read-only
reference about the database.
Correct : C. Data dictionary
60. A data dictionary is created when a __________ created.
Correct : C. Database
61. An Oracle object type has two parts the _________ and__________
Correct : C. Specification and body
62. A(n) _________ can be used to preserve the integrity of a document or a message.
Correct : A. Message digest
63. A hash function must meet ________ criteriA:)
Correct : B. Three
64. What is the main limitation of Hierarchical Databases?
Correct : B. Limited flexibility in accessing data
65. The property (or set of properties) that uniquely defines each row in a table is called the:
Correct : C. Primary key
66. The separation of the data definition from the program is known as:
Correct : B. Data independence
67. The traditional storage of data that is organized by customer, stored in separate folders
in filing cabinets is an example of what type of ‘database’ system?
Correct : A. Hierarchical
68. The database design that consists of multiple tables that are linked together through
matching data stored in each table is called
Correct : D. Relational database
69. The association role defines:
Correct : A. How tables are related in the database
70. The purpose of an N-Ary association is:
Correct : C. To deal with relationships that involve more than two tables
71. In ordered indices the file containing the records is sequentially ordered, a
___________ is an index whose search key also defines the sequential order of the file.
Correct : A. Clustered index
72. Indices whose search key specifies an order different from the sequential order of the
file are called ___________ indices.
Correct : C. All of the mentioned
73. An ____________ consists of a search-key value and pointers to one or more records
with that value as their search-key value.
Correct : A. Index entry
74. In a _______ clustering index, the index record contains the search-key value and a
pointer to the first data record with that search-key value and the rest of the records will be in
the sequential pointers.
Correct : A. Dense
75. In a __________ index, an index entry appears for only some of the search-key values.
Correct : A. Dense
76. Incase the indices values are larger, index is created for these values of the index. This
is called
Correct : C. Multilevel index
77. A search key containing more than one attribute is referred to as a _________ search
key.
Correct : B. Composite
78. Insertion of a large number of entries at a time into an index is referred to as
__________ of the index.
Correct : C. Bulk loading
79. While inserting the record into the index, if the search-key value does not appear in the
index.
Correct : C. The system inserts an index entry with the search-key value in the index at the appropriate position
80. A collection of data designed to be used by different people is called a/an
Correct : B. Database
81. Which of the following is the oldest database model?
Correct : D. Network
82. Which of the following schemas does define a view or views of the database for
particular users?
Correct : D. External schema
83. Which of the following are the process of selecting the data storage and data access
characteristics of the database?
Correct : B. Physical database design
84. Which of the following terms does refer to the correctness and completeness of the data
in a database?
Correct : D. Data integrity
85. A table can be logically connected to another table by defining a
Correct : C. Primary key
86. If the state of the database no longer reflects a real state of the world that the database
is supposed to capture, then such a state is called
Correct : D. Inconsistent state
87. Ensuring isolation property is the responsibility of the
Correct : B. Concurrency-control component of the DBMS
88. Relational Algebra is a __________ query language that takes two relations as input and
produces another relation as an output of the query.
Correct : C. Procedural
89. For select operation the ________ appear in the subscript and the ___________ argument
appears in the paranthesis after the sigmA:)
Correct : A. Predicates, relation
90. The ___________ operation, denoted by −, allows us to find tuples that are in one relation
but are not in another.
Correct : B. Set-difference
91. In precedence of set operators, the expression is evaluated from
Correct : B. Left to right
92. Which one of the following is a set of one or more attributes taken collectively to uniquely
identify a record?
Correct : C. Super key
93. Consider attributes ID, CITY and NAME. Which one of this can be considered as a super
key?
Correct : B. ID
94. A _____ is a property of the entire relation, rather than of the individual tuples in which
each tuple is unique.
Correct : B. Key
95. An attribute in a relation is a foreign key if the _______ key from one relation is used as an
attribute in that relation.
Correct : B. Primary
96. The relation with the attribute which is the primary key is referenced in another relation.
The relation which has the attribute as a primary key is called ______________
Correct : C. Referenced relation
97. The ______ is the one in which the primary key of one relation is used as a normal
attribute in another relation.
Correct : C. Referenced relation
98. A _________ integrity constraint requires that the values appearing in specified attributes
of any tuple in the referencing relation also appear in specified attributes of at least one tuple in
the referenced relation.
Correct : A. Referential
99. A relational database consists of a collection of
Correct : A. Tables
100. A ________ in a table represents a relationship among a set of values.