ITPub博客

NONE Oracle ignores any password file. Therefore, privileged users must be authenticated by the operating system. SHARED More than one database can use a password file. However, the only user recognized by the password file is SYS. EXCLUSIVE The password file can be used by only one databa...

 46 Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)A.The ADDM requires at least four AWR snapshots for analysis.B.The ADDM runs after each AWR snapshot is collected automatically by MMON. C.The results of the ADDM anal...

 15. Which two statements are true about Shared SQL Area and Private SQL Area? (Choose two.)A.Shared SQL Area will be allocated in the shared pool.B.Shared SQL Area will be allocated when a session starts.C.Shared SQL Area will be allocated in the large pool always.D.Priv...

 14. These are points that describe the contents of different memory components:1: Descriptive information or metadata about schema objects that are queried by using SQL statements2: The run-time area for data manipulation language (DML) or data definition language (DDL) statemen...

 13.You have executed this command to change the size of the database buffer cache: SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582; System altered. To verify the change in size, you executed this command: SQL> SHOW PARAMETER DB_CACHE_SIZE NAME TYPE VALUE ------------...

 12. Which is the correct description of a pinned buffer in the database buffer cache? A.The buffer is currently being accessed. B.The buffer is empty and has not been used. C.The contents of the buffer have changed and must be flushed to the disk by the DBWn process. D.T...

 11. Identify the memory component from which memory may be allocated for: 1: Session memory for the shared server 2: Buffers for I/O slaves 3: Oracle Database Recovery Manager (RMAN) backup and restore operations A.Large Pool 大池B.Redo Log Buffer 日志缓存池C.Dat...

 10. Examine the following statement that is used to modify the constraint on the SALES table:SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE;Which three statements are true regarding the above command? (Choose three.)A.The constraint remains valid.B.The inde...

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