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

how can you generate profile of pl/sql applications to identify performance bottlenecks?

Oracle,

1081

what are the benefits of flashback feature?

Oracle,

1024

how can you communicate with operating system files from oracle?

Oracle,

1051

what functionality does oracle provide to secure sensitive information?

Oracle,

994

how can you find out if a table can be redefined?

Oracle,

1014

when does an alert gets signaled?

Oracle,

1052

what are the types of connection load-balancing?

Oracle,

1000

how can you create a user-defined lock?

Oracle,

1019

Can you redefine a table online?

Oracle,

1117

suppose you want to audit specific activities on sensitive data. How can you achieve that?

Oracle,

1002

what is the use of ocr?

Oracle,

1033

what is grd?

Oracle,

1096

how can you get actual data change values from previous transactions in oracle?

Oracle,

1089

what is the use of recording information about current session?

Oracle,

1054

how can you enable flashback feature?

Oracle,

954

Un-Answered Questions { Databases }

What is ms sql server index?

1105

What is full join in sql?

991

What is BCP? When does it used in sql server 2012?

1061

Is mysql still relevant?

909

when is the use of update_statistics command? : Sql dba

1049

Suppose database is running slow, what will you do?

2520

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2322

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

1171

What is sql sandbox in sql server?

1223

How much is a sql server license?

953

What is replication factor in mongodb?

What is regexp?

1141

What is file based approach?

941

Where the sql logs gets stored?

986

What is the usage of synonyms?

1143

For More Un-Answered { Databases } Questions Click Here