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 is constraints and its types?

966

How to find which stored procedure is currently running in sql server?

1007

How to get all stored procedures in sql server?

1015

How do you debug a procedure in sql server?

969

How to check if stored procedure is running in sql server?

1082

Why join is faster than subquery?

1124

What is before trigger?

1019

Which is faster union or join?

988

Why is a primary key important?

1067

What is mutating trigger?

1035

Which is better cte or subquery?

1047

Is it possible to update views?

976

Which is faster count (*) or count 1?

1053

Why use subqueries instead of joins?

1098

Which normal form is best?

964

Un-Answered Questions { Databases }

What happens if variable names collide with table/column names?

1215

What is oracle log switch?

636

What are the features of rdbms?

878

what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

1138

what is the difference between substr and instr function in oracle?

1104

What is oracle d2k? Why we use it?

explain different types of constraints? : Sql server database administration

965

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

1021

Can sql servers linked to other servers?

1062

What is 2nf example?

1009

If you see the value for reloads is high in the estat library cache report is this a matter for concern?

642

How would you lock a table in sybase?

952

How much is a sql server license?

974

What is the index requirement in SQL Azure?

Why is it called mysql?

928

For More Un-Answered { Databases } Questions Click Here