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

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

1 639

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

1 710

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.

1 661

Can you remove an open file under unix?

1 755

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

1 635

When should you increase copy latches?

1 708

How to uncatalog backup?

1 643

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?

1 1262

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

1 576

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

1 625

How to drop an oracle database?

1 627

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?

1 646

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

1 613

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

1 596

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?

1 678

Un-Answered Questions { Databases }

Have you used lexical parameters in reports?

Why we use the openxml clause?

1072

What is the current version of sql?

1091

Is microsoft getting rid of access?

883

Disadvantages of the indexes?

1219

Which statement is used in a select query for partial matching?

1239

What is the difference between upgrade and migration in sql server?

1179

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

If a cursor is open, how can we find in a pl/sql block?

1235

Are you familiar with user exits in reports?

How to use values from other tables in update statements using oracle?

1149

Is primary key always clustered index?

1092

What is subquery? Explain the properties of a subquery?

1056

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1293

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

8225

For More Un-Answered { Databases } Questions Click Here