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 to list the number of database?

1 2522

How to take backup of database?

1 2388

How to create a PostgreSQL user?

1 2528

write a query to find 4th max salary

7 8224

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

1 3196

How global cursor can be declare with dynamic trigger ?

2210

how view used for security purposes?

Glam India,

3 5792

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

1 3094

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,

2058

what is tripstop report?

1834

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 5304

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?

1750

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 4175

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 6260

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 12013

Un-Answered Questions { Databases }

Why are indexes and views important to an organization?

956

What is the usage of nvl function?

1040

What is meant by Active-Passive and Active-Active clustering setup?

1176

What is optimization and its types?

978

mention different types of relationships in the dbms?

1020

Find nth lowest salary or get nth lowest salary?

1029

Explain the use of dde package in d2k.

Is java required for oracle client?

997

What is %s in sql?

1014

Can we perform backup restore operation on tempdb? : sql server database administration

998

what is the difference between Tabular and Matrix report?

170

What is a degree of relation?

1015

Is sql a dbms?

1007

Define RDBMS.

1169

if no size is defined while creating the database, what size will the database have? : Sql server administration

1006

For More Un-Answered { Databases } Questions Click Here