Which of the following in Oracle includes the Oracle system processes and user processes taken together, created for a specific instance of the database operation?

Which of the following areas in Oracle is used for database information shared by the users?

Which of the following objects in Oracle is the named object that establishes paths from one database to another?

Which of the following statements in Oracle allows users to control the properties of their current session by enabling or disabling roles of users and changing language settings?

Which of the following commands in Oracle is used to return the value TRUE if the cursor is already open?

Which of the following types of conflicts may arise in Oracle when EMPLOYEE may be an entity type in one schema and an attribute in another?

Which of the following strategies in the schema design of Oracle focuses on a central set of concepts that are most evident?

Which of the following system files ensures that all the database files are consistent and perform recovery?

Which of the following database link connections in the current session lists all open database links in your session, along with their corresponding instances?

Which of the following phases in Oracle is said to be the node, which after receiving notice from the global coordinator that all nodes have committed, erases status information about this transaction from the commit site?

Which one of the following Java API's is to be used to invoke a static, simple SQL statement from a known table with known column names from a Java object?

Which of the following features in distributed database is the one which allows the NLS (Natural Language Support) settings of the client, the transparency gateway and the non-Oracle data source to be either the same or a subset of the Oracle database server?

Which of the following transactions contains one or more remote statements, all of which refer to a single remote node?

Which of the following metadata in DBMS is concerned with the information system characteristics that include ETL process metadata, back room metadata and transformation metadata?

Which of the following data quality tools used in data warehouse provides a single environment that seamlessly integrates data quality within the data integration process?