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

What are the purposes and advantages stored procedure?

1020

Determine when to use stored procedure to complete sql server tasks?

1120

What is extended stored procedures?

1031

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

1126

What security features are available for stored procedure?

1080

What is stored procedures?

1114

In what three ways is the return statement used in a stored procedure?

1068

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

979

Explain syntax for viewing, dropping and disabling triggers?

1003

Explain triggers?

1066

How to apply cascading referential integrity in place of triggers?

1096

How to invoke a trigger on demand?

1156

What is ms sql server triggers?

1075

What are the instances when triggers are appropriate?

1022

How many triggers you can have on a table?

1035

Un-Answered Questions { Databases }

What is an index associated with a constraint?

1094

Explain the components of rdbms?

1022

between cast and convert which function would you prefer and why?

1023

Can we use mongodb with java?

Why do we use trigger?

1030

what is the maximum size of a row? : Sql server database administration

1084

How do I start a pgadmin server?

914

Can we use having clause without group by?

1032

What is a table in a database?

1098

What is rdms?

999

what is oltp (online transaction processing)? : Sql dba

1132

How do I connect to a postgresql database in windows?

966

What are the functions in mysql?

1012

Difference between case & decode?

726

how to dump all databases for backup. Backup file is sql commands to recreate all db's.

999

For More Un-Answered { Databases } Questions Click Here