Explore topic-wise InterviewSolutions in .

OMB Plus is a scripting language used to manipulate OBJECT and runtime repositories of OWB. OMB Plus is an EXTENSION TCL Programming language and hence has variable CONSTRUCTS, looping and control STRUCTURES.

OMB Plus is a scripting language used to manipulate object and runtime repositories of OWB. OMB Plus is an extension TCL Programming language and hence has variable constructs, looping and control structures.

OMB plus is a flexible, high-level command line METADATA ACCESS tool for Oracle Warehouse BUILDER. We USE OMB Plus to create, modify, delete, and retrieve object metadata in Warehouse Builder design and RUNTIME repositories.

OMB plus is a flexible, high-level command line metadata access tool for Oracle Warehouse Builder. We use OMB Plus to create, modify, delete, and retrieve object metadata in Warehouse Builder design and runtime repositories.

ORACLE Warehouse Builder(OWB) is composed of DESIGN CENTRE, Control center MANAGER, target SCHEMA, Warehouse builder repository, Repository browser, control center service.

Oracle Warehouse Builder(OWB) is composed of Design centre, Control center manager, target schema, Warehouse builder repository, Repository browser, control center service.

Oracle WAREHOUSE Builder (OWB) is an information integration tool that leverages the Oracle Database to TRANSFORM data into high-quality information. The Oracle Database is a CENTRAL COMPONENT in the Warehouse Builder architecture because the Database hosts the Warehouse Builder repository and the CODE generated by Warehouse Builder.

Oracle Warehouse Builder (OWB) is an information integration tool that leverages the Oracle Database to transform data into high-quality information. The Oracle Database is a central component in the Warehouse Builder architecture because the Database hosts the Warehouse Builder repository and the code generated by Warehouse Builder.

An ULTRA Search INSTANCE can be CREATED to provide isolation for the data collections that have been crawled.We can create a read-only SNAPSHOT of a master ORACLE Ultra Search instance. This is useful for query processing or for backup.We can also make a snapshot instance updatable. This is useful when the master instance is corrupted and we want to use a snapshot as a new master instance.

An Ultra Search instance can be created to provide isolation for the data collections that have been crawled.We can create a read-only snapshot of a master Oracle Ultra Search instance. This is useful for query processing or for backup.We can also make a snapshot instance updatable. This is useful when the master instance is corrupted and we want to use a snapshot as a new master instance.

Oracle Ultra Search provides the following APIs:
1) The query API works with indexed data. The Java API does not impose any HTML rendering elements. The application can completely customize the HTML interface.
2) The crawler agent API crawls and indexes proprietary document repositories. The e-mail Java API accesses archived e-mails and is used by the query application to display e-mails. It can also be used to BUILD our own custom query application.
3) The URL rewriter API is used by the crawler to filter and rewrite extracted URL links before they are inserted into the URL QUEUE.
4) The Document Service crawler agent API enables GENERATION of attribute data based on the document contents. It accepts robot metatag instructions from the agent for the target document, and it TRANSFORMS the original document contents for indexing control.

Oracle Ultra Search provides the following APIs:
1) The query API works with indexed data. The Java API does not impose any HTML rendering elements. The application can completely customize the HTML interface.
2) The crawler agent API crawls and indexes proprietary document repositories. The e-mail Java API accesses archived e-mails and is used by the query application to display e-mails. It can also be used to build our own custom query application.
3) The URL rewriter API is used by the crawler to filter and rewrite extracted URL links before they are inserted into the URL queue.
4) The Document Service crawler agent API enables generation of attribute data based on the document contents. It accepts robot metatag instructions from the agent for the target document, and it transforms the original document contents for indexing control.

The ADMINISTRATION tool is independent from the Oracle Ultra SEARCH query APPLICATION. THEREFORE, the administration tool and query application can be hosted on different computers to enhance security and scalability.

