Answer / sivakumar_yandra

whenever we are passing values to the query at runtime then
it is called dynamic query .

Answer / susi kumar.p [infotech enterpr

Runtime Queries which are creating while at forms , modules
and which may usually be allocated with temporary memory
storeage were called as dynamic queries.

best examples are sql statements which we generally used at
forms and modules.

Note:- Thank You Siva

Answer / manu

Using dynamic queries, you can alter the basic structure of a query when the report is run. For example, you could write an expression that changes the table or fields from which data is retrieved based on the user's locale information.

Write the major components of a Database Management System?

3 Answers  

---

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

0 Answers  

---

What are the most common databases?

0 Answers  

---

what is tkprof tool and how it is used???

0 Answers   Genpact,

---

Is it possible to update AS400 database record while reading it with no lock

1 Answers  

---

How many indexes can be created on a table?

0 Answers   Abacus,

---

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?

0 Answers  

---

Is database a hardware or software?

0 Answers  

---

Does aggregate and fact tables gets populated from transactional data with only diffrence in there granularity? Please clarify?

1 Answers  

---

can any one explain about normalization forms with clear explanation in interview point of view. thanks for ur answers.

1 Answers  

---

what is primary key,unique key, foreign key? can u teach me in simple language?

44 Answers   Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro,

---

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

0 Answers   C DAC, CDAC,

---