Top 1000+ Database Subject Mcqs Pdf Download Set No 04

written by Assad Javaid | May 25, 2021

151.Select the correct statement among the following on proper naming of schema constructs

  1. Entity type name applies to all the entities belonging to that entity type and therefore a plural name is selected for entity type.
  2. In the narrative description of the database requirements, verbs tend to indicate the names of
  3. relationship types.        
  4. The  nouns  arising  from a  database  requirement  description  can  be considered as names of attributes.
  5. Additional nouns which are appearing in the narrative description of the database
  6. requirements represent the weak entity type names.  

152.Identify the constraint that limits the values that can be placed in a column.

  1. Not null
  2. Check                   
  3. Foreign Key
  4. Unique                

153.which has conceptual existence like a course in a degree program as an entity?          

  1. Age can be considered as a single value attribute of a person.
  2. An entity type describes the schema or intension for a set of entities
  3. share the same structure.       
  1.                     

154. If W, X, Y and Z are attributes of a relation, which of the following inference rules for functional  Which is correct? Select correct option                

  1. One process at least                      
  2. Two processes at least                 
  3. One process only
  4. Any number of processes

156.A ______ is used to maintain a connection between the users of the database system. Select correct option

  1. Mail server
  2. File Server         
  3. Client-server
  4. None of the given.

157.Which of the following is NOT a component of a DFD?

  1. Dataflow
  2. Data store
  3. External entities
  4. Relationship between external entities

158.Which of the following is correct regarding Dataflow diagram?

  1. Single DFD is required to represent a system
  2. The dataflow must be bidirectional
  3. Created at increasing levels
  4. Used to represent the relationships among the external entities

159.Which of the following is CORRECT about database management system’s languages?

  1. Data definition languages are used to specify the conceptual schema only.  Data manipulation languages are used to create the databases.
  2. Data manipulation languages are used for retrieval, insertion, deletion and modification of data.
  3. Data definition languages are only used to update data in the DBMS.

160.Which of the following concepts is applicable with respect to 3NF?

  1. Full functional dependency
  2. Any kind of dependency
  3. Transitive dependency  
  4. Partial functional dependency

 161.Consider two sets A and B. A contains 3 elements and B contains 4. How many elements do their Cartesian product contains?

  1. 12          
  2. 9
  3. 16
  4. 7               
  1.               

162.Consider two sets A and B. A contains 2 elements and B contains 3. How many elements do their Cartesian product contains?

  1. 6     
  2. 9
  3. 4.5

163.Which of the following is not true about relational tables?

  1. Column values are of the same kind.
  2. Each row is unique.
  3. Each column must have a unique name.
  4. The sequence of rows is significant.     
  1.   

164.Identify the operation which is NOT one of the parts of the five basic set operations in relational algebra?

  1. Join        
  2. Union
  3. Cartesian Product
  4. Set Difference  

165.Consider the following statements.

  1. An entity integrity constraint states that no primary key value can be null.
  2.  A referential integrity constraint is specified between two relations.
  3. C.A foreign key cannot be used to refer

Identify which of the above statements is/are correct.

  1. Only A  
  2. Only B
  3. Only B and C
  4. Only A and B

166.If K is a foreign key in relation R1, then  every  tuple of R1 has a distinct value for K. 

  1. K cannot have a null value for tuples in R1.
  2. K is a  key for some other relation.        
  3. K is a primary key for R1.

167.Identify  the  operation  which  is  NOT  one  of  the  parts  of  the  five  basic  set operations in relational algebra?

  1. Ź Join
  2. Ź Union
  3. Ź Cartesian Product
  4. Ź Set Difference

168.An entity integrity constraint states that no primary key value can be null.

A referential integrity constraint is specified between two relations.

A foreign key cannot be used to refer to its own relation.

Identify which of the above statements is/are correct.

  1. Only A
  2. Only B
  3. Only B and C 
  4. Only A and B

169.Name three kind of basic binary operation on relational algebra

  1. Union
  2. Set operation
  3. Cartesian product

170. Data type

  1. Data type is defined as a set of values along with the operations 
  2. Some common data types are Integer, Float, Variable char, Char,
  3. all

171.What is the importance of minimum cardinality in relation while designing the database.

  1. Minimum Cardinality
  2. T/F
  3. T

172.Shortly describe Procedural DML and Non procedural DML

  1. Procedural Languages
  2. Non -Procedural Languages
  3. Structured query language (SQL)
  4. all

173. Each table must have a ____ key

