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 do you understand by pl/sql cursors?

1088

Enlist the characteristics of pl/sql?

1803

What do you understand by pl/sql records?

1018

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

1035

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

1 4927

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

1135

What is sql comments?

1075

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

1016

Which tcp/ip port does sql server run?

1008

What are different clauses used in sql?

1115

What are different joins used in sql?

1057

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

1043

What are different types of statements supported by sql?

1165

How many aggregate functions are available there in sql?

984

Why do we use sql constraints?

1170

Un-Answered Questions { Databases }

How to display row numbers with the records?

1080

Does dba need to know programming?

570

What is Data Dictionary Cache in Oracle?

1165

Mention the different types of cursor?

988

Which operator is used in query for pattern matching?

1089

Explain what is an index?

1056

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

1631

What do you understand by integration services in sql server?

962

What is database white box testing and black box testing?

1111

How do you optimize a stored procedure in sql?

957

How to use fetch statement in a loop?

1019

How to create a view on an existing table in ms sql server?

1128

What does dba stand for database?

601

What is pdo in mysql?

935

What is microsoft access?

863

For More Un-Answered { Databases } Questions Click Here