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 11777

write a query for the fifth highest salary?

IBM, Matlabs, Ramco,

17 24465

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

2112

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

2261

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 5376

What is the concept of Virtual field?

EDS,

2059

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

2259

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?

2194

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

CybAge,

1 6448

What is the default identifier of structure in C?

CybAge,

3 6802

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

CybAge, Wipro,

8 14741

What is the differnce between Order by and Group by

1 4389

what is data access layer?

2400

Post New Databases AllOther Questions

Un-Answered Questions { Databases AllOther }

WHAT IS CARDINALITIES OF JOIN?

2366

What are different types of resources?

1013

What is lagging in DBMS ?

1261

Explain alternate key?

1078

What is redis good for?

957

What are the validations performed on the source data? If there are junk data available in the source data, how to eliminate it?

2023

Differentiate between unique key and foreign key?

1011

How much does it cost to build a database?

1028

How to produce such kind of file?

1107

If the master device is full, how do I make the master database bigger?

991

What are the advantages of using database?

1022

Give the syntax of exception handling used in DBMS?

1199

After normalization, what are the conditions which have to keep in mind to de-normalize it?

1050

Which database does facebook use?

979

Differentiate between delete and truncate table?

1055

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