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

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

2 5123

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

2148

Can We write bulk collect statement in triggers?

Polaris,

1 9291

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 4849

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

2 7843

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 8362

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 9869

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 11278

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,

2322

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 9497

List the differences between plsql - function & procedures

TCS, Verizon,

2 7472

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

1813

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

10 18453

where the dff data will be stored

Infosys,

2437

key flexfield structure

Infosys,

2176

Un-Answered Questions { Databases }

Is mongodb publicly traded?

How would you improve throughput in sybase?

970

What is compound trigger?

1036

What do you understand by triggers and mention the different types of it?

936

How does mongodb replica set work?

Explain cascading triggers.

1073

What is mongodb stitch?

Explain what is dbms?

1060

Explain clause in sql?

1030

Write about Transaction Management in Oracle 9i?

2121

What are the different operators available in sql?

1000

What is used to replicate sessions between instances in coldfusion clusters?

1072

What is full form of rtm?

1008

If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)

576

What do you understand by anchoring in reports?

For More Un-Answered { Databases } Questions Click Here