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 5624

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 3936

Issues related in upgrading SQL Server 2000 to 2005 / 2008

1890

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 7560

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 }

Hi, I want do a course in DWH Informatica Administrator and Abinito Administrator please tell me some institute in chennai and i am searching for a job,so please help me and my mail id : satty_rh@yahoo.co.in Thanks, Kumar

1982

How do you create a simple access database?

967

What is reference section?

1009

Why do you need a sql server?

1115

What is sleeping status in sql server?

1027

what are the types of join and explain each? : Sql dba

1041

Explain an index segment?

1124

Explain what is the purpose of sql profiler in sql server?

1079

Is java required for oracle client?

1002

What is trigger in sql?

1105

what is a transaction and what are acid properties? : Sql server database administration

1027

Can a database table exist without a primary key?

955

When is the explicit cursor used ?

1038

How to convert character strings into numeric values?

1100

What is pdo database?

946

For More Un-Answered { Databases } Questions Click Here