Databases Interview Questions
Questions Answers Views Company eMail

what is node in sql server?

CarrizalSoft Technologies, Google, NIIT, Nittany, TATA,

2 24314

How to store pdf file in sql server?

CarrizalSoft Technologies, College School Exams Tests, TATA,

1 6006

What is difference between stored procedure & function?

CarrizalSoft Technologies, Concept Infoway, TATA,

3 6069

How to Rebuild Master database in sql server 2005.

Wipro,

2 4639

what is the use of foreginkey

2 5295

please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on

1 2711

create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year

3 3963

How many levels can subqueries be nested in a FROM clause?

7 23551

need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

1 4370

what is the 4 types of validation

2 6185

How to get employee name from employee table which is the fiveth highest salary of the table

Infosys, Rolta,

20 23146

what is trigger . hw will it use them

TCS,

2 5104

How to remove a row in a database table?

IBM,

5 6976

How to retrieve 5th highest sal from emp table?

8 9187

hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

IBM,

3 5494


Un-Answered Questions { Databases }

Can we use commit inside the trigger? If not then how can we save the transaction made by the trigger?

491


how to create a scrollable cursor with the scroll option? : Sql server database administration

580


How can I create table in mysql?

496


Write a query to find 5th highest amount paid from the customer table.

514


What are the advantages of partitioning?

617






Why do we need mongoose?

1


what are null values? : Sql dba

523


How to use online Backups?

1705


What is normalization process?

570


In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1452


How can triggers be used for the table auditing?

570


Can a formula column referred to columns in higher group ?

2058


What is variable and how many types of variable?

274


What are the various Database states.

547


Can we do dml on views?

530