Answer Posted / praveen

A Subquery or Inner query or Nested query is a query within
another SQL query and embedded within the WHERE clause.

A subquery is used to return data that will be used in the
main query as a condition to further restrict the data to
be retrieved.
Temparory tables are used in creation of storing data for a
while and this table is used in another sql .
That means the result of temp table will be used in another
sql up on which the resultant data is to be displayed.

What are pass-through functions and why they are so called? Give some examples.

943

---

What are the benefits of using microstrategy intelligence server?

930

---

How conflicts occur and what are the ways to resolve them?

874

---

What is the conflict resolution window?

979

---

What is the order of precedence of vldb properties?

939

---

Can I access intelligent cubes without olap services?

959

---

What is level prompt?

903

---

How are microstrategy reports performance tuned?

916

---

How to use consolidations in microstrategy report?

990

---

How would you get two images on microstrategy login page?

912

---

What is derived metric?

936

---

Explain true primary keys?

934

---

How will you monitor the errors received while running i-server and report?

890

---

differentiate between two-tier, three-tier and four-tier connections.

929

---

What is percent-to-total shortcut metric in microstrategy?

921

---