ANU Database Management Systems ( 3rd B.Sc computers) Important Questions

Here are the ANU Database Management Systems ( 3rd B.Sc computers) Important Questions. All units question are available here and you can get prepare them.

UNIT-I

Chapter-I( Database Systems)

1. What are the advantages and functions of DBMS?
2. What are the main components of a database system?
3. What is file system? What are the major disadvantages of file system?

Chapter-II (Data Models)

1. What is Data Model? Explain different types of data models with examples.
2. Explain different levels of  Abstraction OR Explain three levels of DBMS architecture.
3. What is Business Rule? What is its purposing in data modeling? Write their characteristics.

Chapter-III( The Relational Database Model)

1. Write different advantages and disadvantages of Relational Database Model.
2. Explain different types of keys used in database models.
3. Explain relational set operators.
4. Write about Codd's Relational Database Rules.

UNIT-II

Chapter-I (Entity Relation Ship Model)

1. What is entity? Explain different types of entities.
2. What is attribute? Explain different types of attributes.
3. Explain ER-Model with the help of a suitable example.
4. Explain connectivity and cordiality with examples.
5. Explain Degree of relationship.

Chapter-II ( Advanced data modeling)

1. What is EER? Explain entity super type and sub type.
2. Discuss about constraints specified on super type and sub type relation ships.
3. What is attribute inheritance? Why is it important.
4.  What is surrogate key and when should you use one.

Chapter-III ( Normalization of Database Tables)

1. What is normalization? Discuss various steps in normalization with net sketch?
2. Explain basic normal forms with examples.
3. Explain advanced normal forms with examples.
4. Define and discuss about multi valued and transitive dependence with example.
5. What is anomaly? What are three types of anomalies caused by database.

UNIT-III

Chapter-I ( Introduction to SQL)

1. Explain various DDL and DML commands with examples in SQL
2. Define SQL? Write its features.
3. Discuss about different types of arithmetic functions in SQL
4. Discuss about different types of group functions in SQL
5. Discuss integrity constraints in SQL with suitable example?
6. Write about ORDER BY clause, GROUP BY clause and HAVING clause with examples.
7. Explain about BETWEEN, IS NULL, LIKE, IN, EXISTS Special operators used in SQL
8. What is an Index? Explain how to create an index in SQL.
9. What is view or Virtual Tables? Explain how to create a view in SQL.

Chapter-II

1. Explain SQL join operators with examples.
2. What is correlated sub-queries and sub-queries? Explain with an example.
3. What is function? Explain group functions( Aggregation) in SQL.
4. What are Triggers? How they are useful? Explain.
5. Differentiate Triggers with procedures.
6. Explain in detail about the stored procedures with examples 
7. Explain in detail about the cursors with examples
8. Write short note on embedded and dynamic SQL?

Chapter-III ( Database Design)

1. Discuss about system development life cycle (SDLC).
2. Explain in detail about the database life cycle (DLC).
3. Distinguish between centralized Vs. Decentralized Database Design
4. What are the factors influence DBMS software selections?

UNIT-IV 

Chapter-I ( Transaction Management and Concurrency control)

1. What is Transaction? Explain various states of Transaction?
2. Explain concurrency control with locking methods?
3. Explain concurrency control with time stamping methods?
4. Explain concurrency control with optimistic methods?
5. Explain Transaction Recovery?
6. What is Deadlock? Discuss techniques to control deadlocks.

Chapter-II (Distributed Database Management Systems)

1. What is DDBMS? Explain it advantages and disadvantages of DDBMS.
2. What are the components of DDBMS.
3. Distinguishes between distributed database and client/server architecture.
4. Explain database recovery management.
5. Explain performance transparency and query optimization?
6. What is serviceability? Explain in detail.

Acharya Nagarjuna University UG & PG Distance Exams Time Tables December-2015

Here are the Acharya Nagarjuna University UG & PG Distance Exams Time Tables December-2015. The university is allotted holidays for IBPS exams dates. Here are the detailed time tables.

