Q1. View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hour that performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives the following error:
ORA-01555: snapshot too old What could be the reason for this error?
Exhibit:
A. The query is unable to get a read-consistent image.
B. There is not enough space in Flash Recovery Area.
C. There is not enough free space in the flashback archive.
D. The query is unable to place data blocks in undo tablespace.
Answer: A
Q2. You are working on a new Oracle Database 11g server, where only the software is installed and no database is created. You plan to create a database on this server using the Database Configuration Assistant (DBCA).
Some of the requirements set for your database creation task are:
1. Configure the database to operate in shared server mode.
2. Disable automatic maintenance tasks such as optimizer statistics collection.
3. Configure a naming method to help the remote user connect to the database instance.
4. Use Automatic Storage Management (ASM) for storing the database files.
5. Configure daily database backup to flash recovery area.
6. Configure Enterprise Manager Database Control to manage the database.
Which of these requirements can be met while creating the database?
A. 4 and 6
B. 2, 3, 4, and 6
C. 1, 2, 4, 5, and 6
D. 1, 2, 3, 4, 5, and 6
Answer: C
Q3. The instance abnormally terminates because of a power outage.
Which statement is true about redo log files during instance recovery?
A. Inactive and current redo log files are required to accomplish recovery
B. Online and archived redo files are required to accomplish instance recovery
C. All redo log entries after the last checkpoint are applied from redo log files to data files
D. All redo log entries recorded in the current log file until the checkpoint position are applied to data files
Answer: C
Q4. Your database instance is running with full workload after database creation. You have decided to use a fixedsize undo tablespace. You want to use the undo Advisor to estimate the capacity of the undo tablespace.
Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undo tablespace? (Choose two.)
A. The retention period to support flashback
B. The expected length of the longest-running query
C. The number of undo tablespaces in the database
D. The size of the Flash Recovery Area for the database instance
Answer: AB
Q5. Which two statements are true regarding a PL/SQL package body? (Choose two.)
A. It cannot be created without a package specification.
B. It cannot invoke subprograms defined in other packages.
C. It can contain only the subprograms defined in the package specification.
D. It can be changed and recompiled without making the package specification invalid.
Answer: AD
Q6. Given below is a list of scenarios:
1. A user terminates his session abnormally.
2. The connection between the server and the client application terminates because of a network failure.
3. A schema is accidentally dropped.
4. The tablespace is accidentally dropped from the database.
5. The hard disk gets corrupted and the data files in the disk are lost.
6. The database instance abnormally shuts down because of power failure.
Which scenarios require DBA intervention to perform recovery?
A. 1, 3, and 6
B. 4, 5, and 6
C. 3, 4, and 5
D. 1, 2, and 6
Answer: C
Q7. You execute the following command to change the status of the SALES tablespace:
SQL> ALTER TABLESPACE sales OFFLINE;
Which statements describe the effect of the command? (Choose all that apply.)
A. The tablespace would require recovery to go back online.
B. A checkpoint is taken on all data files that are associated with the SALES tablespace.
C. The sessions that subsequently try to access the objects in the SALES tablespace receivean error.
D. The new status of the SALES tablespace is recorded in the control file when the database instance is closed.
Answer: BC
Q8. You want to configure and schedule offline database backups to run automatically.
Which tool or utility would you use to achieve this?
A. The XML script
B. The PL/SQL script
C. The DBMS_SCHEDULER package
D. Enterprise Manager to schedule the backup
Answer: D
Q9. The database instance is currently using SPFILE. View the Exhibit and examine the error that you received while running the DB Structure Integrity check. Given below are the steps to recover from the error in random order:
1. Shut down the instance, if not already done.
2. Copy one of the remaining control files to a new location.
3. Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of the control files.
4. Start up the database instance to the NOMOUNT stage.
5. Recover the database to the point of failure of the control file.
6. Open the database.
Identify the correct sequence of steps?
Exhibit:
A. 1, 2, 4, 3, 5, 6
B. 2, 4, 3, 5, 6; 1 not required
C. 4, 5, 6, 2, 3; 1 not required
D. 5, 2, 3, 4; 1 and 6 not required
Answer: A
Q10. Which two statements are true regarding undo tablespaces? (Choose two.)
A. The database can have more than one undo tablespace
B. The UNDO_TABLESPACE parameter is valid in both automatic and manual undo management
C. Undo segments automatically grow and shrink as needed, acting as circular storage buffer for their assigned transactions
D. An undo tablespace is automatically created if the UNDO_TABLESPACE parameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up
Answer: AC