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

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

Microsoft,

2 7422

WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?

8 22171

MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE

IBM, TCS,

2 17597

What is INTVAL( )and where we use Plz any body help me

1 6002

what is primary key and foreign key when and where have to use

5 7733

can you tell me some sites name for sql server 2000 commands with example??? plz reply soon.

2137

can we use a having cluase in groupby clause. if there are 500 records i will give rownumber<250 then how many records does it retrieve. wt is the result of nvl2(null,notnull,null) if there are four tables without using cartesian how many joins can be there. in the sql subqueries wt is the parent ans1)select 2)update,3) delete 4)2&3

i2,

2 6175

What is the difference between a stored procedure and a user defined function in sql server?

Millennium,

2 8019

could u plz explain about joins and views?

2 5411

plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005

3 5521

can anyone explain me the concept of Serialization in Detail and Clear? plz its urgent i have interview on friday (15th feb)

1 6581

what is the sql equivaent of the dataset relation object ?

1 2086

Differences between UNIQUE and DISTINCT in select statements

ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,

26 137033

what is view?

Accenture,

7 11292

How the Action Trigger works? and what is full syntex of srw.run_report?

CMC, Yantro Software,

1 9104

Un-Answered Questions { Databases }

How to convert numeric expression data types using the cast() function?

1145

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2211

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1045

Design database draw er diagram for a certain scenario ?

4652

What is normalization and what are the advantages of it?

1054

Can one drop a column from a table?

1086

How to provide default values to function parameters?

1256

Have you used lexical parameters in reports?

How to Change a users password from unix shell.

1216

How to write a left outer join with the where clause in oracle?

1151

What are different types of constraints?

997

Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:

2313

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2356

What is the current version of sql?

1091

do you know how to configure db2 side of the application? : Sql server database administration

1121

For More Un-Answered { Databases } Questions Click Here