The administration tool is independent from the Oracle Ultra Search query application. Therefore, the administration tool and query application can be hosted on different computers to enhance security and scalability.

Oracle Ultra Search includes highly functional query APPLICATIONS to query and display search RESULTS. The query applications are BASED on JSP and work with any JSP1.1 compliant engine.

Oracle Ultra Search includes highly functional query applications to query and display search results. The query applications are based on JSP and work with any JSP1.1 compliant engine.

The administration tool is a J2EE-compliant WEB application. We can use it to manage ORACLE Ultra SEARCH INSTANCES and access it from the intranet.

The administration tool is a J2EE-compliant Web application. We can use it to manage Oracle Ultra Search instances and access it from the intranet.

In the Oracle DATABASE release, the Oracle Ultra Search middle tier and back END can reside in the same Oracle Home. However, in the OracleAS and Oracle COLLABORATION Suite releases, the middle tier is located in a different Oracle Home.

In the Oracle Database release, the Oracle Ultra Search middle tier and back end can reside in the same Oracle Home. However, in the OracleAS and Oracle Collaboration Suite releases, the middle tier is located in a different Oracle Home.

The Oracle ULTRA Search middle tier components are WEB applications. The middle tier INCLUDES the Oracle Ultra Search ADMINISTRATION tool, the APIS and the query applications.

The Oracle Ultra Search middle tier components are Web applications. The middle tier includes the Oracle Ultra Search administration tool, the APIs and the query applications.

The Oracle Ultra Search back end consists of an Oracle Ultra Search repository and Oracle TEXT. Oracle Text provides text indexing and search CAPABILITIES required to index and query data retrieved from the data sources. The back end INDEXES information from the CRAWLER and SERVES up the query results.

The Oracle Ultra Search back end consists of an Oracle Ultra Search repository and Oracle Text. Oracle Text provides text indexing and search capabilities required to index and query data retrieved from the data sources. The back end indexes information from the crawler and serves up the query results.

The Oracle Ultra Search crawler is a Java process activated by the Oracle server based on a a set SCHEDULE. When activated, the crawler SPAWNS a configurable number of processor threads that FETCH documents from various data sources and index them USING Oracle Text. This index is used for querying. Data sources can be Web sites,database tables, files, mailing lists, Oracle Application Server Portal PAGE groups, or user-defined data sources.

The Oracle Ultra Search crawler is a Java process activated by the Oracle server based on a a set schedule. When activated, the crawler spawns a configurable number of processor threads that fetch documents from various data sources and index them using Oracle Text. This index is used for querying. Data sources can be Web sites,database tables, files, mailing lists, Oracle Application Server Portal page groups, or user-defined data sources.

Oracle ultra search is MADE of the following components:
1) Oracle Ultra search crawler
2) Oracle Ultrasearch BACKEND
3) Oracle Ultra search middle tier.

Oracle ultra search is made of the following components:
1) Oracle Ultra search crawler
2) Oracle Ultrasearch backend
3) Oracle Ultra search middle tier.

Oracle Ultra Search is built on the Oracle DATABASE and Oracle Text technology that provides uniform search-and-location capabilities over multiple repositories such as, Oracle databases, other ODBC compliant databases, IMAP mail servers, HTML documents served up by a Web server, FILES on DISK, and more.

Oracle Ultra Search is built on the Oracle Database and Oracle Text technology that provides uniform search-and-location capabilities over multiple repositories such as, Oracle databases, other ODBC compliant databases, IMAP mail servers, HTML documents served up by a Web server, files on disk, and more.

ORACLE Database Vault PL/SQL Interfaces and PACKAGES are collections that allow SECURITY managers, application developers to configure security POLICY. The PL/SQL procedures and functions allow general database accounts to operate within the boundaries of the access control policy in the CONTEXT of a given database session.

