DBMS

NOVE-2010 SAZ5A/SAE5B

Part-A

What is DBMS and RDBMS?
What is normalization?
What are the basic data types to define an attribute?
Write the general meaning of outer join.
List down the basic arithmetic operators.
What is subform?
What are the basic SQL DDL commands?
Write down the primary functions for error handling.
What are the primary sections of reports?
Write the difference between centralized and distributed database.
What is the role of database administrator?
What is the use of backup?

Part-B

What are the components of database system?
What is functional dependency? Explain.
Discuss Boyce Codd Normal form.
Write a note and list down the aggregation operators.
How to handle the unexpected errors? Explain.
Write a note on table operations.
Describe the client / Server database.

Part-C

Describe the terms related to class and how to convert the class to normalized table.
What is subquery? And also explain the following SQL operators IN, ALL, ANY.
What are the common controls to build a form? Explain.
What are the data storage methods available? Explain.
What are the development stages of a database tasks? Explain.

APRIL-2011 SAE5B / SAZ5A

PART-A

1. What is database?

2. What is normalization?

3. What is DDL?

4. What is a query?

5. Define Foreign Key and Super key.

6. What is multiple table query?

7. What is Cold Backup?

8. What is DML?

9. What is data integrity?

10. Define Distributed Database System.

11. What is data security?

12. Write the important advantage of data distribution.

PART-B

13. Discuss briefly the advantages DBMS.

14. Explain briefly the data dictionary and the system catalog.

15. What do you mean by Correlated subquery?

16. Discuss briefly the data entry through multi-table form.

17. Describe briefly the user interface features.

18. List and describe the functions of the database administrator.

19. Discuss briefly the backup and recovery procedures in the transaction process.

PART-C

20. Discuss how to converting class diagrams to normalized tables.

21. Describe the Data Manipulation and Data Definition commands with suitable example.

22. Discuss the effective design of forms and reports.

23. Explain in detail lie data clustering and partitioning

24. Discuss the following

a) Client / server Databases

b) Object Oriented Databases

NOVE-2011 SAE5B/SAZ5A

PART-A

1. What is DBMS?

2. What is a feasibility study?

3. Define Data Dictionary.

4. What are the situations in which a query will be created?

5. What is the purpose of DISTINCT operator?

6. Write the difference between DDL and DML.

7. What are the primary sections of reports?

8. What are the primary types of forms?

9. What is transaction?

10. List down the data storage methods.

11. What are the development stages in database tasks?

12. What is client/server database?

PART-B

13. What are events? How they are described in a database design?

14. How to convert a class diagram into normalized tables?

15. What are the differences between ORDER BY and GROUP BY commands?

16. Explain the differences between a checkbox and an option button.

17. What is meant by error handling? Explain its two functions.

18. How do menus improve the user interface?

19. Write short notes on DBA.

PART-C

20. List down the components of DBMS. Explain DBMS with its diagram.

21. How to join tables when some items exist in only one of the tables? Discuss.

22. What are the main control can we use on forms? Explain these controls.

23. Discuss about custom reports.

24. Explain the three tier client/server data model.

APRIL-2012 SAE5B/ SAZ5A

PART-A

1. What is meant by Data Dictionary?

2. Define: Entity.

3. What is a primary key?

4. Write the use of DISTINCT keyword with an example.

5. What basic aggregation functions are available in the SELECT command?

6. Define: Subqueires.

7. What are the Basic properties for forms?

8. What are the primary form types?

9. Define: Transaction.

10. What are form events?

11. List the roles of DBA.

12. Define the term: privacy.

PART-B

13. Write short notes on: The feasibility study.

14. Discuss briefly on First and Second normal forms with examples.

15. Write briefly on Query Basic with examples.

16. What are SQL DML statements? Explain with examples.

17. Write short notes on: procedural Languages.

18. What are custom Reports? Discuss briefly.

19. Write short notes on: creating a Distributed Database system.

PART-C

20. Explain the various components of a DBMS.

21. Explain Joins and DDL commands with examples.

22. Explain about programs to Retrieve and save Data with examples.

23. Describe in detail, Data storage methods.

24. Explain web server DataBase fundamentals.

