Answer / suresh

Sr Relational Modelling Multi-Dimensional Modelling
1 Relational models can be very complex with hundreds
of tables having long chains of relationship among them.
Multidimensional modeling are very simple. Each of
the dimension table has a direct relationship with the fact
table
2 Normal data modeling is quite flexible. The
Multidimensional modeling has a rigid structure
3 One of the goals of relational modeling is to
confirm to the rules of normalization. In a normalized
database each data value is stored only once.
Multidimensional modeling are radically
denormalized. The dimension tables have a high number of
repeated values in their fields.
4 Standard relational models are optimized for On
Line Transaction Processing. OLTP needs the ability to
efficiently update data. This is provided in a normalized
database that has each value stored only once.
Multidimensional modeling are optimized for On Line
Analytical Processing. OLAP needs the ability to retrieve
data efficiently. Efficient data retrieval requires a
minimum number of joins. This is provided with the simple
structure of relationship in a Multidimensional modeling,
where each dimension table is only a single join away from
the fact table.
5 SQL queries required to manipulate relational data
MDX queries required to manipulate multi-
dimensional data
6 Tables are units of relational data storage.
Cubes are units of multi-dimensional data storage.
7 Table fields of particular data type store the
actual data. Dimensions and measures stores actual data.
8 Table size is measured in number of record set.
Cube size is measured in number of Cellsets. In
this sense, MS Excel Pivot Table can accommodate 2,040,000
cellsets (8000 * 255). Considering the summary data to be
reported, this is reasonably large. Pivot Table can report
at the most 8000 different items.

I am pavani pursuing 4th B.Tech final semester i want to write the Group 2 Examination , Eligibility of that exam is all degree holders but to hold my Degree 3months are more. but the exam held on 3rd July 2012. i would be complete my B.Tech when exam to be held. so am i eligible to Group2 exam or not , please clarify my doubt.

0 Answers  

---

what is compiler

0 Answers  

---

An integer number is said to be a perfect number if its factors, including 1 but not the number itself, sum to the number. For example, 6 is a perfect number because 6 = 1 + 2 + 3. Write a Java program, which finds and prints all perfect numbers that are less than 1600.

1 Answers  

---

how to increase the water ring vacuum pump efficiency?

0 Answers  

---

Questions on identity?

0 Answers  

---

what is difference between semaphre and deadlock

0 Answers  

---

what is the use of typedef in c language?

0 Answers  

---

convert 140 N.m/cm^2 to N.m/mm^2

0 Answers  

---

any one help me how the following program execute main() { int x=5; printf("%d %d %d",x,x<<3,x>>2); } //output : 5 40 1

1 Answers  

---

A rectangular sheet dimensions a x b is to be made into an open-topped box by cutting a square of side h from each corner and folding the 4 sides up. Find the value of h which allows the maximum volume of the box?

0 Answers  

---

why bin folder is not be created in windows os?

1 Answers  

---

