Home » Other » Training & Certification » Oracle placement questions(require answers)
icon4.gif  Oracle placement questions(require answers) [message #274135] Sun, 14 October 2007 08:28 Go to next message
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 #274138 is a reply to message #274135] Sun, 14 October 2007 09:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ read and follow OraFAQ Forum Guide
2/ "plz" german postal is irrelevant here
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

Don't try to cheat during an interview it is useless interviewers are not stupid.

Database Concepts
SQL Reference
PL/SQL User's Guide and Reference
Application Developer's Guide - Fundamentals

Regards
Michel


Re: Oracle placement questions(require answers) [message #274179 is a reply to message #274138] Sun, 14 October 2007 22:41 Go to previous messageGo to next message
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

Re: Oracle placement questions(require answers) [message #274206 is a reply to message #274179] Mon, 15 October 2007 01:45 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
I think what Michel is trying to say is that so-called "Brain dumps" are illegal and considered cheating. OraFAQ has a very strict policy in this regard: zero tolerance.

I'll give you the benefit of the doubt but keep the forum guidelines in mind. Anyway, most of the questions could be answered by yourself. If you download Oracle 10g XE (200MB) from otn.oracle.com you have a working version of the Oracle database and you can test for yourself. Good luck!

MHE

PS: The statement in the second question is not valid in Oracle.
Re: Oracle placement questions(require answers) [message #274216 is a reply to message #274206] Mon, 15 October 2007 02:04 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

The statement in the second question is not valid in Oracle.

I concur:
SQL> SELECT (TO_CHAR(NVL(SQRT(59483), "INVALID")) FROM DUAL ;
SELECT (TO_CHAR(NVL(SQRT(59483), "INVALID")) FROM DUAL
                                             *
ERROR at line 1:
ORA-00907: missing right parenthesis


SQL> SELECT (TO_CHAR(NVL(SQRT(59483), "INVALID"))) FROM DUAL ;
SELECT (TO_CHAR(NVL(SQRT(59483), "INVALID"))) FROM DUAL
                                 *
ERROR at line 1:
ORA-00904: "INVALID": invalid identifier


SQL> SELECT (TO_CHAR(NVL(SQRT(59483), 'INVALID'))) FROM DUAL ;
SELECT (TO_CHAR(NVL(SQRT(59483), 'INVALID'))) FROM DUAL
                                 *
ERROR at line 1:
ORA-01722: invalid number

Wink

Regards
Michel
Previous Topic: Transforming rows into comma separated output
Next Topic: Interview tips for Trainee Oracle DBA
Goto Forum:
  


Current Time: Fri Mar 29 09:51:55 CDT 2024