Cognos Development Set 1

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Free Online Best Cognos-Development MCQ Questions for improve your basic knowledge of Cognos-Development. This Cognos-Development set 1 test that contains 25 Multiple Choice Questions with 4 options. You have to select the right answer to a question.

Start

Congratulations - you have completed Cognos Development Set 1.

You scored %%SCORE%% out of %%TOTAL%%.

Your performance has been rated as %%RATING%%

Your answers are highlighted below.

Question 1

What can an administrator use to transfer security data from one location to another using Series 7 namespaces?

A	Settings (.csa) file
B	Local authentication cache (.lac) file
C	Local authentication export (.lae) file
D	Configuration specification (.ccs) file

Question 2

In Oracle 11i, which of the following objects does not physically store data?

A	Views
B	Tables
C	Materialized Views
D	All of the Above

Question 3

Which of the following is NOT a usage property in Framework Manager?

A	Fact
B	Dimension
C	Attribute
D	Identifier

Question 4

In Oracle SQL, what is the command that returns the first non-null value in a list of values?

A	NVL
B	DECODE
C	COALESCE
D	INSTR

Question 5

In Analysis Studio, what functionality would cause subtotals or totals to result in more than the sum of the rows or columns?

A	Custom Set
B	Nested Rows
C	Hidden Rows
D	Custom Filters

Question 6

Within Framework Manager, what objects are used to store key-value pairs which create conditional query subjects that allow for substitutions when the report is run?

A	Packages
B	Parameters
C	Filters
D	Query Subjects

Question 7

For what purpose are custom views used in the Transformer?

A	Point-In-Time Reporting
B	Security
C	Manage Languages
D	Performance Optimization

Question 8

In Report Studio, what function would be useful in implementing alternate line shading within a list box?

A	Char_length
B	currentMember
C	mod
D	exp

Question 9

When working with dimensional data in Report Studio, an intersection is useful for obtaining a value from the combination of two or more members that you specify. This intersection is called_____

A	A Singleton
B	An X Axis Measurement
C	A Position
D	A Tuple

Question 10

Which of the following is NOT a valid Oracle SQL statement?

A	SELECT column1, SUM(column2) “column2” FROM table1 GROUP BY column1 ORDER BY column1
B	SELECT column1, SUM(column2) “column2” FROM table1 HAVING SUM(column2) = 0 GROUP BY column1 ORDER BY column1
C	.SELECT column1, SUM(column2) “column2” FROM table1 GROUP BY column1 HAVING SUM(column2) = 0 ORDER BY column1
D	LECT column1, SUM(column2) “column2” FROM table1 ORDER BY column1 GROUP BY column1

Question 11

Are Metric Studio metrics part of the Content Store?

A	Yes
B	No
C	both A and B
D	sometime

Question 12

When tuning performance, one should remember that the following setting takes precedence over the other two settings:

A	Advanced Routing Settings
B	Affinity Settings
C	Balance Request Settings
D	All of the Above

Question 13

In an Oracle SQL insert statement, is it necessary to designate the column names?

A	Yes
B	No
C	always
D	sometime

Question 14

When creating a package in Framework Manager, the following setting allows the data within an object to be used in other objects without the original object itself being available to report users__

A	Select
B	Traverse
C	Unselect
D	Hide

Question 15

In Report Studio, which of the following is not a valid prompt button?

A	Execute
B	Back
C	Cancel
D	Reprompt

Question 16

Within the expression editor of Framework Manager, quality of service indicator on functions gives a visual clue about the behavior of the function. What quality of service indicator reflects the danger of poor performance on some data sources?

A	X
B	!!
C	!
D	&

Question 17

What is the regular aggregate property of a calculated fact object within Framework Manager?

A	Sum
B	Total
C	Average
D	Automatic

Question 18

In Transformer, alternate drill-down paths / alternate hierarchies must have the convergence level that is:

A	Unique
B	Ordered
C	Open
D	Set

Question 19

In Cognos Connection, RSS news feeds may be specified by a URL address_____

A	Yes
B	No
C	both A and B
D	sometime

Question 20

What is the Cognos 8 service that manages the storage of customer applications, including application-specific security, configuration data, models, metrics, reports, and report output?

A	Gateway
B	Package
C	Namespace
D	Content Manager

Question 21

Within Framework Manager, this type of SQL does not process query subjects as subqueries____

A	Pass-Through SQL
B	Cognos SQL
C	Native SQL
D	PL SQL

Question 22

If the user desires to retrieve all rows from Table A and all rows from Table B based on a join criterion, what type of join would be necessary?

A	Left Outer Join
B	Inner Join
C	Cross Join
D	Cartesian Join

Question 23

In Cognos Connection, which of the following is valid permission to be granted at the report level?

A	Run
B	View
C	Traverse
D	Edit

Question 24

In Oracle 11i, what type of index is used to index low cardinality columns in a warehouse environment?

A	Function-based
B	Bitmap
C	Optimized
D	Normal

Question 25

Without using aggregation (Group By), is it possible to determine the minimum or maximum value of a data set using Oracle SQL?

A	Yes
B	No
C	both A and B
D	sometime

Once you are finished, click the button below. Any items you have not completed will be marked incorrect. Get Results

There are 25 questions to complete.

←

List

→

Return

Shaded items are complete.

1	2	3	4	5
6	7	8	9	10
11	12	13	14	15
16	17	18	19	20
21	22	23	24	25
End

Return

NEXT SET 2

Study Zone

MCQ » Cognos Development Set 1

Cognos Development Set 1

Important Links