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,

2884

give a simple example of physical and logical data independence

2628

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

2475

.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 6272

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,

1907

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,

2128

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,

1592

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,

1796

Clipper / DBF error

1 2930

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

1670

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 2646

Explain about ur projets on teradata???

Wipro,

1829

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

1423

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

3i Infotech,

1235

What is a super key?

3i Infotech,

1084

Post New Databases AllOther Questions

Un-Answered Questions { Databases AllOther }

Explain storage manager?

1102

What does specialization in DBMS mean?

1204

what is data access layer?

2444

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

2213

Is redis in memory database?

1055

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

1592

What is ase database?

1059

Explain the various types of normalization.

1128

What are the advantages of normalizing a database.

1101

What is the role of driver manager?

1062

What is the difference between data source and database?

1149

How default key is different from primary key?

1080

What is a Transformation?

1073

What is the difference between database and server?

1074

How many types of normalization? What is the use of it?

1192

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