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 a database example?

981

What is difference between data and database?

1096

Is microsoft access used anymore?

822

What are the benefits of using access?

914

Where is the quick access toolbar located?

970

How do I order columns in sql?

1008

How do you concatenate in sql?

1028

What is having clause in sql?

966

What is sorting in sql?

949

Which sql statement is used to delete data from a database?

959

What is sorting in dbms?

962

Can we use two order by clause in query?

967

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

What is Collation Sensitivity ? What are the various type ?

952

How can a user get the current SQL version?

2 1884

Un-Answered Questions { Databases }

What is Database Management System?

1190

Define mongodb SUM?

How many types of triggers in sql server?

1032

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1148

how many sql dml commands are supported by 'mysql'? : Sql dba

1123

What is meant by an index?

1145

Does mysql scale well?

895

Why do we use set serveroutput on?

966

Explain coalesce.

941

How to connect ms access to sql servers through odbc?

1030

Why is foreign key used?

834

Can primary key be a foreign key?

1059

Is sql harder than python?

1108

What is auto increment in sql?

1122

Is there a way to detect whether fbclient.dll or tbembed.dll is loaded?

For More Un-Answered { Databases } Questions Click Here