2ND PUC COMPUTER SCIENCE MCQs

CHAPTER-13: DATABASE CONCEPTS

Answer all the questions. Each question carries one mark. I Select the correct answer
from the choices given: (Repeated answers will not be considered)

112. Which of the following Application of database ?

a) Telecommunication b) Finance c) banking d) All of these.
113. is a collection of related information.
a) Information b) database c) Relation d) Tuple
114. is a set of values for an attribute in that column
a) Domain b) database c) Relation d) Tuple
115. Collection of record is called as a .
a) Record b) domain c) column d) table.
116.A software package used to manage the databases and run operations in the data is
known as
a) Database management system. b) Structured Query Language
c) Information management d) All of these
117. An in DBMS is a real-world thing or a real-world object which is
distinguishable from other objects in the real world.
a) Attribute b) Entity c) Domain d) Weak entity
118. is a set of data values that are given to an entity.
a) Attribute b) Entity c) Domain d) Instance
119. An is a characteristic which represents the entity.

a) Attribute b) Entity c) Domain d) Instance

120.A row of a table that represents a complete information about a particular entity is

called as a

a) Record b) table c) row d) column

121. Which of the following not belongs to datatypes of DBMS?

a) Integer b) String c) Date d) primary key

122. The RDBMS terminology for a row is

a) Tuple b) relation c) attribute d) degree

123. Which of the following is a valid SQL type?

a) CHARACTER b) NUMERIC c) FLOAT d) All of the above

2ND PUC COMPUTER SCIENCE MCQs
124. is a repository of an organization’s electronically stored data.
a) Data ware house b) Reporting
c) Data mining d) Metadata
125. are components of data ware house.
a) Data ware house & reporting b) Reporting & Metadata
c) Data mining & Metadata d) none of these
126. is concerned with the analysis and picking out relevant information.
a) Data ware house b) Reporting
c) Data mining d) Metadata
127. SQL stands for .
a) Structured Query language b) Procedural Language
c) Theoretical Language d) Unstructured Language
128. SQL statements should be terminated by a .
a) Semicolon b) comma c) dot d) quotes

129. DDL stands for

a) Data duality Language b) Data Definition Language
c) Data Definition Level d) Dual Data Language
130. command used crate a new table.
a) ALTER b) CREATE c) DROP d) INSERT
131. command modifies an existing table.
a) ALTER b) CREATE c) DROP d) INSERT
132. command is used to delete table in SQL.
a) ALTER b) CREATE c) DROP d) DELETE
133. Stands for Data Manipulation Language.
a) Data duality Language b) Data Definition Language
c) Data Manipulation Language d) Dual Data Language
134. command will create a record.
ALTER b) CREATE c) DROP d) INSERT

135. command modifies the existing rows (records) in a table.

a) ALTER b) UPDATE c) DROP d) INSERT
136. command rows (records) from a table from the database.
a) DELETE b) CREATE c) DROP d) INSERT

137. SELECT command is used for querying or retrieving data from a table in the
database.
ALTER b) CREATE c) DROP d) INSERT
2ND PUC COMPUTER SCIENCE MCQs

138. DCL Stands for .

a) Data duality Language b) Data Definition Language
c) Data Manipulation Language d) Data Control Language
139. What is the purpose of GRANT command in SQL?

a) Take back privileges granted from the user b) Gives a privileges to user.

c) Take back and delete from the user d) All of the above

140. takes back privileges granted from user.

a) GRANT b) REVOKE c) ROLLBACK d) COMMIT

141. TCL stands for.
a) Transaction Control Language b) Data Definition Language
c) Data Manipulation Language d) Data Control Language
142. makes all the changes made by statements issued permanent.

a) GRANT b) REVOKE c) ROLLBACK d) COMMIT

143. Undoes all changes since the beginning of a transaction or since a

save point.
a) GRANT b) REVOKE c) ROLLBACK d) COMMIT

144. The which constraints not available in SQL?

a) Primary Key b) Foreign key,
c) Not NULL d) Condition key

145. constraints define a column or combination of columns which uniquely

identifies each row in the table.
a) Primary Key b) Foreign key,
c) Not NULL d) Check
146. constraints identify any column referencing the Primary Key in
another table.
a) Primary Key b) Foreign key,
c) Not NULL d) Check
147. Constraints ensures all rows in the table contain a definite value for the
column which is specified as Not Null.
a) Primary Key b) Foreign key,
c) Not NULL d) Check
2ND PUC COMPUTER SCIENCE MCQs
148. constraints ensure that a column or a group of columns in each row have a
distinct value.
a) Primary Key b) Foreign Key, c) Not NULL d) Unique Key
149. constraints define a business rule on a column. All the rows must satisfy
this rule.
a) Primary Key b) Foreign Key, c) Check d) Unique Key
150. The operator is used to checks the membership condition specified by the
list of values.
a) BETWEEN b) IN c) NOT d) AND
151. operator is used to output data which lies in a range of values.

a) BETWEEN b) IN c) NOT d) AND

152. are the logical operators of SQL.

a) OR b) AND c) NOT d) All of the above

153. SQL Supports comparison operators are

a) =, >, <, >=, <=, <> or != or ^= b) BETWEEN, IN, NOT, AND

