Home » Other » Training & Certification » Some SQL Questions
Some SQL Questions [message #405810] Fri, 29 May 2009 11:20 Go to next message
kishorebonthala
Messages: 15
Registered: May 2008
Location: Bangalore
Junior Member

Hi Friends,

I attended interview on oracle following question i am not able to answer, please help me to solve these.questions

Q) When will say your database in normalized form?
Q) Select * from emp where rownum=2.
Q) In where clause NVL and Decode are valid?
Q) Without select statement we can use DECODE AND CASE?
Q) when do you ambiguous replace error?
Q) using NULL can you create foreign key relation?
Q) How will you change the CLOB data type to NCLOB datatype?
Q) What is the difference between subquery and joins, which will execute faster?
Q) What is forward rollback?
Q) How will be maintaining one to one, one to many and many to many relations?

--kishore
Re: Some SQL Questions [message #405813 is a reply to message #405810] Fri, 29 May 2009 11:55 Go to previous message
Michel Cadot
Messages: 57648
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Q) When will say your database in normalized form?
Normalization
Q) Select * from emp where rownum=2.
ROWNUM
Q) In where clause NVL and Decode are valid?
Yes
Q) Without select statement we can use DECODE AND CASE?
Yes
Q) when do you ambiguous replace error?
What does that mean?
Q) using NULL can you create foreign key relation?
Yes
Q) How will you change the CLOB data type to NCLOB datatype?
DBMS_REDEFINITION
Q) What is the difference between subquery and joins, which will execute faster?
Joins Subqueries
Q) What is forward rollback?
rolling forward, if this is what you mean as forward rollback is meaningless.
Q) How will be maintaining one to one, one to many and many to many relations?
Foreign keys, child tables

All is in the documentation. I recommend you to read:
Database Concepts
SQL Reference

Regards
Michel

Previous Topic: Oracle SOA Architect Certified Expert 1Z0-114
Next Topic: Need Guidance in Oracle Enterprise Linux 1z0-403 exam preparation
Goto Forum:
  


Current Time: Thu Apr 24 14:47:02 CDT 2014

Total time taken to generate the page: 0.18456 seconds