Q1. You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table:

SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE;

Which two statements are true about the effect of the command? (Choose two.)

A. No flashback is possible to bring back the ITEM table

B. The ORDERS table is dropped along with the ITEM table

C. The dependent referential integrity constraints in the ORDERS table are disabled

D. The dependent referential integrity constraints in the ORDERS table are removed

E. The table definition of the ITEM table and associated indexes are placed in the recycle bin

View Answer

Q2. The database is running in ARCHIVELOG mode. Examine the initialization parameters and their values set to enable archiving on your database server:

Which statement is true regarding the archived redo log files?

A. It will be created on the local file system.

B. It will be created only in the Flash Recovery Area.

C. It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the default location $ORACLE_HOME/dbs.

D. It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and location specified by the DB_RECOVERY_FILE_DEST parameter.

View Answer

Q3. These are points that describe the contents of different memory components:

1: Descriptive information or metadata about schema objects that are queried by using SQL statements

2: The runtime area for data manipulation language (DML) or data definition language (DDL) statements

3: Results of SQL queries and PL/SQL functions

4: Executable forms of SQL cursors, PL/SQL programs, and Java classes

5: The information necessary to reconstruct changes made to the database by a transaction

Which of these will be stored in the Shared Pool if the necessary configurations are done?

A. 1 and 2

B. 2 and 5

C. 1,3, and 4

D. 3,4 and 5

E. 1,2,3 and 4

View Answer

Q4. Examine the values for the following initialization parameters:

FAST_START_MTTR_TARGET=0

LOG_CHECKPOINT_INTERVAL=0

Which two will be the implications of these values in your database? (Choose two.)

A. The SGA advisor will be disabled

B. The MTTR advisor will be disabled

C. Automatic checkpoint tuning will be disabled

D. Checkpoint information will not be written to the alert log file

View Answer

Q5. Which statement describes the effect on an index, when the indexed column for the rows is updated in the base table?

A. An update in a leaf row takes place.

B. The index becomes invalid after the update.

C. The leaf block containing the row to be updated is marked as invalid.

D. A row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted.

View Answer

Q6. You plan to configure the new Oracle Database 11g installation by performing these tasks:

- Use Automatic Storage Management (ASM) as the storage option.

- Use Oracle Enterprise Manager Database Control to manage the database.

- Provide the same password for SYS, SYSTEM, SYSMAN, and DBSNMP accounts during the installation.

- Configure the database to send email notifications.

Some tools available to you for installation are:

1: Oracle Universal Installer (OUI)

2: Database Configuration Assistant (DBCA)

3: Database Upgrade Assistant (DBUA)

4: Oracle Net Configuration Assistant

Which tools would you use for this installation?

A. 2

B. 3

C. 1 and 2

D. 3 and 4

E. 1,2 and 4

View Answer

Q7. Which three statements are correct about temporary tables? (Choose three.)

A. Indexes and views can be created on temporary tables

B. Both the data and structure of temporary tables can be exported

C. Temporary tables are always created in a user's temporary tablespace

D. The data inserted into a temporary table in a session is available to other sessions

E. Data Manipulation Language (DML) locks are never acquired on the data of temporary tables

View Answer

Q8. View the Exhibit. What would happen if Oracle Home is not empty?

A. The installation will not be continued until the location is empty.

B. The installation will proceed without overwriting the existing files.

C. The installation can be continued, but the existing files will be overwritten.

D. The installation terminates automatically after showing an error message.

View Answer

Q9. You executed this command to create a temporary table:

SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (

startdate DATE,

enddate DATE,

class CHAR(20)

) ON COMMIT PRESERVE ROWS;

Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction?

A. The rows stay in the table only until session termination

B. The rows stay in the table only until the next transaction starts on the table

C. The rows are visible to all current sessions after the transaction in committed

D. The rows stay available for subsequent sessions after the transaction is committed

View Answer

Q10. View Exhibit1 and Exhibit2 to examine the current memory allocation and parameter settings, respectively. Why are advisors not available for the shared pool and the buffer cache?

A. because the DB_CACHE_ADVICE parameter is set to OFF

B. because Automatic Memory Management (AMM) is disabled for the database instance

C. because Automatic Shared Memory Management (ASMM) is enabled for the database instance

D. because the values for the DB_CACHE_SIZE and SHARED_POOL_SIZE parameters were not set initially

View Answer