Download details UG & PG Distance Exams Time Tables

Acharya Nagarjuna University Computer Based Documentation and Account Package Important Questions

Here are the Acharya Nagarjuna University Computer Based Documentation and Account Package Important Questions for 2nd B.Com Computer students. All the important Questions are presented into two groups like shot answer question and long answer question for each unit.

Unit-I

Short Answer Questions

1. What is a Document? How we can create a document in MS-Word?
2. Explain about Header and Footer in MS-Word with one example.
3. Write short notes on editing text of a document.
4. Explain about end notes and foot notes
5. How to move and copy text in a document?
6. Write about Cut,Copy, Paste options in MS-Word.
7.  Explain about formatting characters in MS-Word.
8. Explain different views in MS-Word.
9. How to give borders and  shadings in MS-Word.
10. What is the use of Autoformat and format painter in MS-Word.?
11. How to insert page numbers Or Date and Time in Headers and Footers in MS-Word.?

Long Answer Questions

1. What are the feature of MS-Word.? Explain the parts in word window.
2. Explain the features and advantages of word processor.
3. Write about text formatting in a document in detail.
4. What are headers and footers? Explain how to create Headers and Footers in MS-Word.

Unit-II

Short Answer Questions

1. What is Template? Explain.
2. How to create table in MS-Word.? Explain.
3. How to insert objects in a document
4. How to import graphics in MS-Word?

Long Answer Questions

1. How tables are created and handled in MS-Word?
2. How to create a table in MS-Word? How to use sorting and filtering techniques in a table.
3. What is template? How to create a template and how to set your new document ?
4. What is table? How to do cell and data formatting in a table?
5. What is Wizard ? Explain about various types of wizards in MS-Word.
6. How to create Tabs and Tables in MS-Word and explain with suitable example.

                             OR

1. What is Graphs? Explain about different types of graphs in MS-Word.
2. How to insert graphs into word document ? And explain usage of clip of art gallery in word.
3. How can you import graphics and explain about drawing objects?

Unit-III

Short Answer Questions

1. Explain any two toolbars in MS-Word
2. What is Mail merge and explain about it ?
3. How to import graphics into a word document?
4. How to draw objects using words drawing features?
5. Explain Find and Replacement in MS-Word?
6. Write about spelling and gamer checker ?

Long Answer Questions

1. What is Mail Merge ? Explain how to create a mail merge in MS-Word?
2. Explain various short cut keys present in MS-Word? Explain each of them.
3. What is Macro? Explain how to read a macro in MS-Word?
4. Explain about the customizing Toolbars and menus in MS-Word?
5. Explain about spell check and clip art in MS-Word 

Unit-IV

Short Answer Questions

1. How can you editing and moving text in Power Point Presentation ?
2. Explain about slide numbering with examples.
3. How can you insert and delete slides in power point.
4. How to print a presentation of MS-Power point.
5. Explain about animation schema in a power point presentation.
6. What are the steps to open the MS-Power Point?

Long Answer Questions

1. Explain different types of slide present in MS-Power Point
2. How to add multimedia to power point presentation?
3. How to work with text  in MS-Power Point?
4. What is a graph? Explain how can we insert a graph in power point presentation?
5. What is a slide? Explain different views of a slide?
6. How to use graphics and multimedia in a presentation?
7. Explain different components of MS-Power Point Window.

Unit-V

Short Answer Questions

1. How to create accounts master in tally
2. Explain about Daybook summaries.
3. Write about chart of accounts.
4. What is a ledger? How to create a ledger in tally?
5. Explain the features of Tally?
6. What are the steps in creation of cash book?

 Long Answer Questions

1. What is a voucher? Explain about Voucher Entry.
2. Explain how to create a ledger with suitable examples.
3. How to create Trial Balance in Tally
4. Explain all the functional keys in Tally.
5. What are the advantages of tally? Explain in detail.
6. Write the procedure to prepare the day book and trail balance- using vouchers.
7. Write a steps to create Accounts master lists.