Hello Friends,this particular section is well focused on the DBMS Basics mcq questions for placement. 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. The full form of DDL is
- Dynamic Data Language
- Detailed Data Language
- Data Definition Language
- Data Derivation Language
C. Data Definition Language
2. 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
3. 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;
4. A set of possible data values is called
- attribute
- degree
- tuple
- domain
D. domain
5. Which of the operations constitute a basic set of operations for manipulating relational data?
- Predicate calculus
- Relational calculus
- Relational algebra
- None of the above
C. Relational algebra
6. Which of the following is another name for weak entity?
- Child
- Owner
- Dominant
- All of the above
A. Child
7. Which of the following database object does not physically exist?
- base table
- index
- view
- none of the above
C. view
8. Which of the following is record based logical model?
- Network Model
- Object oriented model
- E-R Model
- None of these
A. Network Model
9. The natural join is equal to :
- Cartesian Product
- Combination of Union and Cartesian product
- Combination of selection and Cartesian product
- Combination of projection and Cartesian product
D. Combination of projection and Cartesian product
10. Which one of the following is not true for a view:
- View is derived from other tables.
- View is a virtual table.
- A view definition is permanently stored as part of the database.
- View never contains derived columns.
C. A view definition is permanently stored as part of the database.
