In Oracle it is possible to have: A only database and several instances Several databases and a only instance A database replicated in several machines The database and the instance in a only machine 2. . In Oracle, the groups of files redolog: Among other things, they allow Oracle to continue a strategy of management of the data buffer of type “steal / no force” There is only a group of redolog files for database There is only a group of active redolog files for database There is only a group of on-line redolog files for database . In Oracle, it is said that the groups of redolog files are multiplexed if and only if: There are several groups of on-line redolog files There is more than one member per group The ARCHIVELOG mode is activated There are no offline files redo log . In Oracle, about the tablespaces: They are no part of any instance They are organized in segments, extensions and storage blocks They are managed by the database writter (dbwr) process They are stored in one or more files . In Oracle, a table can be stored physically In a only segment In several extensions In several tablespaces In a only file. In Oracle, about the pctfree parameter: It must have a high value for tables which are expected to be rarely updated It is related to the management of the storage blocks It is relevant for operations of type DELETE It is relevant for operations of type UPDATE . In Oracle, for every new session client, it is possible to setup the DBMS so that: A new server process is created A new instance is created A server process is shared with other clients The instance is shared with other clients . In the terminology of Oracle, some of the elements regarding with the database are: Data files Instance Redo log files Control files . In Oracle, the following elements are a part of an instance: The system global memory (SGA) SQL*Plus The database writer process (DBWR) The archiver process (ARCH) . In Oracle, the following elements are a part of the global memory of the system The process global memory The buffer of the log (bitacora) The data buffer The tablespace.
|