NotesMCQS

Computer DataBase Management System Mcqs | BS Computer MCQS

101. Which of the following is not a benefit of normalization?

a. Minimize insertion anomalies

b. Minimize deletion anomalies

c. Minimize updation anomalies

d. Maximize redundancy

102. A collection of concepts that can be used to describe the structure of a database

a. Database 

A
 

b. DBMS 

c. Data model 

d. Data

103. Which of the following concepts is applicable with respect to 2NF?

a. Full functional dependency 

b. Any kind of dependency

c. Transitive dependency

d. Non-transitive dependency

104. User rights information is stored in

a. Physical database 

b. Catalog 

c. Logical database 

d. Buffer

105. A description on a particular collection of data using the given data model

a. Database 

b. Schema 

c. None of the above. 

d. Relation

106. If K is a foreign key in relation R1, then

a. every tuple of R1 has a distinct value for K.

b. K cannot have a null value for tuples in R1.

c. K is a key for some other relation

d. K is a primary key for R1.

107. The ER- data model is an example of:

a. Physical database 

b. Logical database 

c. Relational 

d. Conceptual database

108. In a conceptual database model, which of the following most likely represents a valid 

identifier for a class grades?

a. StudentID 

b. StudentID, CourseID 

c. StudentID, CourseI D, Instructor

d. StudentID, CourseSectionID

109. A ______ is used to maintain a connection between the users of the database system

a. Mail server

b. File Server

c. Client-server

d. None of the given.

110. Consider two sets A and B. A contains 2 elements and B contains 3. How many elements do their

Cartesian product contains?

a. 6 b. 4 c. 5 d. 10

111. UPDATE command belongs to which type of Classification

a. DML b. DDL c. DCL d. DQL

112. The _________ function helps reduce the need to use multiple OR conditions

a. Like b. IN c. AND d. Between

113. Which of the flowing clauses allows to sort the records in result set?

a. Where b. From c. Order By d. Having

114. In SQL queries, while creating tables or relations in database, key columns may be specified by

a. Null 

b. Not Null 

c. Data Type 

d. None of the above

115. Identify the language which is used to specify database schema.

a. DCL 

b. DML 

c. DDL 

d. None of the above

116. What happened if the Where clause is omitted from a Delete Statement?

a. All record from the table are deleted

b. No record from the tables will be deleted

c. First record of the tables will be deleted

d. The statement will not be executed and will give a syntax error

117. Which of the following is a String function in SQL

a. Count b. LEN c. SQRT d. SIN

118. Revoke is a __________ Statement

a. Data Definition 

b. Control Access 

c. Data Manipulation 

d. Data Description

119. Truncate command response time is ____ as compared to Delete command.

a. Poor b. Same c. Better d. worst

120. Which of the following is used to filter rows according to some condition(s)?

a. SELECT 

b. FROM 

c. WHERE 

d. UPDATE

121. Which language is used to permit or prohibit access to a table?

a. DCL b. DDL c. DML d. All of the above.

122. Data Manipulation Language (DML) is the set of commands used to maintain and query a database including updating, inserting, modifying and retrieving data.

a. True 

b. FALSE

123. Which of the following is NOT a DDL command?

a. Create DB 

b. Create table 

c. Delete 

d. Drop

124. Which of the following function falls in the category of Aggregate functions

a. SUM b. MIN c. MAX d. All of the above

125. Value of a function in SQL is always determined by the input parameters

a. TRUE 

b. FALSE

126. Identify the basic part(s) of a SELECT statement?

a. SELECT 

b. FROM 

c. Both SELECT and FROM 

d. DISTINCT

127. GRANT is a ______________ Command

a. DDL 

b. DML 

c. DCL 

d. None of the above

128. Objective of an order by clause is to display or arrange output of a select statement in 

a particular order.

a. True 

b. False

129. A __________ is established when the value of one attribute is dependent on the value of another attribute

a. primary key 

b. data anomaly 

c. dependency 

d. transitive relationship

130. Data redundancies produce unusual and undesirable data management problems caused by __________.

a. transitive requirements 

b. dependencies 

c. normalization 

d. data anomalies

131. Metadata provide the description of the data characteristics but do not describe the set relationships that link the data found within the database

a. True 

b. False

132. A database that is primarily designed to support a company’s day-to-day operations is called a data warehouse.

a. True 

b. False

133. A record is a logically connected set of one or more fields that describes a person, 

place, or thing.

a. True 

b. False

134. The final outcome of a natural JOIN operation yields a table that does not include the 

unmatched row

a. True 

b. False

135. In a relational table, each column represents an attribute and each column has a 

distinctive name.

a. True 

b. False

136. In a relational table, each value in a column must conform to the same data format

a. True 

b. False

137. A key consists of one or more attributes that determine other attributes

a. True 

b. False

138. A primary key can be defined as a superkey with redundancies.

a. True 

b. False

139. To maintain entity integrity, a null value is permitted in the primary key

b. True

b. False

140. A ____ system is composed of software, hardware, procedures, and people.

a. Software b. computer c. file d. database

141. ____ are the people who run the organization’s daily operations.

a. End users 

b. Managers 

c. Database programmers 

d. Data practitioners

142. A telephone number, a birth date, and a customer name are all examples of:

a. Data b. Record c. File d. Database

143. A logically connected set of one or more fields that describes a person, place, or thing is a(n):

a. Data b. A record c. File d. Database

144. Metadata is:

a. raw facts 

b. data about data 

c. user created data 

d. warehoused data

145. A relational database is a group of ____.

a. common fields

b. field values 

c. records 

d. tables

146. Each row in the relational table is known as an entity ____.

a. Instance 

b. relationship 

c. attribute 

d. model

147. Which model represents the end user’s view of the database?

a. Internal 

b. Conceptual 

c. Physical 

d. External

148. Which model operates at the lowest level of abstraction?

a. Conceptual 

b. Internal 

c. External 

d. Physical

149. What type of relationship is expressed with the phrase “Painter paints Painting”?

a. 1:M b. 1:1 c. M:1 d. M:N

150. What type of relationship is expressed with the phrase “Employee manages Store”?

a. 1:M b. 1:1 c. M:1 d. M:N

See also  Physics Notes for Class 11 PDF free download
 
Previous page 1 2 3

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button