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

Oracle (3253)
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 to list the number of database?

1 2590

How to take backup of database?

1 2471

How to create a PostgreSQL user?

1 2598

write a query to find 4th max salary

7 8481

Is it possible to drop a column in a table which contains only one column? How?

1 3279

How global cursor can be declare with dynamic trigger ?

2272

how view used for security purposes?

Glam India,

3 5946

what is cursor?why we will go to cursor?advantages &disadvantages of cursors?

1 3233

query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp

Verizon,

2128

what is tripstop report?

1909

How do you find value of first column before inserting value into the second column in the same table for checking that second column must have different value than first column.

L&T,

2 5435

How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

1803

Restore database SQL2000, SQL2012 Backup of base is created in Microsoft SQL Server 2000 - 8.00.2066, I can't restore on Microsoft SQL Server 2012 - 11.0.2100.60

IT Decisions,

3 4289

two tables are there.1st table EMP has two columns ID and name and contains data 1,A 2,B 3,C 2nd table EmpSal has 2 columns ID and Salary Contains data -1,1000 2,5000 3,3000 Find name of employee having maximum salary ?

CSE,

5 6467

source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?

JPMorgan Chase,

4 12183

Un-Answered Questions { Databases }

Explain superior keys and candidate keys.

876

What is a Built_in subprogram ?

4074

What do I need to start working with sql studio? : sql server management studio

1162

Who developed mongodb?

How do I pipe the output of one isql to another?

1060

Â How to use an oracle sequence generator in a mapping?

1134

What is CDC and explain complete CDC process flow?

639

Is access faster than excel?

822

What is the difference between cartesian product and cross join?

906

Does PostgrSQL support Column constraints? If so how is it done?

1325

What is the rdbms concept in sql?

1049

How to prepare for oracle pl sql certification?

1109

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

1013

How do I do transactions/locking in mongodb?

Does mysql support nosql?

965

For More Un-Answered { Databases } Questions Click Here