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

Explian rowid, rownum? What are the psoducolumns we have?

1000

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1048

What is the starting oracle error number?

1052

What is the starting oracle error number? What is meant by forward declaration in functions?

994

In pl/sql, what is bulk binding, and when/how would it help performance?

994

How would you pass hints to the sql processor?

980

Explain two easy sql optimizations.

1008

How do I write a cron which will run a sql query and mail the results to agroup?

975

Why is sql*loader direct path so fast?

1102

Name three sql operations that perform a sort.

1011

What is the use of the drop option in the alter table command?

596

How do you use automatic pga memory management with oracle 9i and above?

589

Which function is used to find the largest integer less than or equal to aspecific value?

564

Explain procedure to change characterset of a database.

631

What is oracle archived redo log?

593

Un-Answered Questions { Databases }

What is the purpose of a staging area?

What is unpivot?

1011

How do you start single user mode in clustered installations?

941

Is primary key indexed by default?

791

What is pg server?

897

Is driver a software?

839

How does mongodb replica set work?

Who developed mysql?

1013

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1945

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

118

Is foreign key required?

739

How to recreate the index on a firebird table?

906

Why do we need database normalization?

997

Can postgres use multiple indexes?

838

How to connect to a local oracle 10g xe server?

992

For More Un-Answered { Databases } Questions Click Here