What strategies are available for backing-up an Oracle database?

Correct Answer: Personal Oracle lite is single user database for distributed and mobile computing It supports a full range of Java database features as well as advanced replication Or in other words it is Oracle's lightweight, fully-functional, single-user object- relational database A small, zero administration embedded database Some of the features supported: - Java Support - Java Store Procedure Support - Java triggers Supported - Multi-column indexing and outer joins - Easy to use graphical user interface - Supports both object and relational database models - Simultaneous viewing of classes and relational tables

Correct Answer: We use SQLPASSTHROUGH options when we need applications to access data both in the front-end and back-end data servers with a single connection SQL statements that cannot be executed in the solidDB front-end server are passed over to the back end SQLPASSTHROUGH mode can be set as per session or per transaction The connection between the front end and back end is made with a back-end compatible ODBC driver which is loaded dynamically in solidDB server

Correct Answer: Oracle HTTP Server is managed by OPMN which stands for Oracle Process Manager and Notification Server With the use of opmnctl utility we can start, stop and restart Oracle HTTP Server If we don?t use this utility the configuration management infrastructure cannot detect or communicate with the Oracle HTTP Server processes, and problems may occur The startproc command for the case of Windows is: ORACLE_HOME\opmn\bin> opmnctl [verbose] startproc ias-component=HTTP_Server To stop Oracle HTTP Server, use the stopproc command: Windows: ORACLE_HOME\opmn\bin> opmnctl [verbose] stopproc ias-component=HTTP_Server

Correct Answer: Oracle HTTP Server is the Web server component of Oracle Database It is based on the Apache HTTP Server It is robust and reliable server due to following features: - Provide high availability infrastructure integration with Oracle Process Manager and Notification Server (OPMN), for process management, death detection and failover for Oracle HTTP Server processes - Provide Dynamic Monitoring Services (DMS) metrics that give runtime performance statistics for Oracle HTTP Server processes - Enable securing of transactions with Secure Sockets Layer (SSL) technology - Execute Perl scripts in the same process as the Oracle HTTP Server, or as CGI script

Correct Answer: Basic Replication : Basic replication is implemented using standard CREATE SNAPSHOT or CREATE MATERIALIZED VIEW statements It can only replicate data and not procedures, indexes replication is always one-way, and snapshot copies are read only Advanced Replication : Advanced replication supports various configurations of updatable snapshot, multi-master and update anywhere replication It is more difficult to configure but allows data and other database objects like indexes and procedures to be replicated Differences between Basic and Advanced replications: - With basic replication, data replicas provide read-only access to the table data whereas advanced replication features extend the capabilities of basic read-only replication by allowing applications to update table replicas throughout a replicated database system - With Basic Replication applications can query data from local data replicas On the other hand with advanced replication, data replicas anywhere in the system can provide both read and update access to a table's data

Correct Answer: - Online backup is one which is taken at the time the database is running in the ARCHIVELOG mode - Following files should be backed up during the Offline Backup: All data file, all control file and all online redo log file But in the case of the online backup following files is backed up: All data files all archived redo log files and one control file via the alter database command - Offline database we cannot rely upon but in case of online database no issues - Offline backup no archived mode is required but in the online backup it is must

Correct Answer: Oracle Web Cache is a secure reverse proxy cache and a compression engine deployed between Browser and HTTP server, Browser and Content Management server to improve the performance of web sites by caching frequently accessed content Oracle Web Cache supports: - Static content caching - Dynamic content caching - Partial Page catching - Request Filtering

Correct Answer: Oracle Spatial, often referred to as spatial, provides a SQL schema and functions that facilitate the storage, retrieval, update, and query of collections of spatial features in an Oracle database Oracle Spatial is designed to make spatial data management easier and more natural to users of location-enabled applications and geographic information system (GIS) applications Once spatial data is stored in an Oracle database, it can be easily manipulated, retrieved, and related to all other data stored in the database

Correct Answer: Oracle Real Application Clusters (RAC) is a software component we can add to a high-availability solution that enables users on multiple machines to access a single database with increased performance RAC comprises two or more Oracle database instances running on two or more clustered machines and accessing a shared storage device via cluster technology To support this architecture, the machines that host the database instances are linked by a high-speed interconnect to form the cluster Oracle RAC offers features in the following areas: - Scalability - Availability - Load balancing - Failover

Correct Answer: Peoplesoft Database is similar to other database which is used to store data Peoplesoft database stores data in a table format for system PeopleTools and Application tables This is independent of the process you use to retrieve that data from PeopleSoft Inside PeopleSoft database, only three types of tables reside inside the schema: System Catalog tables, PeopleTools tables, and Application data tables Two of these table types, System Catalog and PeopleTools tables, can be referred to as metadata tables; users make use of Application data tables to store the data they need for their processes