Data Warehouse, Cognos, Oracle, SQL Quiz

1. Types of transformation?

Simple Conversion

Structural Conversion

Format

All d above

2. Suitable Data model for OLTP?

ER

Dimensional Modeling

None

3. Using which command it is possible to append data from one table to another which has same column data type but with different data. Existing data should be updated and new data should be inserted.

A. Merge

B. Not possible with single command

C. None of the options

D. INSERT

4. In Report Studio, When selecting a prompt value automatically takes u to the second prompt, what are this type of prompts called?

A. Cascading Prompts

B. Sequence Prompts

C. None of the above

5. In Report Studio, When selecting a prompt value automatically takes u to the second prompt, what are this type of prompts called?

Cascading Prompts

Sequence Prompts

None of the above

6. What is the efficient Way of distributing the reports?

Bursting

Emailing

None

7. Which is not very frequently updated?

ODS

DW

DM

None

8. What does grain of the fact table mean?

Casual Dimensions

None

9. In which of the following is data not updated frequently/

ODS

DWH

Data mart

None

10. Using which of the following models is the performance improved?

A. star schema

B. snowflake

C. constellation

D. hybrid

11. What is true about Cursor for loop?

A. Does not require an exit condition

B. Open Cursor

C. Close Cursor

D. Fetch Cursor

12. Which Schema, help improving the performance?

Star schema

Snow flake

None

13. Which of the following SCD type is used to update existing record with new one by using surrogate key?

A. SCD TYPE 1

B. SCD

C. SCD TYPE 2

D. SCD TYPE 3

14. Which of the following are types of metadata?

ELT

Database

Molap

ELT and Database

ETL,database and Molap

15. Which is true

DM is a logical subset of DW

DW is logical subset of DM

Neither DM nor DW are subset

DW is the subset of DM and DM is subset of DW

16. Which one this is a valid table name?

A. COLUMN

B. NUMBER#1

C. 1TABLE

D. TABLE_MANY_COLUMN_ (goes on like that up to 34 characters.)

17.
Drilling from Analysis Studio report to which report is possible?

Report Studio report

Query Studio report

Metric Studio report

Not possible

18. Which is not cursor attributes?

A. %ROWCOUNT

B. %ISOPEN

C. %NOTFOUND

D. %FOUND

E. %TOO_MANY_ROWS

19. Which of the following is possible to a date variable

Min

Sum

Avg

None

20. Choose correct one

A) single row query will fetch the rows from only one table

B) subqueries cant have aggregate function

C) subqueries cant have analytical function

D) multiple sub query can have like function

21. To compare value with some reference values which chart is used?

Pie

Bar

Line

None

22. The facts are stored in a fact table and a dimensional framework is used to pull out the facts

A. Degenerate Dimensions

B. Junk dimension.

C. Role-Playing Dimension

D. None of the above

23. Which is a context in analysis studio?

Slicer

Dicer

Filter

None

24. Calculate 12salcommission for every record of the emp table choose the appropriate query?

Select 12*sal*nvl(commission,0) from emp ;

Select 12*sal*decode(commission,0) from emp ;

Select 12*sal*nvl(commission) from emp;

Select 12*sal*commission from emp ;

25. Which schema occupies Less memory Space?

Star schema

Snow flake

None

26. What is done in staging area?

Cleansing

Transformation

Temporary storage for incremental extract.

All the above

27. Which is higher in cognos?

Model

Project

Package

28. There are two tables. You need to copy one table to another. Incase the row already exists, update the values else insert the row. How will you do this?

A) Merge command

B) Update statement

C) Not possible

D) Insert

29. Cognos is a

A. ROLAP

B. MOLAP

C. both ROLAP and MOLAP

30. Which is not possible in analysis studio?

A. Standard deviation

B. Correlation

C. Max

D. SUM

31. Which is a windows based tool?

A. framework manager

B. cognos connection

C. query studio

D. none

32. What are the join Conditions available in Universe?

Full outer, right outer and left outer

Theta Join

Self Join

Shortcut Join.

All the above

33. Minimum no of dispatchers required to process a request?

1

2

3

4

34. In the Analysis studio, a cross tab is added in which two measures are adjacent to each other, what is this set called?

Measure Set

Analysis Set

None of the above

35. Which service in the Dispatchers helps to render reports?

Presentation Service

Batch Report Service

Report Service

Job Service

36. What are implicit cursors?

A) Implicit Cursor is not used in Oracle

B) User should be very careful in using Implicit Cursor

C) Implicit cursor used for SQL statements that r not named

None

37. A Query Subject named X should be accessed only by the Management level people, What security mode will u apply

Data level

Object level

Model level

None

38. What is stored in the key file?

A. repository server name

B. user name

C. password

D. all the above

39. To which of the following does the oracle create index implicitly?

A. Primary key

B. Unique

C. Not Null

