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 difference between delete and truncet ?

Fidelity,

7 11793

write a query for the fifth highest salary?

IBM, Matlabs, Ramco,

17 24482

can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?

2116

i applied prompt on country when i run report it shows list of all countries but want it to show only four countries name

Datamatics,

2086

define primary key index, bitmap index, hash index,virtual indwx

Cap Gemini,

3319

How to do performance tunning a database in DB2 V8.2 UDB in linux

2263

1.what are components of querystdio and report studio and cognoss connection? 2. how to use prompts in query studio? 3.what is lock and un lock objects? 4.how to test the re[ports in query studio? 5.how to use brust option and when? 6.what is the performance testing? 7.condition explorer whaen your using? 8.in impromptu how do you create cascading prompt? 9.diff between section and group? 10.types filters where you are using group filters and tabular filter? 11.tabular model, tabular references ,tabular set , tabular sql? 12.what is the use of multi[le packages? 13what types of problems arise when create a join? 14.how to provide package sequirety? 15.report server components? 16.how many kinds of quality subjects? 17.how do you specify the joins? 18.how would you maintain the relations in frame work manager? 19.what is usage of segments and how to provide it? 20.governer settings in frame work maneger? 21.how to create filter in frame work manager? 22diffrence between represention layer and physical layer? 23.how to create prompts in frame work manager? 24.what errors occured when verify the model? 25.how to publish package in net work or local system?

Wipro,

1 5378

What is the concept of Virtual field?

EDS,

2059

what is the full procedure for using store procedure in informatica7.1?

2260

1. How to test Database? Please, give me all details for "SQL,Msaccess, Mysql Database? 2.For which functionalities database used? 3.How to convert Guest to Admin by Mysql database?

2196

Which is the best sorting method if i have to sort the students of Harvard University according to their first name?

CybAge,

1 6454

What is the default identifier of structure in C?

CybAge,

3 6806

Can we have a function Overloading with same number of arguments but with different return types of function

CybAge, Wipro,

8 14761

What is the differnce between Order by and Group by

1 4393

what is data access layer?

2405

Post New Databases AllOther Questions

Un-Answered Questions { Databases AllOther }

How do you connect to a database?

1111

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

2974

What do you mean by cluster and non cluster index?

1079

sparse lookup and where its options we find in OCI and db2?

2224

What is a database lookup?

1097

Difference between sql and mysql?

2099

WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?

2252

Is hive a database?

949

What is a trace file?

1080

Display the employees whose salary is less than average salary.

1066

What is the difference between primary and candidate key?

1133

Explain file manager?

1015

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

1844

Why do we need distributed database?

1003

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

2417

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