Oracle Database Vault PL/SQL Interfaces and Packages are collections that allow security managers, application developers to configure security policy. The PL/SQL procedures and functions allow general database accounts to operate within the boundaries of the access control policy in the context of a given database session.

The DVF schema contains public FUNCTIONS to retrieve (at RUN time) the factor values SET in the Oracle Database Vault access CONTROL configuration.

The DVF schema contains public functions to retrieve (at run time) the factor values set in the Oracle Database Vault access control configuration.

DVSYS SCHEMA STORES objects needed to process Oracle data for Oracle DATABASE vault. This schema contains the roles, VIEWS, accounts, functions, and other database objects that the Oracle Database Vault uses.

DVSYS schema stores objects needed to process Oracle data for Oracle database vault. This schema contains the roles, views, accounts, functions, and other database objects that the Oracle Database Vault uses.

TWO MAJOR schemas of ORACLE DATABASE vault are DVSYS and DVF.

Two major schemas of oracle database vault are DVSYS and DVF.

It is a command-line utility that is USED to PERFORM maintenance tasks on Oracle Database VAULT Installation.

It is a command-line utility that is used to perform maintenance tasks on Oracle Database Vault Installation.

1) DVA allows SECURITY managers who may not be proficient in PL/SQL to CONFIGURE the access control policy through a user-friendly INTERFACE.
2) Oracle Database Vault ADMINISTRATOR provides an extensive collection of security-related reports that assist in understanding the baseline security configuration.
3) These reports help to point out deviations from this baseline.

1) DVA allows security managers who may not be proficient in PL/SQL to configure the access control policy through a user-friendly interface.
2) Oracle Database Vault Administrator provides an extensive collection of security-related reports that assist in understanding the baseline security configuration.
3) These reports help to point out deviations from this baseline.

Oracle DATABASE VAULT ADMINISTRATOR(DVA) is a Java APPLICATION that is built on top of the Oracle Database Vault PL/SQL application programming interfaces (API).

Oracle Database Vault Administrator(DVA) is a Java application that is built on top of the Oracle Database Vault PL/SQL application programming interfaces (API).

1) Create a realm COMPOSED of the database schemas or database objects that we WANT to secure.
2) We can further secure the realm by creating rules, command rules, factors, identities, rule sets, and secure application roles.
3) We can run reports on the activities these components monitor and protect.

1) Create a realm composed of the database schemas or database objects that we want to secure.
2) We can further secure the realm by creating rules, command rules, factors, identities, rule sets, and secure application roles.
3) We can run reports on the activities these components monitor and protect.

A SECURE APPLICATION ROLE is a special Oracle Database role that can be enabled based on the evaluation of an Oracle Database VAULT RULE set.

A secure application role is a special Oracle Database role that can be enabled based on the evaluation of an Oracle Database Vault rule set.

We can have the same RULE in MULTIPLE rule SETS.

We can have the same rule in multiple rule sets.

The rule within a rule set is a PL/SQL expression that EVALUATES to TRUE or FALSE.

The rule within a rule set is a PL/SQL expression that evaluates to true or false.

The RULE SET evaluates to true or false based on the evaluation of each rule it CONTAINS and the evaluation TYPE (All True or Any True).

The rule set evaluates to true or false based on the evaluation of each rule it contains and the evaluation type (All True or Any True).

A rule set is a collection of one or more rules that we can associate with a REALM authorization, COMMAND rule, factor assignment, or secure APPLICATION role.

A rule set is a collection of one or more rules that we can associate with a realm authorization, command rule, factor assignment, or secure application role.

Each FACTOR can have one or more identities. An identitiy is the actual VALUE of a factor. A factor can have SEVERAL identities depending on the factor retrieval method or its identity MAPPING LOGIC.

Each factor can have one or more identities. An identitiy is the actual value of a factor. A factor can have several identities depending on the factor retrieval method or its identity mapping logic.

We can use factors for activities such as AUTHORIZING database ACCOUNTS to connect to the database or creating filter logic to restrict the VISIBILITY and MANAGEABILITY of data.

