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

A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?

571

How can you determine the space left in a file system?

665

You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.

602

Can you remove an open file under unix?

706

How can you determine if an oracle instance is up from the operating system level?

579

When should you increase copy latches?

655

How to uncatalog backup?

577

If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?

1203

What causes the "snapshot too old" error? How can this be prevented or mitigated?

529

How many redo logs should you have and how should they be configured for maximum recoverability?

577

How to drop an oracle database?

580

Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?

604

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

551

Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?

541

Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?

627

Un-Answered Questions { Databases }

You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?

624

What is the latest version of microsoft sql server?

1069

Explain about the return statement?

893

Is microsoft access important?

914

How to count duplicated values in a column in ms sql server?

1110

What is the phantom problem?

1018

how node connect with cpu?

2151

Can you have more than one content canvas view attached with a window ?

2344

What does the not null constraint do?

1122

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5597

Do you know what are different types of replication in sql server?

1118

What is the difference between DATETIME2 and DATETIME?

1092

Explain the use of decode function

What is database replication?

1162

Is microsoft access part of office?

893

For More Un-Answered { Databases } Questions Click Here