053 (14)

66.

 the. Which initialization parameters would youSet  toEnable Automatic Shared Memory Management? (Choose.) A.SetShared_pool_size toZerob.SetStatistics_level toBASICC.SetSga_target toA non-Zero valued.SetDb_cache_size toA non-Zero Valuee.SetStatistics_level toTypicalor  All

67.

.  on Database  of  temporaryIndex-organized Tables (iots)

68.

 the. You have threeTemporaryTablespace groups named G1, G2, andG3inchYourDatabase. You is creating a newTemporaryTablespace asfollows:CREATE TemporaryTablespace TEMP1 Tempfile'/u1/data/temp1.dbf'SIZE 10M tablespaceGROUP "'; Which statement regarding the above command iscorrect? A. It wouldCreateThe tablespace TEMP1inch GroupG1. B. It wouldCreateThe tablespace TEMP1inch GroupG3. C. It would not AddThe tablespace TEMP1 to  any Group. D. It wouldCreateThe tablespace TEMP1inchThedefault Group.

69.

 the. The EMPTable exists inchYourSchema. You want to ExecuteThe following query:SELECTename, Sal. fromEMP as  of TIMESTAMP(Systimestamp-INTERVAL'6'MINUTE)WHEREEname= 'ALLEN'; What is the minimum requirements forThe statement to ExecuteSuccessfully? (Choose Allthat apply) A.archivelog mode must is Enabledb.row movement must be enabled forTheTableC.flashback must beSet  to  on  forTheDatabased.the undo_management parameter must beSet  toAutoe. The undo_retention parameter must beSetAppropriately

70.

 -. You executed the following SQL statement toShrink the EMPLOYEESTableSegment StoredinchThe EXAMPLE tablespace:ALTER TABLEEmployees SHRINKSPACE CASCADE; Which statement isCorrectinchThis scenario? A. The EMPLOYEESTablewould be changed to Read- onlymode during the shrink operation. B. The indexes created onThe EMPLOYEESTablewould need toBe rebuilt after the shrink operation is  Over. C. The shrink behavior 'll be cascaded to  AllDependent segments ofTheTableThat's support a shrink operation. D. Data manipulation Language (DML) operations would notBe possible onThe EMPLOYEESTableDuring the compaction phase ofThe shrink operation.

053 (14)