Important DBMS Questions and Answers IT 402 Class 10
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.
1 MySQL 2. Oracle 3. Microsoft SQL Server 4. Microsoft Access.
Q4. What is the difference between Flat file and Relational ?
Flat File Relational Data is stored in a single table. Data is stored in multiple tables. It is suitable for less amount of data. It is suitable for large amount of data
Q5. What do you mean by database servers?
Q6. Write four advantages of database.
1 It reduces Data Redundancy 2. It allows sharing of data. 3. It help to maintain data integrity. 4. It provides Data Security.
Q7. What do you mean by Data Redundancy?
Q8. What do you mean by Data Integrity?
Q9. What is Data Inconsistency?
Q10. Write two features of database.
1. A database can have one or many tables. 2. Every table in a database has a primary key field which ensures 100% unique values in the 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_id | Stud_name | Class | Fees |
| 1 | Aman | IX | 3000 |
| 2 | Anil | X | 3200 |
Table Teacher
| T_id | T_name | T_Sal | Stud_id |
| 3210 | Mr. Kumar | 60000 | 1 |
| 3211 | Mr. Sethi | 70000 | 2 |
- Identify the primary key in Student and Teacher table.
- Identify the foreign key in Teacher table.
Primary key in Teacher table is : T_id 2. Foreign key in Teacher table is : Stud_id
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
please take a look at ques 9
data inconsistency is when there are multiple mismatched copies while data consistency refers to consistent data…
please look at Q10 there is mistake
thank you for DBMS MCQS