|
|
Posted by Jobs on 10/28/06 06:14
SQL Server and .NET Interview questions free download
You can get full downloads for all real interview questions from
www.questpond.com
Download the JAVA , .NET and SQL Server interview sheet and rate
yourself. This will help you judge yourself are you really worth of
attending interviews. If you own a company best way to judge if the
candidate is worth of it.
http://www.questpond.com/InterviewRatingSheet.zip
2000 Interview questions of .NET , JAVA and SQL Server Interview
questions (worth downloading it)
http://www.questpond.com/InterviewQuestions.zip
Core Java and OOP's Interview questions
http://www.questpond.com/OOPsAndCoreJava.zip
Servlets / JSP Interview questions
http://www.questpond.com/ServletsJSP.zip
Architecture Interview Question
http://www.questpond.com/ArchitectureInterviewQuestions.zip
Project Management Interview questions must to read for all aspiring
project managers
http://www.questpond.com/ProjectManagementInterviewQuestions.zip
Full Address book application in C# with technical specification ,
estimation and test cases
http://www.questpond.com/AddressbookProject.zip
Web services Interview questions
http://www.questpond.com/WebServicesAndRemoting.zip
SQL Server 2005 Database optimization Interview questions
http://www.questpond.com/DatabaseOptimization.zip
SQL Server 2005 DTS Interview questions
http://www.questpond.com/DTSInterviewQuestions.zip
SQL Server datawarehoue and Data mining Interview questions
http://www.questpond.com/DatawareHousingandDataMining.zip
SQLCLR Interview questions
http://www.questpond.com/SQLCLRInterviewquestion.zip
SQL Server XML Interview questions
http://www.questpond.com/SQLServerXML.zip
Basic .NET Framework interview questions
http://www.questpond.com/FrameWorkSampleInterviewQuestions.zip
..NET Interop and COM Interview questions
http://www.questpond.com/InteropdotnetInterviewQuestions.zip
ASP.NET Caching Interview questions
http://www.questpond.com/CachingInterviewQestions.zip
Localization globalization Interview questions
http://www.questpond.com/LocalizationAndGlobalization.zip
Do not know how estimations are done here's a complete book on it
http://www.questpond.com/HowtoPrepareSoftwareQuotations.zip
..NET Interview Questions Book Index
Introduction
Basic .NET Framework
NET Interoperability
Threading
Remoting and Webservices
Caching Concepts
OOPS
ASP.NET
..NET Architecture
ADO.NET
SQL SERVER
UML
Project Management
How to buy the book
SQL Server Interview Questions Book Index
Database Concepts
SQL
..NET Integration
ADO.NET
Notification Services
Service Broker
XML Integration
Data Warehousing/Data Mining
Integration Services/DTS
Replication
Reporting Services
Database Optimization
Transaction and Locks
JAVA Interview Questions Book Index
OOPS and CORE JAVA
Threading
Servlets and JSP
JDBC
EJB
Struts
XML and Web Services
JNI
Project Management
UML
..NET Interview Questions Book
Basic .NET Framework questions
What is IL? (Twist :- What is MSIL or CIL , What is JIT?)
What is the CLR?
What is the CTS?
What is CLS(Common Language Specification)?
What is Managed Code?
What is Assembly ?
What are different types of Assembly?
What is NameSpace?
What is Difference between NameSpace and Assembly?
If you want to view a Assembly how to you go about it (Twist : What is
ILDASM ?) ?
What is Manifest?
Where is version information stored of a assembly ?
Is versioning applicable to private assemblies?
What is GAC (Twist :- What are situations when you register .NET
assembly in GAC ?) ?
What is concept of strong names (Twist :- How do we generate strong
names or what is the process of generating string names , What is use
of SN.EXE , How do we apply strong names to assembly ? , How do you
sign an assembly ?)?
How to add and remove a assembly from GAC?
What is Delay signing ?
What is garbage collection?
Can we force garbage collector to run ?
What is reflection?
What are different type of JIT ?
What are Value types and Reference types ?
What is concept of Boxing and Unboxing ?
What's difference between VB.NET and C# ?
What's difference between System exceptions and Application
exceptions?
What is CODE Access security?
NET Interoperability
How can we use COM Components in .NET (Twist : What is RCW ?)?
Once i have developed the COM wrapper do i have to still register the
COM in registry?
How can we use .NET components in COM (Twist :- What is CCW (COM
callable wrapper) ?, What caution needs to be taken in order that .NET
components is compatible
with COM ?) ?
How can we make Windows API calls in .NET?
When we use windows API in .NET is it managed or unmanaged code ?
What is COM ?
What is Reference counting in COM ?
Can you describe IUKNOWN interface in short ?
Can you explain what is DCOM ?
How do we create DCOM object in VB6?
How to implement DTC in .NET ?
How many types of Transactions are there in COM + .NET ?
How do you do object pooling in .NET ?
What are types of compatibility in VB6?
Threading
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 ?
How can we make a thread sleep for infinite period ?
What is Suspend and Resume in Threading ?
What the way to stop a long running thread ?
How do i debug thread ?
What's Thread.Join() in threading ?
What are Daemon thread's and how can a thread be created as Daemon?
When working with shared data in threading how do you implement
synchronization ?
Can we use events with threading ?
How can we know a state of a thread?
what is a monitor object?
what are wait handles ?(Twist :- What is a mutex object ?)
what is ManualResetEvent and AutoResetEvent ?
What is ReaderWriter Locks ?
How can you avoid deadlock in threading ?
What's difference between thread and process?
Remoting and Webservices
What is an application domain?
What is .NET Remoting ?
Which class does the remote object has to inherit ?
What are two different types of remote object creation mode in .NET ?
Describe in detail Basic of SAO architecture of Remoting?
What is the situation you will use singleton architecture in remoting ?
What is fundamental of published or precreated objects in Remoting ?
What are the ways client can create object on server in CAO model ?
Are CAO stateful in nature ?
In CAO model when we want client objects to be created by "NEW"
keyword is there any precautions to be taken ?
Is it a good design practice to distribute the implementation to
Remoting Client ?
What is LeaseTime,SponsorshipTime ,RenewonCallTime and
LeaseManagerPollTime?
Which config file has all the supported channels/protocol ?
How can you specify remoting parameters using Config files ?
Can Non-Default constructors be used with Single Call SAO?(Twist :-
What are the limitation of constructors for Single call SAO ?)
How can we call methods in remoting Asynchronously ?
What is Asynchronous One-Way Calls ?
What is marshalling and what are different kinds of marshalling ?
What is ObjRef object in remoting ?
What is a WebService ?
What is UDDI ?
What is DISCO ?
What is WSDL?
What the different phase of acquiring a proxy object in Webservice ?
What is file extension of Webservices ?
Which attribute is used in order that the method can be used as
WebService ?
What are the steps to create a webservice and consume it ?
Do webservice have state ?
Caching Concepts
What is application object ?
What's the difference between Cache object and application object ?
How can get access to cache object ?
What are dependencies in cache and types of dependencies ?
Can you show a simple code showing file dependency in cache ?
What is Cache Callback in Cache ?
What is scavenging ?
What are different types of caching using cache object of ASP.NET?
How can you cache different version of same page using ASP.NET cache
object ?
How will implement Page Fragment Caching ?
What are ASP.NET session and compare ASP.NET session with classic ASP
session variables?
Which various modes of storing ASP.NET session ?
Is Session_End event supported in all session modes ?
What are the precautions you will take in order that StateServer Mode
work properly ?
What are the precautions you will take in order that SQLSERVER Mode
work properly ?
Where do you specify session state mode in ASP.NET ?
What are the other ways you can maintain state ?
What are benefits and Limitation of using Hidden fields ?
What is ViewState ?
Do performance vary for viewstate according to User controls ?
What are benefits and Limitation of using Viewstate for state
management?
How an you use Hidden frames to cache client data ?
What are benefits and Limitation of using Hidden frames?
What are benefits and Limitation of using Cookies?
What is Query String and What are benefits and Limitation of using
Query Strings?
OOPS
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 ?
What is difference between abstract classes and interfaces?
What is a delegate ?
What are event's ?
Do events have return type ?
Can event's have access modifiers ?
Can we have shared events ?
What is shadowing ?
What's difference between Shadowing and Overriding ?
What's difference between delegate and events?
If we inherit a class do the private variables also get inherited ?
What are different accessibility levels defined in .NET ?
Can you prevent a class from overriding ?
What's the use of "MustInherit" keyword in VB.NET ?
Why can not you specify accessibility modifier in Interface ?
What are similarities between Class and structure ?
What's a difference between Class and structure's ?
What does virtual keyword mean ?
What are shared (VB.NET)/Static(C#) variables?
What is Dispose method in .NET ?
Whats the use of "OverRides" and "Overridable" keywords ?
Where are all .NET Collection classes located ?
What is ArrayList ?
What's a HashTable ?(Twist :- What's difference between HashTable
and ArrayList ? )
What are queues and stacks ?
What is ENUM ?
What is nested Classes ?
What's Operator Overloading in .NET?
In below sample code if we create a object of class2 which constructor
will fire first ?
What's the significance of Finalize method in .NET?
Why is it preferred to not use finalize for clean up?
How can we suppress a finalize method?
What's the use of DISPOSE method?
How do I force the Dispose method to be called automatically, as
clients can forget to call Dispose method?
In what instances you will declare a constructor to be private?
ASP.NET
What's the sequence in which ASP.NET events are processed ?
In which event are the controls fully loaded ?
How can we identify that the Page is PostBack ?
How does ASP.NET maintain state in between subsequent request ?
What is event bubbling ?
How do we assign page specific attributes ?
Administrator wants to make a security check that no one has tampered
with ViewState , how can we ensure this ?
What's the use of @ Register directives ?
What's the use of SmartNavigation property ?
What is AppSetting Section in "Web.Config" file ?
Where is ViewState information stored ?
What's the use of @ OutputCache directive in ASP.NET?
How can we create custom controls in ASP.NET ?
How many types of validation controls are provided by ASP.NET ?
Can you explain what is "AutoPostBack" feature in ASP.NET ?
How can you enable automatic paging in DataGrid ?
What's the use of "GLOBAL.ASAX" file ?
What's the difference between "Web.config" and
"Machine.Config" ?
What's a SESSION and APPLICATION object ?
What's difference between Server.Transfer and response.Redirect ?
What's difference between Authentication and authorization?
What is impersonation in ASP.NET ?
Can you explain in brief how the ASP.NET authentication process works?
What are the various ways of authentication techniques in ASP.NET?
How does authorization work in ASP.NET?
What's difference between Datagrid , Datalist and repeater ?
>From performance point of view how do they rate ?
What's the method to customize columns in DataGrid?
How can we format data inside DataGrid?
How will decide the design consideration to take a Datagrid , datalist
or repeater ?
Difference between ASP and ASP.NET?
What are major events in GLOBAL.ASAX file ?
What order they are triggered ?
Do session use cookies ?
How can we force all the validation control to run ?
How can we check if all the validation control are valid and proper ?
If you have client side validation is enabled in your Web page , Does
that mean server side code is not run?
Which JavaScript file is referenced for validating the validators at
the client side ?
How to disable client side script in validators?
I want to show the entire validation error message in a message box on
the client side?
You find that one of your validation is very complicated and does not
fit in any of the validators , so what will you do ?
What is Tracing in ASP.NET ?
How do we enable tracing ?
What exactly happens when ASPX page is requested from Browser?
How can we kill a user session ?
How do you upload a file in ASP.NET ?
How do I send email message from ASP.NET ?
What are different IIS isolation levels?
..NET Architecture
What are design patterns ?
What's difference between Factory and Abstract Factory Pattern's?
What's MVC pattern? (Twist: - How can you implement MVC pattern in
ASP.NET? )
How can we implement singleton pattern in .NET?
How do you implement prototype pattern in .NET?(Twist: - How to
implement cloning in .NET ? , What is shallow copy and deep copy ?)
What are the situations you will use a Web Service and Remoting in
projects?
Can you give a practical implementation of FAÇADE patterns?
How can we implement observer pattern in .NET?
What is three tier architecture?
Have you ever worked with Microsoft Application Blocks, if yes then
which?
What is Service Oriented architecture?
ADO.NET
What is the namespace in which .NET has the data functionality classes
?
Can you give a overview of ADO.NET architecture ?
What are the two fundamental objects in ADO.NET ?
What is difference between dataset and datareader ?
What are major difference between classic ADO and ADO.NET ?
What is the use of connection object ?
What is the use of command objects and what are the methods provided by
the command object ?
What is the use of dataadapter ?
What are basic methods of Dataadapter ?
What is Dataset object?
What are the various objects in Dataset ?
How can we connect to Microsoft Access , Foxpro , Oracle etc ?
How do we connect to SQL SERVER , which namespace do we use ?
How do we use stored procedure in ADO.NET and how do we provide
parameters to the stored procedures?
How can we force the connection object to close after my datareader is
closed ?
I want to force the datareader to return only schema of the datastore
rather than data ?
How can we fine tune the command object when we are expecting a single
row or a single value ?
Which is the best place to store connectionstring in .NET projects ?
What are steps involved to fill a dataset ?(Twist :- How can we use
dataadapter to fill a dataset ?)
What are the various methods provided by the dataset object to generate
XML?
How can we save all data from dataset ?
How can we check that some changes have been made to dataset since it
was loaded ?(Twist :- How can cancel all changes done in dataset ? ,How
do we get changed value dataset ? )
How add/remove row's in "DataTable" object of "DataSet" ?
What's basic use of "DataView" ?
What's difference between "DataSet" and "DataReader" ?
How can we load multiple tables in a DataSet ?
How can we add relation's between table in a DataSet ?
What's the use of CommandBuilder ?
What's difference between "Optimistic" and "Pessimistic"
locking ?
How many way's are there to implement locking in ADO.NET ?
How can we perform transactions in .NET?
What's difference between Dataset. clone and Dataset. copy ?
SQL SERVER
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 ?
What are fact tables and dimension tables in OLAP ? (Twist :- can you
explain the star schema for OLAP ? )
What is DTS?
What is fillfactor ? (Twist :- When does plage split occurs ?)
What is RAID and how does it work ?
What's the difference between DELETE TABLE and TRUNCATE TABLE commands?
What are the problems that can occur if you do not implement locking
properly in SQL SERVER ?
What are different transaction levels in SQL SERVER ?(Twist :- what are
different types of locks in SQL SERVER ?)
What are different locks in SQL SERVER ?
Can we suggest locking hints to SQL SERVER ?
What is LOCK escalation?
What are the different ways of moving data/databases between servers
and databases in SQL Server?
What are advantages of SQL 2000 over SQl 7.0 ?
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
What is difference between UNION and UNION ALL SQL syntax ?
How can you raise custom errors from stored procedure ?
What is ACID fundamental and what are transactions in SQL SERVER ?
What is DBCC?
What is purpose of Replication ?
What are different type of replication supported by SQL SERVER ?
What is BCP utility in SQL SERVER ?
What are different types of triggers in SQl SERVER 2000 ?
If we have multiple AFTER Triggers on table how can we define the
sequence of the triggers ?
What is SQl injection ?
UML
What is UML?
How many types of diagrams are there in UML ?(Twist :- Explain in short
all types of diagrams in UML ?)
What are advantages of using UML?(Twist: - What is Modeling and why UML
?)
What's the sequence of UML diagrams in project?(Twist: - How did you
implement UML in your project?)
Just a small Twist: - Do I need all UML diagrams in a project?
Give a small brief explanation of all Elements in activity diagrams?
Explain Different elements of a collaboration diagram ?
Explain Component diagrams ?
Explain all parts of a deployment diagram?
Describe various components in sequence diagrams?
What are the element in State Chart diagrams ?
Describe different elements in Static Chart diagrams ?
Explain different elements of a Use Case ?(Twist: - What's difference
between Activity and sequence diagrams?(I leave this to the readers))
Project Management
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 ?
How do you estimate a project?
What is CAR (Causal Analysis and Resolution)?
How do you handle change request?
What is internal change request?
What is difference between SITP and UTP in testing ?
What are the software you have used for project management?
What are the metrics followed in project management?(Twist: - What
metrics will you look at in order to see the project is moving
successfully?)
You have people in your team who do not meet there deadlines or do not
perform what are the actions you will take ? (Twist :- Two of your
resources have conflict's between them how would you sort it out ?)
How do you start a project?
How did you do resource allocations?
How do you do code reviews ?
SQL Server Interview Questions Book
Database Concepts
What is a database or database management systems (DBMS)?
What's difference between DBMS and RDBMS ?
What are CODD rules?
Is access database a RDBMS?
What's the main difference between ACCESS and SQL SERVER?
What's the difference between MSDE and SQL SERVER 2000?
What is SQL SERVER Express 2005 Edition?
What is SQL Server 2000 Workload Governor?
What's the difference between SQL SERVER 2000 and 2005?
What are E-R diagrams?
How many types of relationship exist in database designing?
Can you explain Fourth Normal Form?
Can you explain Fifth Normal Form?
What's the difference between Fourth and Fifth normal form?
Have you heard about sixth normal form?
What is Extent and Page?
What are the different sections in Page?
What are page splits?
In which files does actually SQL Server store data?
What is Collation in SQL Server?
Can we have a different collation for database and table?
SQL
Revisiting basic syntax of SQL?
What are "GRANT" and "REVOKE' statements?
What is Cascade and Restrict in DROP table SQL?
What is a DDL, DML and DCL concept in RDBMS world?
What are different types of joins in SQL?
What is "CROSS JOIN"?
You want to select the first record in a given set of rows?
How do you sort in SQL?
How do you select unique rows using SQL?
Can you name some aggregate function is SQL Server?
What is the default "SORT" order for a SQL?
What is a self-join?
What's the difference between DELETE and TRUNCATE ?
Select addresses which are between '1/1/2004' and '1/4/2004'?
What are Wildcard operators in SQL Server?
What's the difference between "UNION" and "UNION ALL" ?
What are cursors and what are the situations you will use them?
What are the steps to create a cursor?
What are the different Cursor Types?
What are "Global" and "Local" cursors?
What is "Group by" clause?
What is ROLLUP?
What is CUBE?
What is the difference between "HAVING" and "WHERE" clause?
What is "COMPUTE" clause in SQL?
What is "WITH TIES" clause in SQL?
What does "SET ROWCOUNT" syntax achieves?
What is a Sub-Query?
What is "Correlated Subqueries"?
What is "ALL" and "ANY" operator?
What is a "CASE" statement in SQL?
What does COLLATE Keyword in SQL signify?
..NET Integration
What are steps to load a .NET code in SQL SERVER 2005?
How can we drop a assembly from SQL SERVER?
Are changes made to assembly updated automatically in database?
Why do we need to drop assembly for updating changes?
How to see assemblies loaded in SQL Server?
I want to see which files are linked with which assemblies?
Does .NET CLR and SQL SERVER run in different process?
Does .NET controls SQL SERVER or is it vice-versa?
Is SQLCLR configured by default?
How to configure CLR for SQL SERVER?
Is .NET feature loaded by default in SQL Server?
How does SQL Server control .NET run-time?
What's a "SAND BOX" in SQL Server 2005?
What is a application domain?
How are .NET Appdomain allocated in SQL SERVER 2005?
What is Syntax for creating a new assembly in SQL Server 2005?
Do Assemblies loaded in database need actual .NET DLL?
Does SQL Server handle unmanaged resources?
What is Multi-tasking ?
What is Multi-threading ?
What is a Thread ?
Can we have multiple threads in one App domain ?
What is Non-preemptive threading?
What is pre-emptive threading?
Can you explain threading model in SQL Server?
How does .NET and SQL Server thread work?
How are exception in SQLCLR code handled?
Are all .NET libraries allowed in SQL Server?
What is "Hostprotectionattribute" in SQL Server 2005?
How many types of permission level are there for an assembly?
Can you name system tables for .NET assemblies?
Are two version of same assembly allowed in SQL Server?
How are changes made in assembly replicated?
Is it a good practice to drop a assembly for changes?
In one of the projects following steps where done, will it work?
What does Alter assembly with unchecked data signify?
How do I drop an assembly?
Can we creat SQLCLR using .NET framework 1.0?
While creating .NET UDF what checks should be done?
How do you define a function from the .NET assembly?
Can compare between T-SQL and SQLCLR ?
With respect to .NET is SQL SERVER case sensitive?
Does case sensitive rule apply for VB.NET?
Can nested classes be accessed in T-SQL?
Can we have SQLCLR procedure input as array?
Can object datatype be used in SQLCLR?
How's precision handled for decimal datatypes in .NET?
How do we define INPUT and OUTPUT parameters in SQLCLR?
Is it good to use .NET datatypes in SQLCLR?
How to move values from SQL to .NET datatypes?
What is System.Data.SqlServer?
What is SQLContext?
Can you explain essential steps to deploy SQLCLR?
How do create function in SQL Server using .NET?
How do we create trigger using .NET?
How to create User Define Functions using .NET?
How to create User Defined Create aggregates using .NET?
What is Asynchronous support in ADO.NET?
What is MARS support in ADO.NET?
What is SQLbulkcopy object in ADO.NET ?
How to select range of rows using ADO.NET?
ADO.NET
Which are namespaces for ADO.NET?
Can you give a overview of ADO.NET architecture ?
What are the two fundamental objects in ADO.NET ?
What is difference between dataset and datareader ?
What are major difference between classic ADO and ADO.NET ?
What is the use of connection object ?
What are the methods provided by the command object ?
What is the use of dataadapter ?
What are basic methods of Dataadapter ?
What is Dataset object?
What are the various objects in Dataset ?
How can we connect to Microsoft Access , Foxpro , Oracle etc ?
What's the namespace to connect to SQL Server?
How do we use stored procedure in ADO.NET?
How can we force the connection object to close?
I want to force the datareader to return only schema?
Can we optimize command object when there is only one row?
Which is the best place to store connectionstring ?
What are steps involved to fill a dataset ?
What are the methods provided by the dataset for XML?
How can we save all data from dataset ?
How can we check for changes made to dataset?
How can we add/remove row's in "DataTable" object of
"DataSet" ?
What's basic use of "DataView" ?
What's difference between "DataSet" and "DataReader" ?
How can we load multiple tables in a DataSet ?
How can we add relation's between table in a DataSet ?
What's the use of CommandBuilder ?
What's difference between "Optimistic" and "Pessimistic"
locking ?
How many way's are there to implement locking in ADO.NET ?
How can we perform transactions in .NET?
What's difference between Dataset. clone and Dataset. copy ?
Whats the difference between Dataset and ADO Recordset?
Notification Services
What are notification services?
What are basic components of Notification services?
Can you explain architecture of Notification Services?
Which are the two XML files needed for notification services?
What is Nscontrols command?
What are the situations you will use "Notification" Services?
Service Broker
What do we need Queues?
What is "Asynchronous" communication?
What is SQL Server Service broker?
What are the essential components of SQL Server Service broker?
What is the main purpose of having Conversation Group?
How to implement Service Broker?
How do we encrypt data between Dialogs?
XML Integration
What is XML?
What is the version information in XML?
What is ROOT element in XML?
If XML does not have closing tag will it work?
Is XML case sensitive?
What's the difference between XML and HTML?
Is XML meant to replace HTML?
Can you explain why your project needed XML?
What is DTD (Document Type definition)?
What is well formed XML?
What is a valid XML?
What is CDATA section in XML?
What is CSS?
What is XSL?
What is Element and attributes in XML?
Can we define a column as XML?
How do we specify the XML data type as typed or untyped?
How can we create the XSD schema?
How do I insert in to a table which has XSD schema attached to it?
What is maximum size for XML datatype?
What is Xquery?
What are XML indexes?
What are secondary XML indexes?
What is FOR XML in SQL Server?
Can I use FOR XML to generate SCHEMA of a table and how?
What is the OPENXML statement in SQL Server?
I have huge XML file which we want to load in database?
How to call stored procedure using HTTP SOAP?
What is XMLA ?
Data Warehousing/Data Mining
What is "Data Warehousing"?
What are Data Marts?
What are Fact tables and Dimension Tables?
What is Snow Flake Schema design in database?
What is ETL process in Data warehousing?
How can we do ETL process in SQL Server?
What is "Data mining"?
Compare "Data mining" and "Data Warehousing"?
What is BCP?
How can we import and export using BCP utility?
What is Bulk Insert?
What is DTS ?
Can you brief about the Data warehouse project you worked on?
What is an OLTP (Online Transaction Processing) System?
What is an OLAP (On-line Analytical processing) system?
What is Conceptual, Logical and Physical model?
What is Data purging?
What is Analysis Services?
What are CUBES?
What are the primary ways to store data in OLAP?
What is META DATA information in Data warehousing projects?
What is multi-dimensional analysis?
What is MDX?
How did you plan your Data ware house project?
What are different deliverables according to phases?
Can you explain how analysis service works?
What are the different problems that "Data mining" can solve?
What are different stages of "Data mining"?
What is Discrete and Continuous data in Data mining world?
What is MODEL is Data mining world?
How are models actually derived?
What is a Decision Tree Algorithm?
Can decision tree be implemented using SQL?
What is Naïve Bayes Algorithm?
Explain clustering algorithm?
Explain in detail Neural Networks?
What is Back propagation in Neural Networks?
What is Time Series algorithm in data mining?
Explain Association algorithm in Data mining?
What is Sequence clustering algorithm?
What are algorithms provided by Microsoft in SQL Server?
How does data mining and data warehousing work together?
What is XMLA ?
What is Discover and Execute in XMLA?
Integration Services/DTS
What is Integration Services import / export wizard?
What are prime components in Integration Services?
How can we develop a DTS project in Integration Services?
Replication
Whats the best way to update data between SQL Servers?
What are the scenarios you will need multiple databases with schema?
How will you plan your replication?
What is a publisher, distributor and subscriber in "Replication"?
What is "Push" and "Pull" subscription?
Can a publication support push and pull at one time?
What are different models / types of replication?
What is Snapshot replication?
What are the advantages and disadvantages of using Snapshot
replication?
What type of data will qualify for "Snapshot replication"?
What's the actual location where the distributor runs?
Can you explain in detail how exactly "Snapshot Replication" works?
What is merge replication?
How does merge replication works?
What are advantages and disadvantages of Merge replication?
What is conflict resolution in Merge replication?
What is a transactional replication?
Can you explain in detail how transactional replication works?
What are data type concerns during replications?
Reporting Services
Can you explain how can we make a simple report in reporting services?
How do I specify stored procedures in Reporting Services?
What is the architecture for "Reporting Services "?
Database Optimization
What are indexes?
What are B-Trees?
I have a table which has lot of inserts, is it a good database design
to create indexes on that table?
What are "Table Scan's" and "Index Scan's"?
What are the two types of indexes and explain them in detail?
What is "FillFactor" concept in indexes?
What is the best value for "FillFactor"?
What are "Index statistics"?
How can we see statistics of an index?
How do you reorganize your index, once you find the problem?
What is Fragmentation?
How can we measure Fragmentation?
How can we remove the Fragmented spaces?
What are the criteria you will look in to while selecting an index?
What is "Index Tuning Wizard"?
What is an Execution plan?
How do you see the SQL plan in textual format?
What is nested join, hash join and merge join in SQL Query plan?
What joins are good in what situations? 298
Transaction and Locks
What is a "Database Transactions "?
What is ACID?
What is "Begin Trans", "Commit Tran", "Rollback Tran" and
"Save Tran"?
What are "Checkpoint's" in SQL Server?
What are "Implicit Transactions"?
Is it good to use "Implicit Transactions"?
What is Concurrency?
What kind of problems occurs if we do not implement proper locking
strategy?
What are "Dirty reads"?
What are "Unrepeatable reads"?
What are "Phantom rows"?
What are "Lost Updates"?
What are different levels of granularity of locking resources?
What are different types of Locks in SQL Server?
What are different Isolation levels in SQL Server?
If you are using COM+ what "Isolation" level is set by default?
What are "Lock" hints?
What is a "Deadlock" ?
What are the steps you can take to avoid "Deadlocks" ?
How can I know what locks are running on which resource?
JAVA Interview Questions Book
OOPS and CORE JAVA
What is JVM (Java Virtual Machine)?
What is JIT (Just-in-Time) Compilation?
What is Object Oriented Programming?
What's a Class?
What's an Object?
What's the relation between Classes and Objects?
What are different properties provided by Object-oriented systems?
How do you implement inheritance in Java?
How can we implement polymorphism in Java?
What's an interface and how will you go about implementing an
interface?
What is an Abstract class?
What are Abstract methods?
What's the difference between "Abstract" classes and
"Interfaces"?
What's difference between Static and Non-Static fields of a class?
What are inner classes and what's the practical implementation of
inner classes?
What are packages?
What is a constructor in class?
Can constructors be parameterized?
Can you explain transient and volatile modifiers?
What is the use if "instanceof " keyword?
What are Native methods in Java?
Explain in depth Garbage collector?
How does the garbage collector determine that the object has to be
marked for deletion?
Can you explain "finalize()" method?
How can we force the garbage collector to run?
What's the main difference between "Switch" and "If "
comparison?
What's the use of JAVAP tool?
What are applets?
In which package is the applet class located?
What are native interfaces in Java?
what are Class loader's?
what is Bootstrap, Extension and System Class loader?
Can you explain the flow between bootstrap, extension and system class
loader?
Can you explain how can you practically do dynamic loading?
How can you copy one array in to a different array?
Can you explain the core collection interfaces?
Can you explain in brief the collection classes which implement the
collection interfaces?
What's the difference between standard JAVA array and ArrayList
class?
What's the use of "ensureCapacity" in ArrayList class?
How can we obtain an array from an ArrayList class?
What is "LinkedList" class for?
Can you explain HashSet class in collections?
what is LinkedHashSet class?
what is a TreeSet class?
what's the use of Comparator Interface?
How can we access elements of a collection?
What is Map and SortedMap Interface?
Have you used any collection algorithm?
Why do we use collections when we had traditional ways for collection?
Can you name the legacy classes and interface for collections?
What is Enumeration Interface?
what's the main difference between ArrayList / HashMap and Vector /
Hashtable?
Are String object Immutable, Can you explain the concept?
what is a StringBuffer class and how does it differs from String class?
what is the difference between StringBuilder and StringBuffer class?
What is Pass by Value and Pass by reference? How does JAVA handle the
same?
What are access modifiers?
what is Assertion?
Can you explain the fundamentals of deep and shallow Cloning?
How do we implement Shallow cloning?
How do we implement deep cloning?
What's the impact of private constructor?
What are the situations you will need a constructor to be private?
Can you explain final modifier?
What are static Initializers?
If we have multiple static initializer blocks how is the sequence
handled?
Define casting? What are the different types of Casting?
Can you explain Widening conversion and Narrowing conversion?
Can we assign parent object to child objects?
Define exceptions?
Can you explain in short how JAVA exception handling works?
Can you explain different exception types?
Can you explain checked and unchecked exceptions?
Can we create our own exception class?
What are chained exceptions?
What is serialization?
How do we implement serialization actually?
What's the use of Externalizable Interface?
Threading
What's difference between thread and process?
What is thread safety and synchronization?
What is semaphore?
What are monitors?
What's the importance of synchronized blocks?
How do we create threads?
what's the difference in using runnable and extends in threads?
Can you explain Thread.sleep?
How to stop a thread?
What is wait() and notify() ?
Can you explain how Scheduling and Priority works in threads?
Can you explain Yielding in threading?
what are daemon threads?
JDBC
How does JAVA interact with databases?
Can we interact with non-relational sources using JDBC?
Can you explain in depth the different sections in JDBC?
Can you explain in short how you go about using JDBC API in code?
How do you handle SQL exceptions?
If there is more than one exception in SQLException" class how to go
about displaying
it?
Explain Type1, Type2, Type3 and Type4 drivers in JDBC?
What are the advantages and disadvantages of using JDBC-ODBC bridge
driver?
What are the advantages and disadvantages of using Native-API/
Partially Java Driver?
What are the advantages and disadvantages of using Net-Protocol/
All-Java driver?
What are the advantages and disadvantages of using Native-protocol/
All-Java driver?
Define meta-data?
What is DatabaseMetaData?
Can you explain "ConnectionFactory" class?
I want to display tables of a database how do I do it?
Define "ResultSetMetaData"?
What is the difference between "ResultSet" and "RowSet"?
Can "ResultSet" objects be serialized?
Can you explain "ResultSet", "RowSet", "CachedRowset",
"JdbcRowset" and
"WebRowSet" relation ship?
what are the different types of resultset?
Explain the concept of "PreparedStatement "statement interface?
What's the difference between "Statement" and
"PreparedStatement"?
How can we call stored procedure using JDBC?
Can you explain "CallableStatement" interface in detail?
How do you get a resultset object from stored procedure?
How can we do batch updates using "CallableStatement" Interface?
Define transactions?
what is ACID in transaction?
what are the four essential properties of a transaction?
Explain concurrency and locking?
What are different types of locks?
What are the different types of levels of resource on which locks can
be placed?
Define lock escalation?
What is Table level and Row level locking?
What are the problems that can occur if you do not implement locking
properly?
What are different transaction levels?
Twist: - what are different types of locks?
What is difference between optimistic and pessimistic locking?
What are deadlocks?
How can we set transaction level through JDBC API?
Can you explain transaction control in JDBC?
What are Savepoints in a transaction?
Servlets and JSP
What are Servlets?
What are advantages of servlets over CGI?
Can you explain Servlet life cycle?
What are the two important API's in for Servlets?
Can you explain in detail "javax.servlet" package?
What's the use of ServletContext?
How do we define an application level scope for servlet?
What's the difference between GenericServlet and HttpServlet?
Can you explain in detail javax.servlet.http package?
What's the architecture of a Servlet package?
Why is HTTP protocol called as a stateless protocol?
What are the different ways we can maintain state between requests?
What is URL rewriting?
What are cookies?
What are sessions in Servlets?
What's the difference between getSession(true) and getSession(false)
?
What's the difference between "doPost" and "doGet" methods?
Which are the different ways you can communicate between servlets?
What is functionality of "RequestDispatcher" object?
How do we share data using "getServletContext ()"?
Explain the concept of SSI?
What are filters in JAVA?
Can you explain in short how do you go about implementing filters using
Apache Tomcat?
Twist: - Explain step by step of how to implement filters?
what's the difference between Authentication and authorization?
Explain in brief the directory structure of a web application?
Can you explain JSP page life cycle?
What is EL?
how does EL search for an attribute?
What are the implicit EL objects in JSP?
How can we disable EL?
what is JSTL?
Can you explain in short what the different types of JSTL tags are?
How can we use beans in JSP?
What is <jsp:forward> tag for ?
What are JSP directives?
what are Page directives?
what are include directives?
Can you explain taglib directives?
How does JSP engines instantiate tag handler classes instances?
what's the difference between JavaBeans and taglib directives?
what are the different scopes an object can have in a JSP page?
what are different implicit objects of JSP?
what are different Authentication Options available in servlets?
Can you explain how do we practically implement security on a resource?
How do we practically implement form based authentication?
How do we authenticate using JDBC?
Can you explain JDBCRealm?
Can you explain how do you configure JNDIRealm?
How did you implement caching in JSP?
EJB
What is EJB?
what are the different kind of EJB's?
you are designing architecture for a project how do you decide whether
you should use
session, entity or message driven bean?
Can you explain "EJBHome" and "EJBObject" in EJB?
Can client directly create object of session or entity beans?
Can you explain the concept of local interfaces?
What are the limitations of using Local object?
Which application server have you used for EJB ?
Can you explain step by step practically developing and deploying EJB
component?
what is Passivation and Activation in EJB?
Can beans who are involved in transaction have "Passivation"
process?
How does the server decide which beans to passivate and activate?
In what format is the conversational data written to the disk?
Can you explain in brief Life cycle for Stateless and Stateful beans?
Struts
What's MVC pattern?
Define struts?
Can you explain the directory structure for a struts folder in brief ?
Can you give an overview of how a struts application flows?
Twist: - What are action and action form classes in Struts?
XML and Web Services
What is XML?
What is the version information in XML?
What is ROOT element in XML?
If XML does not have closing tag will it work?
Is XML case sensitive?
What is the difference between XML and HTML?
Is XML meant to replace HTML?
Can you explain why your project needed XML?
What is DTD (Document Type definition)?
What is well formed XML?
What is a valid XML?
What is CDATA section in XML?
What is CSS?
What is XSL?
What is element and attributes in XML?
What are the standard ways of parsing XML document?
In What scenarios will you use a DOM parser and SAX parser?
What is XSLT?
Define XPATH?
What is the concept of XPOINTER?
What is a Web Service ?
What is DISCO ?
What is SOAP ?
What is WSDL ?
Can you explain UDDI ?
Can you explain JAXP ?
What is a XML registry?
What is JAXR?
What is JAXM?
Can you explain how JAXM messaging model works?
Can you explain JAX-RPC?
Internationalization
Can you explain i18n and l10n?
Can you explain internationalization and localization?
What is Locale?
How do we display numbers, currency and Dates according to proper
Locale format?
what are resource bundles?
How do we load a resource bundle file?
How can we do inheritance in resource bundles?
JNI
What is Native Interface in JAVA?
Can you say in brief steps required to implement Native interfaces in
Java?
Can JNI be used for VB6, C# or VB.NET directly?
What are JNI functions and pointers?
How does the garbage collector know JNI objects are no more used?
Twist: - What are the different types of references JNI supports?
Twist: - How to do you delete global objects?
how does the native language C or C++ understand data types in JAVA?
Can you explain exception handling in JNI?
What are limitations for "JNIEnv" pointer in multi-threading
scenarios?
What are the advantages and disadvantages of using "JNI"?
Architecture
What are design patterns ?
What is the difference between Factory and Abstract Factory Patterns?
What is MVC pattern?
Twist: - How can you implement MVC pattern in Servlets and JSP?
How can we implement singleton pattern in JAVA?
How do you implement prototype pattern in JAVA?
Twist: - How to implement cloning in JAVA? What is shallow copy and
deep copy ?
Can you give a practical implementation of FAÇADE patterns?
How can we implement observer pattern in JAVA?
What is three tier architecture?
What is Service Oriented architecture?
What is aspect oriented programming?
Project Management
What is project management?
Is spending in IT projects 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 ?
How do you estimate a project?
What is CAR (Causal Analysis and Resolution)?
What is DAR (Decision Analysis and Resolution) ?
What is a fish bone diagram ?
Twist:- What is Ishikawa diagram ?
What is pareto principle ?
Twist :- What is 80/20 principle ?
How do you handle change request?
What is internal change request?
What is difference between SITP and UTP in testing ?
What is the software you have used for project management?
What are the metrics followed in project management?
Twist: - What metrics will you look at in order to see the project is
moving successfully?
You have people in your team who do not meet there deadlines or do not
perform what
are the actions you will take ?
Twist :- Two of your resources have conflicts between them how would
you sort it out ?
What is black box testing and White box testing?
What's the difference between Unit testing, Assembly testing and
Regression testing?
What is V model in testing?
How do you start a project?
How did you do resource allocations?
How will you do code reviews ?
What is CMMI?
What are the five levels in CMMI?
What is continuous and staged representation?
Can you explain the process areas?
What is SIX sigma?
What is DMAIC and DMADV ?
What are the various roles in Six Sigma implementation?
What are function points?
Twist: - Define Elementary process in FPA?
What are the different types of elementary process in FPA?
What are the different elements in Functions points?
Can you explain in GSC and VAF in function points?
What are unadjusted function points and how is it calculated?
Can you explain steps in function points?
What is the FP per day in your current company?
Twist :- What is your company's productivity factor ?
Do you know Use Case points?
What is COCOMO I, COCOMOII and COCOMOIII?
What is SMC approach of estimation?
How do you estimate maintenance project and change requests?
UML
What is UML?
How many types of diagrams are there in UML ?
Twist :- Explain in short all types of diagrams in UML ?
What are advantages of using UML?
Twist: - What is Modeling and why UML ?
What is the sequence of UML diagrams in project?
Twist: - How did you implement UML in your project?
Just a small Twist: - Do I need all UML diagrams in a project?
Give a small brief explanation of all Elements in activity diagrams?
Explain Different elements of a collaboration diagram ?
Explain Component diagrams ?
Explain all parts of a deployment diagram?
Describe the various components in sequence diagrams?
What are the element in State Chart diagrams ?
Describe different elements in Static Chart diagrams ?
Explain the different elements of a Use Case ?
Twist: - What is the difference between Activity and sequence
diagrams?(I leave this to
the readers)
[Back to original message]
|