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

Oracle,

8 14264

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 26554

how insert selected column only ?

Robert Half,

3 6799

what are collection attributes

GE,

1 4953

what is oracle sql,pl/sql with interfaces

TCS,

2 8572

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

IBM,

3 11293

What are the new features in SQL Server 2005?

Emphasis,

3 7161

What are the different types of backup avaible in SQL SErver

Emphasis, IBM,

6 10550

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

1 2464

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

2 8407

What is indexed views? plz explain with example?

2 4594

What is Covering Indexes? Plz explain with example

3 10041

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

1 2047

what is Archive old data?

1 3689

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 6129

Un-Answered Questions { Databases }

Why should you use or avoid select * statements?

1106

Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1896

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

1149

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

1118

Suppose database is running slow, what will you do?

2590

What is the current version of postgresql?

1170

What is an indexed view?

1018

Which statement is used in a select query for partial matching?

1239

This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?

2558

What is normalization and what are the advantages of it?

1054

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1021

Can we shrink data file in sql server?

1123

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2100

How do I start sql server 2017?

1011

what is spatial nonclustered index

1054

For More Un-Answered { Databases } Questions Click Here