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 30550

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 7178

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

TCS, Wells Fargo,

8 21734

What are ACID Properties?

TCS,

1 5781

why we use cursor?

CarrizalSoft Technologies, Melstar, TCS,

4 15320

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 7150

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 12871

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

2 8766

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 19216

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

3 6302

Explain Trigger with an example?

2 12100

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 5263

how to do application monitoring through AutoSys?

Cognizant,

3 27786

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

2 4577

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

HCL,

1954

Un-Answered Questions { Databases }

SQL Server Architecture ?

2465

How to connect a sql*plus session to an oracle server?

1136

How would you use transactions with couchdb?

What is tablix?

165

What is create statement?

963

What is connection pooling in oracle?

978

what are the new features introduced in sql server 2000? : Sql server database administration

930

Why is foreign key used?

840

What do ddl, dml, and dcl stand for?

923

Is oracle an open source?

1084

How to return query output in html format?

944

Is ms access a rdbms?

742

Does postgres use sql?

843

What do you understand by case manipulation functions?

1040

Explain insert into select statement?

965

For More Un-Answered { Databases } Questions Click Here