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?

979

What is difference between data and database?

1093

Is microsoft access used anymore?

822

What are the benefits of using access?

914

Where is the quick access toolbar located?

968

How do I order columns in sql?

1007

How do you concatenate in sql?

1027

What is having clause in sql?

963

What is sorting in sql?

944

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

956

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 1881

Un-Answered Questions { Databases }

What is a trigger in sql?

1202

What do you know about mongodb?

What is mysql in dbms?

1031

how to implement the logic in procedures if the source side data deleted that will reflect the target side table?

687

What does sql server mean?

1067

What is the use of partition by in sql?

995

How to loop through returning rows?

1034

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

957

When does checkpoint occur in dbms?

1032

Why do we need cursor in pl sql?

1133

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1438

What is concurrency in oracle?

1008

What is the best free database software?

873

Is oracle faster than sql server?

953

How couchdb is different from other sql databases?

For More Un-Answered { Databases } Questions Click Here