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

Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1411)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

How do you simulate a deadlock for testing purposes

1 10312

what is thae main difference between foreingkey and primarykey

5 8909

which version of mysql can't support stored procedure??

3 6116

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

DELL,

13 19582

how to get the third quarter of employee details from emp?

CompuTech,

2 7968

How can i insert data inro a table with 3 columns using FORALL?

Oracle,

2 10876

find the third highest salary?

23 44453

i have cleared the nic test...please send me the interview questions if anyone have them.... my email id is v84priya@gmail.com

NIC,

1891

how to display only 4 records from a table based on a condition for ex i have a table called products in that nid,prodname are fields i want to display only any 4 records of perticular product plz tell me

6 7446

What is the Tune Query

2305

what is autonomouse transaction?

Oracle,

3 8251

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

HCL, ZX,

5 9944

what is the difference between group and having give an example with query and sample output

7 9990

What is Data model and how to prepare a data model.?

TCS,

1 5658

what is a stored procedure and trigger?

3 6096

Un-Answered Questions { Databases }

How many rows ms access can handle?

900

When you should use a low fill factor?

1005

What is open client in sybase?

892

What is 2nf and 3nf?

943

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1172

Explain bcnf (boyce-codd normal form)?

1027

Why is rdbms important?

889

What is aws aurora postgres?

813

How to sort the rows in sql.

1085

How can we collect the statistics of different database objects?

What is Multivalued dependency?

794

How we can create an index in mongodb?

What is meant by <> in sql?

987

How to pass parameters to procedures in oracle?

1053

How to list all columns in a table using odbc_columns()?

990

For More Un-Answered { Databases } Questions Click Here