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 2524

How to take backup of database?

1 2391

How to create a PostgreSQL user?

1 2532

write a query to find 4th max salary

7 8227

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 5793

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

1 3096

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?

1835

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 5306

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 4177

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 6263

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 12016

Un-Answered Questions { Databases }

Is BCNF better than 2NF & 3NF? Why?

1047

How do I keep my database up to date?

929

How would you import a sharepoint list?

800

Other than truncate statement, which other command can by-pass the trigger on the tables?

1134

What the different components of Replication and what is their use?

1069

How can you load microsoft excel data into oracle? : aql loader

1174

Can mysql store files?

925

What are the types of queries in sql?

1086

Why do we need connection pooling?

803

How do you write an inner join query?

952

State the criteria which a trusted publisher should meet before adding him?

858

How to check database size in Oracle?

1191

What is the difference between BPA AND Contract What are documents and test cases u followed

2379

What does database administrator do?

571

What is postgresql written in?

923

For More Un-Answered { Databases } Questions Click Here