 Oracle placement questions(require answers) [message #274135] |
Sun, 14 October 2007 08:28  |
muraliraredew
Messages: 7
Registered: October 2007
Location: Hyderabad
|
Junior Member |
|
|
PL/SQL uses which of the following
A. Early Binding
B. Late binding
C. No Binding
D. Deferred Binging
i saw in a website that the answer is early binding
>SELECT (TO_CHAR(NVL(SQRT(59483), "INVALID")) FROM DUAL is a valid SQL statement.
a. TRUE
b. FALSE
ans:true
3>Once defined, how long will a variable remain so in SQL*Plus?
a. Until the database is shut down
b. Until the instance is shut down
c. Until the statement completes
d. Until the session completes
4>Dropping a table has which of the following effects on a nonunique index created for the table?
a. No effect.
b. The index will be dropped.
c. The index will be rendered invalid.
d. The index will contain NULL values.
5<Which function below can best be categorized as similar in function to an IF-THEN-ELSE statement?
a. SQRT
b. DECODE
c. NEW_TIME
d. ROWIDTOCHAR
6<symbol of realtionship between 2 entities?
7<#To change the default date format in a SQLPLUS Session you have to
(A) Set the new format in the DATE_FORMAT key in the windows Registry.
(B) Alter session to set NLS_DATE-FORMAT.
(C) Change the Config.ora File for the date base.
(D) Change the User Profile USER-DATE-FORMAT.
8# Which of the following is not necessarily an advantages of using a package rather than independent stored procedure in data base.
(A) Better performance. (B) Optimized memory usage.
(C) Simplified Security implementation. (D) Encapsulation.
#9<Integrity constrains are not checked at the time of
(A) DCL Statements. (B) DML Statements.
(C) DDL Statements. (D) It is checked all the above cases.
11#An Arc relationship is applicable when
(A) One child table has multiple parent relation, but for anyone instance of a child record
only one of the relations is applicable.
(B) One column of a table is related to another column of the same table.
(C) A child table is dependent on columns other than the primary key columns of the parent
table.
(D) None of the above.
give small explanation for your answers
[Updated on: Sun, 14 October 2007 22:35] Report message to a moderator |
|
|
|
|
|
| Re: Oracle placement questions(require answers) [message #274179 is a reply to message #274138] |
Sun, 14 October 2007 22:41  |
muraliraredew
Messages: 7
Registered: October 2007
Location: Hyderabad
|
Junior Member |
|
|
1/ read and follow OraFAQ Forum Guide (i can't spend that much time)
2/ "plz" german postal is irrelevant here (yes you are right)
3/ post what you searched, what you found, why you think it is or not correct
4/ yes I think you are lazy and will not give answer until you prove I'm wrong(i don't accept with you).
Don't try to cheat during an interview it is useless interviewers are not stupid. (yes u are right)
it's so simple if am able to spent that much time i would have found the answers myself.
i thought of a short cut but
remained me once again that there are no shortcuts.
thank you Mr.Cadot
hope i spend some time with this forum latter may be at the end of this month
[Updated on: Sun, 14 October 2007 22:44] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
