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 the diff between Truncate table / delete

purge

TCS,

3 15840

what is the age limit for groups1 examination

APPSC,

2314

What is the difference between an Oracle Schema and an Oracle Instance?

IBM,

3 9160

How can one skip any number of rows while loading the DB tables with SQL Loader? Similarly how can one skip any column?

IBM,

1 3719

What is the exact use of Collections?

2197

sql command 2 know current database

4 6874

select name of emplyoee whose total salary is 130 from following table. id name salary 1 a 100 2 b 20 3 c 50 1 a 30 2 b 70 Post the resulantant Query?

7 9039

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

CGI,

1 7928

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

CGI, IBM,

4 10609

What are the difference between Functions/Stored Procs and Triggers and where are they used.

CGI, TCS,

1 6179

Can you have multiple SPs with the same name on a database?

CGI, Quest,

2 7125

Can you create a table with Primary Key not as the clustered index.

CGI,

2 7733

Can you have multiple SPs with the same name on a database?

CGI,

6 12306

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

KPIT,

4 7803

what is the difference between oracle enterprise edition and oracle express edition?

2 7234

Un-Answered Questions { Databases }

What are triggers? Why do we use them? Diff types of triggers? What are magic tables?

1010

What is the difference between commit and rollback?

996

How do I create a sql database?

1057

How to create table show example

1021

What is mean by dbms?

1122

Why do we use set serveroutput on?

1015

How to stop a loop early with break statements in ms sql server?

1077

Can you use order by when defining a view?

1022

Where does mongodb store data linux?

How to convert times to characters in oracle?

1079

What do I do if I forgot my mysql root password?

962

Describe triggers features and limitations?

1059

What are procedures in mysql?

1000

What is using in sql?

1143

Explain multi version concurrency control.

978

For More Un-Answered { Databases } Questions Click Here