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
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