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,

2260

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 3654

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 8769

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 7848

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 7134

Un-Answered Questions { Databases }

What is a lookup table in access?

936

Brief theory of Network, Hierarchical schemas and their properties

846

Does partitioning improve performance sql server?

985

Can a unique key be a foreign key?

834

Explain something about security and SQL Azure?

134

What is a schema in oracle?

1024

What is a named program unit?

1092

What is couchdb?

What is data node in mysql cluster?

993

What is nosql db?

974

What programming language would you use to create embedded functions in ssrs?

185

What is snowflake sql?

1079

What are the ways to tune reporting services?

1007

Explain what is the role of profiler in mongodb?

Query processing is slow(eg select query)how will u solve that

7925

For More Un-Answered { Databases } Questions Click Here