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

What are the purposes and advantages stored procedure?

971

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

1068

What is extended stored procedures?

975

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

1063

What security features are available for stored procedure?

1047

What is stored procedures?

1059

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

1025

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

938

Explain syntax for viewing, dropping and disabling triggers?

968

Explain triggers?

1022

How to apply cascading referential integrity in place of triggers?

1051

How to invoke a trigger on demand?

1102

What is ms sql server triggers?

1028

What are the instances when triggers are appropriate?

991

How many triggers you can have on a table?

1007

Un-Answered Questions { Databases }

What are sql injection vulnerabilities?

997

How do I delete a trigger?

973

How you can move data or databases between servers and databases in sql server?

1061

Differentiate pl/sql and sql?

1075

Explain logical operators in sql server?

1121

What is normalization 1nf 2nf 3nf?

1070

What is scan table/view and seek table/view when its occurs? : sql server database administration

1067

When do we use triggers?

1092

What is Fully Functional dependency?

968

What is ole automation?

How does index makes search faster?

987

Can you roll back the ddl statement in a trigger?

990

Is postgres distributed?

778

How do I create a memory optimized filegroup?

979

What is the difference between a database and instance?

704

For More Un-Answered { Databases } Questions Click Here