Download 1Z0-060 Braindumps 2021

NEW QUESTION 1
Which three statements are true about Flashback Database?

• A. Flashback logs are written sequentially, and are archive
• B. Flashback Database uses a restored control file to recover a database.
• C. The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Are
• D. Flashback Database can recover a database to the state that it was in before a reset logs operation.
• E. Flashback Database can recover a data file that was dropped during the span of time of the flashback.
• F. Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

Answer: CDF

NEW QUESTION 2
Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER by issuing the following command:
1snrctl > STOP
What happens to the sessions that are presently connected to the database Instance?

• A. They are able to perform only queries.
• B. They are not affected and continue to function normally.
• C. They are terminated and the active transactions are rolled back.
• D. They are not allowed to perform any operations until the listener LISTENER is starte

Answer: B

NEW QUESTION 3
Examine the following command;
ALTER SYSTEM SET enable_ddl_logging = TRUE;
Which statement is true?

• A. Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.
• B. All DDL commands are logged in the alert log file.
• C. All DDL commands are logged in a different log file that contains DDL statements and their execution dates.
• D. Only DDL commands that resulted in the creation of new segments are logge
• E. All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.

Answer: C

NEW QUESTION 4
Which three statements are true about Automatic Workload Repository (AWR)?

• A. All AWR tables belong to the SYSTEM schem
• B. The AWR data is stored in memory and in the database.
• C. The snapshots collected by AWR are used by the self-tuning components in the database
• D. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.
• E. AWR contains system wide tracing and logging information.

Answer: CDE

NEW QUESTION 5
Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart.
Examine the following command and its output:
$ crsctl config has
CRS-4622: Oracle High Availability Services auto start is enabled.
What does this imply?

• A. When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically starte
• B. When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still starte
• C. When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.
• D. When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.

Answer: B

NEW QUESTION 6
A redaction policy was added to the SAL column of the SCOTT.EMP table:

All users have their default set of system privileges.
For which three situations will data not be redacted?

• A. SYS sessions, regardless of the roles that are set in the session
• B. SYSTEM sessions, regardless of the roles that are set in the session
• C. SCOTT sessions, only if the MGR role is set in the session
• D. SCOTT sessions, only if the MGR role is granted to SCOTT
• E. SCOTT sessions, because he is the owner of the table
• F. SYSTEM session, only if the MGR role is set in the session

Answer: ABD

NEW QUESTION 7
Which three statements are true about adaptive SQL plan management?

• A. It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.
• B. The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.
• C. It adds new, bettor plans automatically as fixed plans to the baseline.
• D. The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.
• E. The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generate

Answer: ADE

NEW QUESTION 8
Identify two correct statements about multitenant architectures.

• A. Multitenant architecture can be deployed only in a Real Application Clusters (RAC) configuration.
• B. Multiple pluggable databases (PDBs) share certain multitenant container database (CDB) resources.
• C. Multiple CDBs share certain PDB resources.
• D. Multiple non-RAC CDB instances can mount the same PDB as long as they are on the same server.
• E. Patches are always applied at the CDB level.
• F. A PDB can have a private undo tablespace.

Answer: BE

NEW QUESTION 9
In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.
How would you accomplish this?

• A. Setting a metric threshold
• B. Implementing Database Resource Manager
• C. Enabling resumable timeout for user sessions
• D. Decreasing the value of the IDLE_TIME resource limit in the default profile

Answer: D

NEW QUESTION 10
To implement Automatic Management (AMM), you set the following parameters:

When you try to start the database instance with these parameter settings, you receive the following error message:
SQL > startup
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information.
Identify the reason the instance failed to start.

• A. The PGA_AGGREGATE_TARGET parameter is set to zero.
• B. The STATISTICS_LEVEL parameter is set to BASI
• C. Both the SGA_TARGET and MEMORY_TARGET parameters are set.
• D. The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal.

Answer: B

NEW QUESTION 11
Which three are true about the large pool for an Oracle database instance that supports
shared server connections?

• A. Allocates memory for RMAN backup and restore operations
• B. Allocates memory for shared and private SQL areas
• C. Contains a cursor area for storing runtime information about cursors
• D. Contains stack space
• E. Contains a hash area performing hash joins of tables

Answer: ABC

NEW QUESTION 12
You plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.
Which three storage options support the use of HCC?

• A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.
• B. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array
• C. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files
• D. Database files stored in ZFS and accessed using conventional NFS mounts.
• E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature
• F. Database files stored in any file system and accessed using the Oracle Direct NFS feature
• G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

Answer: AEG

NEW QUESTION 13
You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege.
The CDB has several pluggable databases (PDBs) open in the read/write mode. There are ongoing transactions in both the CDB and PDBs.
What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?

• A. The shutdown proceeds immediately.The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolled hack.
• B. The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.
• C. The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.
• D. The statement results in an error because there are open PDBs.

Answer: B

NEW QUESTION 14
Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:

Which two statements are true about redefining the table?

• A. All the triggers for the table are disabled without changing any of the column names or column types in the table.
• B. The primary key constraint on the EMPLOYEES table is disabled during redefinition.
• C. VPD policies are copied from the original table to the new table during online redefinition.
• D. You must copy the VPD policies manually from the original table to the new table during online redefinition.

Answer: AC

NEW QUESTION 15
You must track all transactions that modify certain tables in the sales schema for at least three years.
Automatic undo management is enabled for the database with a retention of one day.
Which two must you do to track the transactions?

• A. Enable supplemental logging for the database.
• B. Specify undo retention guarantee for the database.
• C. Create a Flashback Data Archive in the tablespace where the tables are store
• D. Create a Flashback Data Archive in any suitable tablespace.
• E. Enable Flashback Data Archiving for the tables that require tracking.

Answer: DE

NEW QUESTION 16
You use the segment advisor to help determine objects for which space may be reclaimeD. Which three statements are true about the advisor given by the segment advisor?

• A. It may advise the use of online table redefinition for tables in dictionary managed tablespace.
• B. It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.
• C. It may advise the use of online table redefinition for tables in locally managed tablespaces
• D. It will detect and advise about chained rows.
• E. It may advise the use of segment shrink for free list managed tables.

Answer: ADE

NEW QUESTION 17
You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index.
Which two are possible if table updates are performed which affect the invisible index columns?

• A. The index remains invisible.
• B. The index is not updated by the DML statements on the indexed table.
• C. The index automatically becomes visible in order to have it updated by DML on the table.
• D. The index becomes unusable but the table is updated by the DML.
• E. The index is updated by the DML on the table.

Answer: AE