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

What are all new concepts in SQL Server 2008? That is Exactly Difference between 2005 to 2008

IBM,

2 8719

What is Trace flag?

Wipro,

1 4627

Differences between Standby Vs No recovery?

Wipro,

2 16713

what is lazy writer?

Wipro,

1 8818

Can we move Resource database from one path to another? If yes,How can we?

Wipro,

1 7208

What is the use of Port no?

Wipro,

1 4746

Can you explain some of the DTS problems?

UBS, Wipro,

1 4812

What is Check point? Explain in Brief what it will do?

Wipro,

1 6084

What is DAC? what is the use of it?

Wipro,

1 5975

what is Buffer cash and Log Cache? Can you Explain it?

Wipro,

1 8909

if a table is getting updated what happens if a function is called from sql query?

RBS,

2 9294

hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution

2 4532

how can create data base link for tow servers (scott schema) give examples plz

2 5318

using comand prompt how can import table data and table space with example

2 5645

What is the mandatory setup in cyclecount ?

Oracle,

2753

Un-Answered Questions { Databases }

Where is mongodb data stored mac?

Why plvtab is considered as the easiest way to access the pl/sql table?

1216

What is the command used to fetch first 5 characters of the string?

1401

how many sql dml commands are supported by 'mysql'? : Sql dba

1123

How do you edit data in pgadmin?

857

What are different types of data models available? Explain with example?

1107

How to delete/drop an existing postgresql database?

903

How to find the login name linked to a given user name?

1011

What is dbms in mysql?

971

What mysql means?

940

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

1137

How many columns are in a database table?

905

1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

17641

Who owns postgres database?

816

What are the new features of sql server 2012 reporting service?

133

For More Un-Answered { Databases } Questions Click Here