DBMS VIVA Questions And Interview Questions

DBMS VIVA Questions And Interview Questions

Q31-Cartesian product-
produce the relation that has attributes  of R1 and R2

Q32-The file organization that provides very fast access to any arbitrary record of a file is
Hashed file

Q33-Which of the following is correct:

        (A) SQL query automatically eliminates duplicates.

        (B) SQL permits attribute names to be repeated in the  
              same relation.

        (C) SQL query will not work if there are no indexes on the 
              relations

        (D) None of these           
Ans-D

Q34- It is better to use files than a DBMS when there are   
          -Multiple users wish to access the data.

Q35-The conceptual model is-independent of both hardware 
         and software.

Q36-Which of the following operation is used if we are
         interested in only certain columns of a table?–
projection

Q37-Which of the following operations need the participating 
        relations to be union compatible?
       (A) UNION                 (B) INTERSECTION  
       (C) DIFFERENCE    (D) All of the above      
Ans-D   

Q38-Which of the following is an advantage of view? 
        (A) Data security                        (B) Derived columns 
        (C)  Hiding of complex queries (D) All of the above  
Ans-D

Q39-The user who use easy-to-use menu are called-
Naïve users   

Q40-Which database level is closest to the users? 
       (A) External (B) Internal (C) Physical  (D) Conceptual                  
Ans-A

Q41-Which are the two ways in which entities can participate 
         in a relationship?-
Total and partial

Q42-The result of the UNION operation between R1 and R2 is 
         a  relation that includes-
all the tuples of R1 and R2which have common columns

Q43-Which of the following is a comparison operator in SQL?   
         (A) =                   (B) LIKE 
         (C) BETWEEN (D) All of the above 
Ans-D

Q44-A set of possible data values is called-
domain

Q45-Which of the operation constitute a basic set of operations 
         for manipulating relational data?
Relational  algebra

Q46-Which of the following is another name for weak entity?
         - Child

Q47-Which of the following database object does not physically 
         exist?- view

Q48-NULL is

        (A) the same as 0 for integer

        (B) the same as blank for character

        (C) the same as 0 for integer and blank for character

        (D) not a value                        
Ans: D

Q49-Which of the following is record based logical model?
         - Network Model

Q50-A data dictionary is a special file that contains:

        (A) The name of all fields in all files.

        (B) The width of all fields in all files.

        (C) The data type of all fields in all files.

        (D) All of the above.             Ans: D

Q51-A file manipulation command that extracts some of the  
         records from a file is called - SELECT

Q52-The physical location of a record is determined by a 
         mathematical formula that transforms a file key into a 
         record location is :-B-Tree File

Q53-Using Relational Algebra the query that finds customers, 
         who have a balance of over 1000 is - PCustomer_name(s  
         balance >1000(Deposit))

Q54-In E-R Diagram derived attribute are represented by 
        -Dashed ellipse

Q55-Cross Product is a:- Binary Operator

Q56-An instance of relational schema R (A, B, C) has distinct  
        values of A including NULL values. Which one of the 
        following is true?-
A is not a candidate key

Q57-Consider the join of a relation R with relation S. If R has 
         m tuples and S has n tuples, then the maximum size of join 
         is: - mn

Q58-The natural join is equal to :- Combination of projection 
         and Cartesian product

Q59-Which one of the following is not true for a view:

 (A) View is derived from other tables.

(B) View is a virtual table.

(C) View definition is permanently stored as part of database

(D) View never contains derived columns.     
Ans-C

Q60-In E-R Diagram relationship type is represented by  
        -Diamond

Q61-To delete a particular column in a relation the command  
         used is:-
Alter

Q62-The ______ operator is used to compare a value to a list  
         of literals values that have been specified.- 
BETWEEN

Q63-A B-tree of order m has maximum of ______children –m

Q64-In E-R diagram generalization is represented by-
Triangle

Q65-_________ is a virtual table that draws its data from the 
        result of an SQL  SELECT statement 
--View

Q66-_________ data type can store unstructured data- RAW

Q67-Which two files are used during operation of the 
         DBMS-Data dictionary and transaction log