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 I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)

5 10842

i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?

Tech Mahindra,

4 10179

why pl sql doesn't support retrieving multiple records

Mphasis,

1 7119

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.

Ebix, Hewitt,

11 19225

i want to display 1 to 10 numbers using one select statement.

HCL, Nyros, Oracle,

18 48556

how to debugg a procedure or package using dbms_output.put_line in plsql

Polaris,

1 8013

how can we find the select statement is indexed or not?

CTS,

3 17487

can you any body tell me which service pack is installed in the sql server?

3 5212

Could you please let me know the interfaces in OM / FA??

Oracle,

1 2379

can you any body tell me the how to decrease the logfile

4 6495

I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000

HCL, IBM,

17 21872

i have 9 values in a table i.e -99 -56 -32 41 -2 33 95 -88 55 my question is that i wanna elimenate all -ve values and wann sum of + values in report i m using devsuite 10g its urgent kindly if anyone knows that answer message me the following yahoo id thanx ALI smalipaki@yahoo.com

5 8097

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 8000

what is incremental checkpoint?

CTS,

1 9459

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

CTS,

2 7616

Un-Answered Questions { Databases }

What are the advantages of database?

1011

what is bcp? When does it used? : Sql dba

1055

how many tables will create when we create table, what are they? : Sql dba

1141

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1194

How can we solve concurrency problems?

1120

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 to escape special characters in sql statements? : Sql dba

1113

What is a concurrency problem in dbms?

1051

Design database draw er diagram for a certain scenario ?

4650

What is the primary use of the model database?

1146

What is an indexed view?

1021

what is spatial nonclustered index

1055

What are different types of constraints?

997

Can we shrink data file in sql server?

1123

Is primary key clustered index?

1018

For More Un-Answered { Databases } Questions Click Here