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

I am new to sas, can anybody explain the process of extracting data from source systems,storing in ods and how data modelling is done?

1 30

What are the various tools? - Name a few?

1 32

What are snapshots? What are materialized views & where do we use them? What is a materialized view?

1 26

Where do we use connected and un connected lookups?

1 35

How to determine what records to extract?

1 34

What are materialized views & where do we use them? What is a materialized view log?

1 29

How do you analyze the tables

1 30

How to present flrehird.log file from filling up the disk partition?

1 28

How to pipe multiline string to isqi?

1 29

How to connect with firebird database in delphi using tsqlconnection?

1 34

Is there a way to detect whether fbclient.dll or tbembed.dll is loaded?

1 34

How lo drop all foreign keys in database?

1 29

Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?

1 620

How can be determining the size of the log files?

1 654

Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.

1 638

Un-Answered Questions { Databases }

Why use identity in sql server?

1191

What is a scheduled job or what is a scheduled task?

1033

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8225

What is the current version of sql?

1091

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2088

in oracle BPM composer in part BA model on design model in enterprise model i cannot connection with value chain model work not links in part properties do you can me help me?

1605

Does view occupy space?

1005

How do I find query history in sql server?

1018

Can one drop a column from a table?

1081

how to use regular expression in pattern match conditions? : Sql dba

1105

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

1128

What is a coalesce function?

1275

Is primary key always clustered index?

1092

What are the properties of the transaction?

1069

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

2176

For More Un-Answered { Databases } Questions Click Here