We can use factors for activities such as authorizing database accounts to connect to the database or creating filter logic to restrict the visibility and manageability of data.

A factor is a NAMED variable or a attribute such as user location, database IP address, or session user, which ORACLE database VAULT can recognize and SECURE.

A factor is a named variable or a attribute such as user location, database IP address, or session user, which oracle database vault can recognize and secure.

No. They WORK with rule sets to determine whether or not a STATEMENT is ALLOWED.

No. They work with rule sets to determine whether or not a statement is allowed.

A command RULE is a special rule created to CONTROL how users can execute almost any SQL statement. This includes SELECT, ALTER SYSTEM, DDL and DML statements.

A command rule is a special rule created to control how users can execute almost any SQL statement. This includes SELECT, ALTER SYSTEM, DDL and DML statements.

A realm is a functional grouping of database SCHEMAS,objects and roles that must be secured.After grouping we can USE realms to control the use of SYSTEM privileges to specific ACCOUNTS or roles. This provides fine-grained access control.

A realm is a functional grouping of database schemas,objects and roles that must be secured.After grouping we can use realms to control the use of system privileges to specific accounts or roles. This provides fine-grained access control.

It is formed of the following components that helps US manage security for the database instance. They are:
1)REALMS
2)Command Rules
3) Factors
4) Rule sets
5) Security APPLICATION ROLES.

It is formed of the following components that helps us manage security for the database instance. They are:
1)Realms
2)Command Rules
3) Factors
4) Rule sets
5) Security Application roles.

Oracle Database VAULT has the following components:
1) Oracle Database Vault Access Control Components
2) Oracle Database Vault Administrator (DVA)
3) Oracle Database Vault Configuration Assistant (DVCA)
4) Oracle Database Vault DVSYS and DVF Schemas
5) Oracle Database Vault PL/SQL INTERFACES and Packages
6) Oracle Database Vault and Oracle Label Security PL/SQL APIs
7) Oracle Database Vault Reporting and Monitoring Tools.

Oracle Database Vault has the following components:
1) Oracle Database Vault Access Control Components
2) Oracle Database Vault Administrator (DVA)
3) Oracle Database Vault Configuration Assistant (DVCA)
4) Oracle Database Vault DVSYS and DVF Schemas
5) Oracle Database Vault PL/SQL Interfaces and Packages
6) Oracle Database Vault and Oracle Label Security PL/SQL APIs
7) Oracle Database Vault Reporting and Monitoring Tools.

Oracle DATABASE Vault can be used to protect STANDALONE database instance, Oracle Real Application CLUSTER(RAC).

Oracle Database Vault can be used to protect standalone database instance, Oracle Real Application Cluster(RAC).

Oracle Database VAULT is a SECURITY solution from oracle corporation. It restricts access to CERTAIN areas of the database.Even users with administrative PRIVILEGES have restricted access. This fine-grained access CONTROL protects the database from super-privileged users.

Oracle Database Vault is a security solution from oracle corporation. It restricts access to certain areas of the database.Even users with administrative privileges have restricted access. This fine-grained access control protects the database from super-privileged users.

It is an element of database resource MANAGER. It LINKS a resource plan to a SPECIFIC resource CONSUMER group.

It is an element of database resource manager. It links a resource plan to a specific resource consumer group.

It is a TYPE of RESOURCE allocation METHOD.We can use this method to specify the limit of the DEGREE of PARALLELISM for an operation.

It is a type of resource allocation method.We can use this method to specify the limit of the degree of parallelism for an operation.

It is a type of resource allocation method. By USING CANCEL_SQL or KILL_SESSION as the switch group, we can direct a long-running SQL sement or even an ENTIRE session to be CANCELLED or TERMINATED.

It is a type of resource allocation method. By using CANCEL_SQL or KILL_SESSION as the switch group, we can direct a long-running SQL sement or even an entire session to be cancelled or terminated.

