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 10572

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

Tech Mahindra,

4 9964

why pl sql doesn't support retrieving multiple records

Mphasis,

1 6991

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 18817

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

HCL, Nyros, Oracle,

18 47802

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

Polaris,

1 7912

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

CTS,

3 17303

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

3 5066

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

Oracle,

2278

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

4 6276

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 21256

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 7872

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 7836

what is incremental checkpoint?

CTS,

1 9341

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 7472

Un-Answered Questions { Databases }

What is meant by indexing files?

1058

What is snow flake schema design in database? What's the difference between star and snow flake schema?

879

What are 5 benefits to using access?

894

What is sql analyzer?

1030

How to dump one database for backup.

956

How to use select statement to count the number of rows in oracle?

1062

What are the features of dbms?

959

What are trace flags?

1048

Which directory will you copy your new custom form, what would be its extension (.fmb or .fmx)?

hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...

2177

What is difference between unix timestamp and mysql timestamp?

1019

Why do we study dbms?

956

Explain what is the function of sql server agent windows service?

1006

Can you inner join the same table?

1005

How to insert data from one table to another in postgresql?

843

For More Un-Answered { Databases } Questions Click Here