1Z0-052 무료 덤프문제 온라인 액세스

You want to enable archiving on your database. Presently, the database is running in NOARCHIVELOG mode.
Given below are the steps to accomplish the task in random order:
1 . Shut down the instance.
2 . Execute the ALTER DATABASE ARCHIVELOG command.
3 . Start up the instance and mount the database.
4 . Set the DB_RECOVERY_FILE_DEST initialization parameter to
$ ORACLE_HOME/dest_1.
5. Open the database.
Which is the correct sequence of steps for accomplishing the task?

• A.1, 3, 4, 5; 2
• B.4, 1, 3, 2, 5
• C.1, 3, 4, 5, 2
• D.1, 3, 2, 5; 4
• E.4, 1, 5, 2; 3

Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)?
(Choose two.)

• A.The ADDM analysis provides only diagnostics information but does not provide recommendations
• B.The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR)
• C.The ADDM runs after each AWR snapshot is collected automatically by MMON
• D.The ADDM requires at least four AWR snapshots for analysis
• E.The ADDM calls other advisors if required, but does not provide recommendations about the advisors

Which three are true about the Automatic Workload Repository (AWR)? (Choose three.)

• A.It is the foundation for the self-managing infrastructure
• B.The taking of AWR snapshots cannot be disabled
• C.Its collection level is determined by the value of the STATISTICS_LEVEL database parameter
• D.AWR data is stored in the SYSTEM tablespace
• E.By default, AWR snapshots are taken every 60 minutes

Note the following functionalities of various background processes:
1 . Record the checkpoint information in data file headers.
2 . Perform recovery at instance startup.
3 . Cleanup unused temporary segments.
4 . Free the resources used by a user process when it fails.
5 . Dynamically register database services with listeners.
6 . Monitor sessions for idle session timeout.
Which option has the correct functionalities listed for a background process?

• A.Database Writer Process (DBWn): 1, 3, 4
• B.Process Monitor Process (PMON): 4, 5, 6
• C.System Monitor Process (SMON): 1, 4, 5
• D.Archiver Process (ARCn): 1, 2, 5

Identify the two situations in which the alert log file is updated with details. (Choose two.)

• A.Rebuilding an index using ALTER INDEX ... REBUILD fails with an error "ORA-01578:
  ORACLE data block corrupted (file # 14, block @ 50)."
• B.Inserting a value in a table returns "ORA-00001: unique constraint (SYS.PK_TECHP) violated."
• C.Inserting a value in a table returns "ORA-01722: Invalid Number"
• D.Creating a table returns "ORA-00955: name is already used by an existing object'
• E.Running a query on a table returns "ORA-600: Internal Error"
• F.Rebuilding an index using ALTER INDEX .... REBUILD fails with an error "ORA-01578:
  ORACLE data block corrupted (file #14, block #50)."