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

What do you understand by pl/sql cursors?

1155

Enlist the characteristics of pl/sql?

1850

What do you understand by pl/sql records?

1067

What do you understand by exception handling in pl/sql?

1089

Write a pl/sql script to display the following series of numbers: 99,96,93……9,6,3?

1 5020

What are the ways on commenting in a pl/sql code?

1211

What is sql comments?

1119

Write a sql select query that only returns each name only once from a table?

1081

Which tcp/ip port does sql server run?

1070

What are different clauses used in sql?

1175

What are different joins used in sql?

1109

Why do we use sql constraints? Which constraints we can use while creating database in sql?

1086

What are different types of statements supported by sql?

1218

How many aggregate functions are available there in sql?

1022

Why do we use sql constraints?

1217

Un-Answered Questions { Databases }

How to generate create view script on an existing view?

1045

What sql database should I use?

1203

ABOUT IDENTITY?

2112

What are the roles of dba?

1139

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2322

What are the advantages of using stored procedures?

1009

What is difference between function and trigger?

1120

What is the timestamp datatype in sybase?

1020

What is sql and also describe types of sql statements?

1116

What are %type and %rowtype for?

1114

Is microsoft access still available?

911

What is postgis and postgresql?

935

What is system global area (sga) in oracle?

1041

What are the different column comparison operators in mysql?

995

Explain oracle’s server parameter file.

1041

For More Un-Answered { Databases } Questions Click Here