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??

2850

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 14473

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

2209

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

TCS,

1 4967

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

2445

what is difference between inner join & nested query or subqueries

3034

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

1 4053

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

2286

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

1 7588

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

1 7339

what is the difference between inline query and corelated subquery

1 4484

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

2595

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

Accenture, TCS,

3 11808

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

ABC,

4 8212

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

2988

Un-Answered Questions { Databases }

What does dba stand for database?

599

Explain the use of full option in exp command.

1116

How many columns can a postgres table have?

794

Explain the different types of queries created in reports?

what is the option or command used in informix for finding which dbspace a database resides?

100

What are the different sql server versions you have worked on? : sql server DBA

1013

What is triggers?

959

Explain raiserror in sql server?

1024

What are different types of views?

948

What is difference between hql and sql?

1077

what are local and global variables and their differences? : Sql dba

1070

What is db driver?

954

What do you understand by data independence? What are its two types?

1045

how to create “alternate row colour”?

146

explain the difference between myisam static and myisam dynamic. : Sql dba

944

For More Un-Answered { Databases } Questions Click Here