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 13923

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 25805

how insert selected column only ?

Robert Half,

3 6581

what are collection attributes

GE,

1 4847

what is oracle sql,pl/sql with interfaces

TCS,

2 8388

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

IBM,

3 11105

What are the new features in SQL Server 2005?

Emphasis,

3 6936

What are the different types of backup avaible in SQL SErver

Emphasis, IBM,

6 10266

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

2392

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

2 8254

What is indexed views? plz explain with example?

2 4447

What is Covering Indexes? Plz explain with example

3 9815

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

1965

what is Archive old data?

1 3583

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 5938

Un-Answered Questions { Databases }

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1288

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

1004

You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

963

Give an example of SQL injection attack ?

1006

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

1015

What is the order in which the sql query is executed?

942

What is pgadmin used for?

788

What are sql server procedures?

980

what are the features and advantages of object-oriented programming? : Sql dba

1009

What is PL/SQL ?

2061

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

1068

Does postgres support clustering?

850

How to automatically create a log when an exception is being received into SQL Server?

1289

What are the examples of database management system?

871

What is the rdl file?

138

For More Un-Answered { Databases } Questions Click Here