NOVEMBER 2012 51309//SAE5B/SAZ5A

PART-A

1. What are the basic components of a DBMS?

2. What is meant by first normal forms?

3. Define :Data Dictionary?

4. What is SQL?

5. What is subqury and in what situvation it is useful?

6. What is the purpose of subforms?

7. What are main report types?

8. Define:Procedural Language.

9. What is the purpose of form events?

10. Define:Clustural Analysis.

11. Who is DBA?

12. Distinguish between Physical security and logical security.

PART-B

13.Write short note on: Data types.

14.Discuss on converting class Diagram to Normalized Tables, with examples.

15.Write short notes on: DDL Statements.

16.Discuss briefly on Form Layouts.

17.Write short note on: Table operations.

18.Discuss in detail, Data partitioning.

19.Write about Database Tasks by Development stages.

PART-C

20.What are the advantages of a DBMS? Explain them.

21.Explain the computation using queries with suitable examples.

22.Explain creating forms with example.

23.Explain user interface features.

24.Describe in detail ,Distributed Databases.

APRIL-2013 SAE5B/SAZ5A

PART-A
1. List down the advantages of a DBMS.
2. Define : Class diagrams.
3. What are Events?
4. What is the basic structure of the SQL SELECT command?
5. Define : DLL.
6. List the basic human factors design elements.
7. What are Tabular forms?
8. List the primary sections of Reports.
9. Write the purpose of the SAVEPOINT technique.
10. Write a note on: Data partitioning.
11. What tasks are performed by a DBA.
12. Define: A file-server.

PART-B

13. Explain associations and relationships with examples.
14. Write short notes on: Domain-Key normal form.
15. Explain Testing queries with examples.
16. Discuss briefly on creating forms with examples.
17. Explain Error handling with examples.
18. Discuss on Transactions with examples.
19. Explain about Application types.

PART-C

20. Explain about BCNF and 4NF with examples.
21. Describe in detail, Queries with Multiple tables with examples.
22. Explain Direct manipulation of Graphical objects.
23. Describe Custom reports with examples.
24. What are Client/Server databases? Explain.

NOVE-2013 SAE5B/SAZ5A
PART-A
1. What is DBMS? Give definition.
2. What is the usage of report writer?
3. What are basic data types to define an attribute?
4. What are queries?
5. List down the basic arithmetic operators.
6. What is meant by join operators?
7. What are the basic SQL DDL commands?
8. Write down the basic types of forms.
9. What are the primary sections of reports?
10. What are the primary data storage methods?
11. What is the role of a database administrator?
12. What are the strengths of a distributed database?

PART-B
13. What are the components of a DBMS system? Explain.
14. Explain the Entity- relationship diagram with class.
15. Discuss Boyce codd Normal form.
16. Write a note on aggregation operations.
17. How to handle the unexpected errors? Explain
18. Write a short note on data clustering.
19. Describe the client/server database.

PART-C
20. Explain in detail about 1NF,2NF, and 3NF.
21. What is subquery, nested subquery and the SQL operators in IN, ALL, ANY & EXISTS operation?
22. What are the common controls to build a form? Explain.
23. Explain in detail about the user interface features.
24. What are the development stages of a database tasks?

APRIL - 2014 SAE5B/SAZ5A

PART- A

1. What is a database?

2. Define entity, class and objects.

3. What is encapsulation and why is it important?

4. State any three SQL aggregate functions.

5. Define : Relational algebra.

6. What are the basic properties for forms?

7. List the various report layout elements.

8. Distinguish between horizontal and vertical partitioning.

9. Define : ‘transaction’.

10. State the problems of logical security.

11. What is a distributed database? List its advantages.

12. What is recovery in a database?

PART -B

13. What are the primary benefits provided by a DBMS.

14. Discuss about various association details.

15. Discuss about SQL data manipulation commands.

16. Explain any three controls on forms.

17. Explain the concept of data clustering and data partitioning.

18. Explain the primary role of the data administrator

19. Discuss the three tier Client/Server model.

PART- C

20. Explain the components of database management systems.

21. Explain the process of joining tables in a query.

22. Discuss about report design.

23. Describe the three primary data storage methods.

24. Describe the database tasks by development stages.

