Explore topic-wise InterviewSolutions in .

When an instance of an Oracle DATABASE is started, its control file is used to identify the database and redo LOG FILES that must be OPENED for database OPERATION to proceed. It is also used in database recovery.

When an instance of an Oracle database is started, its control file is used to identify the database and redo log files that must be opened for database operation to proceed. It is also used in database recovery.

• Database name
• Names and LOCATIONS of a database's files and redolog files.
• TIME stamp of database CREATION.

The information in a redo log FILE is USED only to RECOVER the database from a SYSTEM or media failure prevents database DATA from being written to a database's data files.

The information in a redo log file is used only to recover the database from a system or media failure prevents database data from being written to a database's data files.

The primary FUNCTION of the redo log is to RECORD all CHANGES made to DATA.

The primary function of the redo log is to record all changes made to data.

The SET of REDO log files for a DATABASE is COLLECTIVELY KNOWN as the database redo log.

The set of redo log files for a database is collectively known as the database redo log.

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 called a TABLESPACE.

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 called a tablespace.

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 in the data files ALLOCATED for a database.

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 in the data files allocated for a database.

Temporary segments are CREATED by Oracle when a SQL statement needs a temporary work area to complete EXECUTION. When the statement finishes execution, the temporary SEGMENT extents are released to the SYSTEM for future USE.

Temporary segments are created by Oracle when a SQL statement needs a temporary work area to complete execution. When the statement finishes execution, the temporary segment extents are released to the system for future use.

To GENERATE read-consistent database information during database recovery and to ROLLBACK UNCOMMITTED TRANSACTIONS by the users.

To generate read-consistent database information during database recovery and to rollback uncommitted transactions by the users.

A database contains one or more ROLLBACK SEGMENTS to TEMPORARILY STORE "undo" information.

A database contains one or more rollback segments to temporarily store "undo" information.

Each INDEX has an index SEGMENT that STORES all of its DATA.

Each index has an index segment that stores all of its data.

An EXTENT is a specific number of contiguous data blocks, obtained in a SINGLE ALLOCATION and USED to store a specific type of information.

An extent is a specific number of contiguous data blocks, obtained in a single allocation and used to store a specific type of information.

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 size is specified in INIT. ora file and cannot be changed LATTER.

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 size is specified in init. ora file and cannot be changed latter.

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.

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.

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 a GLOBAL object name in a SQL statement or object DEFINITION.

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 a global object name in a SQL statement or object definition.

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 OBJECT NAME in a SQL STATEMENT or object definition.

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 object name in a SQL statement or object definition.

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 in a SQL statement or in the definition of the owner's VIEWS or PROCEDURES.

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 in a SQL statement or in the definition of the owner's views or procedures.

PRIVATE database link, public database link & NETWORK database link.

Private database link, public database link & network database link.

Hash clusters are better choice when a table is OFTEN queried with EQUALITY queries. For such queries the specified cluster KEY value is hashed. The resulting hash key value POINTS directly to the area on disk that stores the specified rows.

Hash clusters are better choice when a table is often queried with equality queries. For such queries the specified cluster key value is hashed. The resulting hash key value points directly to the area on disk that stores the specified rows.

A ROW is STORED in a hash cluster BASED on the RESULT of applying a hash function to the row's cluster key value. All rows with the same hash key value are stores TOGETHER on disk.

A row is stored in a hash cluster based on the result of applying a hash function to the row's cluster key value. All rows with the same hash key value are stores together on disk.

A CLUSTER with an INDEX on the cluster KEY.

A cluster with an index on the cluster key.

A database LINK is a named OBJECT that DESCRIBES a "path" from ONE database to ANOTHER.

A database link is a named object that describes a "path" from one database to another.

A PRIVATE SYNONYMS can be ACCESSED only by the OWNER.

A Private Synonyms can be accessed only by the owner.

A row is STORED in a HASH cluster BASED on the result of applying a hash function to the row's cluster KEY value. All rows with the same hash key value are stores together on disk.

A row is stored in a hash cluster based on the result of applying a hash function to the row's cluster key value. All rows with the same hash key value are stores together on disk.

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 of a related table (the REFERENCED value). It also specifies the type of data manipulation allowed on referenced data and the action to be PERFORMED on dependent data as a result of any action on referenced data.

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 of a related table (the referenced value). It also specifies the type of data manipulation allowed on referenced data and the action to be performed on dependent data as a result of any action on referenced data.

A segment is a SET of extents ALLOCATED for a CERTAIN LOGICAL STRUCTURE.

A segment is a set of extents allocated for a certain logical structure.

A sequence generates a serial list of UNIQUE numbers for NUMERICAL columns of a database's TABLES.

A sequence generates a serial list of unique numbers for numerical columns of a database's tables.

A SYNONYM is an alias for a table, view, SEQUENCE or program UNIT.

A synonym is an alias for a table, view, sequence or program unit.

The minimum NUMBER of GROUPS REQUIRED for a matrix report are 4 E --

The minimum number of groups required for a matrix report are 4 e --

Flex is the property of moving the related FIELDS together by SETTING the flex property on.

Flex is the property of moving the related fields together by setting the flex property on.

