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

ehat is the default port no of sql 2000?

IBM,

2 5037

why Datapump is faster than traditional export and import

Mphasis,

4 21550

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

Mphasis,

2 5331

what is Full Text Search ?

TCS,

1 5255

New concepts of sql server 2005 use in your project.

TCS,

2363

default databases available in sql server and there uses ?

TCS,

4 7137

what is statistics

1 4329

query processing

2175

sql server architecture ?

2394

explain query execution plan

1 4585

how can ur insert the emp table

Wipro,

3 7147

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 6011

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 7818

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

Microsoft,

3 6471

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

Microsoft,

2066

Un-Answered Questions { Databases }

how to dynamically change the page size of d2k reports?

What happens on checkpoint?

1026

Is it true that mongodb uses bson to represent document structure?

What is the use of sign function?

1126

What is meant by distributed system?

997

What are window functions in sql server?

1011

List out the difference between neo4j graph database and mysql database?

Explain iaas, paas and saas?

which gives Oracle R12 Financial training in delhi please give me answer its urgent?

2499

What is a partition function in sql server?

1141

Why its better to use files than a DBMS when there are multiple users to access the data

1181

i have a repeating frame that prints on every page for a product code. But when on page ends the info associated with that product code is truncated and not overflowed to the next page.On the next page data with the new product code is displayed. I want the data for one product code to be continued on the next page if it does not fit on a single page. The values are as: repeating frame vertical = variable horizontal = variable page protect = 0 print object on = first page base printing on = enclosing object for the outermost frame which encloses the repeating frame: print object on = last page base printing on = anchoring object end of layout section = yes rest all the values are same as the repeating frame

2997

What is difference between logical standby database and physical standby database?

676

How column data types are determined in a view?

965

How to create a simple user defined function in ms sql server?

1027

For More Un-Answered { Databases } Questions Click Here