Hello Friends,this particular section is well focused on the Frequently asked Database Multiple Choice Questions Answers 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. It is better to use files than a DBMS when there are
- Stringent real-time requirements.
- Multiple users wish to access the data.
- Complex relationships among data.
- All of the above.
B. Multiple users wish to access the data.
2. The conceptual model is
- dependent on hardware.
- dependent on software.
- dependent on both hardware and software .
- independent of both hardware and software.
D. independent of both hardware and software.
3. What is a relationship called when it is maintained between two entities?
- Unary
- Binary
- Ternary
- Quaternary
B. Binary
4. Which of the following operation is used if we are interested in only certain columns of a table?
- Projection
- SELECTION
- UNION
- JOIN
A. Projection
5. Which of the following is a valid SQL type?
- CHARACTER
- NUMERIC
- FLOAT
- All of the above
D. All of the above
6. The RDBMS terminology for a row is
- tuple
- relation
- attribute
- degree
A. tuple
7. Which of the following operations need the participating relations to be union compatible?
- UNION
- INTERSECTION
- DIFFERENCEqq
- All of the above
D. All of the above
8. The full form of DDL is
- Dynamic Data Language
- Detailed Data Language
- Data Definition Language
- Data Derivation Language
C. Data Definition Language
9. Which of the following is an advantage of view?
- Data security
- Derived columns
- Hiding of complex queries
- All of the above
D. All of the above
10. Which of the following is a legal expression in SQL?
- SELECT NULL FROM EMPLOYEE;
- Select name from employee
- Select name from employee WHERE SALARY = NULL;
- None of the above
B. Select name from employee
