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 pl/sql table? Why is it used?

1060

What is the difference between rollback and rollback to statements?

1069

How many types of triggers exist in pl/sql?

1086

What are some predefined exceptions in pl/sql?

1180

Explain the purpose of %type and %rowtype data types?

943

State few characteristics of pl/sql?

987

What are pl/sql packages?

1112

What is postgresql? Explain the history of postgresql.

898

Provide an explanation about write ahead logging?

805

What are string constants in postgresql?

886

List different datatypes of postgresql?

808

What is multi-version control?

829

What are the indices of postgresql?

932

List different advantages of postgresql?

892

Provide a brief explanation of the functions in postgresql.

819

Un-Answered Questions { Databases }

What is row-level compre?

1016

Mention what is olr?

What is the difference between varchar and varchar types?

1082

What is where clause in sql?

1053

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1410

What is the difference between microsoft sql and mysql?

971

Explain Enterprise Resource Planning (ERP), and what sort of a database is utilised in an ERP application?

965

What are the sql aggregate functions?

1143

Does server sql treat char as a variable-length or fixed-length column?

1056

Is subquery faster than join?

1019

Does google use mongodb?

is there a column to which a default can't be bound? : Sql server database administration

1025

How to insert new line characters into strings?

1005

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

1230

Does sql server 2000 clustering support load balancing?

987

For More Un-Answered { Databases } Questions Click Here