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

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?

What are the various tools? - Name a few?

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

Where do we use connected and un connected lookups?

How to determine what records to extract?

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

How do you analyze the tables

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

How to pipe multiline string to isqi?

How to connect with firebird database in delphi using tsqlconnection?

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

How lo drop all foreign keys in database?

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

560

How can be determining the size of the log files?

594

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

583

Un-Answered Questions { Databases }

What is sharding in mysql?

981

Explain the difference between sql and couchdb?

What is the anchoring in reports?

What is a user view?

770

Explain the covered query in mongodb.

Can you load data into multiple tables at once? : aql loader

1092

What are different types of statements supported by sql?

1175

What if your ocr (oracle cluster registry) is corrupted?

Can I use sql azure as a backup with log shipping or database mirroring?

156

How do I delete a query?

792

How many anonymous blocks can be defined?

1205

Is microsoft access like excel?

830

Have you created fact table and dimension tables?

656

How can you set the threshold at which sql server will generate keysets asynchronously?

1010

How to insert data from one table to another in postgresql?

847

For More Un-Answered { Databases } Questions Click Here