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

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

1807

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

IBM,

2 5623

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

2072

Working with TLogs

1837

How you trouble shoot when any job fails

1937

How to trouble shoot if unable to connect SQL Server

1993

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

2080

Can we drop user if user mapped to any logins

1 3287

How to transfer Logins from SQL Server 2000 to 2005

2 3935

Issues related in upgrading SQL Server 2000 to 2005 / 2008

1889

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

1 3242

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 4950

What is meant by Materialized view?

iGate, Marlabs, Polaris,

2 7559

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

Liquid Hub,

8158

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 3464

Un-Answered Questions { Databases }

What are the database objects?

1061

How to verify the port number of the sql server?

1168

How do I delete a row in mysql?

973

Write the fastest query to find out how many rows exist in a table?

1121

What are the types of normalization?

1031

How to remove duplicate rows from table?

1253

What are the best monitoring tools for the sybase database?

826

What part does database design plays a role in performance of an sql server-based application?

988

How to add, remove, modify users using sql?

1039

What is a trace file and how is it created in oracle?

1062

What is role playing dimension with two examples? : sql server analysis services, ssas

1010

List the different types of collation sensitivities in sql server?

1046

How to execute stored procedure in select statement sql server?

1065

What are the key features of mongodb?

How sql server executes a statement with nested subqueries?

1032

For More Un-Answered { Databases } Questions Click Here