Important DBMS Questions and Answers IT 402 Class 10 RDBMS (basic) Session 1

Share with others

Important DBMS Questions and Answers IT 402 Class 10

DBMS Questions and Answers

DBMS QUESTIONS AND ANSWERS
DBMS QUESTIONS AND ANSWERS

Session 1 : Appreciate the concept of Database Management System

Important DBMS Questions and Answers IT 402 Class 10

Q1. What is database?

Q2. What is DBMS?

Q3. Name two DBMS Software.

Q4. What is the difference between Flat file and Relational ?

Q5. What do you mean by database servers?

Q6. Write four advantages of database.

Q7. What do you mean by Data Redundancy?

Q8. What do you mean by Data Integrity?

Q9. What is Data Consistency?

Q10. Write two features of database.

Q11. What do you mean by RDBMS.

Q12. What is Primary Key?

Q13. What do you mean by Composite Primary key?

Q14. What is Foreign Key?

Q15. Answer the following questions on the basis of following table:

Table : Student

Stud_idStud_nameClassFees
1AmanIX3000
2AnilX3200
DBMS Questions and Answers

Table Teacher

T_idT_nameT_SalStud_id
3210Mr. Kumar600001
3211Mr. Sethi700002
DBMS Questions and Answers
  1. Identify the primary key in Student and Teacher table.
  2. Identify the foreign key in Teacher table.


SESSION 2: CREATE AND EDIT TABLES USING WIZARD AND SQL COMMANDS

SESSION 3: PERFORM OPERATIONS ON TABLE

SESSION 4: RETRIEVE DATA USING QUERY

SESSION 5: CREATE FORMS AND REPORTS USING WIZARD


Disclaimer : I tried to give you the correct answers of above questions but if you feel that there is some mistake in above DBMS Questions and Answers, feel free to contact me at csiplearninghub@gmail.com


Important Links


Share with others

Leave a Reply

%d bloggers like this: