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

How to turn on or off recycle bin for the instance?

1083

How to assign a table row to a record variable?

1040

How to define an anonymous procedure with variables?

1158

How to declare a local variable?

1112

What is a table index?

1098

How a database is related to tablespaces?

1031

How to define a specific record type?

1084

How to estimate disk space needed for an export job?

1049

How to use "if" statements on multiple conditions?

1174

What is the data pump import utility?

1035

How to update a table row with a record?

1008

What is an index associated with a constraint?

1040

What are the numeric comparison operations?

1111

How to delete a column in an existing table?

1076

How to use an explicit cursor without open statements?

1055

Un-Answered Questions { Databases }

How to find the source of a table in sql server?

997

How real and float literal values are rounded?

1157

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

1014

How do check the current running processes?

953

Do you know how to store and query spatial data?

1038

What are the steps to follow to configure SQL*Net?

1039

Mention the differences between local and global temporary tables.

1043

What do database buffers contain?

1029

Where can you find the error log information? : sql server database administration

1025

Which two can be implemented as a centrally located logical architecture?

923

What is primary key index?

979

Is mysql case-sensitive?

888

how can u get last observation in an unknown dataset ?

2436

Write the command to remove all players named sachin from the players table.

1183

How to rollback the current transaction in oracle?

1054

For More Un-Answered { Databases } Questions Click Here