Dept. of Computer Science, St.PiousX College: September 2011

Monday 26 September 2011

Bsc paper-III DBMS question bank

DBMS QUESTION BANK FOR FINAL BSC PAPER III CHAPTER WISE

Chapter 1

1. What is database and DBMS? What are the advantages of DBMS?

2. What are the different types of DBMS?

3. What is file system management? What are the advantages and disadvantages of file system management?

4. Explain different components of database environment with a neat diagram?

5. Explain all DBMS functions in detail.

6. Explain costs and risks of database approach.

7. Explain in detail range of applications.

Chapter 2

1. What are business rules? How do you discover them and translate them into data model components?

2. What are the different types of data models? Explain them in detail.

3. Explain different data models based on degree of abstraction.

4. What is E-R model? Explain.

Chapter 3

1. Explain different keys and integrity constraints available in DBMS.

2. What are relational set operators? Explain them in detail.

3. What is a relationship? Explain different types of relationships in detail.

4. Explain different Codd’s relational database rules.

Chapter 4

1. What is an entity? What are strong and weak entities and associative entities?

2. What is an attribute? Explain different types of attributes.

3. What is a relationship? Explain weak and strong relationships with examples.

4. What is a degree of relationship? Explain various degrees of relationships in detail.

5. Explain step wise procedure of how do you develop an ER diagram using an example of tiny college.

6. What are various database design challenges while developing an ER diagram.

7. Explain key decisions in physical database design.

Chapter 5

1. What is normalization? Explain 1^st, 2^nd and 3^rd normal forms with examples.

2. Explain Boyce-Codd normal form, 4^th normal form with examples.

3. Explain denormalization.

Chapter 6

1. What are super types and sub types? Explain them in detail.

2. Explain specialization hierarchy and inheritance.

3. Explain subtype discriminator, disjoint and overlapping constraints and completeness constraints.

4. Explain entity clustering.

5. Explain when to use primary keys, composite primary keys and surrogate primary keys.

6. Explain at least 2 design cases in flexible database design.

7. Explain attribute inheritance with example.

Chapter 7

1. Explain different DDL, DML AND DCL commands in detail with examples.

2. Explain different data types in SQL? Explain the syntax of creating a table.

3. Explain different SQL constraints and indexes creation with examples.

4. Explain the complete syntax of select statement? What are the different comparision and logical operators used in it.

5. Explain some special operators used in SQL.

6. How do you add and drop columns for a table using advanced data definition commands.

7. What are order by, group by and having clauses? Explain them with suitable examples.

8. What are aggregate functions? Explain them in detail with examples.

9. What are views or virtual tables? Explain their creation.

10. Explain different types of joins with suitable examples.

Chapter 8

1. What are relational set operators? Explain with examples.

2. Explain join operators with using and on clauses.

3. What are queries? Explain them with where, in, having, any, all and from clauses.

4. What are correlated sub queries? Explain them with suitable examples.

5. Explain different SQL functions of various categories with suitable examples.

6. What are oracle sequences? How are they created and used?

7. What are updatable views? Explain how are they updated?

8. What are triggers? Explain with suitable examples

9. Explain stored procedures with suitable examples.

10. Explain PL/SQL processing with cursors with suitable examples.

11. What are PL/SQL stored functions? How are they created?

Chapter 9

1. What is information system? Explain system development life cycle(SDLC) in detail.

2. Explain all steps of DBLC in detail. (each step can be an individual question).

3. Explain database design strategies.

4. Differentiate between centralized and decentralized design.

Chapter 10

1. What is a transaction? Explain transaction properties and transaction log.

2. Explain different problems of concurrency control.

3. Explain concurrency control with locking methods.

4. Explain different types of locks and two phase locking system for serializability.

5. What are dead locks? What are basic techniques to control deadlocks.

6. Explain concurrency control with time stamping methods.

7. Explain concurrency control with optimistic methods.

8. What is database recovery? Explain various techniques used to recover the databases.

Chapter 12

1. What are the advantages and disadvantages of distributed database management systems.

2. What are the characteristics of distributed database management systems.

3. What is distributed processing in distributed databases.

4. Explain the various components of distributed databases.

5. Explain in detail various levels of data and process distribution.

6. Explain various distributed database transparency features.

7. Explain various levels of distribution transparency and also explain various query cases related to it.

8. What is transaction transparency? Explain about distributed requests and distributed transactions.

9. Explain distributed concurrency control. Explain two phase commit protocol.

10. What is performance transparency and query optimization.

11. Explain various steps in distributed database design including fragmentation, replication and allocation.

12. Explain various C.J. DATE’s twelve commandments for distributed databases.

Chapter 13

1. What is business intelligence? Explain business intelligence architecture and framework. Explain its components.

2. Differentiate between decision support data and operational data.

3. Explain decision support database requirements.

4. What is a data warehouse? What are its characteristics? How do you create it?

5. Explain the twelve rules to define a data warehouse.

6. What is OLAP? Explain its four main characteristics.

7. Explain OLAP architecture in detail.

8. What is relational OLAP? Explain its extensions.

9. What is multidimensional OLAP? Differentiate between relational AND multidimensional OLAP.

10. Explain star schema data modeling technique and its components in detail.

11. Explain about attribute hierarchies.

12. Explain star schema representation and performance improving techniques for star schema.

13. Explain various factors common in implementing data warehouse.

14. Explain data mining in detail.

15. Mention the various SQL extensions of OLAP and explain in detail about roll up, cube and material views extensions.

B.Sc paper-IV OPERATING SYSTEM QUESTION BANK

