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

Are stored procedures compiled?

939

What are procedures used for?

1005

What is mutating error?

984

What is cross join example?

1021

What is difference between stored procedure and trigger?

1188

How do I save a stored procedure?

1026

How is debugging done?

991

What is the difference between left and left outer join?

963

Can we call procedure in select statement?

1074

What is a full join?

1012

What is the difference between row level and statement level trigger?

1035

How do I view stored procedures?

988

What is difference between cursor and trigger?

1085

What is sp_helptext?

1078

Can we create view in stored procedure?

988

Un-Answered Questions { Databases }

How to Declare Fixed Length String Value In PL SQL

1165

What is the difference between count 1 and count (*) in a sql query?

1011

what is the use of system.effective.date variable in oracle?

1133

What are the types of optimization?

972

Which sql most popular?

1004

What command do you type to exit the postgresql console application?

871

What do you mean by Correlated subquery?

871

What are triggers mysql?

912

Explain armstrong rules? How they are complete and/or sound?

915

How can you list all the table constraints in a database?

954

How to add a column ‘salary’ to a table employee_details?

1024

How to create new databases with "create database" statements?

1043

What is relationship? What number of sorts of relationship are there?

1165

What is check constraint in sql server?

1014

What is the scd? and Types of SCD?

644

For More Un-Answered { Databases } Questions Click Here