It is a type of resource allocation method. Using this method, we can specify that a user session be automatically SWITCHED to a different group after it RUNS more than a specified NUMBER of seconds. The group that the session should switch to is called as switch group,and the time LIMIT is the switch time. The session can revert to its original CONSUMER group after e end of the top call, whih is defined as an entire PL/SQL block or a seperate SQL statement.

It is a type of resource allocation method. Using this method, we can specify that a user session be automatically switched to a different group after it runs more than a specified number of seconds. The group that the session should switch to is called as switch group,and the time limit is the switch time. The session can revert to its original consumer group after e end of the top call, whih is defined as an entire PL/SQL block or a seperate SQL statement.

It is a type of resource allocation method. We can set a MAXIMUM allowable number of CONCURRENT SESSIONS with in any consumer resource group.All sessions that are beyond the maximum limit are queued for execution after the freeing up of CURRENT active sessions.

It is a type of resource allocation method. We can set a maximum allowable number of concurrent sessions with in any consumer resource group.All sessions that are beyond the maximum limit are queued for execution after the freeing up of current active sessions.

It is a type of RESOURCE allocation method. By setting an UNDO pool directive, we can limit the total AMOUNT of undos that can be generated by a consumer resource GROUP.

It is a type of resource allocation method. By setting an undo pool directive, we can limit the total amount of undos that can be generated by a consumer resource group.

It is a type of RESOURCE allocation method.We can CONTROL resource usageby setting a LIMIT on the MAXIMUM execution time of an OPRATION.

It is a type of resource allocation method.We can control resource usageby setting a limit on the maximum execution time of an opration.

It is a type of RESOURCE ALLOCATION method.We can direct that a user's session be terminated after it has been idle for a specified period of time.We can ALSO SPECIFY that only idle sessions blocking other sessions be terminated.

It is a type of resource allocation method.We can direct that a user's session be terminated after it has been idle for a specified period of time.We can also specify that only idle sessions blocking other sessions be terminated.

Oracle USES MULTIPLE levels of CPU allocation to prioritize and ALLOCATE CPU usage among the competing USER sessions.It is a type of RESOURCE allocation method.

Oracle uses multiple levels of CPU allocation to prioritize and allocate CPU usage among the competing user sessions.It is a type of resource allocation method.

The resource allocation method indictates the specific method we choose to use to allocate RESOURCES like the CPU.The available methods of allocating the DATABASE resources are CPU method, Idle time, Execution time limit, Undo pool, Active session pool, automatic consumer group switching, canelling SQL and terminating sessions, parallel DEGREE limit.

The resource allocation method indictates the specific method we choose to use to allocate resources like the CPU.The available methods of allocating the database resources are CPU method, Idle time, Execution time limit, Undo pool, Active session pool, automatic consumer group switching, canelling SQL and terminating sessions, parallel degree limit.

A subplan is a PART of the resource plan that ENABLES the ALLOCATION of resources in GREATER detailamong the resource consumer groups.

A subplan is a part of the resource plan that enables the allocation of resources in greater detailamong the resource consumer groups.

The resource plan lays how resource consumer groups are ALLOCATED resources. Each resource plan contains a set of resource consumer groups that belong to this plan, TOGETHER with INSTRUCTIONS as to how resources are to be allocated among these groups.

For instance,a resource plan may dictate CPU resources be allocated among THREE resource consumer groups so that the first group gets 60 percent and the remaining two groups get 20 percent each of the TOTAL CPU time.

The resource plan lays how resource consumer groups are allocated resources. Each resource plan contains a set of resource consumer groups that belong to this plan, together with instructions as to how resources are to be allocated among these groups.

For instance,a resource plan may dictate CPU resources be allocated among three resource consumer groups so that the first group gets 60 percent and the remaining two groups get 20 percent each of the total CPU time.