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

How to define numeric 9(3) in db2 table without decimal point??

2787

have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.

IBM, Zensar,

8 14102

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2146

Without giving condition how to retrieve the unmatched records from table.

TCS,

1 4891

can we call primary key a 'address'????

2373

what is difference between inner join & nested query or subqueries

2969

Can anybody tell which is the best training institute for learning Oracle in chennai...? And i also i want placement assurance

1 3964

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2214

when i run my query on yesterday it is fast but today it is slow why?

1 7483

I have a CURSOR then why we need BULK COLLECT again?

1 7231

what is the difference between inline query and corelated subquery

1 4399

Can anybody give me link for BOXI R3.1 Key please

2540

how to find find & delete duplicate rows from two different tables?

Accenture, TCS,

3 11596

how to get rank of diffrent student in same table based on newly inserted row in sql server2008

ABC,

4 8012

i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE

2949

Un-Answered Questions { Databases }

What do you understand by lov and how can it be used?

1014

what happened to the global index when I truncate the data in one of the partition?

1964

what does the SET clause is used for in Neo4j?

What do you mean by e-r model & object-oriented model?

889

What will be query used to get the list of triggers in a database?

955

What causes re-resolution of a stored procedure in sybase?

842

What is difference between ms sql and mysql?

914

Can you get microsoft access for free?

806

Why is oracle so popular?

943

Explain difference between cross join and full outer join?

955

How can I see connections in mysql?

870

What does sign mean sql?

1022

Explain relationship between jdbc and sybase.

847

What is database architecture?

664

In which format image is stored in database?

842

For More Un-Answered { Databases } Questions Click Here