Q1. 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
Answer: BD
Q2. In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC.
What is the impact of this setting?
A. Optimizer statistics are collected automatically.
B. Only timed operating system (OS) statistics and plan execution statistics are collected.
C. The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.
D. Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.
E. The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
Answer: C
Q3. A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable the constraint that was disabled.
What are the two effects of this command? (Choose two.)
A. It fails if any existing row violates the constraint.
B. It does not validate the existing data in the table.
C. It enables the constraint to be enforced at the end of each transaction.
D. It prevents insert, update, and delete operations on the table while the constraint is in the process of being enabled.
Answer: AD
Q4. Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not enabled?
A. It is the time period after which the undo data becomes obsolete.
B. It is the time period after which the committed undo data would be transferred to a temporary tablespace.
C. It is the minimum time period up to which the committed undo data would be retained if free undo space is available.
D. It is the time period after which the undo data is transferred to the Flash Recovery Area to provide read consistency.
Answer: C
Q5. Which two statements are true regarding Oracle Data Pump? (Choose two.)
A. EXPDP and IMPDP are the client components of Oracle Data Pump
B. DBMS_DATAPUMP PL/SQL packages can be used indedendently of the DATA Pump clients
C. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege
D. Oracle Data Pump imports can be done from the export files generated in the Original Export Release 9.x
E. EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands
Answer: AB
Q6. Which two statements are true about alerts? (Choose two.)
A. Clearing an alert sends the alert to the alert history
B. Response actions cannot be specified with server-generated alerts
C. The nonthreshold alerts appear in the DBA_OUTSTANDING_ALERTS view
D. Server-generated alerts notify the problems that cannot be resolved automatically and require administrators to be notified
Answer: AD
Q7. You used the IMMEDIATE option to shutdown your database instance. Consider the steps that will be performed later when you open the database:
1. SGA is allocated.
2. Control file is read.
3. Redo log files are read.
4. Instance recovery is started.
5. Background processes are started.
6. Data files are checked for consistency.
7. Server parameter file or the initialization parameter file is read.
Which option has the correct order in which these steps occur?
A. 7, 1, 5, 2, 3, 6, 4
B. 1, 5, 7, 2, 3, 6; step 4 is not required
C. 7, 1, 5, 2, 3, 6 step 4 is not required
D. 1, 2, 3, 5, 6, 4; step 7 is not required
Answer: C
Q8. In a new installation of Oracle Database 11g, you perform these activities:
1. Organize software and data on different subdirectories to avoid poor performance.
2. Use consistent naming conventions for database files.
3. Separate administrative information pertaining to the database in different directories.
Which option corresponds to the type of activities you performed?
A. Oracle Managed Files
B. Oracle Grid Architecture
C. Optimal Flexible Architecture
D. Oracle database architecture
E. Automatic Storage Management
Answer: C
Q9. Identify two situations in which the block header grows in a data block. (Choose two.)
A. When row directories need more row entries
B. When there is row migration in the data block
C. When there is an increase in the PCTFREE value for the data block
D. When more transaction slots are required than are initially configured
Answer: AD
Q10. A database user SMITH tries to query the V$SESSION view and fails to access it as follows:
Which are the two possible solutions to enable SMITH to query the data in V$SESSION? (Choose two.)
A. granting SELECT privilege to SMITH on V$SESSION
B. granting SELECT privilege to SMITH on V_$SESSION
C. asking the user SMITH to run the catalog.sql script
D. granting SELECT privilege to SMITH on V$FIXED_TABLES
E. setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE
F. creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created
Answer: BF