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 2701

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 2875

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 9999

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 2232

Explain about query and reporting.

1 2157

How to combine two function together?

1 2223

How to use timestamp datatypes

1 2094

How to replace not in with not exist?

1 2209

Explain the family trees and connection by clause.

1 4483

Write the difference between case version and decode version.

2 4969

Write short notes on manual refreshes.

1 2810

How to create an external table.

1 4176

How to customize error conditions.

1 2225

How to generate OIDS

1 2361

How to use online Backups?

1 2276

Un-Answered Questions { Databases }

What are the types of database explain each of them briefly?

1049

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

2307

what are the advantages of sql ? : Sql dba

1136

Do we need to rebuild index after truncate?

1128

how to escape special characters in sql statements? : Sql dba

1110

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

Can we use distinct and group by together?

1129

what is the age limit for groups1 examination

2335

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1207

what is schema? : Sql dba

1133

How to Change a users password from unix shell.

1212

How to put more than 1000 values into an oracle in clause?

1104

Who proposed the relational model?

1027

please send me oracle pl/sql exp resume. and also faqs...

2566

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2174

For More Un-Answered { Databases } Questions Click Here