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 2587

How to take backup of database?

1 2470

How to create a PostgreSQL user?

1 2596

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 3277

How global cursor can be declare with dynamic trigger ?

2272

how view used for security purposes?

Glam India,

3 5937

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

1 3225

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,

2127

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?

1802

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 4287

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 6465

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 12170

Un-Answered Questions { Databases }

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

1202

How to select distinct on multiple columns?

899

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

2068

What is federated tables in mysql?

958

how report can be generated if we have the database designed in oracle 10g?

1939

What are the default system databases in sql server 2000?

1084

What is sql server query analyzer?

1103

Why are data files so large?

What is sql service broker?

1026

How to provide values to user defined function parameters?

1064

What is sql server profiler?

1062

What is database server and how it works?

1098

Why is normalisation important?

989

How to call a function from a stored procedure in SQL Server ?

1087

How can we create the complete backup of data in the oracle.

2201

For More Un-Answered { Databases } Questions Click Here