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

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

2902

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 14724

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

2265

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

TCS,

1 5026

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

2502

what is difference between inner join & nested query or subqueries

3113

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

1 4145

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

2339

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

1 7687

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

1 7435

what is the difference between inline query and corelated subquery

1 4558

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

2647

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

Accenture, TCS,

3 11979

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

ABC,

4 8353

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

3046

Un-Answered Questions { Databases }

What programs use sql?

1087

What is the default port for SQL Server over a firewall?

1144

What are the database administrators utilities available?

1096

What is the disk migration? what is the steps involved in oracle disk migration?

1267

Why should we go for stored procedures? Why not direct queries?

1157

What is dblink?

941

Is mysql an oracle product?

894

What is dcl? : sql server DBA

1321

How to drop an oracle database?

600

Can you explain what are various ways to enhance the ssrs report?

1066

Write down the syntax and an example for create, rename and delete index?

1027

What is mapping schema?

1071

what is the difference between gui testing and database testing? : Mysql dba

1163

Compare sql & pl/sql

1211

What is delimiter in mysql?

930

For More Un-Answered { Databases } Questions Click Here