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

Display the records between two range?

2 3640

Select the Nth lowest value from a table?

4 5495

What is difference between Rename and Alias?

1 4489

Difference between an implicit & an explicit cursor.?

2 7436

What is a OUTER JOIN?

1 2814

What is the purpose of a cluster?

1 3361

What is OCI. What are its uses?

1 3230

How you open and close a cursor variable.Why it is required?

2 3797

Display Odd/ Even number of records?

3 6583

What are various constraints used in SQL?

Polaris,

1 3853

Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

1 3890

Difference between NO DATA FOUND and %NOTFOUND?

1 4491

Can you use a commit statement within a database trigger?

4 5473

What WHERE CURRENT OF clause does in a cursor?

2 4242

Table A has 5 rows and table B has 0 rows Cartesian join on A,B will have----rows

2 4037

Un-Answered Questions { Databases }

How to get a list of all tables in a database?

1060

Which language rdl files made of?

130

Explain filtered indexes?

1005

What is the purpose of TNS?

1034

Do you know concepts and capabilities of sql server?

1064

What is pdo connection?

885

What is the full form of mysql?

1014

How do I order by ascending in sql?

1026

What is database optimization?

959

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1974

What are all ddl commands?

1086

When would you prefer to have a minimum number of indexes?

911

What is the difference between a stored procedure and a query?

1093

Can we store videos inside the sql server table?

987

Create and insert into temp table in sql server?

1036

For More Un-Answered { Databases } Questions Click Here