Name of the University : University of Pune
Name of the College : MIT Arts Commerce & Science College
Degree : BCA
Subject Code/Name : BCA204- File Structure And Database Concepts
Semester : II
Document Type : Question Bank
Website : mitacsc.ac.in
Download Model/Sample Question Paper : https://www.pdfquestion.in/uploads/mitacsc.ac.in/3774-FSDC.pdf
MITS File Structure & Database Concepts Question Paper
File Structure and Organization :
Chapter 1
1. What is File- Explain file structure in details.
2. Define logical & physical files.
Related : MIT Arts Commerce & Science College BCAS108 Organizational Behaviour BCA Question Bank : www.pdfquestion.in/3773.html
3. Explain field structure in brief.
4. Compare variable length record and fixed length record.
5. Discuss the advantages and disadvantagesa) Unordered file
6. Write short notes on sequential files
7. What are Hash files and explain-
8. What is file- Explain different operations performed on the file.
9. State difference in spanned and unspanned records.
10. Write short note on sorted or sequential file
11. Explain index file organization in brief.
12. State different types of indexes.
Chapter 2
Tree Structure Indexing :
1. What is an index file- What is the relationship between this files –
2. What is a clustered index-
3. What are the advantages & disadvantages of index sequential files-
4. What are B+ trees- Give insertion & deletions in the same.
5. Write a note on B tree.
6. What is limit indexing- Explain-
7. Explain multilevel indexing in detail..
8. Explain the structure of index sequential files.
9. Explain B + tree deletion algorithm.
Chapter 3
Database Management System :
1. What is DBMS-
2. What are the limitations of conventional file processing system-
3. What is the difference between the traditional file system & DBMS-
4. State and explain the advantages and disadvantages of DBMS
5. What is data abstraction- What are different levels of data abstraction-
6. What is data independence- What are its different types-
7. List and explain different types of database users-
8. What are functions performed by Database Administrator ( DBA)-
9. Give the difference between logical & physical data independence-
10. Write a short note ona. DDLb. DMLc. DCLd. TCL
11. Explain following terms,a. Instanceb. Schema
12. What capabilities a good DBMS should have-
13. Explain different components of DBMS structure.
Chapter 4
Data Models :
1. Explain different types of Data Models-
2. Explain relational data model with example.
3. Explain network data model with example.
4. Explain hierarchical data model with example.
5. Explain with suitable examples an entity and entity sets.
6. Explain types of entity with suitable examples.
7. Explain types of entity with suitable examples.
8. What is an attributes- Explain its types in detail.
9. Explain relationships & relationship sets with example.
10. Write a short note on ER diagrams.
11. Explain the difference between primary key & foreign key.
12. Explain following terms
a. Primary key
b. Super key
c. Candidate Key
d. Foreign key
e. Composite key
13. State different types of relationship can exist between entity sets in an E – R Model.
14. What is generalization? Explain with examples.
15. What is specialization? Explain with examples.
16. Draw an E‐R diagram for College admission system.
17. Draw an E‐R diagram for Hospital system
Chapter 5
Relational Databases :
1. What are the advantages & disadvantages of RDM-
2. What is a relation- Explain the degree of a relation with types.
3. Write short note on,f. Entityg. Domain
4. What is key constraint- Explain types of constraints.
5. Explain conversion of weak entity set with example.
6. What is data integrity-
7. Enlist the steps followed for conversion of E R to Relational model.
8. Explain different data integrity types-
9. Explain the following operation.a. Selectb. Projectc. Union
Chapter 6
SQL (STRUCTURED QUERY LANGUAGE) :
1. Write short note on SQL
2. What is generalized structure of SQL query (with from & where)
3. Explain the following operations .a. Set operationsb. Predicates
4. Explain the following DDL commands of SQL.a. Create
5. Explain the following DML commands of SQL.a. Insert
6. How tables are created & maintained by using SQL.
7. Explain different aggregate functions with examples.
8. What are nested queries? How would you use the operators in, not in writing nested queries?
9. What is grouping? Discuss the interaction of the having & where clauses.
10. Explain different data types used in SQL?
11. What is the difference between where and having clause of selected statement.
12. What is the use of BETWEEN operators in SQL?