Important DBMS Questions and Answers IT 402 Class 10
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?
Ans. A database is an organized collection of data.
Q2. What is DBMS?
Ans. DBMS stands for Database Management system. It is a software that controls the creation, maintenance and use of a database.
Q3. Name two DBMS Software.
Ans. Two DBMS Software are :
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 DBMS Questions and Answers Q5. What do you mean by database servers?
Ans. Database servers are dedicated computers that hold the actual databases and run only the DBMS and related software.
Q6. Write four advantages of database.
Ans. Four advantages of database are
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?
Ans. Duplication of data in a database is known as data redundancy.
Q8. What do you mean by Data Integrity?
Ans. Data integrity means that the data is accurate and consistent in the database.
Q9. What is Data Consistency?
Ans. Data Consistency means there should be multiple mismatching copies of the same data in a database.
Q10. Write two features of database.
Ans. Two features of database are :
1. A database can have one or many tables. 2. Every table in a database has a primary key field which ensures 00% unique values in the database.
Q11. What do you mean by RDBMS.
Ans. RDBMS stands for Relational Database Management System. When data is to be stored, maintained, and retrieved from multiple tables then special database software are required known as RDBMS.
Q12. What is Primary Key?
Ans. A field which is unique for each and every record in a table is called primary key.
Q13. What do you mean by Composite Primary key?
Ans. When primary key constraint is applied on one or more columns then it is known as Composite Primary Key.
Q14. What is Foreign Key?
Ans. A Foreign Key is a field in one table that refers to the primary key of another table. It is used to link two tables.
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 DBMS Questions and Answers
T_id T_name T_Sal Stud_id 3210 Mr. Kumar 60000 1 3211 Mr. Sethi 70000 2 DBMS Questions and Answers
Identify the primary key in Student and Teacher table. Identify the foreign key in Teacher table.
Ans. 1. Primary Key in Student table : Stud_id
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 firstname.lastname@example.org