Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

user71408


{ City } ne
< Country > bangladesh
* Profession * student
User No # 8840
Total Questions Posted # 0
Total Answers Posted # 32

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

Users Marked my Answers as Correct # 264
Users Marked my Answers as Wrong # 118
Questions / { user71408 }
Questions Answers Category Views Company eMail




Answers / { user71408 }

Question { 9613 }

What is an Integrity Constraint?


Answer

Integrity Constraint is a rule that restricts a value to a
clomn in table.

Is This Answer Correct ?    2 Yes 0 No

Question { 8671 }

What is a database link?


Answer

It's a named path through which remote database can be

accessed.

Is This Answer Correct ?    0 Yes 1 No


Question { 7622 }

What is the Subquery?


Answer

SELECT Statement which is embedded in another class of
SELECT statement is nothing but "Sub-Query".

In this ..Inner query will execute first.based on that
result outer query will execute.

Thank you,
Suresh

Is This Answer Correct ?    6 Yes 0 No

Question { DELL, 21804 }

What is NOCOPY?


Answer

OUT and IN OUT parameters passed by reference which avoid
COPY overhead.

Is This Answer Correct ?    2 Yes 1 No

Question { 22567 }

What is difference between % ROWTYPE and TYPE RECORD ?


Answer

%ROWTYPE is to be used whenever query returns a row of
Database Table.

RECORD TYPE is to be used whenever query returns a columns
of different Tables.

Eg : TYPE IS RECORD (Name Varchar2,
No Number);

Thank you,
Suresh

Is This Answer Correct ?    15 Yes 4 No

Question { 10249 }

What are the PL/SQL Statements used in cursor processing ?


Answer

Declaring a CURSOR
Open the CURSOR
FETCH the rows from the CURSOR
CLOSE the CURSOR...

Is This Answer Correct ?    5 Yes 2 No

Question { 9610 }

What is a cursor for loop ?


Answer

Cursor for loop implicitly declares %rowtype as Loop index
opens the cursor and fetch the rows from active set into
fields and then process it and then close the cursor.

Is This Answer Correct ?    1 Yes 3 No

Question { TCS, 12907 }

What is a 'instead of trigger'?


Answer

These Triggers are used to modify the VIEW whaich can't be
modified by DML statements.

Thank you,
Suresh.

Is This Answer Correct ?    1 Yes 0 No

Question { TCS, 10445 }

Types of backups ?


Answer

1.Physical Backup :-----
a.Hot Backup (which is running)

b.Cold Backup (Which is not running)

2.Logical backup (Done by Programmer)

Is This Answer Correct ?    6 Yes 1 No

Question { Hexaware, 61180 }

What is INSTEAD OF trigger ?


Answer

"Instead Of Triggers " are used to modify the view
which can't be modified by DML Statements.

Is This Answer Correct ?    31 Yes 28 No

Question { BirlaSoft, 22297 }

What is normalization ?


Answer

Normalization is the process of organizing the table to
remove redundancy.

Is This Answer Correct ?    8 Yes 0 No

Question { 22280 }

what is ref cursor in pl/sql?


Answer

Re-usability of a cursor is nothing but " REF CURSOR".
It is of 2 types.
1. Weak REF Cursor
2. Strong REF Cursor.

SYNTAX:
1.Strong Refcursor
SYN: TYPE IS
REFCURSOR RETURN
2.Weak Refcursor
SYN : TYPE IS
REFCURSOR

Thank you,
Suresh

Is This Answer Correct ?    11 Yes 2 No

Question { PreVator, 19398 }

Differentiate between %type and %rowtype attribute in
Oracle PL/AQL programming ?


Answer

%Type is used to change the size of any datatype but only
for one record.

%Rowtype is used to declare a recoed that represents a
particular row of a table.

Is This Answer Correct ?    9 Yes 4 No

Question { 13357 }

what is meant by tuning and tk proof?


Answer

Tkproof is a tool by Oracle to format the trace file Output.

Is This Answer Correct ?    6 Yes 0 No

Question { TCS, 42456 }

what is the output of the query select * from emp where 1=2


Answer

Hi Anfal,

Try the following Query.

SQL> CREATE TABLE EMP_NEW
AS
SELET *
FROM EMP
WHERE 1=2;
Table Created

SQL> SELECT * FROM EMP_NEW
no rows selected.

SQL> DESC EMP_NEW;
Structure will be displayed.

Please correct me if any mistakes.

Thank you,
Suresh

Is This Answer Correct ?    11 Yes 4 No

 [1]   2   3    Next