What are the characteristics of data files ?
A data file can be associated with only one database. Once created a data file can’t change size. One or more data files form a logical unit of database storage... Read more »
‘Oracle Interview Questions’ - KyaPoocha.com
What is a datafile ?
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... Read more »
What are the uses of rollback segment ?
To generate read-consistent database information during database recovery and to rollback uncommitted transactions by the users. Read more »
What is a data segment ?
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... Read more »
What are the different types of segments ?
Data segment, index segment, rollback segment and temporary segment. Read more »
What is row chaining ?
In circumstances, all of the data for a row in a table may not be able to fit in the same data block. When this occurs, the data for the row is stored in a chain... Read more »
How to define data block size ?
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 data blocks. Block... Read more »
What is data block ?
Oracle database’s data is stored in data blocks. One data block corresponds to a specific number of bytes of physical database space on disk. Read more »
What is network database link ?
Network database link is created and managed by a network domain service. A network database link can be used when any user of any database in the network specifies... Read more »
What is public database link ?
Public database link is created for the special user group PUBLIC. A public database link can be used when any user in the associated database specifies a global... Read more »
What is private database link ?
Private database link is created on behalf of a specific user. A private database link can be used only when the owner of the link specifies a global object name... Read more »
Do a view contain data ?
Views do not contain or store data. Read more »
What are Schema Objects ?
Schema objects are the logical structures that directly refer to the database’s data. Schema objects include tables, views, sequences, synonyms, indexes, clusters,... Read more »