Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

2016

How to export the table data (this table having 18 million records) to .csv file. Please tell me is there any faster way to export the data.

8 34719

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

GTL,

2353

What is equi-join?

1 4188

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

Mastek,

2514

How we can migrate the 6i report to 10g reports. What steps need to reuired?

ABC,

2 11482

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

2389

what exactly sql injuction.how to overcome.....

CTS, IBM,

2602

Un-Answered Questions { Databases }

Explain the difference between primary and foreign key?

1148

How many concurrent queries can mysql handle?

953

How index is implemented in oracle database?

1054

Can You Use Data Mining Models In Ssrs?

152

How do I find duplicates in two columns?

1279

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

187

What are different types of sql?

1280

When a primary key constraint is included in a table, what other constraints does this imply?

1031

Can a trigger call a stored procedure?

1137

What is a bit datatype?

1032

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1125

What sybase central?

925

Now days, what makes mongodb best?

What is the usage of distinct keyword?

1120

Can we join two tables without common column?

1070

For More Un-Answered { Databases } Questions Click Here