What is schema?
Answer Posted / salim
schema is collection of objects
(table,view,procedure,function.....)
Is This Answer Correct ? | 148 Yes | 19 No |
Post New Answer View All Answers
What are the execution control statements in oracle?
How to join two tables in a single query using oracle?
What are a collation and state the different types of collation sensitivity?
How to do clean up if create database failed?
Give syntax for SQL and ORACLE joins.
defination of bitmap index
How to define an anonymous procedure without variables?
What is data file?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
What are the parameters that we can pass through a stored procedure?
List the types of joins used in writing subqueries?
what is dynamic SGA and static SGA
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
How to recover a dropped table in oracle?