c)&, *, #, @, !, ~ d) None of the above

154. RDBMS stands for
a) Relational Data Mankind System b) Relation Data Manipulation System
c)Relational Database Management System d) Rotation Database Management System.
155. SQL Group Functions are
a) ADD, DIV, SUB, MULT STA, HALT
b) AVG, MIN, MAX, SUM and COUNT etc.
c) BETWEEN, IN NOT AND, STA
d) SELECT, INSERT, UPDATE, DELETE, DROP
156. is dummy table containing a single row and single column provided by SQL.
a) DOUBLE b) SINGLE c) DUAL d) DOW

112 113 114 115 116 117 118 119 120 121

d b a d a b d a a d

122 123 124 125 126 127 128 129 130 131

a d a b c a a b b a

132 133 134 135 136 137 138 139 140 141

d c d b a d b b a

142 143 144 145 146 147 148 149 150 151

d c d a b c d c a b
2ND PUC COMPUTER SCIENCE MCQs

Fill in the blanks choosing the appropriate word/words from those given in
brackets. (Repeated answers will not be considered)
(Security, Redundancy, DBMS, Database, Table)

157. Collection of rows and columns is called as

158. is a collection of interrelated data?

159. Data duplication is called as .

160. is a software for creating and managing databases?

161. Protection of data is the .

Fill in the blanks choosing the appropriate word/words from those given in
brackets. (Repeated answers will not be considered)
(Data Abstraction, Internal level, Physical level, Conceptual level, view level.)

162. The process of hiding irrelevant details from user is called .

163. is the lower level of data abstraction.
164. Internal level is also known as .
165. of abstraction deals with logical structure of the entire database.
166. The highest level of abstraction that deals with the user’s view of the database is

called .

Fill in the blanks choosing the appropriate word/words from those given in
brackets. (Repeated answers will not be considered)

(Tuple, Rectangle, MySQL, ISAM, Schema)

167. The structure of database is called as .
168. _is the symbol used to represent entity?
169. Row of a table is also called as .
170. Software for creating and managing databases?
171. is a combination of serial and random file organization?
2ND PUC COMPUTER SCIENCE MCQs

Fill in the blanks choosing the appropriate word/words from those given in
brackets. (Repeated answers will not be considered)

(View, Diamond, Oracle, Data mining, DBA)

172. level is also called as external level in data abstraction.

173. is the symbol used to represent relationship in E-R diagram?

174. Person who have the authorization to access, monitor data base is

175. is a software for creating and managing databases?

176. Extracting and discovery of knowledge from large amount of data is called ___ _

Fill in the blanks choosing the appropriate word/words from those given in
brackets. (Repeated answers will not be considered)

(E.F Codd, Hashing, Candidate, Data warehousing, Instances)

177. keys are the keys which are not currently selected as primary key.

178. is the repository of organizations electronically stored data?

179. Father of relational algebra is .

180. is set of values in each row.

181. Algorithm used in random or direct access file organization is .

Fill in the blanks choosing the appropriate word/words from those given in
brackets. (Repeated answers will not be considered)

(Attributes, Data security, Information, Data model, End users)

[Link] model that describes how data is represented and used is
183. describes the characteristics of an entity.
184. The processed for of data is
185. _are the people who access the database for querying, updating, generating
repots.
186. is an example for advantages of DBMS.
2ND PUC COMPUTER SCIENCE MCQs

Fill in the blanks choosing the appropriate word/words from those given in
brackets. (Repeated answers will not be considered)

(Alternate key, Data Model, Foreign key, staging, domain)

187. Key which is not selected as primary key is

188. key combines two database tables.

189. Set of values for an attribute in each column is

190. _describes how data is represented and used.

191. Process of cleaning, standardized and loading data in data warehouse is called _
Fill in the blanks choosing the appropriate word/words from those given in
brackets. (Repeated answers will not be considered)

(one-tier, Data independence, serial file organization, tuple, Attribute)

192. Each column is identified by distinct header called

193. is the architecture where users directly sit on DBMS and uses it.

194. Each row in a table is called

195. stores data in serial order in the database.

196. Ability database to modify schema at one level without affecting it on another level
is
Fill in the blanks choosing the appropriate word/words from those given in
brackets. (Repeated answers will not be considered)

(Tree, domain, DBMS, entity, Database)

197. Set of values for an attribute in each column is

198. is an application software used for creating, updating, managing

database?

199. Hierarchical model follows structure.

200. is a collection of logically related data?

201. is an object like table?

2ND PUC COMPUTER SCIENCE MCQs

Fill in the blanks choosing the appropriate word/words from those given in
brackets. (Repeated answers will not be considered)

(one-tier, Data independence, serial file organization, network model, Attribute)

202. Each column is identified by distinct header called

203. is a data model that follows graph structure.

204. Each row in a table is called

205. _stores data in serial order in the database.

206. Ability database to modify schema at one level without affecting it on another level
is _

Fill in the blanks choosing the appropriate word/words from those given in

brackets. (Repeated answers will not be considered)

(Hierarchical model, Number, random file organization, tuple, G-sat)

207. is an example for data mining software?

208. _is a data model that follows tree structure?

209. Each row in a table is called .

210. stores data in random order in the database.

211. An example for data types used is DBMS is .