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

What is the use of custom fields in report?

957

What is bit data type?

992

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

921

How sql server enhances scalability of the database system?

1141

What is partitioned view?

865

Define compound operators?

876

What are the filtered indexes?

989

Explain transaction server consistency?

933

What is it unwise to create wide clustered index keys?

969

Explain transaction server implicit?

939

Define inner join? Explain with an example?

937

Explain the difference between function and stored procedure?

913

Explain the architecture of ms sql reporting service?

883

What is lock escalation and what is its purpose?

934

Explain syntax for dropping triggers?

898

Un-Answered Questions { Databases }

What is oracle database client?

990

How to connect sybase database from python?

975

How do you write an inner join query?

909

What is the difference between nvl and nvl2?

908

How can I delete duplicate rows?

978

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

974

Tell me in brief how sql server enhances scalability of the database system?

951

What is the usage of the sign function?

1033

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1824

How do you check data on pgadmin 4?

725

What is oracle join syntax?

961

What are the data types in postgresql?

846

Explain the use of owner option in exp command.

1006

what is table? : Sql dba

1008

How to maintain a fill factor in existing indexes?

962

For More Un-Answered { Databases } Questions Click Here