By using the lock option we cannot move the fields in the LAYOUT editor OUTSIDE the frame. This is USEFUL for maintaining the fields.

By using the lock option we cannot move the fields in the layout editor outside the frame. This is useful for maintaining the fields.

Yes it is POSSIBLE to RUN the REPORT without parameter form by setting the PARAM VALUE to Null.

Yes it is possible to run the report without parameter form by setting the PARAM value to Null.

It is POSSIBLE to have more than ONE layout in a report by using the additional layout option in the layout EDITOR.

It is possible to have more than one layout in a report by using the additional layout option in the layout editor.

Formula COLUMNS :: For doing mathematical calculations and returning one value

SUMMARY Columns :: For doing summary calculations such as summations etc.

Place holder Columns :: These columns are USEFUL for storing the value in a VARIABLE .

Formula columns :: For doing mathematical calculations and returning one value

Summary Columns :: For doing summary calculations such as summations etc.

Place holder Columns :: These columns are useful for storing the value in a variable .

Yes. SPECIFIES the mouse CURSOR style. Use this PROPERTY to DYNAMICALLY change the SHAPE of the cursor.

Yes. Specifies the mouse cursor style. Use this property to dynamically change the shape of the cursor.

Specifies the EVENT that will activate the OLE CONTAINING ITEM.

Specifies the event that will activate the OLE containing item.

SPECIFIES WHETHER the WINDOW is a DOCUMENT window or a DIALOG window.

Specifies whether the window is a Document window or a Dialog window.

Yes.

Yes.

Yes.

Yes.

An instance can be started in (or later ALTERED to be in) restricted mode so that when the database is OPEN connections are limited only to those WHOSE user accounts have been granted the RESTRICTED SESSION system privilege.

An instance can be started in (or later altered to be in) restricted mode so that when the database is open connections are limited only to those whose user accounts have been granted the RESTRICTED SESSION system privilege.

ARCHIVED REDO Log CONSISTS of Redo Log files that have archived before being reused.

Archived Redo Log consists of Redo Log files that have archived before being reused.

CLOSE the DATABASE, DISMOUNT the Database and SHUTDOWN the INSTANCE.

Close the Database, Dismount the Database and Shutdown the Instance.

COMPLETE database RECOVERY from disk failure is POSSIBLE only in ARCHIVELOG mode. Online database backup is possible only in ARCHIVELOG mode.

Complete database recovery from disk failure is possible only in ARCHIVELOG mode. Online database backup is possible only in ARCHIVELOG mode.

Exclusive Mode If the FIRST INSTANCE that mounts a database does so in exclusive mode, only that Instance can mount the database.

Parallel Mode If the first instance that mounts a database is STARTED in parallel mode, other instances that are started in parallel mode can ALSO mount the database.

Exclusive Mode If the first instance that mounts a database does so in exclusive mode, only that Instance can mount the database.

Parallel Mode If the first instance that mounts a database is started in parallel mode, other instances that are started in parallel mode can also mount the database.

No.

No.

Start an INSTANCE, Mount the Database and Open the Database.

Rolling forward to recover data that has not been recorded in data files, yet has been recorded in the on-line REDO log, including the contents of ROLLBACK segments. Rolling back transactions that have been explicitly rolled back or have not been committed as INDICATED by the rollback segments REGENERATED in step a. Releasing any resources (locks) held by transactions in process at the time of the failure. Resolving any pending distributed transactions undergoing a two-phase commit at the time of the instance failure.

Start an instance, Mount the Database and Open the Database.

Rolling forward to recover data that has not been recorded in data files, yet has been recorded in the on-line redo log, including the contents of rollback segments. Rolling back transactions that have been explicitly rolled back or have not been committed as indicated by the rollback segments regenerated in step a. Releasing any resources (locks) held by transactions in process at the time of the failure. Resolving any pending distributed transactions undergoing a two-phase commit at the time of the instance failure.

All the default STORAGE PARAMETERS defined for the tablespace can be changed USING the ALTER TABLESPACE command. When objects are CREATED their INITIAL and MINEXTENS values cannot be changed.

All the default storage parameters defined for the tablespace can be changed using the ALTER TABLESPACE command. When objects are created their INITIAL and MINEXTENS values cannot be changed.

The On-line Redo LOG is a set of TWO or more on-line redo FILES that record all committed changes made to the DATABASE. Whenever a transaction is committed, the corresponding redo entries temporarily stores in redo log buffers of the SGA are written to an on-line redo log file by the BACKGROUND process LGWR. The on-line redo log files are used in cyclical fashion.

The On-line Redo Log is a set of two or more on-line redo files that record all committed changes made to the database. Whenever a transaction is committed, the corresponding redo entries temporarily stores in redo log buffers of the SGA are written to an on-line redo log file by the background process LGWR. The on-line redo log files are used in cyclical fashion.

The point at which ORACLE ends writing to one online REDO LOG FILE and begins writing to another is called a log switch.

The point at which ORACLE ends writing to one online redo log file and begins writing to another is called a log switch.

Yes. Change WINDOWS registry(regedit). SET form45_font to the DESIRED FONT.

Yes. Change windows registry(regedit). Set form45_font to the desired font.