What is recovery manager in Oracle?
No Answer is Posted For this Question
Be the First to Post Answer
What are inner join and outer join?
interview questions with answer for cts
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What is oracle database 10g express edition?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?
Please explain compound trigger in oracle?
What is analyze command used for?
Explain overloading. Can functions be overloaded?
Name the various constraints used in oracle?