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 3607

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 5484

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

7 26255

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 5261

what is the 4 types of validation

2 7553

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

Infosys, Rolta,

20 30200

what is trigger . hw will it use them

TCS,

2 6469

How to remove a row in a database table?

IBM,

5 9034

How to retrieve 5th highest sal from emp table?

8 11936

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 7276

Un-Answered Questions { Databases }

How do I enable postgis on pgadmin?

1052

Is postgresql free to use?

839

What is an Extension of entity type?

908

What do you mean by cql and how to execute cql commands in neo4j?

When you use CKM?

633

What is a virtual table in sql?

1046

State some of the uses of MS Access?

952

What is the difference between grant and with grant while giving permissions to the user?

1035

What is self contained sub query?

1126

What is the requirement of self-join?

1220

Why we use joins in sql?

1040

What is database development process?

946

Is mysql is a programming language?

1047

How to use sum function in where clause in mysql?

1020

How to populate a table in sql server?

1006

For More Un-Answered { Databases } Questions Click Here