Technical Interview Questions – Exchange 2003 1. Tell me a bit about the capabilities of Exchange Server. 2. What are the different Exchange 2003 versions? 3. What's the main differences between Exchange 5.5 and Exchange 2000/2003? 4. What are the major network infrastructure for installing Exchange 2003? 5. What is the latest Exchange 2003 Service Pack? Name a few changes in functionality in that SP. 6. What are the disk considerations when installing Exchange (RAID types, locations and so on). 7. You got a new HP DL380 (2U) server, dual Xeon, 4GB of RAM, 7 SAS disks, 64-bit. What do you do next to install Exchange 2003? (you have AD in place) 8. Why not install Exchange on the same machine as a DC? 9. Are there any other installation considerations? 10. How would you prepare the AD Schema in advance before installing Exchange? 11. What type or permissions do you need in order to install the first Exchange server in a forest? In a domain? 12. How would you verify that the schema was in fact updated? 13. What type of memory optimization changes could you do for Exchange 2003? 14. How would you check your Exchange configuration settings to see if they're right? 15. What are the Exchange management tools? How and where can you install them? 16. What types of permissions are configurable for Exchange? 17. How can you grant access for an administrator to access all mailboxes on a specific server? 18. What is the Send As permission? 19. What other management tools are used to manage and control Exchange 2003? Name the tools you'd use. 20. What are Exchange Recipient types? Name 5. 21. You created a mailbox for a user, yet the mailbox does not appear in ESM. Why? 22. You wanted to change mailbox access permissions for a mailbox, yet you see the SELF permission alone on the permissions list. Why? 23. What are Query Based Distribution groups? 24. What type of groups would you use when configuring distribution groups in a multiple domain forest? 25. Name a few configuration options for Exchange recipients. 26. What's the difference between Exchange 2003 Std. and Ent. editions when related to storage options and size? 27. Name a few configuration options related to mailbox stores. 28. What are System Public Folders? Where would you find them? 29. How would you plan and configure Public Folder redundancy? 30. How can you immediately stop PF replication? 31. How can you prevent PF referral across slow WAN links? 32. What types of PF management tools might you use? 33. What are the differences between administrative permissions and client permissions in PF? 34. How can you configure PF replication from the command prompt in Exchange 2003? 35. What are the message hygiene options you can use natively in Exchange 2003? 36. What are the configuration options in IMF? 37. What are virtual servers? When would you use more than one? 38. Name some of the SMTP Virtual Server configuration options. 39. What is a Mail Relay? Name a few known mail relay software or hardware options. 40. What is a Smart Host? Where would you configure it? 41. What are Routing Groups? When would you use them? 42. What are the types of Connectors you can use in Exchange? 43. What is the cost option in Exchange connectors? 44. What is the Link State Table? How would you view it? 45. How would you configure mail transfer security between 2 routing groups? 46. What is the Routing Group Master? Who holds that role? 47. Explain the configuration steps required to allow Exchange 2003 to send and receive email from the Internet (consider a one-site multiple server scenario). 48. What is DS2MB? 49. What is Forms Based Authentication? 50. How would you configure OWA's settings on an Exchange server? 51. What is DSACCESS? 52. What are Recipient Policies? 53. How would you work with multiple recipient policies? 54. What is the "issue" with trying to remove email addresses added by recipient policies? How would you fix that? 55. What is the RUS? 56. When would you need to manually create additional RUS? 57. What are Address Lists? 58. How would you modify the filter properties of one of the default address lists? 59. How can you create multiple GALs and allow the users to only see the one related to them? 60. What is a Front End server? In what scenarios would you use one? 61. What type of authentication is used on the front end servers? 62. When would you use NLB? 63. How would you achieve incoming mail redundancy? 64. What are the 4 types of Exchange backups? 65. What is the Dial-Tone server scenario? 66. When would you use offline backup? 67. How do you re-install Exchange on a server that has crashed but with AD intact? 68. What is the dumpster? 69. What are the e00xxxxx.log files? 70. What is the e00.chk file? 71. What is circular logging? When would you use it? 72. What's the difference between online and offline defrag? 73. How would you know if it is time to perform an offline defrag of your Exchange stores? 74. How would you plan for, and perform the offline defrag? 75. What is the eseutil command? 76. What is the isinteg command? 77. How would you monitor Exchange's services and performance? Name 2 or 3 options. 78. Name all the client connection options in Exchange 2003. 79. What is Direct Push? What are the requirements to run it? 80. How would you remote wipe a PPC? 81. What are the issues with connecting Outlook from a remote computer to your mailbox? 82. How would you solve those issues? Name 2 or 3 methods 83. What is RPC over HTTP? What are the requirements to run it? 84. What is Cached Mode in OL2003/2007? 85. What are the benefits and "issues" when using cached mode? How would you tackle those issues? 86. What is S/MIME? What are the usage scenarios for S/MIME? 87. What are the IPSec usage scenarios for Exchange 2003? 88. How do you enable SSL on OWA? 89. What are the considerations for obtaining a digital certificate for SSL on Exchange? 90. Name a few 3rd-party CAs. 91. What do you need to consider when using a client-type AV software on an Exchange server? 92. What are the different clustering options in Exchange 2003? Which one would you choose and why.

3 Answers   AB Inc, Convergys, Good Luck, HP, IBM, Microsoft,

---