Top 1000+ Database Subject Mcqs Pdf Download Set No 15

written by Assad Javaid | May 27, 2021

701.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. all
  4. Logical data independence

702. What does this SL statement do?

  1. Grant permission to Amelia only to retrieve data from Employee table and grant permission to Heroin, only to
  2. update the designation from Employee table.
  3. Grant permission to Heroin in order to grant, and update permission to Amelia.
  4. Grant permission to Amelia & Heroin to update designation of employees in the Employee table
  5. Grant permission to Amelia and Heroin to update all data except designation in Employee table  
  1.   

703. Which key word is available in SL to enforce referential integrity?

  1. Check
  2. Primary Key 
  3. Set Default
  4. Unique

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

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

705. How many clustered indexes do each database table have?

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

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

 is DDL Command.

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

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

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

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

709.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. must preserve the consistency of the database
  4. dependant on other concurrent transactions    
  1.     

710.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;

711.Suppose there are 4 fields in a table named CUST customer id, first name, last-named, phone.

Which of the following gives all the information of the customers in the table whose last name is ALI?

  1. FROM CUST WHERE last-named=’ALI’; 
  2. FROM CUST WHERE last-named=ALI;
  3. FROM CUSTOMER WHERE name=ALI;
  4. FROM CUSTOMER WHERE last-named=ALI;  
  1.  

712.Identify the  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
  4. Property at any cost whereas the dependency reservation property is sometimes sacrificed.

713. The process of normalization through decomposition must achieve the dependency reservation property at any cost whereas the lossless join property is sometimes sacrificed Which of the following is not true  with respect to demoralization?

  1. A demoralized data model is not the same as a data model that has not been normalized
  2. Demoralization takes place before the normalization process
  3. It is an attempt to optimize the performance of database
  4. Demoralization process cannot be initiated before the Database design

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

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

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

716.DML commands are used for inserting data into databases  

  1. creating databases
  2. destroying databases
  3. creating DB objects  
  4. none

717.Which of the following is IN with respect to file systems?

  1. At the physical level
  2. independence at the user level.
  3. A logical record is concerned with efficient storage of information in the secondary storage devices.
  4. pointer or hashed address scheme may be employed to provide a certain degree of data

718.Some physical organizations use pointers to record blocks to locate records on disk. The efficiency of a file system depends on how efficiently operations such as retrieve, insert, update, delete may be performed on the information stored in the file. Which of the following is  regarding Dataflow diagram?

  1. Single DFD is required to resent a system
  2. The dataflow must be bidirectional
  3. Created at increasing levels of detail

719.The  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
  2. entity type.
  3. In the narrative description of the database requirements, verbs tend to indicate the names
  4. of relationship types.
  5. The nouns arising from a database requirement description can be considered as names of attributes
  6. Additional nouns which are appearing in the narrative description of the database requirements resent the weak entity type names.
  1.     

720.identifying the owner entity type relevant to a given entity type

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

721.Identify the  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, a tuple in one relation that refers to another relation must refer to a n existing tuple.

 722.What is the impact of setting multiple indexes for the same key, in index sequential files?

  1. Multiple indexes for the same key can not be set
  2. It increases efficiency   
  3. It decreases efficiency
  4. It will increase complexity as the access time will be increase.

733.Which of the following is not true regarding Indexes?

  1. Index can be defined even when there is no data in the table
  2. It support Range selections
  3. It can be created using ‘Create Index’ statement
  4. It can not be created on composite attributes 

734.While recovering data, which of the following files does a recovery m anger examines at first?

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

735.The main memory of a computer system is also known as?

  1. ROM
  2. RAM 
  3. PROM
  4. Hard disk

736.___    __is a control that enables users to one  from an associated list; users can also type an  Combo box ?

  1. Button
  2. Text box
  3. Static area  

737.The records data by burning microscopic holes in the surface of the disk with a laser?

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

738.Which of following is NOT generally the aim of data partitioning and placement of data?

  1. Reduce Workload
  2. Balance Workload
  3. Merging different relations 
  4. Speed up rate of useful works.

739.ALTER TABLE?

RENAME COLUMN _description TO _Descp, Std_ID to Student_ID. Syntax of

  1. ALTER TABLE is NOT .
  2. True
  3. False     

740.Which of the following is true regarding Index?

  1. Index can only be created for a single table in database
  2. Index can maximum be created for two tables in database
  3. Index can be created for every table in the database  
  4. Index should be created for every table in the database

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

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

742.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
  4. database.     
  5. Rows can not be updated or deleted in the view

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

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

 

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

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

746.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 modeling
  3. In demoralization it is required to add redundant data.
  4. It enhances the performance of DB

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

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

749.What is the maximum limit of keys in context with Indexed sequential files?

  1. 255    
  2. 235
  3. 0 
  4. none 

750.Structural constraints of a relationship type refer to identifying the owner entity type relevant to a given entity type

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

<Previous Page

Take Quiz No 15

Next Page >