ITPub博客

 7. You have issued a SHUTDOWN ABORT command to bring down your database instance. Considerthe 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. ...

 6. Note the following points describing various utilities in Oracle Database 11g:1: It enables the high-speed 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...

4. Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type of backups that can be performed on the database?A.You can perform online whole database backups.B.You can perform offline whole database backups.C.You cannot perform schema-level ...

3.While observing the index statistics, you find that an index is highly fragmented, thereby resulting in poor database performance. Which option would you use to reduce fragmentation without affecting the users who are currently using the index? A.Validate the index structure using th...

2.Which two statements are true about the Automatic Workload Repository (AWR)? (Choose two.)A.All AWR tables belong to the SYSTEM schema.B.The AWR contains systemwide tracing and logging information.C.The snapshots collected by the AWR are accessible through data dictionary views....

 1. 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:...