Showing posts with label CS. Show all posts
Showing posts with label CS. Show all posts

Tuesday, October 25, 2011

DBMS-Interview Questions

Database Questions

  1. What are the different types of joins?
  2. Explain normalization with examples.
  3. What cursor type do you use to retrieve multiple recordsets?
  4. Diffrence between a "where" clause and a "having" clause
  5. What is the difference between "procedure" and "function"?
  6. How will you copy the structure of a table without copying the data?
  7. How to find out the database name from SQL*PLUS command prompt?
  8. Tadeoffs with having indexes
  9. Talk about "Exception Handling" in PL/SQL?
  10. What is the diference between "NULL in C" and "NULL in Oracle?"
  11. What is Pro*C? What is OCI?
  12. Give some examples of Analytical functions.
  13. What is the difference between "translate" and "replace"?
  14. What is DYNAMIC SQL method 4?
  15. How to remove duplicate records from a table?
  16. What is the use of ANALYZing the tables?
  17. How to run SQL script from a Unix Shell?
  18. What is a "transaction"? Why are they necessary?
  19. Explain Normalizationa dn Denormalization with examples.
  20. When do you get contraint violtaion? What are the types of constraints?
  21. How to convert RAW datatype into TEXT?
  22. Difference - Primary Key and Aggregate Key
  23. How functional dependency is related to database table design?
  24. What is a "trigger"?
  25. Why can a "group by" or "order by" clause be expensive to process?
  26. What are "HINTS"? What is "index covering" of a query?
  27. What is a VIEW? How to get script for a view?
  28. What are the Large object types suported by Oracle?
  29. What is SQL*Loader?
  30. Difference between "VARCHAR" and "VARCHAR2" datatypes.
  31. What is the difference among "dropping a table", "truncating a table" and "deleting all records" from a table.
  32. Difference between "ORACLE" and "MICROSOFT ACCESS" databases.
  33. How to create a database link ?

Operating Systems- Interview Questions

  1. What is MUTEX ?
  2. What isthe difference between a 'thread' and a 'process'?
  3. What is INODE?
  4. Explain the working of Virtual Memory.
  5. How does Windows NT supports Multitasking?
  6. Explain the Unix Kernel.
  7. What is Concurrency? Expain with example Deadlock and Starvation.
  8. What are your solution strategies for "Dining Philosophers Problem" ?
  9. Explain Memory Partitioning, Paging, Segmentation.
  10. Explain Scheduling.
  11. Operating System Security.
  12. What is Semaphore?
  13. Explain the following file systems : NTFS, Macintosh(HPFS), FAT .
  14. What are the different process states?
  15. What is Marshalling?
  16. Define and explain COM?
  17. What is Marshalling?
  18. Difference - Loading and Linking ?

Object-Orientation Concepts, UML interview Questions- For CS Students Only

  1. What is inheritance?
  2. Difference between Composition and Aggregation.
  3. Difference: Sequence Diagrams, Collaboration Diagrams.
  4. Difference: 'uses', 'extends', 'includes'
  5. What shall I go for Package Diagram?
  6. What is Polymorphism?
  7. Is class an Object? Is object a class?
  8. Comment: C++ "includes" behavior and java "imports"
  9. What do you mean by "Realization"?
  10. What is a Presistent, Transient Object?
  11. What is the use of Operator Overloading?
  12. Does UML guarantee project success?
  13. Difference: Activity Diagram and Sequence Diagram.
  14. What is association?
  15. How to resolve many to many relationship?
  16. How do you represent static members and abstract classes in Class Diagram?
  17. Can we use UML for user interface (UI) design?
  18. Every object has : state, behavior and identity - explain
  19. How to reverse engineer C++ code in UML?
  20. What are the tools you used for OOAD?
  21. Difference: Object Oriented Analysis (OOA) and Object Oriented Design (OOD)?
  22. What are the four phases of the Unified Process ?
  23. How do you convert uses cases into test cases?
  24. Explain Class Diagram in Detail.
  25. What are the Design Patterns you know.
  26. When do you prefer to use composition than aggregation?
  27. UML: IS it a process, method or notation?
  28. Does a concept HAVE to become a class in Design?
  29. What are the good practices to use while designing for reuse?
  30. Can you think of some nice examples where *multiple* actors are associated with a use case ?
  31. How to use CRC Cards for Class Design?
  32. What is the difference between static and dynamic Classificaition.Give some examples.
  33. Explian following terms: Constraint Rules, Design by contract.
  34. What is Object Constraint Language (OCL)?
  35. Difference Between Attribute and Association.
  36. What are associative classes?