Home » SQL & PL/SQL » SQL & PL/SQL » Doubts abt various data objects...
Doubts abt various data objects... [message #243611] Fri, 08 June 2007 00:50 Go to next message
fortunethiyagu
Messages: 94
Registered: December 2006
Member

Hi,

Here are the doubts ..

(1) Is RECORD in oracle is DATABASE OBJECT?
(2) What is HINT in oracle?
(3) what is Driver table in oracle?
(4) What are advantages of packages other than inter related collections of procedures, function..and overloading concepts?
(5) VARRAY, NESTED TABLE, RECORDS are the only collection of oracle?
(6) CASE : composite index is created for column A, B, C 
    if we try to use B, C for some select query...
    is the index used in select query?
(7) what happen if there is OUT paramter used in function?


Thanx in advance...
Re: Doubts about various data objects... [message #243624 is a reply to message #243611] Fri, 08 June 2007 02:01 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Where did you get these questions from?
icon10.gif  Re: Doubts about various data objects... [message #243675 is a reply to message #243624] Fri, 08 June 2007 06:10 Go to previous messageGo to next message
fortunethiyagu
Messages: 94
Registered: December 2006
Member

One of my friend got interviewed for oracle.
These are the questions he got and now he want to get the answer atleast by this time.

I have given some answer for this. But i dont know whether its correct.Plz let me know the answer for the questions.

(1) Is RECORD in oracle is DATABASE OBJECT?
No.

(2) What is HINT in oracle?
Like remarks used to provide comments.

(3) what is Driver table in oracle?
no Idea!!

(4) What are advantages of packages other than inter related collections of procedures, function..and overloading concepts?
related objects can identified easily
Wrapping is easier if its a package.
Memory allocation
Records, varray, nested tables canbe used globally.


(5) VARRAY, NESTED TABLE, RECORDS are the only collection of oracle?
Yes.

(6) CASE : composite index is created for column A, B, C
if we try to use B, C for some select query...
is the index used in select query?
No,is not used. IF B or C is defined as unique then implicit
index can be used.


(7) what happen if there is OUT paramter used in function?
Returns only specified return data type value

Am I correct? Razz

[Updated on: Fri, 08 June 2007 06:11]

Report message to a moderator

Re: Doubts about various data objects... [message #243719 is a reply to message #243675] Fri, 08 June 2007 11:26 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
Is RECORD in oracle is DATABASE OBJECT?

ita a composite datatype

Quote:
What is HINT in oracle?


Oracle hints is a debugging tool

http://www.dba-oracle.com/art_otn_cbo_p7.htm

Quote:
what is Driver table in oracle?


not sure

Quote:
VARRAY, NESTED TABLE, RECORDS are the only collection of oracle?


Composite data type
Re: Doubts about various data objects... [message #243723 is a reply to message #243675] Fri, 08 June 2007 11:46 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
fortunethiyagu wrote on Fri, 08 June 2007 13:10
(6) CASE : composite index is created for column A, B, C
if we try to use B, C for some select query...
is the index used in select query?
No,is not used. IF B or C is defined as unique then implicit
index can be used.

It might be used. That's called index skipping.


Quote:

(7) what happen if there is OUT paramter used in function?
Returns only specified return data type value

Depends on what you call "return". The OUT variable is filled.
With OUT arguments it is no longer usable in SQL. That's why you'd better change it into a procedure, to avoid mixed return types (the actual return type and the OUT parameter).
icon10.gif  Re: Doubts about various data objects... [message #243775 is a reply to message #243723] Fri, 08 June 2007 23:31 Go to previous message
fortunethiyagu
Messages: 94
Registered: December 2006
Member

Thank you...

It will be useful for me. Razz
Previous Topic: Help with reading ranges from a different table
Next Topic: performance tuning of merge
Goto Forum:
  


Current Time: Sun Dec 04 00:07:50 CST 2016

Total time taken to generate the page: 0.12181 seconds