Top 1000+ Database Subject Mcqs Pdf Download Set No 03

by
Print/Downlaod pdf

101. User rights information is stored in

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

102.Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of

  1. Physical data independence
  2. Concurrency control.
  3. Logical data independence.      
  4. Functional dependency
  1.                               

103.Which of the following is NOT a feature of Context DFD?

  1. one process (which represents the entire system)  all sources/sinks (external entities)
  2. data flows linking the process to the sources and sinks (external entities)
  3. sub-processes (which explain and decomposed the major process into small processes           
  1.                    

104. A relation (from the relational database model) consists of a set of tuples  which implies that

  1. all  topless in a relation must be distinct
  2. relational model supports multi-valued attributes whose values can be represented in sets.
  3. any two topless, the values associated with all of their attributes may be the same.
  4. all topless in particular relation may have different attributes.
  1.                   

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

  1. NOT NULL
  2. CHECK              
  3. UNIQUE

106. Consider the following table obtained using Student and Instructor relations. Which relational algebra operation could have been applied on the pair of relations Student and Instructor to obtain the above data?

  1. Instructor – Student
  2. Student ∩ Instructor  Instructor ÷ Student  Student – Instructor
  1.                

107.Identify the correct statement with respect to normalization.

  1. Normalization is a formal technique that can be used only at the starting phase of the database design.
  2. Normalization can be used as a top-down standalone database design technique.
  3. The process of normalization through decomposition must achieve the lossless join property at any cost whereas the dependency reservation property is sometimes sacrificed.
  4. The process of normalization through decomposition must achieve the dependency reservation property at any cost whereas the lossless join property is sometimes sacrificed.

108.Consider the relation Interview(Candidate No, Interview Date  InterviewTime, StaffNo, RoomNo) 

  1. FD1  Candidate No, Interview Date -> Interview Time, Staff No, Room No
  2. FD2  Room No, Interview Date, Interview time -> Staff No, Candidate No
  3. FD3  Staff No, Interview Date -> Room No

109.Which of the following is correct?

  1. The relation Interview is in 3NF       
  2. The FD3 violates 3NF.
  3. The FD2 violates 2NF.

110..Identify the INCORRECT statement among the given.

  1. An entity may be an object with a physical existence like a car, a house or an Employee.
  2. One cannot consider something which has conceptual existence like a course in a degree program
  3. as an entity.      
  4. Age can be considered as a single value attribute of a person.
  5. An entity type describes the schema or intension for a set of entities which share the same structure. Structural constraints of a relationship type refer to

 111. Identifying the owner entity type relevant to a given entity type

  1. whether the existence of an entity depends on it being related to another entity via the relationship type.    
  2. the role that a participating entity from the entity type plays in each relationship instance. 
  3. the constraints applicable in granting access to tables, columns and views in a database schema.

112. DBMS?

  1. Database 
  2. Data base management
  3. Data      

 113. Data model  ?    

 Data

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

All          

114. An entity can be logically connected to another by defining a ____.

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

115. The ____ constraint specifies whether each entity super type occurrence must also be a member of at least one subtype.

  1. specialization 
  2. uniqueness
  3. inheritance
  4. completeness 

116.Database management systems, operating systems, applications and utilities are all examples of ?

  1. hardware
  2. software             
  3. computer infrastructure  input and output   
  1.        

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

  1. Full functional dependency    
  2. Any kind of dependency
  3. Transitive dependency  Non-transitive dependency    
  1.                    

118. database system allows the following EXCEPT

  1. management and control of data towards an efficient working of an organization. 
  2. It is more critical functions in organizations to be computerized and the need to keep a large volume of data available
  3. it is up to the minute current state increased.
  4. any user to access all its data.
  5. integration of data across multiple applications into a single application.

119. User rights information is stored in

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

120. The ER- data model is an example of

  1. Physical database
  2. Logical database
  3. Relational database
  4. Conceptual database       

121. Which of the following is true about NOT NULL constraint?

  1. enforce domain integrity
  2. limit the values that can be placed in a column.
  3. prevents any actions that would destroy links between tables with the corresponding data values
  4. enforces the uniqueness of the values in a set of columns
  1.                          

122. Which of the following is correct?

  1. The relation Interview is in BCNF. 
  2. The FD3 violates 3NF.
  3. The FD3 violates BCNF.
  4. The FD2 violates 2NF.

123.Consider the following diagram depicting a kind of a relationship type where X and Z are entities and Y is a relationship type Select the correct statement among the following on the above diagram.

  1. The relationship type Y is of cardinality ratio 1  N.     
  2. The diagram depicts existence dependencies.
  3. The participation of X in the Y relationship type is total.  The participation of Z in the Y relationship type is partial.

124. Select the correct statement among the following. Role names are not technically necessary in relationship types when all the participating entity types are distinct.

  1. When different entity types participate only once in a single relationship type it is called a recursive relationship.  
  2. Cardinality ratios for binary relationship are displayed on Entity Relationship Diagrams by using a diamond shape notation.
  3. Partial participation which is also called existence dependency is displayed as a double line connecting the participating entity type to the relationship.

 125.Which of the following is true about relational schema?

  1. The sequence of columns is significant
  2. The sequence of rows is significant. 
  3. Contains only derived attributes.
  4. Values are atomic.  

126. Consider the given relations Student and Instructor as given below. Please note that First Name and L Name also denote the First Name and Last Name respectively.

Which of the following statements is correct with respect to the two relations given above?

  1. The two relations are not union-compatible since their attribute names differ.
  2. The set operations such as CARTESIAN PRODUCT and DIVISION can be applied on these two relations.
  3. To find out those students who work as instructors, it is necessary to perform the operation Student ∩ Instructor.
  4. To find out the students who are not instructors, it is necessary to perform the operation Student ÷ Instructor.

127. Consider the following relation R and its sample data. (Consider that these are the only topples for the given relation) Which of the following statements is NOT correct?

  1. The functional dependency Project No -> Depart No holds over R.
  2. The functional dependency (Employee No, Project No) -> Department No holds over R.
  3. The functional dependency Depart No -> Project No holds over R.  The functional dependency Employee No -> Depart No holds over R.

128. A collection of related data is

  1. Logical model Database            
  2. Data
  3. Relational model 

129. A weak entity type

  1. must have total participation in an identifying relationship  does not have a key attribute(s)
  2. both (a) and (b)       
  3. none of the above

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

  1. Database
  2. Schema
  3. None of the above.
  4. Relation

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

132. 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. A foreign key cannot be used to refer to its own relation. Identify which of the above statements is/are correct.

133. Which of the following constraints enforces entity integrity?

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

134. Which of the following constraints no enforces entity integrity?

  1. PRIMARY KEY
  2. FOREIGN KEY 
  3. CHECK
  4. None   

135. Which of the following enforces a relation into 1st normal form  The domain of attribute must include only atomic values?

  1. T
  2. F
  3. True

 136. Which of the following is a feature of PRIMARY KEY constraint?

  1. unique identifier for a row within a database table      
  2. allow any actions that would destroy links between tables
  3. limit the values that can be placed in a column.
  4. enforces that the column will only accept null values.
  5. Structural constraints of a relationship type refer to

137. identifying the owner entity type relevant to a given entity type Which of the following is true about relational schema?

  1. The sequence of columns is significant  The sequence of rows is significant. 
  2. Contains only derived attributes.
  3. Values are atomic. 

138. A ____ relationship exists when an association is maintained within a single entity.

  1. unary
  2. ternary
  3. binary
  4. weak

139. Which of the following is a correct way to implement one-to-many relationship while designing tables?

  1. by splitting the data into two tables with primary key
  2. foreign key relationships.
  3. composite primary key of the junction table.

140.Identify the correct statement.

  1. Entity integrity constraints specify that primary key values can be composite.
  2. Entity integrity constraints are specified on individual relations. 
  3. Entity integrity  constraints are specified between weak entities.
  4. When entity integrity rules are enforced,
  5. a topple in one relation that refers to another relation must refer to an existing topple.

141.A software package designed to store and manage databases

  1. Database
  2. DBMS   
  3. Data model Data

142 Who is responsible for authorizing access to the database, for coordinating and monitoring its use? Select correct option

  1. Database Designer
  2. Database Administrator
  3. End User
  4. Application Programmer

143.Which of the following constraints enforces referential integrity?

  1. FOREIGN KEY
  2. CHECK
  3. KEY UNIQUE

144.As part of database naming conventions, attribute names should use suffixes such as ID, NUMBER or CODE for the ?

  1. primary key
  2. foreign key
  3. index
  4. determinant

145.Which one is true regarding relation?

  1. Every attribute value Non atomic  Attribute in table may not have unique name table order of the column is relevant
  2. the order of the rows is irrelevant      

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

  1. Minimize insertion anomalies
  2. Minimize deletion anomalies
  3. Minimize updating anomalies
  4. Maximize redundancy  

147.Controlling redundancy in a database management system DOES NOT

  1. help to avoid duplication
  2. avoid unnecessary wastage of storage space  avoid unauthorized access to data Click here for detail  avoid inconsistency among data                           

148.In a conceptual database model, which of the following most likely represents a valid identifier for a class grades?

  1. Student ID
  2. Student ID, Course ID
  3. Student ID, Course ID, Instructor ID
  4. Student ID, Course Section ID   

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

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

150.Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of

  1. Physical data independence.
  2. Concurrency control.
  3. Logical data independence.       

<Previous Page
Take Quiz No 03
Next Page >

Post Views: 748