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

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

Patni,

1 2686

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?

1 2867

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 9959

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.

1 2218

Explain about query and reporting.

1 2146

How to combine two function together?

1 2216

How to use timestamp datatypes

1 2084

How to replace not in with not exist?

1 2196

Explain the family trees and connection by clause.

1 4468

Write the difference between case version and decode version.

2 4950

Write short notes on manual refreshes.

1 2798

How to create an external table.

1 4168

How to customize error conditions.

1 2208

How to generate OIDS

1 2348

How to use online Backups?

1 2272

Un-Answered Questions { Databases }

Any work done in oracle workflow builder. Did you customize or build a new workflow?

Can one drop a column from a table?

1075

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1015

Were you involved in any data conversion, which one?

Is microsoft getting rid of access?

877

Design database draw er diagram for a certain scenario ?

4635

What versions of clipper does netlib support?

1064

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1118

How to write a left outer join with the where clause in oracle?

1136

How can I check that whether automatic statistic update is enabled or not?

1101

Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:

2297

Is it possible to have clustered index on separate drive from original table location?

1026

What is sql server query analyzer?

1112

what are all the common sql function? : Sql dba

1113

What are the different subsets of sql?

1635

For More Un-Answered { Databases } Questions Click Here