D. Check

40. A User desires to join two relational sources with a single Source Qualifier have been correctly imported into the mapping. Next, she must establish a primary/foreign key relationship between two ports in the source definitions. Assuming that the relationship does not currently exist on the database server,what are the required steps to do this?

A. Use the source Analyser to establish that primary/foreign key relationship and save the repository

41. What does check Integrity do?

A. Parses joins, conditions and objects.

B. Validates cardinalities, loops and contexts.

C. Validates universe structure.

D. All the above.

42. Content Store stores what data?

Data required for the Application

Report Specification and published models,connection info for data sources

Cube data

43. What does check Integrity do?

A. Parses joins, conditions and objects.

B. Validates cardinalities, loops and contexts.

C. validates universe structure.

D. All the above

44. A developer wishes to use the data preview to determine the total number of rows in a relational source table. The number of rows exceeds 10000. What is the proper procedure for this operation?

A. Connect the data Previewer to the source table with all settings left to the defaults.

B. Connect the data Previewer to the source table and check the option “Count rows”

D. This operation is not supported.

45. Source for frame work manager

A. XML

B. Excel sheet

C. Homogenous and hetero

D. All the above.

E. Informix promptu

46. The detail filter is the one

A. applied to summary rows

B. applied to grand total

C. applied to detailed rows

D. applied to the entire rowsd. applied to the entire rowsd. applied to the entire rows

47. Which of the following are necessary for Cursor FOR loop?

A) Open cursor

B) Parse cursor

C) Fetch cursor

D) None of the above

48. What is the output of: round(trunc(mod(1600/10),-1),2)

0

0.00

Error

49. Which is different oracle constraint?

Primary Key

Unique

Not null

Check

None

50. For which of the below can a drill mode be applied:

A. Measures

B. Dimensions

C. Detail

D. All the above

51. Under what circumstances can a Target definition be edited from the Mapping Designer, within the mapping where that Target definition is being used?

A. When the Target definition is not shared(not a shortcut)

C. Always

Never

Data Warehouse, Cognos, Oracle, SQL Quiz

1. Types of transformation?

2.

What first name or nickname would you like us to use?

2. Suitable Data model for OLTP?

3. Using which command it is possible to append data from one table to another which has same column data type but with different data. Existing data should be updated and new data should be inserted.

4. In Report Studio, When selecting a prompt value automatically takes u to the second prompt, what are this type of prompts called?

5. In Report Studio, When selecting a prompt value automatically takes u to the second prompt, what are this type of prompts called?

6. What is the efficient Way of distributing the reports?

7. Which is not very frequently updated?

8. What does grain of the fact table mean?

9. In which of the following is data not updated frequently/

10. Using which of the following models is the performance improved?

11. What is true about Cursor for loop?

12. Which Schema, help improving the performance?

13. Which of the following SCD type is used to update existing record with new one by using surrogate key?

14. Which of the following are types of metadata?

15. Which is true

16. Which one this is a valid table name?

17. Drilling from Analysis Studio report to which report is possible?

18. Which is not cursor attributes?

19. Which of the following is possible to a date variable

20. Choose correct one

21. To compare value with some reference values which chart is used?

22. The facts are stored in a fact table and a dimensional framework is used to pull out the facts

23. Which is a context in analysis studio?

24. Calculate 12*sal*commission for every record of the emp table choose the appropriate query?

25. Which schema occupies Less memory Space?

26. What is done in staging area?

27. Which is higher in cognos?

28. There are two tables. You need to copy one table to another. Incase the row already exists, update the values else insert the row. How will you do this?

29. Cognos is a

30. Which is not possible in analysis studio?

31. Which is a windows based tool?

32. What are the join Conditions available in Universe?

33. Minimum no of dispatchers required to process a request?

34. In the Analysis studio, a cross tab is added in which two measures are adjacent to each other, what is this set called?

35. Which service in the Dispatchers helps to render reports?

36. What are implicit cursors?

37. A Query Subject named X should be accessed only by the Management level people, What security mode will u apply

38. What is stored in the key file?

39. To which of the following does the oracle create index implicitly?

41. What does check Integrity do?

42. Content Store stores what data?

43. What does check Integrity do?

44. A developer wishes to use the data preview to determine the total number of rows in a relational source table. The number of rows exceeds 10000. What is the proper procedure for this operation?

45. Source for frame work manager

46. The detail filter is the one

47. Which of the following are necessary for Cursor FOR loop?

48. What is the output of: round(trunc(mod(1600/10),-1),2)

49. Which is different oracle constraint?

50. For which of the below can a drill mode be applied:

51. Under what circumstances can a Target definition be edited from the Mapping Designer, within the mapping where that Target definition is being used?

17.
Drilling from Analysis Studio report to which report is possible?

24. Calculate 12salcommission for every record of the emp table choose the appropriate query?