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

Is it possible to call a stored procedure within a stored procedure?

1032

What function does a database engine serve in the sql server?

1087

Explain the creation and execution of a user-defined function in the sql server?

1113

List the different normalization forms?

1025

What are a scheduled jobs?

998

Why is replication required on the sql server?

1110

Which language is supported by sql server?

1069

Which tcl commands are available on the sql server?

1145

List the types of recovery model available in sql server?

976

List the advantages of using stored procedures?

1115

What command is used to delete a table from the database in the sql server and how?

1198

When is update_statistics command used?

1091

What are 3 ways to get a count of the number of records in a table?

1127

What is a user-defined function in the sql server and what is its advantage?

1145

What are the pre-defined functions in the sql server?

1192

Un-Answered Questions { Databases }

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2097

What is the difference between truncate and delete in mysql?

1183

What is normal form in dbms?

961

How will you add a new style in a table?

850

Why use mysql procedures?

1034

How does distributed database work?

1042

What is ora-1555 snapshot too old error? Explain in detail?

739

How to Sync Two SQL Azure Databases?

121

Is facebook a database?

925

Explain the concepts and capabilities of sql server?

1018

What is the beast way to write CTE in SQL Server ?

1101

How do I truncate a sql log file?

1143

What is nosql database and why you use nosql database?

What do you mean by conflict serializability in dbms?

974

how can we repair a mysql table? : Sql dba

1043

For More Un-Answered { Databases } Questions Click Here