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

Databases AllOther Interview Questions

Questions Answers Views Company eMail

what is tkprof tool and how it is used???

Genpact,

2771

give a simple example of physical and logical data independence

2485

Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it

2354

.dbf file corrupted Dear Friends, I am using DBF file in Foxpro. DBF file corrupt and show message "Not a database file" Waiting for your reply. With regards!

3 5972

Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool

Miracle Software,

1797

query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp

Verizon,

2006

I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage

IBM,

1501

First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9

IBM,

1685

Clipper / DBF error

1 2759

how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.

1551

what are different types of datasets? what are different characteristics or properties of those datasets? what are the advantages and disadvantages of each dataset on each other?

OVGU,

1 2484

Explain about ur projets on teradata???

Wipro,

1729

During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?

1329

Under which circumstance should you create an index on a table?

3i Infotech,

1096

What is a super key?

3i Infotech,

978

Post New Databases AllOther Questions

Un-Answered Questions { Databases AllOther }

What are different types of resources?

954

What is the difference between specialization and generalization?

967

Explain entity ?

961

how node connect with cpu?

2078

What is a sequence? Explain it with one example?

1099

What will happen non-clustered index will be created on clustered index?

981

What does new grouping sets enables you to do?

978

What is the database url?

996

Explain buffer manager?

895

wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..

3009

what are wrappers and build ups and what it's use?

2111

Explain inner and outer joins with examples.

1131

What are the various ways to execute a query in teradata?

2543

WHAT IS NEED BY METION DATFMT AND TIMFMT IN H-SEPICITION IN RPGLE?

2911

How to implement database security?

919

For More Un-Answered { Databases AllOther } Questions Click Here