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

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 statements
2: The runtime area for data manipulation language (DML) or data definition language (DDL) statements
3 : Results of SQL queries and PL/SQL functions
4 : Executable forms of SQL cursors, PL/SQL programs, and Java classes
5 : The information necessary to reconstruct changes made to the database by a transaction Which of these will be stored in the Shared Pool if the necessary configurations are done?

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

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

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

Given below is a list of scenarios:
1. A user terminates his session abnormally.
2. The connection between the server and the client application terminates because of a network failure.
3 . A schema is accidentally dropped.
4 . The tablespace is accidentally dropped from the database.
5 . The hard disk gets corrupted and the data files in the disk are lost.
6 . The database instance abnormally shuts down because of power failure.
Which scenarios require DBA intervention to perform recovery?

• A.3, 4, and 5
• B.1, 3, and 6
• C.1, 2, and 6
• D.4, 5, and 6

Identify the logical structure that will never have more than one data segment created for it.

• A.nonclustered table
• B.external table
• C.global temporary table
• D.partitioned index
• E.partitioned table

The database is running in ARCHIVELOG mode. Examine the initialization parameters and their values set to enable archiving on your database server:

Which statement is true regarding the archived redo log files?

• A.It will be created on the local file system in the location specified LOG_ARCHIVE_DEST_1 parameter.
• B.It will be created only in the flash recovery area (fast recovery area).
• C.It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the default location $ORACLE_HOME/dbs.
• D.It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and location specified by the DB_RECOVERY_FILE_DEST parameter.