Which statements are true regarding the creation of an incident package file by using the EM Workbench Support? (Choose all that apply.)
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?
You have two database servers SEMP and SACCT. The database in the SEMP server maintains the employee information and the database in the SACCT server maintains the accounts payable information. The employees submit the expense reports to the accounts payable department. A user of the accounts payable database wants to extract the employee information from the database in the SEMP server for cross-verification.
Which schema object enables the user to access the information from the remote database?
Which two activities are NOT supported by the Data Recovery Advisor (DRA)? (Choose two.)
You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to the point of failure.
Which configuration will you do to accomplish the task?
You configured the Flash Recovery Area (FRA) for your database. The database instance is running in ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area.
Which two files are removed automatically if the space is required in the FRA as per the retention policy? (Choose two.)
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.)
Which two statements are true regarding B-tree index? (Choose two.)
Which three statements are true about logical structures of the Oracle database? (Choose three.)
Which scenarios require DBA intervention to perform recovery? (Choose three.)