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?

922

What is difference between data and database?

1018

Is microsoft access used anymore?

767

What are the benefits of using access?

818

Where is the quick access toolbar located?

913

How do I order columns in sql?

914

How do you concatenate in sql?

975

What is having clause in sql?

929

What is sorting in sql?

898

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

898

What is sorting in dbms?

891

Can we use two order by clause in query?

919

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 ?

955

What is Collation Sensitivity ? What are the various type ?

906

How can a user get the current SQL version?

2 1739

Un-Answered Questions { Databases }

What is in a database?

811

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2203

How to transfer data from a cursor to variables with a "fetch" statement?

1024

Can we insert data into a view?

1065

How do you send email on SQL Server?

1003

How can I join two tables in database?

994

What is parameterized cursor in oracle?

1067

What is the difference between indexing and hashing?

1080

What is the difference between sql and isql*plus?

1007

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2473

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2029

What is blocking and how would you troubleshoot it? : sql server database administration

994

What is the difference between Normalization and De-normalization?

1031

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2332

In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

1234

For More Un-Answered { Databases } Questions Click Here