siddhartha


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

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

Users Marked my Answers as Correct # 0
Users Marked my Answers as Wrong # 2
Questions / { siddhartha }
Questions Answers Category Views Company eMail




Answers / { siddhartha }

Question { 2538 }

Name two files used for network connection to a database.


Answer

Tnsnames.ora, listener.ora

Is This Answer Correct ?    0 Yes 0 No

Question { 6184 }

What is cardinality?


Answer

It refers to uniqueness of data contained in a column...

Is This Answer Correct ?    0 Yes 0 No


Question { Teledata, 7834 }

How to find the date and time of last updated table?


Answer

select scn_to_timestamp(max(ora_rowscn)) from

Is This Answer Correct ?    0 Yes 0 No

Question { iNautix, 23218 }

Write a query to get last 10 records from the table.


Answer

select * from
minus
select * from
where
rownum <= (select count(*) - &n from )

Is This Answer Correct ?    0 Yes 0 No

Question { 2074 }

What does ROLLBACK do ?


Answer

It is used to undo the work performed by the current transaction.

Is This Answer Correct ?    0 Yes 0 No

Question { 3519 }

display your age in months?


Answer

select trunc(months_between(sysdate,'22-mar-1995')/12) as age from dual;

Is This Answer Correct ?    0 Yes 2 No