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 30495

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 7165

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

TCS, Wells Fargo,

8 21712

What are ACID Properties?

TCS,

1 5774

why we use cursor?

CarrizalSoft Technologies, Melstar, TCS,

4 15314

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 7145

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 12867

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

2 8761

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 19186

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

3 6293

Explain Trigger with an example?

2 12095

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 5258

how to do application monitoring through AutoSys?

Cognizant,

3 27784

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

2 4568

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

HCL,

1950

Un-Answered Questions { Databases }

What is clustered and nonclustered index in sql?

944

How do you see the locking status in mongo instances?

How to delete a database from mysql server.

1070

Benefits of Stored Procedures?

976

Which sql server table is used to hold the stored procedure scripts?

1067

Explain about integration services of Microsoft SQL server?

1038

Explain transaction server consistency?

979

What are the different data types in mysql?

926

What is union and union all keyword in sql?

1046

How do I connect to postgresql access?

1028

What are the advantages of oracle 12c?

1182

How to write a left outer join with the where clause in oracle?

1086

What is Relational Calculus?

892

Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

2208

What is varchar example?

1037

For More Un-Answered { Databases } Questions Click Here