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

How do you prevent oracle from giving you informational messages during and after a sql statement execution?

596

How can you find all the processes on your system?

585

What happens when the default and temp tablespace clauses are left out from create user statements?

589

What is pct free/pct used/pct increase parameter in segment? What is growth factor?

577

When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?

612

What is pct free/pct used/pct increase parameter in segment?

590

What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?

607

How can you find out how many users are currently logged into the database? How can you find their operating system id?

558

What happens if a tablespace clause is left off of a primary key constraint clause?

589

Discuss row chaining, how does it happen?

582

You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?

618

How can you find dead processes?

550

I am getting error "no communication channel" after changing the domain name? What is the solution?

608

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

560

You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?

605

Un-Answered Questions { Databases }

what is profile in odi?

662

What do you mean by atomicity and aggregation?

923

Does postgres automatically index primary key?

812

How to execute the package in oracle?

1096

To do safe backups what is the feature in mongodb that you can use?

Can we join tables without foreign key?

975

A tablespace has a table with 30 extents in it. Is this bad? Why or why not.

597

can I ask about perl, dbi and dbd informix? Other products?

111

Is it possible to communicate to couchdb without going through http/ api?

what is the full procedure for using store procedure in informatica7.1?

2274

Is access difficult to learn?

845

How do you create an access file?

993

How do you exit a database?

912

How many columns can a postgres table have?

808

application server is slow what may be the problem

2238

For More Un-Answered { Databases } Questions Click Here