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 5264

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

1 2228

Can We write bulk collect statement in triggers?

Polaris,

1 9400

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 4948

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

2 7974

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 8619

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 10074

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 11534

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,

1 2402

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 9884

List the differences between plsql - function & procedures

TCS, Verizon,

2 7607

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

1 1892

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

10 18823

where the dff data will be stored

Infosys,

1 2562

key flexfield structure

Infosys,

1 2251

Un-Answered Questions { Databases }

What is a concurrency problem in dbms?

1041

What is in place upgrade in sql server?

1118

1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

1841

Where can you add custom error messages to sql server?

1197

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2291

define sql insert statement ? : Sql dba

1089

What is the latest version of postgresql?

946

What is current version of mysql?

1057

What are the properties of the transaction?

1066

What is the current version of postgresql?

1150

How to put more than 1000 values into an oracle in clause?

1099

How do I find query history in sql server?

1018

This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?

2553

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2343

do you know how to configure db2 side of the application? : Sql server database administration

1113

For More Un-Answered { Databases } Questions Click Here