Home
|
Submit an interview question
|
Filter by category
|
Filter by job function
|
Filter by company
Member Information
User Id
Password
Remember Me
Forgot Password
Technology Category
.NET
(
1202
)
Languages
(
103
)
Database
(
146
)
Operating System
(
48
)
Reporting
(
5
)
Third-Party Tools
(
2
)
Testing
(
91
)
OOP
(
75
)
Web Development
(
40
)
Design Patterns
(
89
)
General
(
9
)
Networking
(
88
)
Hardware
(
63
)
Brain Exercise
(
2
)
Others
(
37
)
Our Network
.NET Heaven
C# Corner
Interview Corner
Longhorn Corner
Mindcracker
VB.NET Heaven
Home
»
Database
JOB FUNCTION
Senior Management
Tech Lead
Sr. Developer
Programmer
DBA
Project Manager
Team Lead
Sr. Programmer
Developer
Others
Project Lead
Architect
SUB CATEGORY
SQL Server
Others
DB2
SQL
Oracle
MS Access
Interview Questions
Answers
Posted On
What is lock escalation?
by
Sapna Malik
1
Sep 25, 2009
What are defaults? Is there a column to which a default can't be bound?
by
Sapna Malik
0
Sep 20, 2009
How to add DateTime Control in normal DataGrid Server Control?
by
Pradeep
0
Sep 16, 2009
What does COMMIT do ?
by
Pradeep
2
Sep 14, 2009
what is the difference between count(*) and count(1) ?
by
Pradeep
1
Sep 14, 2009
What are the advantages of using Query Strings?
by
Partap Tanwar
1
Sep 14, 2009
can any one give me a sample example of database project
by
sumaira manzoor
0
Sep 02, 2009
can any one give me some sample example of database project ?
by
sumaira manzoor
0
Sep 02, 2009
Explain the concurrency problems using DATA SETS?
by
Pradeep
0
Sep 02, 2009
What is the diff b/w HTML server Controls and Web Server Controls?
by
Sapna Malik
1
Sep 02, 2009
1
2
3
4
5
6
7
8
9
10
...
Interview Questions
Answers
Posted On
What is a schema? What are the limitations of a DTD?
by
Partap Tanwar
1
Sep 02, 2009
What are the Back ground processes in Oracle?
by
Partap Tanwar
1
Sep 01, 2009
What is the physical and logical structure of oracle?
by
Partap Tanwar
1
Sep 01, 2009
What is the difference between materialized view and snapshot?
by
Pradeep
1
Sep 01, 2009
What is the difference between B TREE INDEX and BITMAP INDEX?
by
Pradeep
1
Sep 01, 2009
What are the Large object types supported by Oracle?
by
Sapna Malik
1
Sep 01, 2009
How to check if variable is NULL In Stored Procedure?
by
Purushottam Rathore
1
Sep 01, 2009
How MySQL is different from SQL?
by
Sapna Malik
1
Aug 28, 2009
Difference between DBMS & RDBMS?
by
Sapna Malik
1
Aug 28, 2009
How we can count duplicate entry in particular table against Primary Key ? What are constraints?
by
Sapna Malik
1
Aug 28, 2009
1
2
3
4
5
6
7
8
9
10
...
Interview Questions
Answers
Posted On
What is Referential integrity?
by
meera mishra
1
Aug 27, 2009
SQL Query Question
by
Praveen Moosad
2
Aug 25, 2009
What is the difference between groupby and orderby?
by
Pradeep
1
Aug 24, 2009
What is Call By Value and Call By Reference?
by
Pradeep
4
Aug 24, 2009
Which is more faster parameterized query or stored procedure?
by
Puran Mehra
2
Aug 21, 2009
Where you will use the cursor in the database ?
by
BHOOPENDRA NATH PANDEY
0
Aug 20, 2009
What is Heap Table? What is the advantage and dis advantage of Heap Table?
by
Gangadhar
1
Aug 20, 2009
What is denormalization and difference between normalization and denormalization?
by
Sapna Malik
0
Aug 20, 2009
What is the difference between TRUNCATE and DELETE commands?
by
Pradeep
3
Aug 20, 2009
What is the use of the DROP option in the ALTER TABLE command?
by
Pradeep
1
Aug 19, 2009
1
2
3
4
5
6
7
8
9
10
...
Interview Questions
Answers
Posted On
How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables?
by
Pradeep
1
Aug 19, 2009
What is the use of DESC in SQL?
by
Pradeep
1
Aug 19, 2009
What command is used to create a table by copying the structure of another table?
by
Pradeep
1
Aug 19, 2009
Can we call stored procedure from function
by
Manish Dwivedi
1
Aug 18, 2009
Find out Emp_id who earn second higest Salary ?
by
Tauhidul Islam
1
Aug 17, 2009
What is the difference between SQL coammand and T-SQL command?
by
Puran Mehra
2
Aug 13, 2009
How to write a multiple row delete trigger in sqlserver.... eg--I want to delete 5 rows in abc table and those 5 rows should be updated in xyz table....
by
sudeep kumar
2
Jul 31, 2009
What's the difference between a primary key and a unique key?
by
Purushottam Rathore
2
Jul 29, 2009
Difference between Store Procedure and Trigger?
by
Purushottam Rathore
2
Jul 29, 2009
What do you mean by Common Table Expression?
by
Raghvendra Singh
1
Jun 22, 2009
1
2
3
4
5
6
7
8
9
10
...
Interview Questions
Answers
Posted On
What are the disadvantage of Stored Procedure?
by
Raghvendra Singh
3
Jun 22, 2009
How update database two(2) table from dataset ?
by
Hoang Nam
1
May 06, 2009
SQL and Access Database is using different SQL Statement?
by
Henry Thet
2
Apr 30, 2009
Can u explain Joins in SQL with examples?
by
Poonam Jain
5
Apr 18, 2009
How will you modify a data on a linked server ?
by
sanjeev singh
0
Apr 17, 2009
I have a table Table1. It's have four collumns Name, Age, Address, Friends.. One Pursion have a Name, Age, Address but He have many Friends.. So how Inserted a many friends name in a single collumn........
by
Neeraj Srivastava
1
Mar 29, 2009
What is the need of VIEWS in DataBase
by
sanjeev singh
5
Feb 26, 2009
What is the difference between excute query and excute nonquery.?
by
sanjeev singh
2
Feb 20, 2009
How to create virtual directory in the Reporting services 2008
by
shailesh rathi
0
Feb 11, 2009
What is Storedprocedures and its advantages.Explain
by
krishna dhanekula
1
Jan 01, 2009
1
2
3
4
5
6
7
8
9
10
...
Interview Questions
Answers
Posted On
Explain with examples Views,Indexes,Functions,Triggers in SQL server2005?
by
krishna dhanekula
1
Dec 29, 2008
What is the difference between data replication and data backup
by
Dumpy Jyoti
1
Dec 10, 2008
what is meant by output parameter in sql storedprocedure?
by
manikandan r
1
Oct 17, 2008
How can we use ConnectorJ JDBC Driver with MS SQL?
by
Imran Kabir
1
Jun 20, 2008
How to get a book from database MS access that contain 'i' charactor in it's name like internetbook or networkingbook. what will be java query for this purpose?
by
Imran Kabir
1
Apr 14, 2008
How to retrive a student with height marks,second height and third height from MS access database what wil be the query for this purpuse?
by
Imran Kabir
3
Apr 14, 2008
SELECT * FFROM EMP WHERE ROWNUM > 5. What will be the output of the query and why
by
Suraj Jaiswal
4
Jan 14, 2008
Is it possible to configure the security options of SQL through an interface (designed in VB or any other language)??
by
Waqar Khan
0
Nov 21, 2007
Can I have a Brief explanation abt Stocks concept in Sqlserver2005
by
vasu madhala
0
Nov 06, 2007
Write an algorithm for single linked list
by
1
Sep 30, 2007
1
2
3
4
5
6
7
8
9
10
...
Interview Questions
Answers
Posted On
what are the components of Co_related Sub Queries? what is the defaule datatype in the data base?
by
Basha Sd
2
Aug 14, 2007
As when we create one primary key in table, clustered index will be created. Same way if we have two primary keys in table which index will be get created?
by
Virag Jain
1
Jul 17, 2007
How The Clustered Index work for a table ?
by
Atul Sinha
1
Jun 04, 2007
What is the difference between a query and stored procedure?
by
chaitanya k
5
May 11, 2007
How the rowcount works?
by
sarika
2
May 08, 2007
what will be the result of this query :Select 1 from a table.
by
sarika
4
May 07, 2007
Can you call Trigger from Stored Procedure?
by
3
Apr 09, 2007
What's the maximum size of a row?
by
Deepak Agrawal
1
Apr 04, 2007
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
by
Deepak Agrawal
1
Apr 04, 2007
What is the maximum number of Procedures and Functions in a Package?
by
Deepak Agrawal
1
Apr 04, 2007
1
2
3
4
5
6
7
8
9
10
...
Interview Questions
Answers
Posted On
What is the difference between non-relational database system and relational database system?
by
sumit khadilkar
2
Mar 30, 2007
What does an EXPLAIN PLAN statement does?
by
Anantha Narayanan
1
Mar 26, 2007
What is the difference between PRIMARY KEY and UNIQUE KEY with NOT NULL constraint?
by
Anantha Narayanan
3
Mar 26, 2007
Is it possible to use COMMIT inside Triggers in Oracle?
by
Anantha Narayanan
1
Mar 26, 2007
What is the difference between a function and a stored procedure in Oracle?
by
Anantha Narayanan
2
Mar 26, 2007
How can you delete duplicate records in sql server?
by
Naveen Sikri
5
Mar 26, 2007
When to use Inner join & when to use subquery?
by
2
Mar 16, 2007
What is cursor? and Types of Cursor?
by
3
Mar 16, 2007
We have a table with one field name {amit,amit,karan,karan,sumit},write a query to show the name and number of its occurrence.
by
Amit Soni
3
Feb 26, 2007
im new to this SQL language, my questions are going to be simple basic stuff. How is the having clause used with group by?
by
Rahid Ahmed
1
Jan 31, 2007
1
2
3
4
5
6
7
8
9
10
...
Interview Questions
Answers
Posted On
how to find given query is optimized or not
by
esk
1
Jan 31, 2007
What will be the result of this query:- select * from TableName order by 1 . Wll this query throw an error?
by
Martin Jakob
1
Dec 16, 2006
how can we call the one store procedure with in the anoyher store procedure
by
Divya Parashar
2
Dec 13, 2006
What is the default optimization done in oracle and sql server
by
sai
0
Dec 04, 2006
Difference between ISQL and OSQL
by
Rangoli
1
Dec 04, 2006
How to disable an index using select query
by
Ravi Kumar Dehariya
2
Dec 04, 2006
Types of optimization
by
sai
1
Dec 04, 2006
When would you denormalize
by
Ravi Kumar Dehariya
1
Dec 04, 2006
Is there a column to which a default can't be bound?
by
Reetaish Kapoor
1
Dec 02, 2006
I want to implement one-to-one, one-to-many and many-to-many relationships while designing tables. How can i do this?
by
Haasim Khan
1
Dec 02, 2006
1
2
3
4
5
6
7
8
9
10
...
Interview Questions
Answers
Posted On
How to find out duplicate records in sql server?
by
1
Nov 30, 2006
Are there any Commands, can be used to calculate the performance of a Querry?
by
sai
1
Nov 30, 2006
What is merging?
by
Ravi Kumar Dehariya
1
Nov 30, 2006
What is DESCRIBE command in SQL Server?What is its purpose?
by
2
Nov 30, 2006
What is difference between stored procedure transformation and external procedure transformation?
by
sai
0
Nov 30, 2006
What is the difference between "IS" and "AS" while creating procedure. Ex:- create procedure IS or A
by
1
Nov 30, 2006
How to programmatically find out when the SQL Server service started?
by
Venkat Raju
1
Nov 30, 2006
Why a stored procedure cannot be used in a select statement ?
by
Raj
1
Nov 18, 2006
Types of Replication in SqlServer 2000
by
Divya Parashar
2
Nov 15, 2006
How can we delete Duplicate row in table?
by
Ravi Kumar Dehariya
2
Nov 14, 2006
1
2
3
4
5
6
7
8
9
10
...
Interview Questions
Answers
Posted On
What are Reataional Queries? Give an Example.
by
Shaj Shaj
1
Oct 30, 2006
What is the advantage of using DBO.Tablename over just Tablename in the SQL stored procedure or query ?
by
Raushan
1
Aug 26, 2006
In SQL Server2000 a table having similer rows. How can you update a row?
by
madhukumar koppula
3
Aug 17, 2006
What is difference between UNIQUE and PRIMARY KEY constraints
by
Puran Mehra
8
Aug 04, 2006
What are the various Database states.
by
1
Jul 26, 2006
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
by
1
Jul 26, 2006
Whar are the various system databases used in SQL Server 2005
by
1
Jul 26, 2006
What is a Data Warehouse
by
1
Jul 26, 2006
Whats is an OLTP Database
by
1
Jul 26, 2006
What are the magic tables available in SQL Server 2000?
by
2
Jul 20, 2006
...
11
12
13
14
15
Interview Questions
Answers
Posted On
In the TCP client-servel model, how does the three-way handshake work in opening connection?
by
Dinesh Beniwal
1
Jul 15, 2006
Which stored procedure will you be running to add a linked server?
by
Bhasker Das
1
Jul 15, 2006
Can you explain the types of Joins that we can have with Sql Server?
by
Dinesh Beniwal
2
Jul 15, 2006
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
by
Bhasker Das
2
Jul 15, 2006
Can you give me some DBCC command options?
by
Dinesh Beniwal
1
Jul 15, 2006
What is the use of DBCC commands?
by
Bhasker Das
2
Jul 15, 2006
Can we use Truncate command on a table which is referenced by FOREIGN KEY?
by
Bhasker Das
1
Jul 15, 2006
Can you tell me the difference between DELETE & TRUNCATE commands?
by
Dinesh Beniwal
2
Jul 15, 2006
What are the types of indexes available with SQL Server?
by
Dinesh Beniwal
2
Jul 15, 2006
Can you give an example of Stored Procedure?
by
Dinesh Beniwal
2
Jul 15, 2006
...
11
12
13
14
15
Interview Questions
Answers
Posted On
What is a trigger?
by
Bhasker Das
1
Jul 15, 2006
What is a Stored Procedure?
by
Dinesh Beniwal
1
Jul 15, 2006
What is a self join?
by
Bhasker Das
2
Jul 13, 2006
What is a view?
by
Bhasker Das
1
Jul 13, 2006
What is normalization?
by
Ravi Kumar Dehariya
2
Jul 13, 2006
What is BCP?
by
1
Jul 13, 2006
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
by
1
Jul 13, 2006
What are the authentication modes in SQL Server?
by
Dinesh Beniwal
1
Jul 13, 2006
How do you troubleshoot SQL Server if its running very slow?
by
1
Jul 13, 2006
Can you explain the role of each service?
by
Dinesh Beniwal
1
Jul 13, 2006
...
11
12
13
14
15
Interview Questions
Answers
Posted On
When do you use SQL Profiler?
by
Dinesh Beniwal
1
Jul 13, 2006
Can you link only other SQL Servers or any database servers such as Oracle? -
by
1
Jul 13, 2006
Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?
by
1
Jul 13, 2006
What command do we use to rename a db?
by
Dinesh Beniwal
1
Jul 13, 2006
What do you mean by COLLATION?
by
Manu
1
Jul 13, 2006
Where do you think the users names and passwords will be stored in sql server?
by
1
Jul 13, 2006
What is a Linked Server?
by
Manu
1
Jul 13, 2006
Which TCP/IP port does SQL Server run on?
by
Manu
1
Jul 13, 2006
From where can you change the default port?
by
Nipun Tomar
1
Jul 13, 2006
What is the basic difference between clustered and a non-clustered index?
by
Manu
2
Jul 13, 2006
...
11
12
13
14
15
Interview Questions
Answers
Posted On
When do we use the UPDATE_STATISTICS command?
by
Nipun Tomar
1
Jul 13, 2006
What is an Index?
by
Manu
2
Jul 13, 2006
What are cursors?
by
Nipun Tomar
1
Jul 12, 2006
Which TCP/IP port does SQL Server run on?
by
Nipun Tomar
1
Jul 12, 2006
What is the basic difference between clustered and a non-clustered index?
by
nikhil kansal
1
Jul 12, 2006
...
11
12
13
14
15
Hosted by MaximumASP
|
Found a broken link?
|
Contact Us
|
Terms & conditions
|
Privacy Policy
|
Advertise with us
Current Version:
2.2009.3.2
© 1999 -
2009
Mindcracker LLC. All Rights Reserved
Channels
:
Jobs
|
Interviews
|
Consulting
|
Training
|
Photos
|
Authors
|
Tips
|
Forums
|
E-Books
|
Blogs
Programming
:
C#
|
Visual Basic
|
ASP.NET & Web Development
|
C++
|
Other .NET Languages
|
Windows Vista
|
XAML
|
Tutorials
Sponsors
:
ASP.NET Hosting
|
Clickatell
|
Dundas Software
|
DynamicPDF
|
RedGate Software
|
Visual Studio 2010