What is schema?

Answer Posted / niraj

A schema is a collection of database objects. A schema is
owned by a database user and has the same name as that
user. Schema objects are logical structures created by
users to contain, or reference, their data. Schema objects
include structures like tables, views, and indexes.

Is This Answer Correct ?    6 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the use of owner option in exp command.

569


What is the difference between hot backup and cold backup in oracle?

520


What is object data modeling?

507


How to write a left outer join with the where clause in oracle?

629


What is a trigger and what are its types in oracle?

534






master table and child table performances and comparisons in Oracle ?

1666


Explain about functional dependency and its relation with table design?

552


Are truncate and delete commands same? If so why?

654


Is primary key indexed by default in oracle?

548


what are the default admin accounts in Oracle 10g ?

508


State some uses of redo log files?

564


What is user managed backup in Oracle?

612


Differentiate between translate and replace?

629


Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

859


How to estimate disk space needed for an export job?

562