UML Interview Questions

 

1.                   What is UML?

Project Management Interview Questions

What is project management?

Is spending in IT project’s constant through out the project?

Who is a stakeholder ?

Can you explain project life cycle ?(Twist :- How many phases are there in
software project ?)

Are risk constant through out the project ?

Can you explain different software development life cycles ?

What is triple constraint triangle in project management ?

What is a project baselines ?

What is effort variance?

How is normally a project management plan document organized ?

Oracle Interview Questions

  1. List components of an Oracle instance?
  2. Which background process and associated database component guarantees that committed data is saved even when the changes have not been recorded in the data files?
  3. What is the maximum number of database writer processes allowed in an Oracle instance?
  4. Which background process is not started by default when you start up the Oracle instance?
  5. Describe a parallel server configuration.
  6. Choose the right hierarchy, from largest to smallest, from this list of logical database structures.

OOPS Interview Questions

What is Object Oriented Programming ?

What’s a Class ?

What’s a Object ?

What’s the relation between Classes and Objects ?

What are different properties provided by Object-oriented systems ?(Twist :- Can
you explain different properties of Object Oriented Systems?)(Twist :- What’s
difference between Association , Aggregation and Inheritance relationships?)

How can we acheive inheritance in VB.NET ?

What are abstract classes ?

What’s a Interface ?

.Net Multi Threading Interview Questions

What is Multi-tasking ?

What is Multi-threading ?

What is a Thread ?

Did VB6 support multi-threading ?

Can we have multiple threads in one App domain ?

Which namespace has threading ?

Can you explain in brief how can we implement threading ?

How can we change priority and what the levels of priority are provided by .NET
?

What does Addressof operator do in background ?

How can you reference current thread of the method ?

What’s Thread.Sleep() in threading ?

SQL Server Interview Questions

What is normalization? What are different type of normalization?

What is denormalization ?

What is a candidate key ?

What are different types of joins and whats the difference between them ?

What are indexes and What is the difference between clustered and nonclustered
indexes?

How can you increase SQL performance ?

What is the use of OLAP ?

What’s a measure in OLAP ?

What are dimensions in OLAP ?

What are levels in dimensions ?

IIS Interview Questions

General IIS related questions

Database Interview Questions

What is normalization
-    What is an index and types of indexes. How many number of indexes can be used per table
-    What is a constraint. Types of constraints
-    What are code pages
-    What is referential integrity
-    What is a trigger
-    What are different types of joins
-    What is a self join
-    Authentication mechanisms in Sql Server
-    What are user defined stored procedures.
-    What is INSTEAD OF trigger

Data Warehouse Interview Questions

  1. What is the data type of the surrogate key?
  2. What are the steps to build the data warehouse?
  3. What are the different architectures of data warehouse?
  4. What are the advantages data mining over traditional approaches?
  5. What is the difference between view and materialized view?
  6. What is the main difference between Inmon and Kimball philosophies of data warehousing?
  7. What is junk dimension? what is the difference between junk dimension and degenerated dimension?

.Net Interview Questions

  1. Explain the .NET architecture.
  2. How many languages .NET is supporting now? - When .NET was introduced it came with several languages. VB.NET, C#, COBOL and Perl, etc. The site DotNetLanguages.Net says 44 languages are supported.