Introducing The New!
Surepassexam Collection
Get Unlimited Access to all
Surepassexam's PREMIUM files
Q1. Your database instance is started using the server parameter file (SPFILE). You executed a
command to change the value of the LOG_BUFFER initialization parameter:
ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH;
What would be the outcome of this command?
A. The command succeeds only if Automatic Memory Management is not enabled.
B. The command succeeds, but you need to restart the database for changes to take effect.
C. The command returns an error because the size of the redo log buffer cannot be changed dynamically.
D. The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area (SGA).
Answer: C
Q2. Which statement is true about loading data using the conventional path of SQL*Loader?
A. Redo is not generated while performing conventional path loads
B. Only PRIMARY KEY, UNIQUE KEY and NOT NULL constraints are checked
C. No exclusive locks are acquired when the conventional path loads are performed
D. Instead of performing transactions, SQL*Loader directly writes data blocks to the data files
E. INSERT triggers are disabled before the conventional path load and reenabled at the end of the load
Answer: C
Q3. 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
Q4. 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.
Answer: AD
Q5. Which two statements describe good practices for an application developer to reduce locking conflicts in Oracle database? (Choose two.)
A. Avoid coding unnecessary longrunning transactions.
B. Allow the database to handle locks in default locking mode.
C. Always explicitly code the locks as per the requirement of the application.
D. Allow escalation of row locks to block locks if too many row locks cause problem.
Answer: AB
Q6. Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode?
Exhibit:
A. The backup will consist of used data blocks only.
B. The database must be shut down to accomplish the backup.
C. The backup can be accomplished without shutting down the database.
D. The backup will contain all database files that have never been backed up.
Answer: B
Q7. Note the following points describing various utilities in Oracle Database 11g:
Which point describes the Oracle Data Pump utility?
1. It enables the transfer of data from one database to another
2. It provides a complete solution for the backup, restoration and recovery needs of the entire database
3. It enables the loading of data from an external file into tables of an Oracle Database
4. It provides a tape backup management for the Oracle ecosystem
A. 1
B. 2
C. 3
D. 4
E. 1 and 3
F. 1, 2, 3 and 4
Answer: A
Q8. View the Exhibit to examine the details for an incident.
Which statement is true regarding the status of the incident?
A. The DBA is working on the incident and prefers that the incident be kept in the ADR
B. The incident is now in the Done state and the ADR can select the incident to be purged
C. The incident has been newly created and is in the process of collecting diagnostic information
D. The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support
Answer: D
Q9. Which two activities are NOT supported by the Data Recovery Advisor (DRA)? (Choose two.)
A. Recover from failures in the RAC environment.
B. Diagnose and repair a data file corruption online.
C. Diagnose and repair a data file corruption offline.
D. Diagnose and repair failures on a standby database.
Answer: AD
Q10. All the database users are presently connected to the database instance and working. The HR user has opened three database sessions and executed the following command in one of his sessions:
SQL> UPDATE persons SET ccode='U031' WHERE ccode='U029'
123 rows updated.
SQL> DELETE FROM persons WHERE exp='Y'
3 rows deleted.
The SYS user opens a new session after HR executed the above commands.
Which sessions can see the effect of the UPDATE and DELETE commands?
A. All sessions of the HR user only
B. All sessions of the HR user and the SYS user
C. The session of the HR user that executed the commands
D. All the sessions for which the database users have access privilege to the PERSONS table
Answer: C
Q11. See the Exhibit to observe the roles assigned to the SL_REP user.
Which statement is true about the assignment of the SELECT_CATALOG_ROLE role to the SL_REP user?
A. The user must enable the role explicitly
B. The user can grant the role to other users
C. The user cannot user the role until the DBA enables it explicitly
D. The user can start using the role immediately without any changes
Answer: A
Q12. View the Exhibit and examine the output of the query.
What do you infer from this?
A. The SGA_TARGET is a static parameter.
B. The instance is started, but the database is not yet open.
C. The server parameter file (SPFILE) was used to start the instance.
D. The SGA_TARGET parameter does not have any effect on the database instance until the SGA_MAX_SIZE parameter is specified.
Answer: C
Q13. You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOG mode.
Which two statements are true in this scenario? (Choose two.)
A. You must shut down the database instance to perform the backups.
B. You must configure the Flash Recovery Area (FRA) for the database.
C. You can perform complete database backups without closing the database.
D. All the previous closed database backups including control files become invalid afteryou configure the database to ARCHIVELOG mode.
Answer: CD
Q14. You are using Enterprise Manager to schedule backups for your database.
Which type of script would be generated by the backup scheduler?
A. XML script
B. PL/SQL script
C. Operating system script
D. Recovery Manager (RMAN) script
Answer: D
Q15. 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
Answer: A