What is schema?

Answer Posted / peter

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 ?    14 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we view last record added to a table?

602


Give the various rollback segment states.

579


How to view existing locks on the database?

553


Explain drop constraint oracle?

593


What is a system tablespace and when it is created?

563






How oracle handles dead locks?

602


Is there an oracle sql query that aggregates multiple rows into one row?

546


Why packages are used in oracle?

543


what is Single Byte Overhead...?

2064


How to bring a tablespace offline?

543


How to create a new tablespace in oracle?

560


when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1477


Explain oracle 12c new features for developers?

540


How to define a sub function?

669


What privilege is needed for a user to delete rows from tables in another schema?

563