Data Warehouse, Cognos, Oracle, SQL Quiz
.
- 1.
- Drilling from Analysis Studio report to which report is possible?
- A.
Report Studio report
- B.
Query Studio report
- C.
Metric Studio report
- D.
Not possible
Correct Answer
A. Report Studio report - 2.
Minimum no of dispatchers required to process a request?
- A.
1
- B.
2
- C.
3
- D.
4
Correct Answer
A. 1 -
- 3.
In the Analysis studio, a cross tab is added in which two measures are adjacent to each other, what is this set called?
- A.
Measure Set
- B.
Analysis Set
- C.
None of the above
Correct Answer
A. Measure Set -
- 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
Correct Answer
A. Cascading Prompts -
- 5.
Content Store stores what data?
- A.
Data required for the Application
- B.
Report Specification and published models,connection info for data sources
- C.
Cube data
Correct Answer
B. Report Specification and published models,connection info for data sources -
- 6.
Which service in the Dispatchers helps to render reports?
- A.
Presentation Service
- B.
Batch Report Service
- C.
Report Service
- D.
Job Service
Correct Answer
A. Presentation Service -
- 7.
A Query Subject named X should be accessed only by the Management level people, What security mode will u apply
- A.
Data level
- B.
Object level
- C.
Model level
- D.
None
Correct Answer
A. Data level -
- 8.
What is the efficient Way of distributing the reports?
- A.
Bursting
- B.
Emailing
- C.
None
Correct Answer
A. Bursting -
- 9.
Which schema occupies Less memory Space?
- A.
Star schema
- B.
Snow flake
- C.
None
Correct Answer
B. Snow flake -
- 10.
Which Schema, help improving the performance?
- A.
Star schema
- B.
Snow flake
- C.
None
Correct Answer
A. Star schema -
- 11.
Which is not very frequently updated?
- A.
ODS
- B.
DW
- C.
DM
- D.
None
Correct Answer
B. DW -
- 12.
Suitable Data model for OLTP?
- A.
ER
- B.
Dimensional Modeling
- C.
None
Correct Answer
A. ER -
- 13.
Types of transformation?
- A.
Simple Conversion
- B.
Structural Conversion
- C.
Format
- D.
All d above
Correct Answer
D. All d above -
- 14.
What does grain of the fact table mean?
- A.
Casual Dimensions
- B.
None
Correct Answer
A. Casual Dimensions -
- 15.
Which is not cursor attributes?
- A.
A. %ROWCOUNT
- B.
B. %ISOPEN
- C.
C. %NOTFOUND
- D.
D. %FOUND
- E.
E. %TOO_MANY_ROWS
Correct Answer
E. E. %TOO_MANY_ROWS -
- 16.
Which of the following SCD type is used to update existing record with new one by using surrogate key?
- A.
A. SCD TYPE 1
- B.
B. SCD
- C.
C. SCD TYPE 2
- D.
D. SCD TYPE 3
Correct Answer
C. C. SCD TYPE 2 -
- 17.
What does check Integrity do?
- A.
A. Parses joins, conditions and objects.
- B.
B. Validates cardinalities, loops and contexts.
- C.
C. validates universe structure.
- D.
D. All the above
Correct Answer
C. C. validates universe structure. -
- 18.
The facts are stored in a fact table and a dimensional framework is used to pull out the facts
- A.
A. Degenerate Dimensions
- B.
B. Junk dimension.
- C.
C. Role-Playing Dimension
- D.
D. None of the above
Correct Answer
B. B. Junk dimension. -
- 19.
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.
A. Connect the data Previewer to the source table with all settings left to the defaults.
- B.
B. Connect the data Previewer to the source table and check the option “Count rows”
- C.
C. This operation is not supported because the number of rows exceeds 10000. It is supported only when number of rows is 10000 or less.
- D.
D. This operation is not supported.
Correct Answer
D. D. This operation is not supported. -
- 20.
Under what circumstances can a Target definition be edited from the Mapping Designer, within the mapping where that Target definition is being used?
- A.
A. When the Target definition is not shared(not a shortcut)
- B.
B. When the Target definition is not shared(not a shortcut) and when the user has write permission on the folder where the mapping is stored
- C.
C. Always
- D.
Never
Correct Answer
D. Never -
- 21.
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.
A. Use the source Analyser to establish that primary/foreign key relationship and save the repository
- B.
B. Use the source Analyser to establish that primary/foreign key relationship,save the repository,and run the appropriate SQL statement on the database tables t ocreate the actual primary / foreign key relationship
- C.
C. Use the source Analyser to establish that primary/foreign key relationship,open the SQL Editor in the Source qualifierand generate the join statement,modify the join statement is required and save the repository.
- D.
D. Use the source analyzer to establish that primary /foreign key relationship , regenerate the source Qualifier SQL using the SQL editor,press the okay button and save the repository.
Correct Answer
C. C. Use the source Analyser to establish that primary/foreign key relationship,open the SQL Editor in the Source qualifierand generate the join statement,modify the join statement is required and save the repository. -
- 22.
Which is a context in analysis studio?
- A.
Slicer
- B.
Dicer
- C.
Filter
- D.
None
Correct Answer
C. Filter -
- 23.
Which of the following are types of metadata?
- A.
ELT
- B.
Database
- C.
Molap
- D.
ELT and Database
- E.
ETL,database and Molap
Correct Answer
E. ETL,database and Molap -
- 24.
In which of the following is data not updated frequently/
- A.
ODS
- B.
DWH
- C.
Data mart
- D.
None
Correct Answer
B. DWH -
- 25.
Which is a windows based tool?
- A.
A. framework manager
- B.
B. cognos connection
- C.
C. query studio
- D.
D. none
Correct Answer
A. A. framework manager -
- 26.
Using which of the following models is the performance improved?
- A.
A. star schema
- B.
B. snowflake
- C.
C. constellation
- D.
D. hybrid
Correct Answer
A. A. star schema -
- 27.
What is true about Cursor for loop?
- A.
A. Does not require an exit condition
- B.
B. Open Cursor
- C.
C. Close Cursor
- D.
D. Fetch Cursor
Correct Answer
A. A. Does not require an exit condition -
- 28.
Which is higher in cognos?
- A.
Model
- B.
Project
- C.
Package
Correct Answer
B. Project -
- 29.
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.
A) Merge command
- B.
B) Update statement
- C.
C) Not possible
- D.
D) Insert
Correct Answer
A. A) Merge command -
- 30.
Which of the following are necessary for Cursor FOR loop?
- A.
A) Open cursor
- B.
B) Parse cursor
- C.
C) Fetch cursor
- D.
D) None of the above
Correct Answer
D. D) None of the above -
- 31.
In Report Studio, When selecting a prompt value automatically takes u to the second prompt, what are this type of prompts called?
- A.
A. Cascading Prompts
- B.
B. Sequence Prompts
- C.
C. None of the above
Correct Answer
A. A. Cascading Prompts -
- 32.
Which is not possible in analysis studio?
- A.
A. Standard deviation
- B.
B. Correlation
- C.
C. Max
- D.
D. SUM
Correct Answer
B. B. Correlation -
- 33.
Cognos is a
- A.
A. ROLAP
- B.
B. MOLAP
- C.
C. both ROLAP and MOLAP
Correct Answer
C. C. both ROLAP and MOLAP -
- 34.
Source for frame work manager
- A.
A. XML
- B.
B. Excel sheet
- C.
C. Homogenous and hetero
- D.
D. All the above.
- E.
E. Informix promptu
Correct Answer
D. D. All the above. -
- 35.
Choose correct one
- A.
A) single row query will fetch the rows from only one table
- B.
B) subqueries cant have aggregate function
- C.
C) subqueries cant have analytical function
- D.
D) multiple sub query can have like function
Correct Answer
A. A) single row query will fetch the rows from only one table -
- 36.
What is stored in the key file?
- A.
A. repository server name
- B.
B. user name
- C.
C. password
- D.
D. all the above
Correct Answer
C. C. password -
- 37.
What does check Integrity do?
- A.
A. Parses joins, conditions and objects.
- B.
B. Validates cardinalities, loops and contexts.
- C.
C. Validates universe structure.
- D.
D. All the above.
Correct Answer
C. C. Validates universe structure. -
- 38.
Which one this is a valid table name?
- A.
A. COLUMN
- B.
B. NUMBER#1
- C.
C. 1TABLE
- D.
D. TABLE_MANY_COLUMN_ (goes on like that up to 34 characters.)
Correct Answer
B. B. NUMBER#1 -
- 39.
For which of the below can a drill mode be applied:
- A.
A. Measures
- B.
B. Dimensions
- C.
C. Detail
- D.
D. All the above
Correct Answer
B. B. Dimensions -
- 40.
The detail filter is the one
- A.
A. applied to summary rows
- B.
B. applied to grand total
- C.
C. applied to detailed rows
- D.
d. applied to the entire rows d. applied to the entire rows d. applied to the entire rows
Correct Answer
C. C. applied to detailed rows -
- 41.
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.
A. Merge
- B.
B. Not possible with single command
- C.
C. None of the options
- D.
D. INSERT
Correct Answer
A. A. Merge -
- 42.
To which of the following does the oracle create index implicitly?
- A.
A. Primary key
- B.
B. Unique
- C.
C. Not Null
- D.
D. Check
Correct Answer
A. A. Primary key -
- 43.
To compare value with some reference values which chart is used?
- A.
Pie
- B.
Bar
- C.
Line
- D.
None
Correct Answer
B. Bar -
- 44.
Which is different oracle constraint?
- A.
Primary Key
- B.
Unique
- C.
Not null
- D.
Check
- E.
None
Correct Answer
E. None -
- 45.
What is done in staging area?
- A.
Cleansing
- B.
Transformation
- C.
Temporary storage for incremental extract.
- D.
All the above
Correct Answer
D. All the above -
- 46.
Calculate 12*sal*commission for every record of the emp table choose the appropriate query?
- A.
Select 12*sal*nvl(commission,0) from emp ;
- B.
Select 12*sal*decode(commission,0) from emp ;
- C.
Select 12*sal*nvl(commission) from emp;
- D.
Select 12*sal*commission from emp ;
Correct Answer
A. Select 12*sal*nvl(commission,0) from emp ; -
- 47.
Which of the following is possible to a date variable
- A.
Min
- B.
Sum
- C.
Avg
- D.
None
Correct Answer
A. Min -
- 48.
Which is true
- A.
DM is a logical subset of DW
- B.
DW is logical subset of DM
- C.
Neither DM nor DW are subset
- D.
DW is the subset of DM and DM is subset of DW
Correct Answer
A. DM is a logical subset of DW -
- 49.
What is the output of: round(trunc(mod(1600/10),-1),2)
- A.
0
- B.
0.00
- C.
Error
Correct Answer
C. Error -
- 50.
What are the join Conditions available in Universe?
- A.
Full outer, right outer and left outer
- B.
Theta Join
- C.
Self Join
- D.
Shortcut Join.
- E.
All the above
Correct Answer
E. All the above -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Oct 16, 2023Quiz Edited by
ProProfs Editorial Team -
Jul 08, 2016Quiz Created by
Jeetu Dewda
Back to top