databases Online Quiz - 2

Description: databases Online Quiz - 2
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

How to find out no. of objects in a database.

  1. Sp_find

  2. select * from Sys.sysobjects

  3. select * from sys.dm_exec_objects

  4. Sp_helpobjects

Correct Option: B

What are three steps of data recovery when database goes in recovery mode.

  1. Analysis ,redo,undo

  2. Redo.Analysis ,undo

  3. Undo,analysis,Redo

  4. Analysis,Redo,Recovery

Correct Option: A




Correct Option: D
  1. administrator

  2. manager

  3. designer

  4. directror

Correct Option: A,C,D
  1. sequential file stage

  2. File set stage

  3. Lookup file set stage

  4. Row generator stage

Correct Option: A,D
  1. Constraints,Derivations,Stage variables

  2. Derivations,Constraints,Stage variables

  3. Stage variables,Derivations,Constraints

  4. Any of the above

Correct Option: C

What are the join stages available in lookup stage?

  1. LeftOuter Join,Right Outer Join,Inner join

  2. Outer Join,Inner Join

  3. Left Outer Join,Inner Join

  4. Left Outer Join,Right Outer Join

Correct Option: C
  1. Automatically handle activities that fail

  2. Add checkpoints so sequence is restartable on failure

  3. Log warnings after activities that finish with status other than ok

  4. Log report messages after each job run

Correct Option: B
  1. Derivations,Stage variables,Constraints

  2. Stage variables,Constraints,Derivations

  3. Constraints,Stage variables,Derivations

  4. Constraints,Derivations,Stage variables

Correct Option: B
  1. Run the cube through the pcoptimizer utility that is shipped with Cognos 8 BI.

  2. Enable the Allow dynamic usage of dimension information governor in Framework Manager.

  3. Edit the EnablePCOptimizer entry in the Cognos.ini file so that its value=1, and then rebuild the cube.

  4. Ensure that the Pass-through SQL setting is enabled onall regular dimensions in the Framework

Correct Option: A

What technique can Framework Manager modelers use to implement a time dimension for models that lack a time dimension?

  1. Create relationships from date fields inone dimension to date fields in another dimension.

  2. Use parameter maps to map date values in one query subject to date values in another query subject.

  3. Use theTime Dimension wizard togenerate a time dimension and create the appropriate relationships.

  4. Identify a time dimension table source, import into the model and create relationships to fact query subjects.

Correct Option: D
  1. Using a different query subject icon for display inthe studios.

  2. Viewing the properties of the query subjects in Report Studio.

  3. Viewing the properties of the query subjects in Framework Manager.

  4. Using the same name for the dimension in each star schema grouping.

Correct Option: D

If authors want to perform OLAP-style queries directly against a relational database, which Framework Manager modeling technique will a modeler use?

  1. Create regular and measure dimensions and set scope.

  2. Create shortcuts to regular dimensions and fact query subjects.

  3. Create star schema groupings for dimension and fact query subjects.

  4. Create relationships between regular dimensions andmeasure dimensions.

Correct Option: A

Which of the following is correct regarding the Cognos 8 securityenvironment?

  1. Cognos 8 must be configured to use only one authentication provider at a time

  2. Toperform authentication of users, a connection to the Cognos namespace must be defined

  3. In Framework Manager, object security is implemented by defining access toobjects for users, groups and roles defined in theauthentication providers

  4. In Framework Manager, object security is implemented by defining access toobjects for groups and roles (of which users are members), not individual users

Correct Option: C

What is true of a Framework Manager model of an operational database lacking a time dimension?

  1. Virtual star schema models require a time dimension for multi-fact queries.

  2. Report authors cannot create multi-fact, time-based queries.

  3. Time-based rollups for multi-fact queries may be difficult to handle.

  4. Report authors cannot create multi-fact, time-based queries unless using a union.

Correct Option: C
- Hide questions