OPERATING SYSTEM

QUESTION BANK

UNIT-I

1. What is an Operating System

2. Explain the following

a. Multi Programming System

b. Time Sharing System

c. Distributed Systems

d. Real time Systems

3. What is an interrupt .Explain how interrupts are handled?

4. Explain in detail about storage structure Hierarchy and caching

5. Explain I/O structure (this includes DMA) Or What is DMA

6. Explain inn detail computer system architecture?

a)single processor system

b)multi processor systems

c)clustered system

7. what is dual mode operation?

8. write about timer?

9. what are the responsibilities of operating system in connection with

a) process management

b)memory management

c)storage management

d)protection and security

10. write about caching?

11. Write briefly about I/O systems?

12. Write short notes on Special purpose systems?(Real time Embedded systems, Multi media systems,

Handheld systems).

13. Write short notes on computer environment

a)Traditional computing

b)Client-Server computing

c)Peer-to-Peer computing

d)Web-based computing

14. Compare Traditional computing and Client-Server computing?

15. What are the various operating system services?

16. Explain briefly operating system interfaces?

a)Command interpreter

b)Graphical user interface

17. What is a system call. Explain briefly how system calls are handled?

18. What are the various types of system calls ? Explain briefly.

19. Write short notes on system programs?

20. Explain briefly operating system design and implementation?

21. What are the various types of operating structures ? Explain briefly.

a)Simple Structure

b)Layered Approach

c)Micro Kernels

d)Modules

22. Explain about vitual machines?

23. Write short notes on

a)VMware

b)Java Vitual Machine

24. What is System Boot?

25. What is a process, process state and process control block (PCB).
      26. What are various scheduler .Explain briefly.(Long-Term , Short-Term, Medium-Term)
      27. What is a 'context switch'?
      28. Explain briefly about the operations on processes.
                a) Process Creation
                b) Process Termination.
   29. Explain in detail Inter Process Communication.
            a)Shared Memory
            b)Message Passing
30. Explain IPC System with example?
31.  Explain communications in Client-Server systems.
              a) Sockets
              b)Remote procedure calls
              c)Remote method invocation.

Saturday 24 September 2011

Bsc paper-ii java question bank

BSC(Computer Science) QuestionBank

PAPER-II

Subject: Object Oriented Programming with Java and Data Structures

Unit-I

1. What is OOP? Explain the basic concepts of OOPS with examples?

2. What are the Benefits and Applications of OOPs?

3. What are the features of JAVA?

4. How much JAVA differs from C and C++?

5. How JAVA associated with internet and brings out its contribution to WWW?

6. What are web browsers? Explain various types?

7. What are the hardware and software requirements of java? Explain

the systems that supports java, required for java?

8. What are tools that are included in JDK. Explain with the flow chart? What are mostly used packages?

9. Explain a simple java program and the unique features of a program?

10. Write program to find the area of a room. Explain the basic structures of a java program?

11. What are java Tokens and five types of tokens in java?

12. Classification of java statements with diagram?

13. What are the steps involved in implementation of java program?

14. What are command line arguments? Explain with simple program?

15. What are the various types of constants which java supports?

16. What are the 2 ways .Through which we can assign values to variables?

17. Write a program to illustrate how to read data from the keyboard?

18. What are the 3 kinds of java variables .Describe briefly the problems which arise using symbolic constants?

19. What is type casting? Explain briefly? Program to illustrate to creation and casting of a program?

Unit-II

1.Explain abiut arithmetic operators with examples?

2.What are the different types of Relational operators.Explain with a program?

3.What are the different types of logical operators? Explain the concept of assignment operators with advantages using them?

4.How many types of If statements are there?Explain with syntax and examples.

5.Write a program which illustrates switch case statement?

6.What is looping?what are the four steps which are included in the looping process?Explain while loop with examples?

7.How is the execution of for loop done? Write a program to compute the ‘power of 2’using for loop?

8.How is the nesting done in for loops?

9.How are the jumps done in loops? Explain with example?

10.How are the labels defined in Java? Illustate it with the program?

11.What is class? How are variables and methods defined in class?

12.How do you create objects? How are the members of the class accessed using objects?

13.Write a program to calculate area of room using classes?

14.What is a Constructor? When the constructor is invoked and how?

15.Define method overloading? Write a program to illustrate it?

16.What is the purpose of using static members and write a program using static?

17.Explain the concept of inheritance with examples and also write a program?

18.What are the different types of inheritance .Explain?

19.What are access modifiers? How many types of access modifiers are there?

Unit-III

1.What is an Array? How is an array created in a one-dimensional array? Explain with examples?

2.Write a program to sort the elements in an array?

3.Explain two-dimensional arrays with examples?

4.Write a program to illustrate two dimensional array?

5.How can we implement strings? Write a program to sort the strings in alphabetical order?

6.Write a program to illustrate the manipulation of strings?

7.What is the class used to create generic dynamic arrays? What are its advantages?

8.What is the difference between autoboxing and unboxing>

9.What are the advantages of using enumerated types? Write a program to illustrate it?

10.What are interfacse? Define them with examples? How can they be extended?

11.How can ca class implement interfaces? Write a program using interfaces?

12.write a program to show that interfaces supports multiple inheritance?

13.What are packages? Briefly list the benefits of packages?

14.Differentiate between java API packages and system packages?

15.How can the packages be used in other classes or clients?

16.What is static import? Explain its use?

17.How will you declare a class inorder to hide them?

18.How can we add classes to an existing package? Explain briefly?