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 17790

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

5 10133

how can u get last observation in an unknown dataset ?

Genpact,

2488

Describe the P2P cycle ?

1 3749

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 6212

what is data set ?

1 3482

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 4209

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

Oracle,

2092

In a table only one column how to update rows

Microsoft,

5 9936

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

Oracle,

1 4686

Un-Answered Questions { Databases }

What is the difference between writing data to mirrored drives versus raid5 drives

990

Can unique keys be null?

949

Can I run multiple instances of sql server 2000 at the same time on one computer?

1122

what rules exist regarding format, content, flame wars, etc

119

What are subquery and its properties?

1105

What is insert query in mysql?

954

How can you check the version of sql server?

1163

What language is mysql written in?

1031

How many primary keys can a table have?

1059

Explain about recursive stored procedures?

851

Why should we go for stored procedures? Why not direct queries?

1158

what is asm?

1116

What are the different types of columns types constraints in the sql server?

1135

Can you explain the select into statement?

1091

What is a sequence? Explain it with one example?

1280

For More Un-Answered { Databases } Questions Click Here