Top 1000+ Database Subject Mcqs Pdf Download Set No 05

by
Print/Downlaod pdf

201.Suppose there are 8 rows and 4 columns in TABLE1 and 3 rows and 4 columns in TABLE2;what is the size of the Cartesian product incase of CROSS JOIN between these two tables ?

 ( The number of rows in the first table multiplied by the number of rows in the second table )

  1. 24
  2. 12
  3. 16
  4. 6 

202.Which of the following is not one of the properties of Transaction? 

  1. atomicity
  2. consistency
  3. redundancy  
  4. durability

203.Which of the following is INCORRECT about VIEWS?

  1. It is not possible to left out the data which is not required for a specific view.  
  2. A database view displays one or more database records on the same page.
  3. Views can be used as security mechanisms

204. Relationship ?what is the relationship between faculty and course 

  1. 1M
  2. MM  
  3. Ternary

205.Which of the following is used to add or drop columns in an existing table?

  1. ALTER   
  2. HAVING
  3. SELECT

206.Which of the following is a correct way of selecting all the columns from a table called PERSONS?

  1. SELECT FROM * Persons
  2. SELECT * FROM Persons  
  3. SELECT * WHERE Persons
  4. SELECT WHERE * Persons  

207.Which of the following is NOT a feature of Indexed sequential files ?

  1. Records are stored in sequence and index is maintained. 
  2. Dense and nonsense types of indexes are maintained.
  3. Track overflows and file overflow areas can not be ensured.  
  4. Cylinder index increases the efficiency

208.Consider the given relations Student and Instructor as given below.

Please note that First Name and Last 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 two relations are union-compatible since they have the same type of tuples .
  3. The set operations such as CARTESIAN PRODUCT and DIVISION can be piped on these two relations .

209.Which of the following serves as a milestone or reference point in the log file? 

  1. Constraints
  2. Relations
  3. Check points   
  4. Transactions identities

210.Which of the following is not true regarding DB transactions ?

  1. A set of database operations that are processed partly 
  2. A database transaction is a logical unit of database operations
  3. A database transaction must be atomic
  4. A database transaction must contains the ACID property 

211.Which of the following are the general activities , which are performed during the development of application programs?

  1. Data input
  2. programs 
  3. Editing
  4. Display
  5. All of given    

212.Browser based forms are developed in the following tools EXCEPT

  1. HTML
  2. Scripting language 
  3. Front Page
  4. Web-based Forms  

213.Which of the following is not a form of optical disk?

  1.  WORM
  2. Erasable Optical
  3. EEPROM 
  4.  CD ROM

214.Which of the following is the correct description of cache hit?

  1. When data is found in the cache  
  2. When data is removed in the cache
  3. The number of times the cache is accessed directly by the processor 
  4. When data is lost from the cache 

215. In which of the following situations?

  1. Relatively static  
  2. Relatively deletion
  3. Relatively dynamic

216. Only one type of constraint can be enforced in any table by CREATE command

  1. True      
  2. false

217.Which of the following is disadvantage of chaining technique to handle the collisions ? 

  1. Unlimited Number of elements
  2. Fast re-hashing
  3. Overhead of multiple linked lists   
  4. Maximum number of elements must be known    

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

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

219.You can’t modify more than one table at a time through a view. 

  1. True   
  2. False

220.Which of the following is one of the purposes of using DML commands ? 

  1. Creating databases
  2. Destroying databases
  3. Inserting data in tables  
  4. None

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

222.What is the alternate name of Data Dictionary? 

  1. Index
  2. Metadata  Data
  3. System Catalog  

223.IN function helps reduce the need to use multiple AND conditions .

  1. True
  2. False  

224.Browser based forms are developed in the following tools EXCEPT HTML  Scripting language

  1. File  Version  1.0.1
  2. Front Page
  3. Web-based Forms   

225.Which of the following are the general activities , which are performed during the development of application programs?

  1. Data input
  2. programs
  3. Editing
  4. Display
  5. All of given 

226.Which of the following is not true about De -normalization?

  1. It is the process of attempting to optimize the performance of a database
  2. De-normalization is a technique to move from lower to higher normal forms of database modeling 
  3. It enhances the performance of DB
  4. In de-normalization it is required to add redundant data.

