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

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

If you have an example table, what is the best way to get sizing data for the production table implementation?

565

What file will give you oracle instance status information? Where is it located?

634

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

597

How would you find total size of database in os level?

578

What is ora-1555 snapshot too old error? Explain in detail?

701

What is an artificial (derived) primary key?

621

What is different type of rman backup?

679

You see multiple fragments in the system tablespace, what should you check first?

599

Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?

545

Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?

592

How do you set up your tablespace on installation level: low?

582

If you see the value for reloads is high in the estat library cache report is this a matter for concern?

643

If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)

590

What parameters control copy latches?

610

Un-Answered Questions { Databases }

In DBMS, what are the two integrity rules used?

959

what is the scripts in data base?

2171

Is microsoft access difficult to learn?

801

How do you run a trace?

920

What is optimization in database?

954

State few characteristics of pl/sql?

991

How do I start mongodb in ubuntu?

What is the difference between substr & instr functions?

1249

how to shutdown mysql server? : Sql dba

1117

Is ssrs support other database except ms sql server?

142

What is auto increment?

1020

What is the definition for sql server 2000?

1113

What's the difference between file and database? Can files qualify as a database?

979

How to increment dates by 1 in oracle?

1112

what's the information that can be stored inside a bit column? : Sql server database administration

1047

For More Un-Answered { Databases } Questions Click Here