Question 1

Explain how to start and stop the Oracle HTTP Server.

Accepted 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

Question 2

What is ODBC SQLPASSTHROUGH option?

Accepted 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

Question 3

What is personal oracle lite?

Accepted 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

Question 4

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

Accepted Answer

The backup strategies that are provided by Oracle are as follows: - Logical backup using Exports and import - Physical file system backup - RMAN Recovery Manger which is also known as incremental files system backup

Question 5

Whar are the Difference between online and offline backups?

Accepted 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

Question 6

What is the Oracle Web Cache?

Accepted 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

Question 7

What is Oracle Spatial?

Accepted 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

Question 8

What is RAC and how is it different from non RAC databases?

Accepted 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

Question 9

What is a PeopleSoft database?

Accepted 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

Question 10

How does the PeopleSoft database interact with the Oracle?

Accepted Answer

A Peoplesoft database is expression which point out a database containing Peoplesoft objects For Oracle and only for Oracle, Peoplesoft consists in 3 schemas namely: - PS (PSDBOWNER table owner), - PEOPLE (for connection checking) and - SYSADM (by default), the last one contains all the objects/data One of the database objects is connected with single Oracle schema, and all processes that connect to the database use the standard PSFT login procedure PSFT login is used because to refer to the collection of tables in the administrative schema within an Oracle database Every process that makes a 2-tier connection to the database identifies itself with a PSFT user or operator ID Hence the interaction goes

Question 11

What is locking ? what are the advantages of locking?

Accepted Answer

Locking is a mechanism to ensure data integrity while allowing maximum concurrent access to data It is used to implement concurrency control when multiple users access table to manipulate its data at the same time Advantages : - Avoids deadlock conditions - Avoids clashes in capturing the resources

Question 12

Explain how to lock and unlock a user account in Oracle.

Accepted Answer

SQL> ALTER USER user_name ACCOUNT LOCK; SQL> ALTER USER user_name ACCOUNT UNLOCK;

Question 13

What is a shared pool?

Accepted Answer

Shared pool in oracle contains cache information that collects, parses, interprets and executes SQL statements that goes against database This shared pool acts like a buffer for these SQL statements

Question 14

A data warehouse is composed of

Accepted Answer

A data warehouse is a relational database that is designed for query and analysis rather than transaction processing. It usually contains historical data that is derived from transaction data, but it can include data from other sources. Data warehouses are designed to help you analyze your data.

Question 15

What is the most important feature of Java?

Accepted Answer

Java is a platform independent language

Question 16

What is the difference between a JDK and a JVM?

Accepted Answer

JDK is Java Development Kit which is for development purpose and it includes execution environment also JVM is Java Virtual Machine which is a run time environment for the compiled java class files Hence you will not be able to compile your source files using a JVM

Question 17

What do you mean by platform independence?

Accepted Answer

Platform independence means that we can write and compile the java code in one platform (Eg Windows) and can execute the class in any other supported platform (Eg Linux,Solaris,etc)

Question 18

What are instance variables?

Accepted Answer

Instance variables are those which are defined at the class level Instance variables need not be initialized before using them as they are automatically initialized to their default values

Question 19

Does Java support multiple inheritance?

Accepted Answer

Java doesn't support multiple inheritance

Question 20

Are arrays primitive data types?

Accepted Answer

In Java, Arrays are objects

Technology Questions