 Related Questions Schema objects are the logical structures that directly refer to the database's data. Schema objects include tables, views, sequences, synonyms, indexes, clusters, database triggers, procedures, functions Indexes are automatically maintained and used by ORACLE. Changes to table data are automatically incorporated into all relevant indexes. Latest Answer : Index is a Database object . It can be accessed rows physical fast. when you move the table from different table spaces or same table spaces indexes will unusually status. So You compulsory rebuild the index. Rebuilding the index is very fast than drop ... Every ORACLE database has one or more physical data files. A database's data files contain all the database data. The data of logical database structures such as tables and indexes is physically stored Latest Answer : the data of logical database, say tables,indeses etc are stored in datafile.they can be associated with only one database. once created their size can not be altered. but we can add new data file to the table space. ... A rule defined on a column (or set of columns) in one table that allows the insert or update of a row only if the value for the column or set of columns (the dependent value) matches a value in a column Latest Answer : Referential integrity is a relationship between two tables, one being the 'parent' and the other being the 'child'. The 'child' table references values in the 'parent' table's primary key to ensure all data between ... UPDATE and DELETE Restrict - A referential integrity rule that disallows the update or deletion of referenced data.DELETE Cascade - When a referenced row is deleted all associated dependent rows are deleted. Latest Answer : Foreign key value must exist as PK value on some other  table...FK value can be null but PK can't ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
