Triggers and Rules
Explain Triggers and Rules?
Expert
Triggers are defined as the special user which defined actions typically in the form of stored procedures, which are automatically triggered by the server based upon data related events. It may perform the complex actions and may use full power of the procedural languages. A rule involves unique type of trigger which is used in order to perform simple checks over the data.
Can we have a report with several data providers?
How can I partition any table in Sybase? Explain.
Describe some of the major objectives of normalization?
Describe briefly the term data warehouse?
Briefly describe the new features of SQL Server 2005 Analysis Services (or SSAS)?
Describe the main characteristic of the database administrator?
Briefly explain SQL Server 2005 Business Intelligence components?
You have been given a setup of tables with data and inquired to make a new database to store them. What are you looking for, when you observe the data values in the tables?
Give brief introduction of the term an OLAP system and OLTP system?
Briefly describe the foreign key columns in dimension table and fact table?
18,76,764
1938131 Asked
3,689
Active Tutors
1457225
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!