ITPub博客

（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_SIZENAME 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.The buffer is a ca...

（11）Identify the memory component from which memory may be allocated for:1: Session memory for the shared server2: Buffers for I/O slaves3: Oracle Database Recovery Manager (RMAN) backup and restore operationsA.Large PoolB.Redo Log BufferC.Database Buffer CacheD.Program ...

（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 index on the con...

（9）View the Exhibit and examine the privileges granted to the SL_REP user.答案：（A）解析：因为SL_REP具有GRANT ANY OBJECT PRIVILEGE权限，所以可以将任何对象权限授予任何用户。

（8）Observe the information in the columns:1: The SGA2: The cursor state3: User-session data4: The stack spacea. Text and parsed forms of all SQL statementsb. Run-time memory values for the SQL statement, such as rows retrievedc. Security and resource usage information...

（7）You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider the 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.5: Background proce...

（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 the loading...

（5）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...

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

（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 the ANA...

（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: ORA-01555:...

到此，Oracle 11G 1Z0-051的所有题目的解析都给大家总结完了。希望大家参考、练习、顺利通过OCP考试！

（175）Which two statements are true regarding savepoints? (Choose two.)A. Savepoints are effective only for COMMIT.B. Savepoints may be used to ROLLBACK.C. Savepoints can be used for only DML statements.D. Savepoints are effective for both COMMIT and ROLLBACK.E. Savepoints can be...

（174）Which statement is true regarding transactions? (Choose all that apply.)A. A transaction can consist only of a set of DML and DDL statements.B. A part or an entire transaction can be undone by using ROLLBACK command.C. A transaction consists of a set of DML or DCL statements.D....

（173）When does a transaction complete? (Choose all that apply.)A. when a DELETE statement is executedB. when a ROLLBACK command is executedC. when a PL/SQL anonymous block is executedD. when a data definition language ( DDL) statement is executedE. when a TRUNCATE statement i...

（172）The SQL statements executed in a user session are as follows:CREATE TABLE product (pcode NUMBER(2), pname VARCHAR2(10));INSERT INTO product VALUES (1, 'pen');INSERT INTO product VALUES (2,'pencil');SAVEPOINT a;...

（171）Which three statements/commands would cause a transaction to end? (Choose three.)A. COMMITB. SELECTC. CREATED. ROLLBACKE. SAVEPOINT答案：（A、C、D）

一个recoverycatalog是一个数据库中的方案，被RMAN使用来存储关于一个或多个Oracle数据库的元数据。recovery catalog提供了下面的好处：1. recovery catalog对于存储在每个目标数据库控制文件中的RMAN库提供了冗余。recoverycatalog就像是第2个元数据库。2. recovery catalog将所有的目标数据库集中进行管...