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

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1875

What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue

IBM,

2 5726

You are doing log shipping due to some reasons it is failing. How you will proceed from there

2115

Working with TLogs

1900

How you trouble shoot when any job fails

1984

How to trouble shoot if unable to connect SQL Server

2034

If user is owning any SQL Objects, can we drop that user

2133

Can we drop user if user mapped to any logins

1 3358

How to transfer Logins from SQL Server 2000 to 2005

2 4030

Issues related in upgrading SQL Server 2000 to 2005 / 2008

1944

Observed that some SP’s / Jobs are processing late, how to troubleshoot to improve performance?

1 3325

T1: T2 A X--- this is updated record B B like this T1 table having no.of records updated. write a query"retrive updated record from T2"

Cognizant,

2 5065

What is meant by Materialized view?

iGate, Marlabs, Polaris,

2 7695

what is the Ticketing tool used in Wipro technologies at Bangalore...???

Liquid Hub,

8206

I have a table that log salary-increase-process have fields: autoid, old_salary, acctno and table EMP: acctno, name, salary I want to list count increase-salary of employees, each have old_salary, new_salary. Help me with SELECT statement, please!

1 3542

Un-Answered Questions { Databases }

How to create table show example

1021

What are differences in between sql server 2012 and sql server 2016?

1099

How would you extract DDL of a table without using a GUI tool?

2538

What is a left join?

1010

what is log shipping? : Sql dba

1167

What is the diff bet plan,package,dbrm?

1164

What is a relational database management system?

1175

What is the maximum size of sql server database?

1066

What are types of data model?

601

How do I open a sybase database?

1057

Why indexing is needed?

1046

How to link tables in sql server?

978

Write a sql query to sort on different column name according to the parameters passed in the function?

964

What is data type for image in mysql?

907

What is a select query statement in ms sql server?

1132

For More Un-Answered { Databases } Questions Click Here