DATABASE Systems MCQS

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