227.Which of the following gives all the fields from employee table named as EMP?

  1. SELECT * from EMP ;  
  2. SELECT emp* from EMP’
  3. SELECT emp_id where EMP; 
  4. SELECT * where EMP;
  5. all

228.Which of the following types of partitioning reduces the chances of unbalanced partitions?

  1. Vertical  List
  2. Hash
  3. Range

229.While recovering data, which of the following files does a recovery manager examines at first?

  1. A system file
  2. Log file   
  3. Data dictionary
  4. Metadata

230.Which of the following is NOT a feature of Indexed sequential files ?

  1. Records are stored in sequence and index is maintained. 
  2. Dense and nonsense types of indexes are maintained.
  3. Track overflows and file overflow areas can not be ensured.  
  4. Cylinder index increases the efficiency

231.ALTER TABLE exams

RENAME COLUMN Q_description TO Question_Descp, Studied to Student_ID. Syntax of ALTER TABLE

  1. True
  2. False

232. Which of the following SQL commands deletes a record of an employee with the employee_id 12345, from a table named PERSON.

  1. DELETE FROM person WHERE employee_id = ‘12345’
  2. DELETE WHERE person FROM employee_id = 12345
  3. DROP FROM person WHERE employee_id = 12345
  4. DELETE WHERE person WHERE employee_id = 12345  
  1.           

233.Which of the following is not a form of optical disk?

  1. CD ROM
  2. WORM
  3. Erasable Optical
  4. EEPROM 

234.Which of the following is the correct description of cache hit?

  1. When data is found in the cache  
  2. When data is removed in the cache
  3. The number of times the cache is accessed directly by the processor  When data is lost from the cache

235.In which of the following situations , Clustering is suitable  Frequently updating

  1. Relatively static  
  2. Relatively deletion
  3. Relatively dynamic

236.Which of the following is disadvantage of chaining technique to handle the collisions ?

  1. Unlimited Number of elements
  2. Fast re-hashing
  3. Overhead of multiple linked lists  
  4. Maximum number of elements must be known

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

 Select correct option Dataflow

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

238.Laser records data by burning microscopic holes in the surface of the disk with a

  1. Hard disk
  2. RAM
  3. Optical disk   
  4. Floppy disk

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

240.Which of the following is NOT a feature of a good interface?

A.    Process based

B.   Data structure based  

C.  User friendly

D.  Consistency

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

242.Which key word is available in SQL to enforce referential integrity?

  1. Check
  2. PK
  3. Set Default
  4. Unique

243.Which of the following statements are Data Definition Language command? 

  1. INSERT
  2. UPDATE 
  3. GRANT
  4. TRUNCATE  

 244. How many clustered index(es ) do each database table have? 

  1. 2
  2. 3
  3. 5
  4. 1  

245.Which of the following is true about DELETE command? 

  1. is DDL Command.
  2. Resets identity of the table  cannot
  3. activate a trigger
  4. Can be Rolled back 

246.Which of the following will be deleted relating to a table if you use TRUNCATE command?

  

  1. indexes
  2. table structure
  3. columns 
  4. constraints
  5. all rows in a table  

 247.Which of the following is not true about De-normalization?

  1. It is the process of attempting to optimize the performance of a database
  2. De-normalization is a technique to move from lower to higher normal forms of database modeling
  3. In de-normalization it is required to add redundant data.
  4. It enhances the performance of DB

 248.Which of the following is not a feature of TRANSACTION?

  1. Users should be able to regard the execution of each transaction as atomic.
  2. Each transaction, run by itself.
  3. the consistency of the database
  4. dependant on other concurrent transactions

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

250.Which of the following is incorrect with respect to indexed sequential files ? 

  1. New records are added to an overflow file
  2. Record in main file that precedes it is updated to contain a pointer to the new record
  3. The overflow is merged with the main file during a batch update
  4. Multiple indexes for the same key field cannot be setup 
  1.  

<Previous Page
Take Quiz No 05
Next Page >

Post Views: 719