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


Please Help Members By Posting Answers For Below Questions

What are the execution control statements in oracle?

605


How to join two tables in a single query using oracle?

566


What are a collation and state the different types of collation sensitivity?

551


How to do clean up if create database failed?

576


Give syntax for SQL and ORACLE joins.

636






defination of bitmap index

1631


How to define an anonymous procedure without variables?

553


What is data file?

619


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??

1614


What are the parameters that we can pass through a stored procedure?

553


List the types of joins used in writing subqueries?

573


what is dynamic SGA and static SGA

3841


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.

1578


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

1860


How to recover a dropped table in oracle?

607