Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3253)
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 31672

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 7424

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

TCS, Wells Fargo,

8 22122

What are ACID Properties?

TCS,

1 5891

why we use cursor?

CarrizalSoft Technologies, Melstar, TCS,

4 15525

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 7304

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 13061

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

2 8902

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 20023

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

3 6441

Explain Trigger with an example?

2 12221

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 5411

how to do application monitoring through AutoSys?

Cognizant,

3 28002

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

2 4716

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

HCL,

1 2017

Un-Answered Questions { Databases }

How to define array in mongoose schema?

What is clustered index

1083

Have you used lexical parameters in reports?

What versions of clipper does netlib support?

1086

Can delete statement be rollbacked?

1050

What is subquery? Explain the properties of a subquery?

1056

How to convert numeric expression data types using the cast() function?

1142

Which statement is used in a select query for partial matching?

1239

what is schema? : Sql dba

1137

Equi join and non equi join is possible with sql server?

1126

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2046

Where can you add custom error messages to sql server?

1203

i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in

1856

What are the advantages of database?

1009

Any work done in oracle workflow builder. Did you customize or build a new workflow?

For More Un-Answered { Databases } Questions Click Here