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 10837

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

Tech Mahindra,

4 10173

why pl sql doesn't support retrieving multiple records

Mphasis,

1 7115

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 19204

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

HCL, Nyros, Oracle,

18 48545

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

Polaris,

1 8011

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

CTS,

3 17483

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

3 5206

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

Oracle,

1 2376

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

4 6494

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 21866

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 8084

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 7997

what is incremental checkpoint?

CTS,

1 9454

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 7610

Un-Answered Questions { Databases }

what is spatial nonclustered index

1054

How raid can influence database performance?

1114

How to provide default values to function parameters?

1251

What are different types of constraints?

996

What is a scheduled job or what is a scheduled task?

1033

How to use values from other tables in update statements using oracle?

1150

When should you use an instead of trigger?

1044

What is sql or structured query language?

1220

Does view occupy space?

1007

What is the difference between case version and decode version?

1104

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

Can we do dml on views?

1032

What are the two main functions of queries in databases?

1525

Is there some bulk load or other way to import a lot of data fast?

931

What is the latest version of postgresql?

951

For More Un-Answered { Databases } Questions Click Here