Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Databases AllOther Interview Questions
Questions Answers Views Company eMail

what is difference between delete and truncet ?

Fidelity,

7 7530

write a query for the fifth highest salary?

IBM, Matlabs, Ramco,

17 15042

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

1266

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,

1220

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

Cap Gemini,

2415

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

1405

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 3957

What is the concept of Virtual field?

EDS,

1231

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

1396

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?

1324

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

CybAge,

1 4998

What is the default identifier of structure in C?

CybAge,

3 4247

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

CybAge, Wipro,

8 9906

What is the differnce between Order by and Group by

1 3076

what is data access layer?

1536


Post New Databases AllOther Questions






Un-Answered Questions { Databases AllOther }

What is the DIF format and when we will use in teradata

1626


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

1220


Which database does facebook use?

107


What are different types of data models available? Explain with example?

190


Why do we need distributed database?

115






What are the types of joins?

168


What are the types of indexes that are present inside a database?

180


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

1296


How heap is implemented in database?

171


Which three commands cause a transaction to end?

197


What is database and its types?

126


Explain phantom deadlock?

175


Differentiate between delete and truncate table?

176


Explain database partitioning.

163


How does database replication work?

110