Top 1000+ Database Subject Mcqs Pdf Download Set No 14

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

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

652.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  
  1.   

653.Which of the following is true about TRUNCATE?

  1. Can be Rolled back.
  2. Activates Triggers.
  3. is DML Command
  4. Resets identity of the table

654.Which of the following is the  way to find out the size of Cartesian product incase of CROSS JOIN?

  1. the number of columns in the first table multiplied by the number of columns in the second table.
  2. the 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.   

655.Suppose there are 8 rows and 4 columns in TABLE 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. 32
  2. 2
  3. 3
  4. 6     

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

  1. Atomicity
  2. Consistency
  3. redundancy  
  4. durability    

657.Which of the following is IN 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 .
  3. Views can be used as security mechanisms
  4. Views are generally used to focus the perception each user has of the database.

658.Each course section is assigned a particular faculty member, and each course section corresponds particular course. Conceptually, what is the relationship between faculty and course not course selection ?

  1. M
  2. MM
  3. Ternary  
  4. none

136):Which of the following is used to add or drop columns in an existing table?

  1. ALTER  
  2. HAVING
  3. SELECT
  4. THEN     

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

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

660.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 non dense types of indexes are maintained.
  3. Track overflows and file overflow areas can not be ensured.
  4. Cylinder index increases the efficiency 

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

Please note that F name and L name also denote the First Name and Last Name respectively

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

  1. The two relations are union compatible since they have the same type o f tuple.
  2. The set operations such as CARTESIAN PRODUCT and DIVISION can be applied on these two relations.
  3. The two relations are not union compatible since their attribute names differ
  4. To find out the students who are not instructors, it is necessary to perform the operation Student ÷
  5. Instructor.   

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

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

664.Which of the following are the general activities, which are

performed during the development of application programs

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

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

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

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

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

667.Which of the following is the  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  

668.In which of the following situations, Clustering is suitable?

  1. Frequently updating
  2. Relatively static  
  3. Relatively deletion
  4. Relatively dynamic

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

  1. True
  2. False       

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

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

671.Consider the following relation R and its sample data. Consider that these are the only tuples for the given

Relation Which of the following statements is NOT ?

  1. The functional dependency ProjNo > Dept No holds over R.
  2. The functional dependency Emp No, Prog No > Dept No holds over R.
  3. The functional dependency Dept No > Prog  No holds over R.
  4. The functional dependency Employ > Dept No holds over R.

   672.An entity type is

  1. defined when the database is actually constructed
  2. a specific type such as an integer, text, date, logical etc
  3. a coherent set of similar objects that we want to store data on e.g. STUDENT, COURSE, CAR

   673.An entity can be logically connected to another by defining a     __.

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

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

  1. True  
  2. False
  3. both   

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

676.Which of the following statements is true about the views?

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

  677.What is the alternate name of Data Dictionary?

  1. Index
  2. Metadata
  3. Data
  4. System Catalog  

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

  1. True
  2. False

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

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

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

  1. Data input program
  2. Editing
  3. Display
  4. All

681.Which of the following is not true about Demoralization?

  1. It is the process of attempting to optimize the performance of a database
  2. Demoralization is a technique to move from lower to higher normal forms of database modelin
  3. It enhances the performance of DB
  4. In demoralization it is required to add redundant data.
  1.  

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

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

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

  1. Vertical
  2. List
  3. Hash 
  4. Range    

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

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

 686.ALTER TABLE

  1. RENAME COLUMN _description TO _Descp, Std_ID to Student_ID. Syntax of
  2. ALTER TABLE is NOT .
  3. True
  4. Fal

687.A description on a particular collection of data using the given data mod

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

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

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

689.A relational database one that consists of two or more tables

  1. a database that is able to process tables, queries, forms, orts and macros
  2. one that consists of two or more tables that are joined in some way
  3. the same as a flat file database

687.A description on a particular collection of data using the given data mod

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

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

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

689.A relational database one that consists of two or more tables

  1. a database that is able to process tables, queries, forms, orts and macros
  2. one that consists of two or more tables that are joined in some way
  3. the same as a flat file database

 690.Which of the following is NOT a component of a DFD

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

692.Which of the following SL commands deletes a record of an employee with the employee_id 2345, from a table named PERSON.

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

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

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

694.Which of the following is the  description of cache hit?

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

695.In which of the following situations, Clustering is suitable?

  1. Frequently updating
  2. Relatively static  
  3. Relatively deletion
  4. Relatively dynamic  

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

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

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

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

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

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

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

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

  1. Consistency
  2. Process based
  3. Data structure based  
  4. User friendly