NOVEMBER- 2014 SAE5B/ SAZ5A

SECTION- A

1. Define the term ‘DBMS’.

2. What is the purpose of a class diagram?

3. What are the primary data types used in business applications?

4. What is the purpose of outer joins?

5. What is view?

6. State the various controls on forms.

7. Why would you need to use procedural code when SQL is so powerful?

8. Define transaction with an example.

9. What are the three primary options of the Resume statement?

10. State the physical security controls.

11. State the problems of logical security.

12. What is a disaster plan?

SECTION - B

13. Explain the costs and benefits of the feasibility study.

14. Explain the process of converting a class diagram to normalized tables with an example.

15. Discuss about SQL data definition commands.

16. Explain the human factors design elements for effective design of reports and forms.

17. Explain the concept of data clustering and data partitioning.

18. Discuss about backup and recovery.

19. Explain the Web as a Client/Server System.

SECTION - C

20. Describe the class diagram association details.

21. Discuss about subtotals and GROUP BY statement in SQL.

22. Explain the four basics types of forms.

23. Describe the three primary data storage methods.

24. Discuss about database security and privacy.

APRIL-2015 SAE5B / SAZ5A

PART-A

1. Define Foreign key.
2. Define Relational Database.
3. What is normalization?
4. Write the differences between DDL and DML.
5. Write the general meaning of Outer Join.
6. How to create a table? Give one example.
7. What is subform?
8. Write down the primary functions for error handling.
9. What is data partitioning?
10. write the difference between centralized and distributed database.
11. Who is DBA?
12. What is the use of backup?

PART-B

13. Write a note on feasibility study.
14. What is functional dependency? Explain 2NF.
15. Explain subtotals and group by command.
16. Write a note on aggregation operators.
17. How to enter the data on forms using controls?
18. Write a note on Table Operations.
19. What is security and privacy? Describe briefly.

PART-C

20. How to convert the class diagram to Normalized table? Explain in detail.
21. Explain about the sub queries in detail.
22. How to write the programs to retrieve and save data?
23. What are the data storage methods available? Explain
24. Describe about the client / server database.

Nove-2015 SAE5B/SAZ5A

Part -A

1. What is Data Dictionary?
2. What is the purpose of a feasibility study?
3. Define: Class Diagram.
4. What is meant by Second Normal From?
5. Define : DML
6. What are Reports?
7. What do you mean by Transaction?
8. Define: Sequential Organization.
9. Write a note on : primary key
10. What is meant by Distributed Data Base?
11. Define : HTML.
12. What is meant by Object Oriented Database?

Part -B

13. Discuss the advantages of DBMS.
14. Write Short Notes on : Data Types.
15. Explain briefly on: Query Basics.
16. Discuss about Testing Queries.
17. Explain about Direct Manipulation of Graphical Objects.
18. Discuss the Table Operations.
19. Write Short Notes on : Client /Server Databases.

Part - C

20. Describe about various Components of a DBMS.
21. Explain various Joins with examples.
22. Explain about Effective Design of Forms and Reports.
23. Describe about Data clustering and Partitioning.
24. Explain the Database Tasks by Development Stages.

APRIL-2016 SAE5B/SAZ5A

Part- A

List the components of a DBMS.
What is meant by Table?
List the data types in SQL Server.
What is meant by First Normal Form?
Define :DDL
What are Graphical objects?
What do you mean by validation?
Define : Switchboard Forms.
Write a note on: Events.
What is the primary role of the Data Administrator?
List the Database Tasks by Development Stages.
What is meant by Client/Server Database?

Part -B

13. Discuss about Feasibility Study.

14. Write Short Notes on : Class Diagrams

15. Explain briefly on : Computation Using Queries.

16. Discuss about JOINS with examples.

17. Write Short Notes on : Procedural Languages.

18. Discuss about Distributing Application.

19. Write Short Notes on: Web as a Client/Server system.

Part -C

20. Describe about Converting Class Diagrams to Normalized Tables with examples.

21. Explain the Queries with Multiple Tables with suitable examples.

22. Explain about Programs to Retrieve and Save Data.

23. Describe about Data Storage Methods.

24. Explain about Database Administration.