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?

931

What is difference between data and database?

1028

Is microsoft access used anymore?

773

What are the benefits of using access?

821

Where is the quick access toolbar located?

919

How do I order columns in sql?

922

How do you concatenate in sql?

984

What is having clause in sql?

933

What is sorting in sql?

904

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

907

What is sorting in dbms?

897

Can we use two order by clause in query?

929

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 ?

971

What is Collation Sensitivity ? What are the various type ?

916

How can a user get the current SQL version?

2 1760

Un-Answered Questions { Databases }

What are the advantages of microsoft access?

838

Is mysql from oracle?

924

What is meant by database in access 2010?

812

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

2720

How to load data with sql*loader?

1012

How do I install postgresql?

829

What is the difference between shrink database and shrink file?

843

When do we use namespace in mongodb?

Explain the hierarchical database?

966

does odi support web services?

533

How can you view the errors encountered in a trigger?

922

How to get a list of columns using the "sys.columns" view in ms sql server?

924

How to create Drill down report?

2080

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1021

Can we join 3 tables in sql?

966

For More Un-Answered { Databases } Questions Click Here