Oracle Database Fundamentals
Questions about Oracle RDBMS architecture, processes, and distributed database features
Questions
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?
- Oracle database
- Oracle instance
- Control files
- Schema objects
- Shared pool
Which of the following areas in Oracle is used for database information shared by the users?
- Program Global Area
- Server processes
- Background processes
- System Global Area
- Private Global Area
Which of the following objects in Oracle is the named object that establishes paths from one database to another?
- Cluster
- Synonyms
- Program units
- Database links
- Sequence
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?
- DDL statements
- DML statements
- Session control statements
- Transaction control statements
- System control statements
Which of the following commands in Oracle is used to return the value TRUE if the cursor is already open?
- %ISOPEN
- %FOUND
- %NOTFOUND
- %ROWCOUNT
- %LIKE
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?
- Naming conflicts
- Type conflicts
- Domain conflicts
- Error conflicts
- Execution conflicts
Which of the following strategies in the schema design of Oracle focuses on a central set of concepts that are most evident?
- Top-down strategy
- Bottom-up strategy
- Inside-out strategy
- Mixed strategy
- Single strategy
Which of the following system files ensures that all the database files are consistent and perform recovery?
- Log Writer
- SMON
- Checkpoint
- Recoverer
- Archiver
Which of the following database link connections in the current session lists all open database links in your session, along with their corresponding instances?
- V$DBLINK
- OWNER_ID
- LOGGED_ON
- GV$DBLINK
- DB_LINK
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?
- Commit phase
- Prepare phase
- Forget phase
- Prepared phase
- Abort phase
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?
- SQLJ
- JDBC
- Java Stored Procedures
- CORBA or EJB
- Servlets or JavaServer
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?
- Distributed Query Optimization
- Client/Server Environment
- Homogeneous Distributed Environment
- Remote Procedure Calls
- Heterogeneous Distributed Environment
Which of the following transactions contains one or more remote statements, all of which refer to a single remote node?
- Distributed transaction
- Remote transaction
- Distributed query
- Remote query
- Online query
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?
- Business metadata
- Operational metadata
- Technical metadata
- Hybrid metadata
- Target 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?
- Informatics
- Oracle 10g warehouse builder
- SAS (Statistical Analysis System)
- MySAP business intelligence
- Data profiling