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

1 2025

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 34779

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

GTL,

1 2359

What is equi-join?

1 4204

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,

1 2524

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

ABC,

2 11495

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

1 2404

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

CTS, IBM,

1 2613

Un-Answered Questions { Databases }

What is the best sql course?

1041

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1121

How to define array in mongoose schema?

How can we solve concurrency problems?

1116

What is sql server query analyzer?

1116

List out the different types of locks available in sql server?

1041

Explain system functions or built-in functions? What are different types of system functions?

1055

how many tables will create when we create table, what are they? : Sql dba

1136

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2088

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 is the difference between for xml raw and for xml auto?

1108

Any work done in oracle workflow builder. Did you customize or build a new workflow?

How do I start sql server 2017?

1005

Have you used lexical parameters in reports?

How to convert numeric expression data types using the cast() function?

1142

For More Un-Answered { Databases } Questions Click Here