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 meant by physical order and logical order in clustered index and non clustered index.

2 7942

what is debit memo and credit memo in AR?

1 4045

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?

Cap Gemini, TCS,

13 23732

sql server syntax to add "!" sign to "name" field of "employee" table in a manner that all names have the same lenght of 20 characters

1 3382

how to find the first two highest salaries in deptno in emp table

2 5595

select sal from emp group by sal

TCS,

3 6393

Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.

IBM,

1 4597

A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?

IBM,

1 5344

What is the difference between SQL and SQL Server?

CTS, TCS,

2 6015

How do use Having,Group by,Group function in SQL?

1749

A table has 150 records. How do you retrieve 100th row to 120th row from that table ?

IBM,

21 27660

In Oracle 10g, "g" Stands for what?

Mphasis,

5 15970

WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.

3 7097

According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?

2 4667

what is port in oracle? how is it related to database application.

1950

Un-Answered Questions { Databases }

what is dynamic SGA and static SGA

4422

What is the index key?

930

What sql database should I use?

1147

WHAT IS ecc 6.0

2151

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

1004

Explain database link?

1131

Explain the wait events in statspack report 'db sequential real'?

641

What do you mean by query evaluation engine?

982

What is the use of procedures?

976

Does oracle database need java?

1013

can we use lexical perameter in oracle plsql if yes how

2316

What is transaction server implicit?

1015

What type of database is postgresql?

840

How to list all columns in a table using odbc_columns()?

977

What are the new security features added in sql server 2012? : sql server security

1029

For More Un-Answered { Databases } Questions Click Here