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 remove records from table? no name 1 a 2 b 1 a 2 b 3 c

Oracle,

8 13975

how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?

Accenture, IBM, Marlabs,

16 25898

how insert selected column only ?

Robert Half,

3 6610

what are collection attributes

GE,

1 4867

what is oracle sql,pl/sql with interfaces

TCS,

2 8411

when we use function instead of procedure? plz tell me the situation with ex?

IBM,

3 11145

What are the new features in SQL Server 2005?

Emphasis,

3 6975

What are the different types of backup avaible in SQL SErver

Emphasis, IBM,

6 10316

what is the role of auditor in auditing data oriented applications?

2402

About Indexed Views? with example? plz reply...

2 8278

What is indexed views? plz explain with example?

2 4469

What is Covering Indexes? Plz explain with example

3 9854

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1982

what is Archive old data?

1 3599

could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh

3 5965

Un-Answered Questions { Databases }

How do I transfer data from one database to another in mysql?

917

What mysql means?

956

What are access modules?

781

How much memory does mongodb need?

How do I make my sql query run faster?

954

How can you move the master database

2058

how to load data files into tables with 'mysqlimport'? : Sql dba

1106

Is join and inner join the same?

1016

What is pl sql in oracle?

1056

Is access better than excel?

923

How to receive output values from stored procedures?

1161

What is indexes?

1066

What are the different parts of a database application called in access?

798

What are the set operators in sql?

1089

How does distributed database work?

995

For More Un-Answered { Databases } Questions Click Here