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: SQL> ALTER USER user_name ACCOUNT LOCK; SQL> ALTER USER user_name ACCOUNT UNLOCK;

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)

Correct 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

Correct Answer: Java doesn't support multiple inheritance

Correct Answer: In Java, Arrays are objects