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

purge

TCS,

3 15718

what is the age limit for groups1 examination

APPSC,

2259

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

IBM,

3 9026

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 3653

What is the exact use of Collections?

2144

sql command 2 know current database

4 6710

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 8766

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 7846

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 10449

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

CGI, TCS,

1 6093

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

CGI, Quest,

2 7039

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

CGI,

2 7616

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

CGI,

6 12096

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 7650

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

2 7133

Un-Answered Questions { Databases }

How do I find the size of a sql server database?

931

Explain different types of index?

1066

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2353

Is access database still used?

855

Why neo4j is called graph database?

Does oracle use sql?

935

Write a query to fetch duplicate records from a table using mysql?

941

What is database management definition?

923

What can sql server reporting services do?

1114

How will you identify oracle database software release?

1016

What is a sub query and what are the different types of subqueries?

1128

Explain index covering?

839

What is data node in mysql cluster?

993

What is the difference between internal & external schema?

763

What is the best free database software?

877

For More Un-Answered { Databases } Questions Click Here