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

Will the writetext statement activate a trigger?

1116

Other than truncate statement, which other command can by-pass the trigger on the tables?

1149

Is it important for a database administrator to understand the operating system and file access?

1016

What is the fastest way to permanently delete a 1 million row table named customers?

1269

How do you rebuild an identity column?

968

Define a cross join?

1042

Explain an incremental backup?

1018

How will you know when statistics on a table are obsolete?

1095

How you can find out if an index is useful to the optimizer?

954

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

1008

What are statistics?

1017

Can a unique index be created on a column, which contains null?

934

How can a database be repaired?

1006

What are the differences between triggers and stored procedures?

1085

Where are full-text indexes stored?

1006

Un-Answered Questions { Databases }

What is function and stored procedure?

860

What is shrink log file?

922

What is an execution plan? How would you view the execution plan?

1095

How to implement a database management system?

1071

How do I completely remove mysql from windows?

994

What is the basic structure of an sql?

1120

How to generate create procedure script on an existing stored procedure?

1027

Write a sql query to sort on different column name according to the parameters passed in the function?

920

What is a recursive stored procedure?

1203

How do I find duplicates in a single column in sql?

1039

Is postgresql secure?

945

What are spatial functions?

823

What is sql server schema compare? How we can compare two database schemas?

1049

Can group functions be used in the order by clause in oracle?

1017

what is the difference between truncate and drop statements? : Sql dba

1144

For More Un-Answered { Databases } Questions Click Here