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

Correct 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

Correct 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

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

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: 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: 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

Correct Answer: historical data from legacy systems

Explanation:

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.

Correct Answer: Java is a platform independent language

Correct 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

Correct 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)