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 8436

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

2 5711

how many columns can a plsql table have

NIIT,

13 21604

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

3 6093

what r routers?

1 4365

What is the difference between temp table and table variable?

Microsoft,

8 27242

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

2274

What are the attributes of SQL*PLUS ?

Dream Careers, Oracle,

2 10501

what are three different authentications to connect linked servers?

CitiGroup,

1 5458

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

Satyam,

2 6714

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

1 3941

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

8 9077

What is deadlock and how to avoid the deadlocks.

TCS, Wipro,

3 10889

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 7431

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 10415

Un-Answered Questions { Databases }

How to add an address record into adventureworkslt?

1001

How do I count duplicates in sql?

1125

How do you know if your mysql server is alive?

1089

How do you update sql?

996

Can we take the full database backup in log shipping?

968

Can %notfound return null after a fetch?

1076

Explain how to send email from sql database?

1063

What are the advantages of policy management?

1012

How do I upgrade sql?

1015

How can you change the name of any existing table by using the sql statement?

1008

Which is the most used database?

952

Why do we use procedures in pl sql?

1057

How to start instance with a minimal initialization parameter file?

1055

How many types of canvases are there.

Can mongodb replace oracle?

For More Un-Answered { Databases } Questions Click Here