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 17641

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

5 9944

how can u get last observation in an unknown dataset ?

Genpact,

2436

Describe the P2P cycle ?

1 3661

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 6111

what is data set ?

1 3399

What is stored procedure in SQL..??

2 4903

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 4110

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

Oracle,

2043

In a table only one column how to update rows

Microsoft,

5 9781

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

Oracle,

1 4594

Un-Answered Questions { Databases }

Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1838

What is the difference in accessing db between sql server vs sql azure?

174

What are pl sql procedures?

1024

Explain the difference between drop and truncate commands in sql?

1053

what is unique key constraint? : Sql dba

1035

Can I install mysql on mac?

977

What is maintaining database?

897

What are the disadvantages of a query?

1020

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2549

What are joins in sql?

1044

Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?

590

What happens if null values are involved in boolean operations?

987

What are the functions used to encrypt and decrypt the data present in mysql?

1107

How to control the max size of a heap table?

1003

What is the use of sp_helprotect in sybase?

968

For More Un-Answered { Databases } Questions Click Here