Databases AllOther Interview Questions
Questions Answers Views Company eMail

what is difference between delete and truncet ?

Fidelity,

7 9665

write a query for the fifth highest salary?

IBM, Matlabs, Ramco,

17 19638

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

1677

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,

1667

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

Cap Gemini,

2850

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

1851

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 4672

What is the concept of Virtual field?

EDS,

1626

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

1820

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?

1732

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

CybAge,

1 5743

What is the default identifier of structure in C?

CybAge,

3 5453

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

CybAge, Wipro,

8 12301

What is the differnce between Order by and Group by

1 3768

what is data access layer?

1982


Post New Databases AllOther Questions

Un-Answered Questions { Databases AllOther }

How concurrency problems effect the database?

639


What is database schema name?

584


What is the concept of Virtual field?

1626


Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?

2036


What is Object Oriented model?

626






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

1667


What is meant by distributed system?

541


Differentiate between delete and truncate table?

633


Explain artificial key?

743


What are the disadvantages of views in a database?

549


What is ole db source in ssis?

554


what is data access layer?

1982


On startup, the transaction log of a database has filled and recovery has suspended, what can I do?

558


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

1704


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

1677