Hello Friends,this particular section is well focused on the Frequently asked Database Fundamentals MCQs in the various competitive exam.The set of questions are very basic and easily understandable by reader.we have kept the question hardness level to very basic.

 

1
. which of the following is record based logical model?
  • Network Model
  • Object oriented model
  • E-R Model
  • None of these
2
. A data dictionary is a special file that contains:
  • The name of all fields in all files.
  • The width of all fields in all files.
  • The data type of all fields in all files.
  • All of the above.
3
. A file manipulation command that extracts some of the records from a file is called
  • SELECT
  • PROJECT
  • JOIN
  • PRODUCT
4
. 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
  • Hashed File
  • Indexed File
  • Sequential file.
5
. A primary key is combined with a foreign key creates
  • Parent-Child relation ship between the tables that connect them.
  • Many to many relationship between the tables that connect them.
  •  Network model between the tables that connect them.
  • None of the above.
6
. In E-R Diagram derived attribute are represented by
  • Ellipse
  • Dashed ellipse
  • Rectangle
  • Triangle
7
. Cross Product is a:
  • Unary Operator
  • Ternary Operator
  • Binary Operator
  • Not an operator
8
. 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 a candidate key
  • A is not a candidate key
  • A is a primary Key
  • Both (A) and (C)
9
. 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
  • M+N
  • (M+N)/2
  • 2(M+N)

 
 
You may be interested in:
Database Management System Basics MCQs
Database Management System Online Tests
Database Management System Short Questions With Answers
Database Management System Tutorials