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 are the limitations of sql express?

1069

Which language is used in sql?

1058

How delete all records from table in sql?

977

What does truncate mean in sql?

1021

How do I find duplicates in sql?

929

What is normalization sql?

1055

Is sql a microsoft product?

951

Is sql better than excel?

1153

Why is sql important?

1105

Does access use sql?

1039

Which sorts rows in sql?

1019

What are the different ways to optimize a sql query?

946

Why does sql need a server?

1039

What does count (*) mean in sql?

1583

What is pivot in sql?

915

Un-Answered Questions { Databases }

What do you understand by a profiler with reference to mongodb?

Explain procedure cache?

960

what is csv? : Sql dba

997

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 ?

1029

How to return top 5 rows in oracle?

1062

What is create statement?

954

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1163

How to select 10 records from a table?

1157

How do I enable remote access to postgresql database?

821

What is the Tune Query

2291

Write an sql query for deleting duplicate rows?

995

Who is dba in dbms?

581

Explain what are service-specific middleware?

972

What is crud in mongodb?

What is the name of query language used by neo4j?

For More Un-Answered { Databases } Questions Click Here