Databases Interview Questions
Questions Answers Views Company eMail

which is best institute to learn sql server in ameerpet or sr nagar or maithrivanam?please help

3 6539

which is best institue to learn oracle 11i in ameerpet or maithrivanam or sr nagar please help

5 12842

Without Using Cursors , How to Select the Selected row??

CarrizalSoft Technologies, Wipro,

3 7849

How many index can be created for single table

CarrizalSoft Technologies, Verizon,

4 17046

what is the uses of cusor

Perot Systems,

3 4540

what is difference between sqlserver and oracle?

CMC,

5 10297

SQLERRM is a a. Constraint b. Pre Defined Exception c. Pseduocolumn d. Constant e. None of Above.

Cognizant,

2 4959

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

1553

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 31643

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

GTL,

1852

What is equi-join?

1 3359

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,

1967

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

ABC,

2 10242

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

1836

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

CTS, IBM,

2035


Un-Answered Questions { Databases }

List the advantages of using stored procedures?

556


What is auditing in sql server?

499


Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

1744


Explain procedure cache?

513


What port does sql server use?

499






Mention how you can inspect the source code of a function?

1


What is benefit of creating memory optimized table?

533


what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

641


What is structure of dbms?

481


How to use old values to define new values in update statements in ms sql server?

673


What is single-user mode?

516


Write a query to select all teams that won either 1, 3, 5 or 7 games.

809


When is the use of update_statistics command?

549


How is image stored in database?

577


how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1212