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

what is meant by physical order and logical order in clustered index and non clustered index.

2 8045

what is debit memo and credit memo in AR?

1 4162

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 24057

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 3447

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

2 5704

select sal from emp group by sal

TCS,

3 6513

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 4662

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 5412

What is the difference between SQL and SQL Server?

CTS, TCS,

2 6141

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

1790

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

IBM,

21 28361

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

Mphasis,

5 16215

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 7229

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 4760

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

1996

Un-Answered Questions { Databases }

tell me about various levels of constraint. : Sql dba

1084

Explain phantom deadlock?

1271

What is the stored procedure?

1054

What is the sql case statement used for?

1133

What is DML (Data Manipulation Language)?

910

What degree do database administrators need?

599

What is the function of grid naming service used in oracle rac

What is default value database?

1067

Which Model uses the SET concept

1046

What is the best partition size for windows 10?

1057

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1835

Why do we use the mysql database server?

1111

Why use stored procedures in mysql?

1032

How do you declare a variable in pl sql?

1073

What is an index associated with a constraint?

1094

For More Un-Answered { Databases } Questions Click Here