samir kumar sahoo


{ City }
< Country > india
* Profession *
User No # 23649
Total Questions Posted # 0
Total Answers Posted # 27

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 172
Users Marked my Answers as Wrong # 42
Questions / { samir kumar sahoo }
Questions Answers Category Views Company eMail




Answers / { samir kumar sahoo }

Question { IBM, 8006 }

What does DML stand for and what are some examples of it?


Answer

DML stands for Data Manipulation Language.This langage
enables the users to make manipulation operations on the
data present in the database.

Is This Answer Correct ?    2 Yes 0 No

Question { 37037 }

What is IMAGECOPY ?


Answer

It is a utility by using of which we can take the back up
of the tablespace after bulk update or insert operations.
it is generally used for recovery process.

Is This Answer Correct ?    15 Yes 3 No


Question { 10214 }

Advantages of de normalized data?


Answer

Denormalized data makes data retrieval operation faster and
reliable due to minimum number of joins used for
it.Therefore it improves the performance of the system.

Is This Answer Correct ?    10 Yes 5 No

Question { 9285 }

What is operational data source (ODS)?


Answer

It is a collection of integrated databases designed to
support operational monitoring. Unlike the OLTP databases
the data in the ODS are integrated, subject oriented and
enterprise wide data.

Is This Answer Correct ?    4 Yes 0 No

Question { 9386 }

Compare ?Data mining? and ?Data Warehousing??


Answer

Data mining means it is a methodology by which the
analyst can get knowledge from the summary data present in
the DWH which is usuful for the future business planning.


DataWareHouse is a relational database which is subject
oriented,time variant, non volatile and integrated database
for the support of the business.

Is This Answer Correct ?    7 Yes 6 No

Question { 7604 }

What is an OLTP (Online Transaction Processing) System?


Answer

OLTP stands for OnLine Transaction Processing . It uses
database tables(Fact and Dimention tables) to enable
multidimentional viewing, analysis and querying of large
amount of data.

Is This Answer Correct ?    3 Yes 1 No

Question { Texas, 10524 }

what is loop in frameworkmanager ?


Answer

A LOOP IS NOTHING BUT A CLOSED PATH DUE TO JOINS IN FRAME
WORK MANAGER. THE JOIN CONSISTS OF ATLEAST THREE TABLES.
THIS PROBLEM CAN BE RESOLVED BY USING ALIAS OR SHORT CUTS.
THE LOOP GENERALLY DEGRADES THE PERFORMANCE BECAUSE IT TAKES
MORE EXECUTION TIME AND DISPLAY WRONG RESULTS DUE TO A
NUMBER OF JOINS.SO WE BETTER TRY TO AVOID USING OF LOOPS IN
FRAME WORK MANAGER TOOL.

Is This Answer Correct ?    4 Yes 0 No

Question { 5004 }

What is Read-Only Transaction ?


Answer

A Read_only transaction is one type of transaction which
ensures that all the execution query results that are
performed in this transaction will be remain consistent as
it allows only read priviledges to the users in order to
keep data secure in database.

Is This Answer Correct ?    0 Yes 0 No

Question { CTS, 57248 }

Query to get max and second max in oracle in one query ?


Answer

SELECT sal FROM(SELECT DISTINCT(sal) FROM employees ORDER
BY sal DESC) WHERE ROWNUM<=2;

Is This Answer Correct ?    23 Yes 2 No

Question { Verinon Technology Solutions, 13681 }

find out first highest salary?


Answer

SELECT DISTINCT salary FROM (SELECT DISTINCT salary,ROWNUM
rn FROM employee ORDER BY salary desc) WHERE rn=1;

Is This Answer Correct ?    6 Yes 2 No

Question { 10372 }

what is the syntax of DROP command?


Answer

DROP object ;

object means database object like table,index,view,sequence
etc.

Is This Answer Correct ?    1 Yes 0 No

Question { EDS, 8199 }

what is the use of surrogate key in businessobjects


Answer

A Surrogate key is a system generated key which is assigned
to be a primary key in the system(table).When data coming
from multiple data sources then there will be a possibility
of duplications and at that situation the system uses the
surrogate key in order to mantain data consistency.

Is This Answer Correct ?    3 Yes 1 No

Question { NIIT, 16780 }

what is the output of select * from emp where null=null &
select * from emp where 1=1


Answer

select*from emp where null=null;

this command will not return any record bcoz the
condition null=null false as two null values are not equal.


select*from emp where 1=1;

will return all the records present in the table emp as
the condition 1=1 is always true.

Is This Answer Correct ?    2 Yes 0 No

Question { HCL, 17264 }

what are typees of dimensions


Answer

There are various types of dimensions, they are

1.Regular dimension
2.Slowly Changing Dimension
3.Fastly Changing Dimension
4.Conformed Dimension
5.Junk Dimension
6.Degenerated Dimension
7.Measure Dimension
8.Mini Dimension

Is This Answer Correct ?    1 Yes 0 No

Question { 8107 }

various types of joins


Answer

Generally there are five types of joins in oracle:

Self Join
Equi Join
Cartesian Join
Outer Join(Left outer join,Right outer join)
Non_Equi JOin

Is This Answer Correct ?    7 Yes 0 No

 [1]   2    Next