Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

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 3525

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 5211

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

7 25986

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 5177

what is the 4 types of validation

2 7421

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

Infosys, Rolta,

20 29473

what is trigger . hw will it use them

TCS,

2 6352

How to remove a row in a database table?

IBM,

5 8846

How to retrieve 5th highest sal from emp table?

8 11677

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 7128

Un-Answered Questions { Databases }

How do I create an extended event in sql server?

957

What happen when we delete the table using trigger?

907

Why is rdbms important?

880

Can an automatic recovery be initiated by a user?

1018

What do you mean by mainframe connect tool in sybase?

898

How do I get to sql server configuration manager?

1012

Is record in pl sql?

979

Name the buffer in which all the commands that are typed in are stored

810

Is mysql from oracle?

972

What is the difference between myisam dynamic and myisam static in mysql?

1013

Why does oracle 9i treat an empty string as null?

1060

Does sql server 2000 full-text search support clustering?

870

Where is mysql password stored?

932

What is a partition function in sql server?

1142

How useful is microsoft access?

867

For More Un-Answered { Databases } Questions Click Here