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

ehat is the default port no of sql 2000?

IBM,

2 5130

why Datapump is faster than traditional export and import

Mphasis,

4 21735

orra 1555 what is this error,why it is occur?

Mphasis,

2 5487

what is Full Text Search ?

TCS,

1 5332

New concepts of sql server 2005 use in your project.

TCS,

2407

default databases available in sql server and there uses ?

TCS,

4 7297

what is statistics

1 4416

query processing

2221

sql server architecture ?

2442

explain query execution plan

1 4655

how can ur insert the emp table

Wipro,

3 7259

There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.

Microsoft,

2 6125

There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep

Microsoft,

4 7958

I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.

Microsoft,

3 6593

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

Microsoft,

2120

Un-Answered Questions { Databases }

When you use @@error and try-catch?

1100

Explain the use of rows option in imp command.

1143

How many number of columns can a RECORD GROUP have ?

2076

Which table keeps the locking information?

987

what is the different between now() and current_date()? : Sql dba

1077

Tell me when is the update_statistics command used?

1207

How many knowledge modules you used?

629

How many types of indexes are there in sql?

1048

What are the types of database servers?

1050

What is a mutating table error and how can you get around it?

1130

What is difference between 2 tier and 3 tier architecture?

834

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

977

What are the key configuration files for sql server reporting services ?

171

What is replication in mongodb?

Why do we use cursors?

1047

For More Un-Answered { Databases } Questions Click Here