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

After update how do u know how many records got updated

TCS,

4 8646

select statement does not retrieve any records. what exception is raised?

2 5841

how many columns can a plsql table have

NIIT,

13 22048

what is load balancing and what u have used to do this?(sql loader)

3 6273

what r routers?

1 4460

What is the difference between temp table and table variable?

Microsoft,

8 27563

what is the full procedure for using store procedure in informatica7.1?

1 2328

What are the attributes of SQL*PLUS ?

Dream Careers, Oracle,

2 10638

what are three different authentications to connect linked servers?

CitiGroup,

1 5569

what is the exact navigation to create a radio button in form6i? can i create the radio button in report6i?

Satyam,

2 6833

after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble

1 4085

please give me the answer for this: query which generates the second highest integer in the table?

8 9460

What is deadlock and how to avoid the deadlocks.

TCS, Wipro,

3 11022

I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer.

Satyam,

4 7631

How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.

AppLabs,

2 10528

Un-Answered Questions { Databases }

what is bcp? When does it used? : Sql dba

1055

what is spatial nonclustered index

1055

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?

1847

What is self contained sub query?

1138

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8227

What are the different types of subquery?

1233

Equi join and non equi join is possible with sql server?

1131

please send me oracle pl/sql exp resume. and also faqs...

2568

Does group by remove duplicates?

1112

Who proposed the relational model?

1029

How to convert character strings into numeric values?

1187

How to provide default values to function parameters?

1251

what are aggregate and scalar functions? : Sql dba

1124

What is an indexed view?

1021

What is current version of mysql?

1073

For More Un-Answered { Databases } Questions Click Here