Theory Question Paper

DOWNLOAD

Practical Question Papers

Sample 1

1.

Import the data from Oracle and from flat file and also create a Metadata. Also draw the ER model on paper. [Assume your own database]

20

2.

Show the configuration of Listener, Repository and Workspace. Show the performance to Examiner. And Write the necessary steps on paper.

20

3.

Viva

5

4.

Journal

5

Sample 2

1.

Import the data from Oracle and from flat file and also create a Metadata. Also draw the ER model on paper. [Assume your own database]

20

2.

Show the mapping of your source and target table using necessary operators. [Use atleast two operators. And Create suitable configurations required for your project.]

20

3.

Viva

5

4.

Journal

5

Sample 3

1.

Import the data from Oracle and from flat file and also create a Metadata. Also draw the ER model on paper. [Assume your own database]

20

2.

Show the ETL process using necessary operators using Design Center. [Use at least two operators. And Create suitable configurations required for your project.]

20

3.

Viva

5

4.

Journal

5

Sample 4

1.

Create a SQL SERVER database module and a flat file module.

Import its metadata. Show the necessary steps to the Examiner.

(Consider any SQLSERVER  database)

20

2.

Create your own table in excel. Create a pivot table and pivot chart from it.

20

3.

Viva

5

4.

Journal

5

Sample 5

 1.

Create a SQL SERVER database module and a flat file module. Import its metadata. Show the necessary steps to the Examiner.

(Consider any SQLSERVER  database)

20

2.

Create a target structure. Design a staging area in mapping editor to show mapping of the source and target table using suitable operators.

20

3.

Viva

5

4.

Journal

5

Sample 6

1.

Create a SQL SERVER database module and a flat file module.

Import its metadata. Show the necessary steps to the Examiner.

(Consider any SQLSERVER  database)

20

2.

Import data from SQL SERVER in excel and create a pivot table and chart.

20

3.

Viva

5

4.

Journal

5

Sample 7

1.

Import the data from Oracle and from flat file and also create a Metadata. Also draw the ER model on paper. [Assume your own database]

20

2.

Create at least two cubes and define the necessary dimensions and measures. [Use at least two operators. And Create suitable configurations required for your project.]

20

3.

Viva

5

4.

Journal

5

Sample 8

1.

Import the data from Oracle and from flat file and also create a Metadata. Also draw the ER model on paper. [Assume your own database]

20

2.

Design the staging area which should include a cube, table as a source. [Use at least two operators. And Create suitable configurations required for your project.]

20

3.

Viva

5

4.

Journal

5

Sample 9

1.

Import the data from Oracle and from flat file and also create a Metadata. Also draw the ER model on paper. [Assume your own database]

20

2.

Design the structure of your data warehouse based on your above data in mapping editor. [Use at least two operators. And Create suitable configurations required for your project.]

20

3.

Viva

5

4.

Journal

5

 

Sample 10

1.

Import the data from Oracle and from flat file and also create a Metadata. Also draw the ER model on paper. [Assume your own database]

20

2.

Design the ETL process and also add the dimensions and functions such as aggregations. [Use at least two operators. And Create suitable configurations required for your project.]

20

3.

Viva

5

4.

Journal

5

Sample 11

1.

Import the data from Oracle and from flat file and also create a Metadata. Also draw the ER model on paper. [Assume your own database]

20

2.

Design the structure of your data warehouse based on your above data in mapping editor. [Use at least two operators. And Create suitable configurations required for your project.]

20

3.

Viva

5

4.

Journal

5

Sample 12

1.

Import the data from Oracle and from flat file and also create a Metadata. Also draw the ER model on paper. [Assume your own database]

20

2.

Design the data warehouse using ETL process based on your above data in mapping editor. And retrieve the cube using pivot table. [Use at least two operators. And Create suitable configurations required for your project.]

20

3.

Viva

5

4.

Journal

5

Sample 13

1.

Create a SQL SERVER database module and a flat file module.

Import its metadata. Show the necessary steps to the Examiner.

(Consider any SQLSERVER  database)

20

2.

Show creation of a target table, Dimensions and Cube in OWB. Also create a target user.

20

3.

Viva

5

4.

Journal

5

Sample 14

1.

Create a SQL SERVER database module and a flat file module.

Import its metadata. Show the necessary steps to the Examiner. (Consider any SQLSERVER  database)

20

2.

Show the mapping of the target table and a cube using suitable operators. Deploy the cube and show the result to the Examiner.

20

3.

Viva

5

4.

Journal

5

Sample 15

1.

Design the staging area which includes a cube, table as a source inData Object Editor.

[Create the necessary source data required for the process. Use at least two operators. And Create suitable configurations required for your project.]

40

2.

Viva

5

3.

Journal

5

Sample 16

1.

Import the data from Oracle and from flat file and also create a Metadata. Also draw the ER model on paper. [Assume your own database]

20

2.

Create a cube using suitable dimensions and also show the use of Table Look Up operator.  [Use atleast two operators. And Create suitable configurations required for your project.]

20

3.

Viva

5

D.

Journal

5

Sample 17

A.

Design the data warehouse using ETL process in Data Object Editor.

Also Create a Cube and Mapping in the given process. [Make Suitable Assumptions for required source and target data]  [Use at least two operators.]

40

B.

Viva

5

C.

Journal

5

Sample 19

1.

Import the data from Oracle and from flat file and also create a Metadata. Also draw the ER model on paper. [Assume your own database]

20

2.

Design the data warehouse using ETL process based on your above data in mapping editor. And retrieve the cube using pivot table. [Use at least two operators. And Create suitable configurations required for your project.]

20

3.

Viva

5

4.

Journal

5

Next paper > Geographic Information Systems Paper

Comment down below if you have any questions and don’t forget share with your classmates.