Home » Other » Training & Certification » Some SQL Questions
Some SQL Questions [message #405810] Fri, 29 May 2009 11:20 Go to next message
kishorebonthala
Messages: 16
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: 68625
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: Fri Mar 29 05:55:09 CDT 2024