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

2901

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 14723

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

2501

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 4144

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

2338

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

1 7685

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

1 7434

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 11976

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

ABC,

4 8352

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 }

How do I know if mongodb is installed?

Difference between table function and pipelined function?

1082

What are the different type of replication in sql server?

1015

What is the meaning of disabling a trigger?

1237

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1273

Explain user defined functions?

1047

Are stored procedures compiled?

980

What is the purpose of a table?

995

what are ddl statements in mysql? : Sql dba

1269

What is the purpose of using pl/sql?

1189

What is postgresql dba?

980

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1159

Transactions are used to treat sets of SQL statements atomically. State Whether True or False?

1502

Describe the difference between embedded and dynamic sql.

1144

I assigned a primary key to my table in microsoft access, I was expecting my data to be sorted. Is that a right approach?

980

For More Un-Answered { Databases } Questions Click Here