Each Non-clustered table has a data segment. All of the table's data is stored in the extents of its data segment. Each cluster has a data segment. The data of every table in the cluster is stored in the cluster's data segment.
A schema is collection of database objects of a User.
A schema is collection of database objects of an user and is used synonym of an user.
Schema name = user name
Yes a Tablespace can hold objects from different Schemes in Oracle
An integrity constraint is a declarative way to define a business rule for a column of a table.
A data block size is specified for each ORACLE database when the database is created. A database users and allocated free database space in ORACLE datablocks. Block size is specified in INIT.ORA file and can?t be changed latter.
A data block size is defined by DB_BLOCK parameter in pfile and there could be non standard block sizes supported by Oracle upto block size of 32bytes
Once set the block size could not be changed and the database has to be created again
Webmaster 22nd of May 2012
Tell us what you feel about Oracle Database Architecture Interview Questions and Answers
All comments will be published after review. No login or registration is required to post a comment on Oracle Database Architecture Interview Questions and Answers We offer and invite you to submit your valuable comment now; Please be respectful of others when commenting. Insulting others, self-promotional comments, website promotional comments, marketing stuff, SEO Techniques, SMS-style content and off-topic comments will not be approved at this information portal.
So start sharing your thoughts regarding Oracle Database Architecture Interview Questions and Answers
Thank you.