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

1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

HP,

3 17794

write a query that returns first characters of each word in Oracel/Sql pl sql

5 10136

how can u get last observation in an unknown dataset ?

Genpact,

2491

Describe the P2P cycle ?

1 3751

Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15

2 6217

what is data set ?

1 3484

What is stored procedure in SQL..??

2 5010

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 4213

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

Oracle,

2094

In a table only one column how to update rows

Microsoft,

5 9939

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

Oracle,

1 4688

Un-Answered Questions { Databases }

what is a view? : Sql dba

1137

How to use "out" parameter properly?

1125

Explain the cube operator?

1060

Do you know what are the reporting services components?

1022

What are the set operators union, union all, minus & intersect meant to do?

1038

How to write a query with an inner join in ms sql server?

1099

Differentiate between pl/sql and sql?

1217

What are actual parameters and formal parameters?

1180

What is a user-defined function in the sql server and what is its advantage?

1143

Use of an integrity constraint is better to validate data. Explain

1094

Mention a query to add email validation to your database

973

What is the maximum number of records in mysql table?

979

What are the drawback of rdbms?

999

How do I add another column in postgresql?

887

How to use "in out" parameter properly?

1107

For More Un-Answered { Databases } Questions Click Here