Interview Questions Answers in Cognos, Oracle AllOther, Oracle General

anuradha kovi

{ City } pune
< Country > india
* Profession * software engineer
User No # 23705

Total Questions Posted # 4
Total Answers Posted # 30

Total Answers Posted for My Questions # 6
Total Views for My Questions # 22925

Users Marked my Answers as Correct # 213
Users Marked my Answers as Wrong # 122

Answers / { anuradha kovi }

Question { 7420 }

Compare and contrast TRUNCATE and DELETE for a table.

Answer

DELETE: IT IS A DML COMMAND(DATA MANIPULATION LANGUAGE) .
IT DELETES DATA MEANS (DELETES ALL RECORDS) IN TABLE.
BUT STRUCTURE WILL BE THERE.
AND
DATA DELETES TEMPERORLY.
THEN USE ROLLBACK WE CAN GET THE DATA.

TRUNCATE: IT IS A DDL COMMAND (DATA DEFNITION LANGUAGE).
TRUNCATE ALL RECORDS IN A TABLE.
BUT STRUCTURE WILL BE THERE.
BUT DATA GOES PERMINANTLY.
WE CANT USE ROLLBACK HERE.
IT SHOLUD NOT WORK. WHY BCZ DATA TRUNCATES
PERMENANTLY.

Is This Answer Correct ?

1 Yes

0 No

Question { DELL, 62006 }

What is the difference between drill down and drill through?

Answer

Drillthrough: It will navigate from summary to detail
report. (i.e Navigate from 1 report to another report.)

Drilldown: It will navigate from detail to summary level
information with in the report.

Is This Answer Correct ?

8 Yes

25 No

Question { Accenture, 210265 }

Difference between primary key and unique key ?

Answer

7. Primary Key doesnt allow the Null Values. where as in
Unique accept the Null values.
One table may have more than one Unique Key Constraint.
But it sholud have only one Primary Key Constraint column.

Is This Answer Correct ?

77 Yes

47 No

Question { 10523 }

what is the syntax of INSERT command?

Answer

we use Dept table or Any table Insert Command

Insert into dept(Dname,deptno,location.....)values
('Darway',30,'Sweadon');

Or

Insert into dept values('&dname',deptno,'&location'....)

Is This Answer Correct ?

2 Yes

0 No

Question { 13534 }

what is the syntax of DROP command?

Answer

5. drop table

Is This Answer Correct ?

2 Yes

0 No

Question { TCS, 11913 }

How we check the errors before running the report,plz let
me know the answer

Answer

Just--------------- Validate a Report.(In Run Menu.

Then findout Errors.

Is This Answer Correct ?

3 Yes

0 No

Question { 31873 }

wHAI IS THE DIFFERENCE BETWEEN LIST REPORT AND CROSSTAB
REPORT?

Answer

List Report----> List report show data in rows and columns.
Whereas
crosstab report show data in grids with dimension in rows
and columns and measures in cells or in the intersection
points.

Is This Answer Correct ?

12 Yes

4 No

Question { 22471 }

What is Stich Query in Reportnet?

Answer

I am not sure about this que.

Is This Answer Correct ?

1 Yes

3 No

Question { IBM, 9238 }

can reportnet supports cubes???

Answer

Reportnet is not supported to create Cubes.

Is This Answer Correct ?

3 Yes

0 No

Question { 36469 }

what is difference between where clause and having clause?

Answer

Where Clause------------------ It is used to Filter Rows
(i.e Restrict Rows and It appiles to the Individual Rows).

Having Clause----------------- It appies on Groups (i.e
Aggregate Functions).

Is This Answer Correct ?

23 Yes

3 No

Question { Cognizant, 27274 }

cognos is holap or molap or rolap

Answer

ROLAP---------------- It is related to Cognos Reportnet.

MOLAP---------------- It is related to Cognos8.
HOLAP---------------- It is A combination of MOALP+ROLAP.

So that we will use in HOLAP in Cognos 8 BI Suite.

Note:
In Reportnet---------- we doesn't have Drillup and Drill
Down.

In Cognos 8 BI Suite-------------- we can do Drillup and
Drill down.

Is This Answer Correct ?

5 Yes

1 No

Question { HCL, 7945 }

what is prompt variable

Answer

Prompt variable----------------- It is a Filter which
allows the user to select the required value which has to
be Filtered.
We have Valueprompt.
Tree Prompt.
Select and Search Prompt.
Time Prompt.
Date and Time Prompt.
Intervel Prompt.
Generated Prompt.

Is This Answer Correct ?

3 Yes

1 No

Question { HCL, 20996 }

what are typees of dimensions

Answer

We have Junk Dimension
Conformed Dimension
Degenerated Dimension

Is This Answer Correct ?

1 Yes

0 No

Question { 11136 }

Column level security in report

Answer

We have Object level security level will be there. in Frame
work Manager.

we dont have ColumnLevel Security.

Is This Answer Correct ?

1 Yes

1 No

Question { 7635 }

why r u using etl tool.

Answer

MAIN ETL PURPOSE IS
EXTRACTION,
TRASFORMATION
AND LODING.

THIS IS ONE OF THE ETL TOOL IN DWH.

ETL: WE HAVE TO FETCH THE DATA FROM MULTIPLE SOURCES.
EX:ORACLE,XML,FLATFILES ETC..............

THEN DATA GOES TO STAGING AREA.
HERE ACCORDING CLENT REQUIREMENT WE NEED TO CLEANSING
SCRUBBING AND AGGREGATING DATA IN STAGINGAREA.

IF WE NEED TRANSFORMATION WITH THE HELP OF TRANSFORMATION
TRANFER DATA INTO TRANSFORMATION.

FINALLY LOADING DATA INTO DWH OR TARGET DWH.

FOR THIS PURPOSE WE NEED TO USE ETL TOOL.

I THINK IS IT CLEAR FOR U.

IF U GET ANY DOUBT ON THIS PLS LET ME KNOW.

Is This Answer Correct ?

7 Yes

0 No