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

After update how do u know how many records got updated

TCS,

4 8412

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

2 5689

how many columns can a plsql table have

NIIT,

13 21525

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

3 6070

what r routers?

1 4354

What is the difference between temp table and table variable?

Microsoft,

8 27212

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

2261

What are the attributes of SQL*PLUS ?

Dream Careers, Oracle,

2 10478

what are three different authentications to connect linked servers?

CitiGroup,

1 5447

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

Satyam,

2 6700

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

1 3921

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

8 9030

What is deadlock and how to avoid the deadlocks.

TCS, Wipro,

3 10860

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 7395

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 10394

Un-Answered Questions { Databases }

Does google have a database like access?

977

What do we use to remove duplicate records while fetching a data in mysql ?

967

hiding item in report how like that properly,thats manually but at runtime i want to do

3244

What is mysql_pconnect?

914

Mention what are the key characteristics of rac or why to use rac?

What do you mean by % and _ in the LIKE statement?

986

Can I install mysql on mac?

986

I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

2266

What happens if strings are casted into wrong code pages in ms sql server?

1117

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1985

Is mysql a odbc?

928

What is key.next.item trigger?

Explain the properties of a relational table?

1027

How do you link data in access?

939

How to include date and time values in sql statements?

1090

For More Un-Answered { Databases } Questions Click Here