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

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

Oracle,

1129

what are the benefits of flashback feature?

Oracle,

1094

how can you communicate with operating system files from oracle?

Oracle,

1096

what functionality does oracle provide to secure sensitive information?

Oracle,

1055

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

Oracle,

1062

when does an alert gets signaled?

Oracle,

1114

what are the types of connection load-balancing?

Oracle,

1048

how can you create a user-defined lock?

Oracle,

1058

Can you redefine a table online?

Oracle,

1160

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

Oracle,

1059

what is the use of ocr?

Oracle,

1079

what is grd?

Oracle,

1157

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

Oracle,

1141

what is the use of recording information about current session?

Oracle,

1112

how can you enable flashback feature?

Oracle,

1010

Un-Answered Questions { Databases }

Why should one not prefix user stored procedures with ‘sp_’?

1104

Mention the 3 ways to get a count of the number of records in a table.

1029

what type of index will get created after executing the above statement? : Sql server database administration

1028

What is the difference between multiload and fastload interms of performance?

1052

How to maintain a fill factor in existing indexes?

1060

How do I tune a sql query?

1044

What is a snapshot log?

1053

What are the types of keys?

1070

How do I start mongodb locally?

What is the sql query to find the employee who has Nth maximum salary?

5439

What is a dead lock in oracle?

1181

What are the different methods to insert document?

what is a trigger? : Sql dba

1095

What is regclass in postgresql?

991

Explain the benefits of running stored procedure on a database engine?

985

For More Un-Answered { Databases } Questions Click Here