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

Explain the collation?

1127

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

892

Describe how to use linked server?

1038

You want to implement the one-to-one relationship while designing tables. How would you do it?

981

Give a example to search fr a string in all stored procedure in sql server.

1004

Explain the etl (extraction, transformation, and loading)?

1009

What is a trace frag?

1103

Is it possible for a stored procedure to call itself or recursive stored procedure?

964

What is similarity and difference between truncate and delete in sql?

1119

Difference between drill down and drill through report.

968

What is openxml in sql server?

1193

What is replace and stuff function in sql server?

1084

What are the rules to use the rowguidcol property to define a globally unique identifier column?

1039

What is scheduled job and how to create it?

1014

Describe in brief sql server monitoring ways.

1068

Un-Answered Questions { Databases }

Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?

2948

What is use of postgresql?

906

What are the consideration at tehe migration of Oracle 9i to 10G.

3080

Is mongodb a data lake?

what is ora 24313?what is the procedure to exclude that error?

2581

what are numeric data types? : Sql dba

1073

How to find table changes in sql server?

1137

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1355

What is the use of a namespace in mongodb?

Can we insert data in view oracle?

1054

How do I force an index to be used in sybase?

850

Which query language is used for neo4j?

define and explain the differences between clustered and non-clustered indexes.

1205

How to do performance tunning a database in DB2 V8.2 UDB in linux

2277

What are different partitioning techniques in database?

912

For More Un-Answered { Databases } Questions Click Here