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

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 10535

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

Tech Mahindra,

4 9944

why pl sql doesn't support retrieving multiple records

Mphasis,

1 6979

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 18774

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

HCL, Nyros, Oracle,

18 47708

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

Polaris,

1 7903

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

CTS,

3 17279

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

3 5044

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

Oracle,

2272

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

4 6252

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 21163

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 7848

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 7815

what is incremental checkpoint?

CTS,

1 9329

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 7451

Un-Answered Questions { Databases }

What are the execution control statements in oracle?

1098

What are the properties of the transactions?

1119

How is sql used in oracle?

1012

Explain active/passive and active/active cluster configurations?

1063

What is schemabinding a view?

923

What will be objects between two dates in mongodb?

What is postmaster pid file in postgres?

962

How many columns is too many mysql?

908

Can we save image in database?

986

What is difference between primary and secondary key?

1033

How do you set a trace flag in sql server?

1041

What is transactional trigger property?

Can I delete event logs?

929

What do you understand by join?

1104

What is right outer join in sql server joins?

1186

For More Un-Answered { Databases } Questions Click Here