ITPub博客

 View the Exhibit and examine the privileges granted to the SL_REP user. The EMP table is owned by the SCOTT user. The SL_REP user executes the following command:SQL> GRANT SELECT ON scott.emp TO hr;Which statement describes the outcome of the command? A.The c...

 8. Observe the information in the columns:1: The SGA a. Text and parsed forms of all SQL statements2: The cursor state b. Run-time memory values for the SQL statement, such as rows retrieved3: User-session data c. Security and resource usage information4: The stack ...

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