Important questions of DBMS for III B.Com(CA)

Unit-1

1. Define a)Data  b)Data Base  c)Information d)DBMS
2. What are the Objectives of DBMS.
3. Explain the classification of DBMS.
4. Explain the history of DBMS.
5. Explain in detail about the three tier schema architecture of DBMS.

Unit-2

1. Discuss the main characteristics of the database approach and specify how it differs from traditional file system.
2. What are the drawbacks of File-Based System
3. Explain briefly about different types of Data Models.
4. Briefly explain Components of DBMS.
5. What are the responsibilities of DBA b) What are the different types of database end users? Discuss the main activities of each.
6. Write a note on Vendors and its products in DBMS.

Unit-3

1. Discuss in detail about the concepts of E-R model with suitable examples.
2. Explain the difference among Entity, Entity Type & Entity Set.
3. What is Attribute? Explain attribute classification.
4. What is Relationship? Explain Degree of Relationship.
5. Write a note on Generalization and Specialization with example.
6. Write different CODD's Rules in DBMS.
7. Explain about Set operators in Relational algebra. b) Explain about Mapping of Binary 1:1 relationship types and Binary M:N relationship type

Unit-4

1. Mention various DML operations with examples.
2. Describe the concept of Referential Integrity.
3. List and explain the common data types available in SQL.
4. What is a group function? List and explain how to use group functions in SQL with appropriate examples.
5. Explain Set Operations.

Unit-5

1. Explain the structure of PL/SQL.
2. Explain briefly about Control Structures in PL/SQL.
3. Write a note on Iterative Controls.
4. Define Cursor. Explain Active Set.
5. Explain different types of Triggers in PL/SQL.
6. Difference between Function and Package in PL/SQL.

Important questions of web technology for III B.Com(CA)

Unit-1

1. Explain briefly about different types of computer networks.
2. Write a note on LAN and WAN.
3. Explain briefly bout formatting text in HTML.
4. Describe the structure of HTML.
5. What are the different types of HTML Headings.
6. Write a brief note on Multimedia Objects.
7. Explain different types of List.
8. Write a note on Table and anchor tag.

Unit-2

1. Explain different types of style sheets in CSS.
2. Explain how to create a Block of information in CSS.
3. Explain properties and values of TEXT in CSS.
4. Explain Layers in CSS.

Unit-3

1. What is DHTML?
2. Explain Briefly about String and Mathematical functions in Javascript.
3. Explain briefly about Arrays in JavaScript.
4. What is a variable and operator in  JavaScript.

Unit-4

1. Explain objects in JS.
2. Explain briefly about Exception Handling in JS.
3. What are the events available in JS.
4. Explain briefly about Built-in Objects.

Unit-5

1. Explain data Validation.
2. Explain briefly about message and confirmation boxes.
3. Write a note on Roll over Buttons.
4. Explain briefly about Text Based Systems.