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.
PRACTICE IT NOW TO SHARPEN YOUR CONCEPT AND KNOWLEDGE
1. which of the following is record based logical model?
- Network Model
- Object oriented model
- E-R Model
- None of these
A. Network Model
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.
D. All of the above.
3. A file manipulation command that extracts some of the records from a file is called
- SELECT
- PROJECT
- JOIN
- PRODUCT
A. SELECT
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.
B. Hashed 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.
A. Parent-Child relation ship between the tables that connect them.
6. In E-R Diagram derived attribute are represented by
- Ellipse
- Dashed ellipse
- Rectangle
- Triangle
B. Dashed ellipse
7. Cross Product is a:
- Unary Operator
- Ternary Operator
- Binary Operator
- Not an operator
C. Binary 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)
B. A is not a candidate key
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)
A. MN
