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

which is the best institute to learn Oracle DBA 10g/11g, please advise, someone?

2 5245

Does any body please help me what question's have asked for SSRS in the interview?

2214

Can We write bulk collect statement in triggers?

Polaris,

1 9371

can we write stored function in out parameters? how to call through select statement? how to written more than one value plz give the exmple?

1 4921

select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?

2 7942

In table three columns with 1 milion records(here there is no sequence values) i want add one more column with sequence values from the first how it is posible?

Tech Soft,

4 8568

suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between 1 5 7.How can we do this using sql query??

Keane India Ltd,

5 10050

What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

ABC, Accenture,

5 11470

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

Cisco,

2387

how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900

8 9803

List the differences between plsql - function & procedures

TCS, Verizon,

2 7583

Respected sir, Please send me technical questions related to oracle apps..

1878

How do you retrieve the last N records from a table?

10 18749

where the dff data will be stored

Infosys,

2546

key flexfield structure

Infosys,

2236

Un-Answered Questions { Databases }

What are the advantages of having an index on the sql server?

979

Write a query to create a duplicate table with and without data present?

915

Do you know the different ddl commands in sql?

1109

How do I change the max connection in mysql?

1011

What is program global area (pga) in oracle?

1095

Differentiate between delete and truncate.

1117

Explain what are tp-lite and tp-heavy monitors?

963

What is oracle partial backup?

640

What is the difference between Delete, Truncate and Drop in Oracle?

1189

What are triggers in ms sql server?

1235

How to change the password of a login name in ms sql server?

1063

What is a system tablespace?

1139

How to display employee records who gets more salary than the average salary in the department?

1128

How default key is different from primary key?

1082

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2264

For More Un-Answered { Databases } Questions Click Here