What is schema?
Answer Posted / smnad
Every design that we made in the data base is called as
schema .like table , namefeild , columns and all the feild
that will be generated by the user is called as schema.
| Is This Answer Correct ? | 59 Yes | 17 No |
Post New Answer View All Answers
What is the difference between translate and replace in oracle?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
Explain mutating triggers.
How to define an oracle sub procedure?
List the parts of a database trigger.
How can we force the database to use the user specified rollback segment?
How many data types are supported?
Explain the use of consistent option in exp command.
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
Give the different types of rollback segments.
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.
Can multiple columns be used in group by in oracle?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process