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

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?

1 682

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

1 637

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

1 688

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

1 641

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

1 631

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

1 758

What is an artificial (derived) primary key?

1 682

What is different type of rman backup?

1 746

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

1 654

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

1 591

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?

1 653

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

1 627

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

1 697

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

1 650

What parameters control copy latches?

1 656

Un-Answered Questions { Databases }

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2089

How do I remove duplicates in two columns?

1178

How to Change a users password from unix shell.

1213

i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in

1856

List the ways in which dynamic sql can be executed?

1083

How do I find the sql server version?

1099

How to select all columns of all rows from a table in oracle?

1124

Is inner join faster than left join?

1273

How can you append an identity column to a temporary table?

1065

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1041

how to escape special characters in sql statements? : Sql dba

1110

what is bcp? When does it used? : Sql dba

1053

what is sql server agent? : Sql dba

1179

what is schema? : Sql dba

1137

please send me oracle pl/sql exp resume. and also faqs...

2566

For More Un-Answered { Databases } Questions Click Here