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

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

Patni,

2626

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2818

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

4 9783

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

2171

Explain about query and reporting.

2097

How to combine two function together?

2138

How to use timestamp datatypes

2043

How to replace not in with not exist?

2097

Explain the family trees and connection by clause.

1 4392

Write the difference between case version and decode version.

2 4821

Write short notes on manual refreshes.

2742

How to create an external table.

1 4093

How to customize error conditions.

2153

How to generate OIDS

2266

How to use online Backups?

2207

Un-Answered Questions { Databases }

List the ways in which dynamic sql can be executed?

1020

How to run sql statements with oracle sql developer?

1076

What do you understand by a database object? Can you list a few of them?

1020

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1088

How do I completely uninstall postgresql?

872

Explain the difference between sql and couchdb?

What’s the use of custom fields in report?

945

what are all the different types of indexes? : Sql dba

1052

What is the difference between mysql and sql?

1056

What are the applications of database?

893

How to run queries with sql server management studio express?

1098

Why would you use sql agent? : sql server DBA

1092

What are the new features in release 11i?

What does trigger mean in psychology?

967

Which table keeps information about stored procedures?

945

For More Un-Answered { Databases } Questions Click Here