Q1. You executed the following command to create a password file in the database server:

$ orapwd file = orapworcl entries = 5 ignorecase=N

Which statement describes the purpose of the above password file?

A. It records usernames and passwords of users when granted the DBA role

B. It contains usernames and passwords of users for whom auditing is enabled

C. It is used by Oracle to authenticate users for remote database administrator

D. It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating groups

View Answer

Q2. SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;

What is the effect of this command?

A. One audit record is created for every successful DROP TABLE command executed in the session of SCOTT

B. One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users

C. One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session

D. One audit record is created for every session of any other user in which a table owned by SCOTT is dropped successfully

E. One audit record is created for every successful DROP TABLE command executed by any user to drop tables owned by SCOTT

View Answer

Q3. You executed the following command to create a tablespace called SALES_DATA:

SQL> CREATE TABLESPACE sales_data

DATAFILE SIZE 100M

SEGMENT SPACE MANAGEMENT AUTO;

Which two statements are true about the SALES_DATA tablespace? (Choose two)

A. The database automatically determines the extent-sizing policy for the tablespace.

B. The segments are automatically shrunk when the contents are removed from them.

C. The allocation of extents within the tablespace is managed through the dictionary tables.

D. The space utilization description of the data blocks in segments is recorded in bitmap blocks.

E. The space utilization description of the data blocks in segments is managed through free lists.

View Answer

Q4. In your database instance, the user sessions are connected to the database server from the remote machines. You want to achieve the following for these users:

1. The user account must be locked after four unsuccessful login attempts.

2. The user must be prompted to change the password at regular intervals.

3. The user may not have more than three simultaneous sessions.

4. The user session must automatically be logged off if more than 10 minutes elapsed time used.

How would you accomplish the above?

A. By assigning profiles for the users

B. By implementing Fine-Grained Auditing (FGA)

C. By granting a secure application role to the users

D. By implementing the Database Resource Manager plan

View Answer

Q5. 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

Q6. View the Exhibit and examine the undo tablespace attributes. Your database instance is experiencing a large volume of transactions from non-DBA users in the last one hour. The undo tablespace NDOTBS1 is full with transactions and no transaction was committed more than one hour ago. The database has two more undo tablespaces.

What happens to the new DML operations in this scenario?

Exhibit:

A. The DML commands will fail

B. The undo data generated by the DML is stored in one of the two other undo tablespace

C. The undo data generated by the DML will overwrite the extents that contain committed undo data

D. The undo data generated by the DML is stored in the SYSTEM undo segment of the SYSTEM tablespace

View Answer

Q7. Examine the following command that is used to create a table:

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

A. A CHECK constraint is created on the OID column

B. A NOT NULL constraint is created on the OID column

C. The ORDERS table is the only object created in the USERS tablespace

D. The ORDERS table and a unique index are created in the USERS tablespace

E. The ORDERS table is created in the USERS tablepsace and a unique index is created on the

OID column in the SYSTEM tablespace

View Answer

Q8. View the Exhibit and examine the initialization parameter settings.

Which three initialization parameters are to be set manually as they are not automatically tuned? (Choose three.)

A. LOG_BUFFER

B. SORT_AREA_SIZE

C. JAVA_POOL_SIZE

D. STREAMS_POOL_SIZE

E. DB_16K_CACHE_SIZE

F. DB_KEEP_CACHE_SIZE

View Answer

Q9. View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view.

After 30 minutes, you executed the following command:

SQL> SELECT reason,metric_value FROM dba_outstanding_alerts; 

REASON                        METRIC_VALUE 

------------------------------                ---------------------- 

Tablespace [TEST] is [28 perce nt] full     28.125 

What could be the reason for the elimination of the other rows in the output?

Exhibit:

A. An Automatic Workload Repository snapshot has been taken recently.

B. The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.

C. The threshold alerts conditions are cleared and the alerts are transferred to BA_ALERT_HISTORY.

D. The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.

View Answer

Q10. Automatic Shared Memory Management (ASMM) has been enabled for your database instance.

The initialization parameters for the components that are managed by ASMM are not set. After observing the effects of ASMM, you executed the following command:

SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;

Which statement is true in this scenario?

A. The minimum memory size for the database buffer cache is set to 100 MB.

B. The maximum memory size that can be obtained by the database buffer cache during ASMM is set to 100 MB.

C. The minimum memory size allocated for a server process in the database buffer cache in dedicated mode is set to 100 MB.

D. The maximum memory size from the database buffer cache that can be released for dynamic distribution during ASMM is set to 100 MB.

View Answer