Database level roles are used to manage the security of the database. The role can be either fixed or flexible. Fixed roles are predefined while flexible roles can be created. Examples of some fixed database level roles are db_owner, db_securityadmin, db_datawriter etc.
Select item name, color, clothes size, sum(quantity) from sales group by rollup(item name, color, clothes size); How many grouping is possible in this rollup? a) 8 b) 4 c) 2 d) 1
Where is Data Sources in OLAP?
What are Fact Tables?
Which one of the following is the right syntax for DECODE ? a) DECODE (search, expression, result [, search, result]… [, default]) b) DECODE (expression, result [, search, result]… [, default], search) c) DECODE (search, result [, search, result]… [, default], expression) d) DECODE (expression, search, result [, search, result]… [, default])
Which of the following below is/are OLAP vendors? a) Cognos b) Infor c) Oracle corporation d) All of the above
Data that can be modeled as dimension attributes and measure attributes are called _______ data. a) Multidimensional b) Singledimensional c) Measured d) Dimensional
Explain about the database marketing application of OLAP?
Explain about multidimensional features present in OLAP?
Explain about analysis?
What are the different industries which use this marketing tool?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
