1.A ………….. specifies the actions needed to remove the drawbacks in the current design of database.
a. 2 NF
b. 3 NF
c. Normal form
d. 1 NF
Correct Answer: c
2.A relation is in ……………. if an attribute of a composite key is dependent on an attribute of other composite key.
a. 3NF
b. 2NF
c. BCNF
d. 1NF
Correct Answer: a
3.In 2NF
a. No multivalve dependencies exist.
b. No partial multivalve dependencies exist.
c. No partial functional dependencies exist
d. No functional dependencies exist.
Correct Answer: c
4.The normal form that is not necessarily dependency preserving is
a. 3NF
b. 2NF
c. BCNF
d. 4NF
Correct Answer: a
5.Which normal form is considered adequate for normal relational database design?
a. 3NF
b. 2NF
c. 5NF
d. 4NF
Correct Answer: a
6.The relational model is based on the concept that data is organized and stored in two-dimensional tables called ……………………….
a. Records
b. Keys
c. Relations
d. Fields
Correct Answer: c
7.……….. contains information that defines valid values that are stored in a column or data type.
a. Default
b. Index
c. View
d. Rule
Correct Answer: b
8.. ……. First proposed the process of normalization.
a. Edward Codd
b. Edgar F. Codd
c. Edgar. W
d. Edward Stephen
Correct Answer: b
9.For using a specific database …………… command is used.
a. database name use
b. Both A &B`
c. None of them
d. use database`
Correct Answer: d
10.A relation is ………………. if every field contains only atomic values that is, no lists or sets.
a. 1 NF
b. 2 NF
c. 3 NF
d. BCNF
Correct Answer: a
11.Which of the following is not comparison operator?
a. =<
b. <>
c. <
d. >=
Correct Answer: a
12.An outstanding functionality of SQL is its support for automatic ………… to the target data.
a. functioning
b. notification
c. navigation
d. programming
Correct Answer: c
13.. ………… is a special type of integrity constraint that relates two relations & maintains consistency across the relations.
a. Domain Integrity Constraints
b. Domain Constraints
c. Referential Integrity Constraints
d. Entity Integrity Constraints
Correct Answer: c
14.…………..specifies a search condition for a group or an aggregate.
a. WHERE Clause
b. HAVING Clause
c. GROUP BY Clause
d. FROM Clause
Correct Answer: b
15.Drop Table cannot be used to drop a table referenced by a …………… constraint.
a. Composite Key
b. Foreign Key
c. Local Key
d. Primary Key
Correct Answer: b
16.In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction?
a. CREATE SCHEMA
b. CREATE PACKAGE
c. CREATE CLUSTER
d. Create Table
Correct Answer: a
17.Which character function can be used to return a specified portion of a character string?
a. SUBSTRING
b. POS
c. SUBSTR
d. INSTR
Correct Answer: c
18.Which of the following is TRUE for the System Variable $date$?
a. Can be assigned to any field only during design time.
b. Can be assigned to a global variable.
c. Can be assigned to any variable or field during run time.
d. Can be assigned to a local variable.
Correct Answer: a
19.What are the different events in Triggers?
a. Select, Commit
b. Insert, Update, Delete
c. Drop, Comment
d. Define, Create
Correct Answer: b
20.Which is the subset of SQL commands used to manipulate Oracle Database Structures, including tables?
a. Data Definition Language
b. Data Manipulation Language
c. Data Described Language
d. Data Retrieval Language
Correct Answer: a
21.Which of the following SQL command can be used to modify existing data in a database table?
a. MODIFY
b. CHANGE
c. NEW
d. UPDATE
Correct Answer: d
22.When SQL statements are embedded inside 3GL, we call such a program as ……….
a. distinct query
b. embedded SQL
c. nested query
d. nested programming
Correct Answer: b
23…………….. provides option for entering SQL queries as execution time, rather than at the development stage.
a. SQL
b. Dynamic SQL
c. PL/SQL
d. SQL*Plus
Correct Answer: b
24.The RDBMS terminology for a row is
a. degree
b. tuple
c. relation
d. attribute
Correct Answer: a
25.To change column value in a table the ……… command can be used.
a. create
b. insert
c. alter
d. update
Correct Answer: d
26.The full form of DDL is
a. Data Definition Language
b. Dynamic Data Language
c. Detailed Data Language
d. Data Derivation Language
Correct Answer: a
27.To pass on granted privileges to other user the …… clause is used
a. select option
b. grant option
c. create option
d. update option
Correct Answer: b
28.A set of possible data values is called
a. tuple
b. domain
c. attribute
d. degree
Correct Answer: b
29………. is critical in formulating database design.
a. normalizing
b. functional dependency
c. number of tables
d. row column order
Correct Answer: b
30.A primary key if combined with a foreign key creates
a. Network model between the tables that connect them
b. one to one relationship between the tables that connect them
c. Parent-Child relationship between the tables that connect them
d. Many to many relationship between the tables that connect them
Correct Answer: c
31.A …………. represents the number of entities to which another entity can be associated
a. schema
b. information
c. mapping cardinality
d. table
Correct Answer: c
32.Which two files are used during operation of the DBMS
a. Data dictionary and transaction log
b. Query languages and utilities
c. DML and query language
d. Data dictionary and query language
Correct Answer: a
33.A ……….. is a set of column that identifies every row in a table.
a. composite key
b. candidate key
c. foreign key
d. super key
Correct Answer: d
34.What is a data integrity?
a. It is the data contained in database that is shared
b. It is the data contained in database that is accurate and consistent.
c. It is the data contained in database that is non redundant.
d. It is the data contained in database that is secured
Correct Answer: b
35.In SQL the word ‘natural’ can be used with
a. Semi join
b. inner join
c. full outer join
d. right outer join
Correct Answer: b
36.Which of the following relational algebraic operations is not from set theory?
a. Intersection
b. Cartesian Product
c. Select
d. Union
Correct Answer: c
37.An entity set that does not have sufficient attributes to form a primary key is a
a. strong entity set
b. simple entity set
c. primary entity set
d. weak entity set
Correct Answer: d
38.In case of entity integrity, the primary key may be
a. both Null and not Null
b. any value
c. not Null
d. Null
Correct Answer: c
39.A logical schema
a. describe meta data
b. is the entire database.
c. is a standard way of organizing information into accessible parts.
d. describes how data is actually stored on disk
Correct Answer: b
40.Which of the following is another name for weak entity?
a. Child
b. Owner
c. Dominant
d. Parent
Correct Answer: a
41.Which of the following is record based logical model?
a. E-R model
b. None of the above
c. Network Model
d. Object oriented model
Correct Answer: c
42.A file manipulation command that extracts some of the records from a file is called
a. JOIN
b. PRODUCT
c. SELECT
d. PROJECT
Correct Answer: c
43.In E-R Diagram derived attribute are represented by
a. Dashed ellipse
b. Ellipse
c. Rectangle
d. Triangle
Correct Answer: a
44.The natural join is equal to
a. Combination of projection and Cartesian product
b. Cartesian Product
c. Combination of Union and Cartesian product
d. Combination of selection and Cartesian product
Correct Answer: a
45.In E-R diagram relationship type is represented by
a. Diamond
b. Ellipse
c. Dashed ellipse
d. Rectangle
Correct Answer: a
46.In E-R diagram generalization is represented by
a. Ellipse
b. Dashed ellipse
c. Rectangle
d. Triangle
Correct Answer: d
47.A table joined with itself is called
a. Outer Join
b. Equi Join
c. Self Join
d. Join
Correct Answer: c
48………… means multiple copies of the same data items.
a. Data redundancy
b. Data reduction
c. B) Data integrity
d. Data consistency
Correct Answer: a
49.Different values for the same data item is referred to as …….
a. data inconsistency
b. data consistency
c.
d. data duplication
Correct Answer: a
50.The ………. returns row after combining two tables based on common values.
a. union
b. join
c. difference
d. product
Correct Answer: b
51. Information is processed from____________________.
a. Memory
b. Input
c. Data
d. outpot
Correct Option: c
52. MIS stand for:
a. Management information Service
b. Management information Server
c. Management Information system
d. Master inform system
Correct Option: c
53. Which is the data model:
a. Network
b. Object-relational
c. Relational
d. All of these
Correct Option: d
54. _______ is information about data.
a. Entity
b. Relations
c. Meta data
d. Data
Correct Option: c
55. A user that manage the files of applications in DBMS is called:
a. None of these
b. File Manager
c. Administrator
d. Database Analyst
Correct Option: b
56. Grant and revoke is the type of comand:
a. DCL
b. DDL
c. DQL
d. DML
Correct Option: a
57. _______ Is the real world object, such as person place etc:
a. Attribute
b. Records
c. Allof these
d. Entity
Correct Option: d
58. An entity has a set of __________ that describe it.
a. Tuples
b. Relations
c. Attributes
d. Entity
Correct Option: c
59. Data is the type of attribute:
a. Single Values
b. Multi Values
c. Comosite
d. Simple
Correct Option: c
60. _______ is the attributes or group of attributes that uniquely identify occurrence of each entity.
a. Super key
b. All of above
c. Primary Key
d. Foigen key
Correct Option: c
61. A data wherehouse uses:
a. health care data
b. historical operational data
c. partial oprational data
d. future oprational data
Correct Option: b
62. Metadata enables database designers and users to do all of the following except:
a. Sample data
b. understand what data exist
c. what the data mean
d. None of these
Correct Option: a
63. A database application can perform which of the following activities?
a. Add records
b. Read records
c. Update records
d. All of these
Correct Option: d
64. Data administrator are responsible for:
a. writing application programs
b. managing technical issues in the database environment
c. Overall management of data resources in an organization
d. Physical database design
Correct Option: c
65. Which of the following type of database are the most common?.
a. Personal
b. Enterprise
c. Workgroup
d. Department
Correct Option: d
66. Structured data may include which of the following:
a. Dates
b. Photo image
c. video clip
d. None of these
Correct Option: a
67. Database Management systems were first introduced in the 1950s.
a. FALSE
b. TRUE
c. …….
d. ………
Correct Option: a
68. Which of the following is true for relational database?.
a. All of above
b. Data is represented by tables
c. It is difficult to access data
d. complex programs have to be written for simple quries
Correct Option: b
69. A shared database should:
a. be secure
b. provide for backup and recovery
c. be accurate and avilable
d. All of these
Correct Option: d
70. All entrprise resource planning (ERP) systemare heavily dependent on database to store data required by the ERP applications.
a. TRUE
b. FALSE
c. …….
d. ……..
Correct Option: a
71. Entity is a_____________________.
a. present working model
b. thing in real world
c. Object of relation
d. Model of relation
Correct Option: b
72. A many to many relationship between two entities usually results in how many tabels ?.
a. FIVE
b. Three
c. Two
d. Four
Correct Option: b
73. Which of the following is a single valued attribute ?
a. Register-number
b. Address
c. Refrence
d. Subject-taken
Correct Option: a
74. E-R technique is a:
a. None of these
b. Top-down aapproach
c. Bottom-up approach
d. Left Right approach
Correct Option: b
75. In ER the detail of the entities are hidden from the user. This process is called:
a. abstraction
b. generalization
c. specialization
d. None of these
Correct Option: a
76. An_____ is a set of entities of the same type thate share the same properties , or attributes.
a. Entity model
b. Relation set
c. Attribute set
d. Entity set
Correct Option: d
77. ________ express the number of entities to which anothor entity can be associated via a relationship set.
a. Partcipition constraints
b. Nne of the metioned
c. Maping cardinality
d. Relational cardinality
Correct Option: c
78. Which of the following uniquely identifies the elements in the relation ?
a. Primery key
b. Secondry Key
c. Forigen key
d. composite key
Correct Option: a
79. Drop tabel cannot be used to drop a tabel refrenced by a _________ constraint.
a. composite key
b. Foreign key
c. Local key
d. Primary key
Correct Option: b
80. Not applicable condition can be represented in relation entry as:
a. 0
b. Blank space
c. NULL
d. NA
Correct Option: c
81. Creating read only database is a task that is ______ assigned to beginning database professionals.
a. seldom
b. never
c. Commonly
d. always
Correct Option: c
82. Evert Boyee-Codd normal form is in .
a. first normal form
b. second normal form
c. third normal form
d. All of these
Correct Option: d
83. Eliminatinating modification anomalies is a(n) ___________ of normilization .
a. advantage
b. disadvantage
c. Both A and B
d. Neither
Correct Option: a
84. A function that has no partial functional dependencies is in ________ form:
a. 2NF
b. 3NF
c. 4NF
d. BCNF
Correct Option: a
85. 5NF is designed to cope with :
a. multivalued depedency
b. All of above
c. jion dependency
d. transitive dependency
Correct Option: c
86. A relation in this form is free of all modification anomalies.
a. first normal form
b. second normal form
c. third normal form
d. Domain/keu normal form
Correct Option: d
87. If there is more than one key for relayion schema in DBMS then each key in relation schema is classified as:
a. primary key
b. foreign key
c. Candidate key
d. super key
Correct Option: c
88. The functional dependency of two sets E and F are considered as equivalent if
a. E2 =F2
b. E*=F2
c. E+F=E-F
d. E* =F*
Correct Option: d
89. ABCNF is:
a. loss less join but dependency preserving
b. None of these
c. loss less join but not dependency preserving
d. not loss less join but depedency preserving
Correct Option: c
90. Afunctional dependency is a relationship between or among :
a. tables
b. relatins
c. attributes
d. rows
Correct Option: c
91. A Primery key is a composite key that was selected to b the main identifier for the relation
a. FALSE
b. TRUE
c.
d.
Correct Option: a
92. In a relation the row are sometimes called “fields”.
a. FALSE
b. TRUE
c.
d.
Correct Option: a
93. A function dependency is always an equation.
a. FALSE
b. TRUE
c.
d.
Correct Option: a
94. A tuple is a (n):
a. Row of table
b. Column of table
c. Key of a table
d. Two dimensional table
Correct Option: a
95. Arelation in this from is free of all modification anomalies.
a. first normal from
b. second normal from
c. Third normal from
d. Domain
Correct Option: d
96. An attribute is a (n):
a. row of a table
b. key of a table
c. column of table
d. two dimensional table
Correct Option: c
97. The primary key is selected from the:
a. determine keys
b. foregin keys
c. candidate keys
d. composite keys
Correct Option: c
98. Row is synonymous with the term:
a. record
b. relation
c. column
d. field
Correct Option: a
99. Information is processed from______________.
a. none of these
b. Data
c. output
d. memory
Correct Option: b
100. Which is data model
a. object-relational
b. relational
c. netwrok
d. all of these
Correct Option: d
101. Which is not feature of database
a. Data integrity
b. data redundancey
c. independence
d. flexibility
Correct Option: b
102. which is the database language:
a. none of these
b. SQL
c. c
d. c++
Correct Option: b
103. which level of database is viewed by users:
a. All of these
b. External level
c. internal level
d. conceptual level
Correct Option: b
104. Schema is usually stored in
a. none of these
b. data Dictionary
c. both
d. tables
Correct Option: b
105. schema is defined by :
a. DDL
b. DML
c. DCL
d. DQL
Correct Option: a
106. DML language is used to :
a. Access Data
b. define schema
c. all of these
d. define internal level
Correct Option: a
107. Which is the most popular data base model:
a. relational model
b. netwrok model
c. hierarchical model
d. object oriented
Correct Option: a
108. An entity records are called:
a. Attributes
b. Tuples
c. Entity
d. relational
Correct Option: b
109. A database application can perfrom which of the following activities?
a. add records
b. update records
c. read records
d. All of above
Correct Option: d
110. Which of the following types of database are the most common?
a. enterprise
b. workgroup
c. personal
d. department
Correct Option: d
111. A many to many relationship between two entities usually result in how many tables?
a. four
b. Three
c. one
d. two
Correct Option: b
112. Which of the following can be multivated attribute?
a. date- of-birth
b. al of the mentioned
c. phone _num
d. name
Correct Option: c
113. If an SDT uses only synthesized attributesit is called as?
a. S_attributes
b. R_attributes
c. T_attributes
d. A_attributes
Correct Option: a
114. The database desgin prevents some data from being stored due to__________.
a. update anomalies
b. selection anomalies
c. insertion anomalies
d. deletion anomalies
Correct Option: c
115. ______________ is the structure of the database.
a. none of these
b. schema
c. table
d. relation
Correct Option: b
116. DBMS is the bridge between operating system and _________.
a. user
b. database administator
c. Application program
d. none of these
Correct Option: c
117. A table is a synonymous with the terms:
a. Rows
b. records
c. column
d. attributes
Correct Option: a
118. Which of the following is a group of one or more attributes that uniquely identifies a row?
a. tuple
b. relation
c. key
d. determine
Correct Option: c
119. The information stored in the information repository can be accessed by
a. security managers
b. database administrators
c. client servers
d. host comuter
Correct Option: b
120. DCL stands for
a. data console level
b. data control language
c. data console language
d. data control level
Correct Option: b
121. ……….. Database is used as template for all database created.
a. temp DB
b. none of above
c. master
d. model
Correct Option: c
122. Which of the following is/are the DDL statements?
a. create
b. Drop
c. Alter
d. All of above
Correct Option: d
123. A share collection of logically related data.
a. Records
b. database
c. mark sheet
d. result
Correct Option: a
124. The description of the data is knows as.
a. teach
b. System catalog
c. file
d. dictionary
Correct Option: b
125. Which of the following is a physical storage media?
a. Aand B
b. RAM
c. optical storage
d. tape storage
Correct Option: a
126. Data about data is called
a. data blank
b. C both a
c. none of above
d. E meta data
Correct Option: d
127. Select the example of the netwrok database
a. none of above
b. IDBMS
c. ingress
d. unity
Correct Option: b
128. SET concept used in _________?
a. both a and b
b. none of above
c. netwrok model
d. relational model
Correct Option: c
129. Group of information stored in a database at a specific moment is
a. view
b. none of these
c. instance
d. schema
Correct Option: c
130. The user querry syantax is varified by
a. DBMS
b. none of above
c. Parser
d. DBA
Correct Option: c
131. In the hierarchical database a hashing function is used for location?
a. Root
b. primery key
c. collisions
d. duplicate records
Correct Option: a
132. The data model which describes how the data is actually stored is:
a. Logical model
b. None of these
c. Internal model
d. External model
Correct Option: c
133. The users who use easy-to-use menu are called:
a. Stand-alone users
b. Casual end users
c. Naïve users
d. Sophisticated end users
Correct Option: c
134. Data about data is normally termed as:
a. Data Bank
b. None of these
c. Meta Data
d. Directory
Correct Option: c
135. In E-R diagram generalization is represented by:
a. Rectangle
b. Triangle
c. Ellipse
d. Dashed Ellipse
Correct Option: b
136. The method of access which uses key transformation is known as
a. Sequential
b. Hash
c. Direct
d. Random
Correct Option: b
137. A table joined with itself is called:
a. Equi Join
b. Self join
c. Join
d. Outer join
Correct Option: b
138. Which one is an example for network database?
a. None of these
b. IDBMS
c. Unify
d. Ingress
Correct Option: b
139. Relational calculus is a
a. Data definition language
b. High-level language
c. Non-Procedural language
d. Procedural language
Correct Option: c
140. ODBC stand for:
a. Oral Databse Connectivity
b. Object Databse Connectivity
c. Open Database Connectivity
d. Oracle Database Connectivity
Correct Option: c
141. The daatabase schema is written in:
a. DDL
b. DCL
c. DML
d. HLL
Correct Option: a
142. In Hierarchical model records are organised as:
a. Graph
b. Tree
c. Links
d. List
Correct Option: b
143. Related fields in a database are grouped to form a
a. Bank
b. Data record
c. Data file
d. Menu
Correct Option: b
144. A report genertor is used to
a. Print files on paper
b. Update files
c. Data entry
d. Delete files
Correct Option: a
145. Key to represent the relationship between tables is called
a. None of these
b. Foreign key
c. Primary key
d. Secondary key
Correct Option: b
146. Which of the following are the properties of entities?
a. Table
b. Groups
c. Attributes
d. Switchboards
Correct Option: c
147. The RDBMS terminology for row is
a. Degree
b. Tuple
c. Relation
d. Attribute
Correct Option: b
148. Which database level is closest to the users?
a. Internal
b. Physical
c. Conceptual
d. External
Correct Option: d
149. A set of possible data values is called
a. Tuple
b. Degree
c. Attribute
d. Domain
Correct Option: d
150. In E-R diagram derived attribute is represented by:
a. Rectangle
b. Triangle
c. Dashed ellipse
d. Ellipse
Correct Option: c
151. In E-R diagram relationship type is represented by:
a. Recatangle
b. Dashed Ellipse
c. Ellipse
d. Diamond
Correct Option: d
152. _____ operator is used for appending two strings.
a. ||
b. _
c. %
d. &
Correct Option: a
153. Cross Product is a:
a. Ternary Operator
b. Not an operator
c. Binary Operator
d. Unary Operator
Correct Option: c
154. Which of the following database object does not physically exist?
a. None of these
b. View
c. Index
d. Base table
Correct Option: b
155. Which of the following is not a database object?
a. Relationships
b. Queries
c. Tables
d. Repors
Correct Option: a
156. The overall description of a database of a database is called ___
a. Database Schema
b. Data integrity
c. Data manipulation
d. Data Definition
Correct Option: a
157. A data dictionary is a repository that manages ___
a. Spell Checker
b. Data Validator
c. Meta Data
d. Memory
Correct Option: c
158. In the relational modes, cardinality is termed as:
a. Number of tables
b. Number of constraints
c. Number of tuples
d. Number of attributes
Correct Option: c
159. Architecture of the database can be viewed as:
a. Four levels
b. Three levels
c. one level
d. Two levels
Correct Option: b
160. In a relational model, relations are termed as:
a. Attribute
b. Tables
c. Rows
d. Tuples
Correct Option: b
161. Duplicate data is referred to as:
a. Redundant Data
b. Accurate data
c. Storage data
d. None of these
Correct Option: a
162. What are the different view to present a Table ?
a. Datasheet view
b. Design view
c. Pivot table view
d. All of these
Correct Option: d
163. In one-to-many relationship the table on ‘many’ side is called _______
a. Sister
b. Master
c. Child
d. Parent
Correct Option: c
164. In one-to-many relationship the table in ‘one’ side is called _______
a. Owner
b. Master
c. Parent
d. Child
Correct Option: c
165. Which data type allows alphanumeric characters and special symbols to be entered?
a. Mixed
b. Text
c. Memo
d. Auto number
Correct Option: b
166. It is used to establish an association between related tables.
a. Relationship
b. Line
c. Primary key
d. Records
Correct Option: a
167. This key that uniquely identifies each record is called :
a. Unique key
b. Field Name
c. Primary key
d. Key Record
Correct Option: c
168. Which name must be unique within a database ?
a. Character
b. Table
c. Field
d. Record
Correct Option: b
169. The third stage of designing a database is when we create___________ between tables
a. Relaionship
b. Join
c. Query
d. None of these
Correct Option: a
170. Which of the following fields has width of 8 bytes?
a. Date/Time
b. Memo
c. Number
d. Hyperlink
Correct Option: a
171. In a database Table, the each category of information Is called __________
a. All of the above
b. Field
c. Tuple
d. Record
Correct Option: b
172. Manipulation of data to achieve the required objectives and result is called
a. data processing
b. none
c. both a and b
d. operation
Correct Option: c
173. A logical grouping of characters is a.
a. all
b. field
c. file
d. record
Correct Option: b
174. DBMS is a set of _____ to access the data.
a. programs
b. information
c. codes
d. metadata
Correct Option: a
175. DBMS provides a convenient and efficient environment.
a. TRUE
b. FALSE
c.
d.
Correct Option: a
176. which of the following is not a level of abstraction.
a. view
b. user
c. physical
d. logical
Correct Option: b
177. A level that describes how a record is stored.
a. user
b. view
c. physical
d. logical
Correct Option: c
178. A logical structure of the database.
a. instance
b. schema
c. attribute
d. parameter
Correct Option: b
179. which of the following is not an object based logical model.
a. semantic
b. functional
c. Network
d. ER
Correct Option: c
180. SQL is ________.
a. Relational
b. network
c. IMS
d. hierarchical
Correct Option: a
181. The parts of an operation or function must includes
a. implementation
b. interface
c. both a and b
d. storage capacity
Correct Option: c
182. The implications of database management approaches includes
a. flexibility
b. economies of scale
c. reduce development time
d. all of these
Correct Option: d
183. The files used for speedy disk search by providing the specialized structure of data are classified as.
a.
b. indexes
c. glossaries
d. content specification
Correct Option: b
184. In database management system the types of data structure used in indexes
a. tree data structure
b. content and glossary structure
c. both a and b
d. hash data structure
Correct Option: c
185. The description of structure and organization of data in a database is contained in.
a. none
b. Data dictionary
c. Data mine
d. structure query language
Correct Option: b
186. Database application contains procedure for .
a. adding records
b. deleting records
c. processing queries
d. All
Correct Option: d
187. Data that cause inconsistency lacks.
a. data anomaly
b. Data integrity
c. Good data
d. data redundancy
Correct Option: b
188. The process of converting the requests into results between three-schema architecture internal, external and conceptual levels is called.
a. transforming
b. dependence
c. mapping
d. pitching
Correct Option: c
189. The levels in which the three schema architecture can be defined includes.
a. conceptual schema
b. external schema
c. internal schema
d. all of above
Correct Option: d
190. The capacity to alter the database schema at one level without altering any other schema level is classified as .
a. data transformation
b. Data independence
c. data maping
d. data dependence
Correct Option: b
191. which of the following is not a level of data abstraction.
a. logical level
b. view level
c. critical level
d. physical level
Correct Option: c
192. which of the following is not a schema.
a. physical schema
b. logical schema
c. critical schema
d. database schema
Correct Option: c
193. which of the following is a data Model ?
a. entity relationship model
b. object based data model
c. relational data model
d. All of above
Correct Option: d
194. Logical design of database is called.
a. Database schema
b. database instence
c. database snapshot
d. all of above
Correct Option: a
195. which of the following is the structure of the database.
a. none of these
b. schema
c. table
d. relation
Correct Option: b
196. _______ is a classical approch to database design..
a. botto-up approch-
b. top-down approch
c. left-right approch
d. righ-left approch-
Correct Option: b
197. A disadvantage of partitioning is .
a. none
b. extra space and update time
c. simplicity
d. both a and b
Correct Option: b
198. DBA stands for
a. database application
b. Database administrator
c. data basic administrator
d. database authority
Correct Option: b
199. The relationship can be .
a. one to one
b. one to many
c. many to many
d. All
Correct Option: d
200. Entities can be associated with one another in which of the following.
a. relationship
b. entity
c. attribute
d. identifier
Correct Option: a
201. Which of the following represents the entities.
a. teacher
b. student
c. aero plan
d. All
Correct Option: d
202. In ER diagram rectangle represents
a. weak entity
b. relationship
c. attribute
d. entity class
Correct Option: d
203. A relationship is an associated between
a. objects
b. databases
c. fields
d. Entities
Correct Option: d
204. Attribute may share a .
a. name
b. location
c. table
d. Domain
Correct Option: d
205. which type of attribute is used to identify a set of instances of a given entity
a. instance
b. none
c. Non- unique
d. unique
Correct Option: c
206. A _____ attribute need not be physically stored within the database.
a. composite
b. multivated
c. single-valued
d. Derived
Correct Option: d
207. A ____ relationship exists when three entities are associated.
a. weak
b. Ternary
c. unary
d. binary
Correct Option: b
208. The columns of a table correspond to.
a. cell
b. field
c. table
d. record
Correct Option: b
209. The foreign key is found in.
a. pivot table
b. index table
c. parent table
d. dependent table
Correct Option: d
210. A relation is analogous to a
a. row
b. File
c. field
d. record
Correct Option: b
211. A relation is also known as
a. attribute
b. table
c. tuple
d. relationship
Correct Option: b
212. Which one of the following refers to “data about data”?
a. Directory
b. Sub Data
c. Meta Data
d. Warehouse
Correct Option: c
213. To which of the following the “DBA” reffered?
a. None of these
b. Database Administrator
c. Data bank Administrator
d. Data Administrator
Correct Option: b
214. In general, a file is basically a collection of all related
a. Records
b. Database
c. Fields
d. Row&Column
Correct Option: a
215. Row of a relation are known as
a. Entity
b. Tuple
c. Degree
d. All of the above
Correct Option: d
216. Which one of the following refers to the number of tuple in relation?
a. Entity
b. None of these
c. Cardinality
d. Column
Correct Option: c
217. Which of the following is a type of Data manipulation command
a. Delete
b. Alter
c. Create
d. All of the above
Correct Option: a
218. Which of the following refers to the number of attributes in a relation
a. Degree
b. Column
c. Row
d. All of the above
Correct Option: a
219. The magor component of Data base management system is called
a. Database manager
b. File manager
c. Data manager
d. All of the above
Correct Option: a
220. A database is an organized collection of____ related data
a. Loosely
b. Badly
c. Logically
d. Physically
Correct Option: c
221. How many components of a database environment?
a. 8
b. 7
c. 5
d. 4
Correct Option: a
222. The architecture of database can be viewed as the ____
a. Four level
b. Three level
c. One level
d. Two level
Correct Option: b
223. In a relational model, a the relation is generally termed as ____
a. Row
b. Table
c. Tuples
d. Attributes
Correct Option: b
224. Which one of the following refers to the level of data abstractions that describes exactly how the data actually stored
a. File level
b. Logical level
c. Physical level
d. Conceptual level
Correct Option: c
225. In a relational model, cardinality is termed as:
a. A number of tuple
b. A number of attributes
c. A number of table
d. A number of constrains
Correct Option: a
226. The database schema is written in
a. DDL
b. DML
c. HLL
d. DCL
Correct Option: a
227. In the architecture of database system external level is the
a. Physical level
b. view level
c. Conceptual level
d. Logical level
Correct Option: b
228. A subschema expresses
a. All of the above
b. External view
c. Physical view
d. Logical level
Correct Option: b
229. Set concept is used in:
a. Relational model
b. None of these
c. Network model
d. Hierarchical model
Correct Option: c
230. An advantage of partitioning is
a. Extra space
b. Both
c. None of these
d. Efficiency
Correct Option: d
231. In E-R diagram derived attributes are represented by
a. Triangle
b. Ellipse
c. Dashed ellipse
d. Rectangle
Correct Option: c
232. In an E-R model relationship is represented by
a. Rectangle
b. Ellipse
c. Dashed Ellipse
d. Diamond
Correct Option: d
233. In one-to-one relationship the table on”many” side is called
a. Parent
b. Sister
c. Child
d. Master
Correct Option: c
234. Entity is a_____
a. Object of relation
b. Thing in real world
c. Object of realtion
d. Model of realtion
Correct Option: b
235. Not applicable condition can be represented in relationentry as
a. Na
b. Blank space
c. Null
d. 0
Correct Option: c
236. In one-to-many relationship thr table in “one” side is called
a. Owner
b. None of these
c. Parent
d. Child
Correct Option: c
237. How many types of entities
a. 3
b. 2
c. 9
d. 7
Correct Option: a
238. Which one of the following is related to modality
a. Mandatory
b. Unidirectional
c. Both A and B
d. Optional
Correct Option: c
239. Attributes may share a
a. Name
b. Location
c. Table
d. Domain
Correct Option: d
240. A relationship ias an association between ____
a. Object
b. Database
c. Field
d. Entities
Correct Option: d
241. How many types of database language
a. 2
b. 3
c. 6
d. 8
Correct Option: a
242. A table must have
a. sort key
b. Conposite key
c. Primary key
d. Secondary key
Correct Option: c
243. Which one of the following key is generally used to represent relationship between the table?
a. Sort key
b. Forign key
c. Primary key
d. Secondary key
Correct Option: b
244. The union of primary key of the related entity set becomes a _____ of the relation.
a. composite key
b. Super key
c. Candidate key
d. Primary key
Correct Option: b
245. A report generator is used to
a. Print files on paper
b. Data entry
c. Delete file
d. Update file
Correct Option: a
246. Two table can be linked with relationship to _____
a. EnsureData entry
b. Create primary key
c. Ensure forign key
d. Ensure data integrity
Correct Option: d
247. Anomalies imply additional work to be done for:
a. Insertion into relation
b. Modifications of a relation
c. Loss of information due to deletion
d. All of the above
Correct Option: d
248. In ___ normal form, any multi- valued attribute have been removed
a. Fourth
b. First
c. Second
d. Third
Correct Option: b
249. A candidate key is a ____ key that contain no extra attributes
a. Primary
b. Super
c. Forign
d. Secondary
Correct Option: b
250. Relation is also derived from
a. None of these
b. Set theory
c. Table
d. Row
Correct Option: b
251. Dta is a type of attribute:
a. single values
b. multivalues
c. composite
d. simple
Correct Option: c
252. An entity has a set of _________ that describe it .
a. tuples
b. relation
c. Attribute
d. entity
Correct Option: c
253. The database approach requires additional costs and risks.
a.
b. TRUE
c. FALSE
d.
Correct Option: b