Select correct option

  1. primary
  2. secondary
  3. logical
  4. foreign

174. 1 In a three-level DBMS architecture, the ______ level interacts directly with the users .

Select correct option

  1. external
  2. conceptual
  3. internal
  4. physical

175 .A collection of concepts that can be used to describe the structure of a database Select correct option

  1. Database
  2. DBMS
  3. Data model
  4. Data

176 .Which of the following constraints enforces entity integrity? Select correct option

  1. PRIMARY KEY
  2. FOREIGN KEY
  3. CHECK
  4. NOT NULL 

177.Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss ?

Select correct option

  1. User accessible
  2.  Catalog
  3.  Data processing
  4. Recovery service  

178.Which of the following is NOT a component of a DFD? Select correct option

  1. Dataflow
  2. Data store
  3. External entities
  4. Relationship between external entities

 179Data inconsistency leads to a number of problems such as Select correct option ?

  1. loss of information and incorrect results
  2. less secure data
  3. redundant data
  4. Slow database development

180.User rights information is stored in

Select correct option

  1. Physical database
  2. Catalog
  3. Logical database
  4. Buffer

181.A table can be logically connected to another table by defining a ____. Select correct option

  1. hyperlink
  2. common attribute
  3. primary key
  4. super key

182. Which levels are mostly used for Detailed DFD? Select correct option

  1. Level-0, Level-1
  2. Level-1, Level-2
  3. Level-2, Level-3
  4. Level-3, Level-4

183. Which of the following constraints enforces entity integrity?

Select correct option

  1. PRIMARY KEY  
  2. FOREIGN KEY
  3. CHECK
  4. NOT NULL

184.The most widely used conceptual model is the ____ model. Select correct option

  1. implementation
  2. ER  
  3. Object Oriented internal
  4. all

185.201PK?

  1. A primary key is an attribute
  2. (or set of attributes )
  3. values

186..particular instance entity.

 True

 false?

Select correct option

  1. True
  2. False
  3. None of the given

187.Which model operates at the lowest level of abstraction? Select correct option

  1. conceptual
  2. internal
  3. external
  4. physical   

188.Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss ?

Select correct option

  1. User accessible catalog
  2. Data processing
  3. Recovery service  
  4. Authorization service

189. A description on a particular collection of data using the given data model Select correct option

  1. Database
  2. Relation
  3. Schema  
  4. None

190.A candidate key that does not have a null value and is selected to uniquely identify all other attribute values in any given row is called a ____.

Select correct option

  1. super key
  2. candidate key
  3. primary key
  4. secondary key

191. Data inconsistency leads to a number of problems such as Select correct option

  1. loss of information and incorrect results
  2. less secure data
  3. redundant data
  4. Slow database development

192.Wich of the following constraints enforces entity integrity? Select correct option

  1. PRIMARY KEY 
  2. FOREIGN KEY
  3. CHECK
  4. NOT NULL

193.Which of the following is a feature of CHECK constraint? Select correct option

  1. limit the values that can be placed in a column.
  2. used to enforce referential integrity.
  3. enforces the uniqueness of the values in a set of columns .
  4.  is a unique identifier for a row within a database table.

194. In “One to Many” cardinality one instance of a relation is mapped with Select correct option many instances of second entity type

  1. One instance of second entity type
  2. Primary key of 2 relations
  3. none of above

195. Binary relationships are those, which are established between Select correct option

  1. One entity type
  2. Two entity type
  3. Three entity type
  4. Unlimited entities

196.in “many to many relationship” one instance of first entity can be mapped with many instances of second entity Select correct option

true

false

197.Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss ?

  1. User accessible catalog  Data processing
  2. Authorization service
  3. Recovery service  

198.Which of the following statements is true about the views? view is always a complete set of all the tables in a database

  1. View can not be used for retrieving data
  2. The results of using a view are not permanently stored in the database.
  3. Rows can not be updated or deleted in the view
  4. all

199.Which of the following is true about TRUNCATE?

  1. Can be Rolled back.
  2. Activates Triggers .
  3. DML Command.
  4. Resets 

200.Which of the following is the correct way to find out the size of cartesian product incase of CROSS JOIN?

  1. Number of columns in the first table multiplied by the number of columns in the second table.
  2. number of columns in the first table multiplied by the number of rows in the second table. 
  3. the number of rows in the first table multiplied by the number of columns in the first table.
  4. the number of rows in the first table multiplied by the number of rows in the second table.

<Previous Page

Take Quiz No 04

Next Page >