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

consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ename who having maximum salary in deptno 10 and 20.

Mind Tree,

24 30624

While connecting to Oracle Db i am getting the following error message- ORA-12154: TNS:could not resolve the connect identifier specified what are the steps to solve this problem?

IBM,

4 7188

what is the difernece between named and anonymous pl/sql blocks??

TCS, Wells Fargo,

8 21755

What are ACID Properties?

TCS,

1 5786

why we use cursor?

CarrizalSoft Technologies, Melstar, TCS,

4 15328

We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.

IBM,

2 7161

After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )

CarrizalSoft Technologies, iGate,

3 12886

What is the Extension of Oracle Database? As extension of Access Database is .mdb

2 8774

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

3i Infotech, Rolta, TCS,

17 19252

I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?

3 6317

Explain Trigger with an example?

2 12105

I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?

3 5270

how to do application monitoring through AutoSys?

Cognizant,

3 27801

A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?

2 4584

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

HCL,

1961

Un-Answered Questions { Databases }

What is difference between sql and rdbms?

1022

What is restrict in sql?

1130

What is secondary or slave in mongodb?

How to turn off warning messages during php execution?

1062

How do I check mysql version?

1056

How does cross join work?

968

What Is Rdbms?

1171

Explain different backup plans?

956

Why mongodb is required?

List the different types of collation sensitivities in sql server?

1054

Difference between truncate, delete and drop commands?

1092

What is mdf ldf and ndf?

1009

What is odm database?

1022

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1960

In what condition is it good to disable a trigger?

1033

For More Un-Answered { Databases } Questions Click Here