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 2433

How to take backup of database?

1 2314

How to create a PostgreSQL user?

1 2453

write a query to find 4th max salary

7 8011

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

1 3131

How global cursor can be declare with dynamic trigger ?

2163

how view used for security purposes?

Glam India,

3 5664

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

1 2967

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,

2022

what is tripstop report?

1777

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 5209

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?

1710

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 4051

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 6082

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 11843

Un-Answered Questions { Databases }

What are different types of joins in the sql?

935

What do you mean by cql?

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

128

Differences between package and loadplans?

553

How many categories of functions based their return modes?

1070

Describe the three levels of data abstraction?

845

What is difference between primary and secondary key?

989

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

869

What is a string in mysql?

865

How do indexes help, types?

931

What packages(if any) has oracle provided for use by developers?

5739

Explain can you implement data mining in ssrs?

156

what is 'mysqladmin' in mysql? : Sql dba

987

How to rename databases in ms sql server?

1145

How do I view postgresql data?

741

For More Un-Answered { Databases } Questions Click Here