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

What is a database example?

1028

What is difference between data and database?

1160

Is microsoft access used anymore?

866

What are the benefits of using access?

971

Where is the quick access toolbar located?

1020

How do I order columns in sql?

1072

How do you concatenate in sql?

1086

What is having clause in sql?

1018

What is sorting in sql?

984

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

1005

What is sorting in dbms?

1010

Can we use two order by clause in query?

1015

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 ?

1093

What is Collation Sensitivity ? What are the various type ?

1001

How can a user get the current SQL version?

2 2012

Un-Answered Questions { Databases }

Is null in mysql?

913

What is meant by temporal data?

1001

What is a mongodb cluster?

What are the data types in ms access?

931

What are the disadvantages of views in a database?

1102

Does office 365 include ms access?

907

Does sql support programming?

1115

How is data stored in postgresql?

896

Is sybase a database? Explain.

1012

Why do we create stored procedures & functions in pl/sql and how are they different?

993

What is use of except clause? How does it differ from not in clause?

1066

Where do we use decode and case statements?

1060

What is database client?

1047

What is recursive stored procedure?

1141

Why packages are used in oracle?

1118

For More Un-Answered { Databases } Questions Click Here