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?

985

What is difference between data and database?

1098

Is microsoft access used anymore?

825

What are the benefits of using access?

916

Where is the quick access toolbar located?

973

How do I order columns in sql?

1012

How do you concatenate in sql?

1030

What is having clause in sql?

970

What is sorting in sql?

952

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

964

What is sorting in dbms?

965

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 ?

954

How can a user get the current SQL version?

2 1892

Un-Answered Questions { Databases }

What the different topologies in which replication can be configured?

1092

How do you know if sql server is running on your local system?

1043

Is mysql frontend or backend?

908

How to select some specific columns from a table in a query in ms sql server?

1005

What is hot backup and logical backup?

1051

How do I delete a row in mysql?

973

What do you understand by pl/sql cursors?

1090

Explain what is “asynchronous” communication in sql server service broker?

918

How to fetch alternate records from a table?

1245

What are the differences between decimal and float in ms sql server?

1253

How do I add a sybase driver to sql developer?

870

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

1040

How to create multiple collections in mongodb?

Explain syntax for dropping triggers?

934

Does an index slow down updates on indexed columns?

974

For More Un-Answered { Databases } Questions Click Here