[Oct 26, 2022] Updates Up to 365 days On Valid 1z0-062 Braindumps [Q36-Q53]

NEW QUESTION 36
Your database is running in NOARCHIVLOG mode.
Examine the following parameters:

You execute the following command after performing a STARTUP MOUNT:
SQL> ALTER DATABASE ARCHIVELOG;
Which statement is true about the execution of the command?

It executes successfully and sets the Fast Recovery Area as the local archive destination.

It executes successfully and issues a warning to set LOG_ARCHIVE_DEST while opening the database.

It fails and returns an error about LOG_ARCHIVE_DEST not being set.

It executes successfully and sets $ORACLE_HOME/dbs as the default archive destination.

NEW QUESTION 37
You are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace.
The table does not have a primary key and is used by an OLTP application.
Which technique will move the table and indexes while maintaining the highest level of availability to the application?

Oracle Data Pump.

An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.

An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to movethe indexes.

Online Table Redefinition.

Edition-Based Table Redefinition.

NEW QUESTION 38
Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace.
The table does not have a primary key and is used by an OLTP application.
Which technique will move the table and indexes while maintaining the highest level of availability to the application?

Oracle Data Pump.

An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.

An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.

Online Table Redefinition.

Edition-Based Table Redefinition.

NEW QUESTION 39
Examine the structure of the sales table, which is stored in a locally managed tablespace with Automatic Segment Space Management (ASSM) enabled.

You want to perform online segment shrink to reclaim fragmented free space below the high water mark.
What should you ensure before the start of the operation?

Row movement is enabled.

Referential integrity constraints for the table are disabled.

No queries are running on this table.

Extra disk space equivalent to the size of the segment is available in the tablespace.

No pending transaction exists on the table.

NEW QUESTION 40
Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?
(Choose three.)

A DBA can check specific tables with the DMU

The database to be migrated must be opened read-only.

The release of the database to be converted can be any release since 9.2.0.8.

The DMU can report columns that are too long in the converted characterset.

The DMU can report columns that are not represented in the converted characterset.

NEW QUESTION 41
What is the benefit of running the catctl.plscript during an upgrade of a pre-12c database to an Oracle 12c database?

It provides a summary of the upgrade results.

It recompiles all invalid PL/SQL and Java code.

It generates a log file containing the fixes that can be made to the source database.

It provides parallel upgrade options to finish the upgrade process with a reduced down time.

It generates fix-up scripts to be run on the source database before upgrade.

NEW QUESTION 42
You install Oracle Grid Infrastructure for a standalone server.
Which two components are automatically included in the Oracle Restart configuration?
(Choose two.)

A pre-existing Oracle Net Listener

Oracle Notification services

A pre-existing database

A pre-existingOracle management agent

OracleCSSDservice

NEW QUESTION 43
Which three statements are true about automated maintenance tasks?

They run at predefined time intervals that are intended to occur during a period of low system load.

An Oracle Schedulerjob is created for each maintenance task that is scheduled to run in a maintenance window.

A maintenance window is automatically extended until all the maintenance tasks defined are completed.

A repository is maintained in theSYSTEMtablespace to store the history of execution of all tasks.

Predefined maintenance tasks consist of automatic optimizer statistics collection, running Automatic Segment Advisor, and running Automatic SQL Tuning Advisor.

NEW QUESTION 44
You created a new database using the “create database” statement without specifying the “ENABLE
PLUGGABLE” clause.
What are two effects of not using the “ENABLE PLUGGABLE database” clause?

The database is created as a non-CDB and can never contain a PDB.

The database is treated as a PDB and must be plugged into an existing multitenant container database
(CDB).

The database is created as a non-CDB and can never be plugged into a CDB.

The database is created as a non-CDB but can be plugged into an existing CDB.

The database is created as a non-CDB but will become a CDB whenever the first PDB is plugged in.

NEW QUESTION 45
Which three factors influence the optimizer’s choice of an execution plan?

the optimizer_mode initialization parameter

type of connection used to connect to database instance

cardinality estimates

object statistics in the data dictionary

fixed baselines

NEW QUESTION 46
Automatic Shared Memory Management (ASMM) is enabled for your database instance. You execute the following
command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;
Which statement is true?

It succeeds and the minimum size for the DEFAULT buffer pool is set to 100M.

It fails because DB_CACHE_SIZE is a static initialization parameter.

It fails because ASMM is enabled and individual SGA components cannot be sized.

It succeeds and the value is changed in the SPFILE immediately, but the change takes effect only at the next
instance startup.

NEW QUESTION 47
Identify three benefits of Unified Auditing.

Decreased use of storage to store audit trail rows in the database.

It improves overall auditing performance.

It guarantees zero-loss auditing.

The audit trail cannot be easily modified because it is read-only.

It automatically audits Recovery Manager (RMAN) events.

A: Starting with 12c, Oracle has unified all of the auditing types into one single unit called Unified auditing. You don’t have to turn on or off all of the different auidting types individually and as a matter of fact auditing is enabled by default right out of the box. The AUD$ and FGA$ tables have been replaced with one single audit trail table. All of the audit data is now stored in Secure Files table thus improving the overall management aspects of audit data itself.
B: Further the audit data can also be buffered solving most of the common performance related problems seen on busy environments.
E: Unified Auditing is able to collect audit data for Fine Grained Audit, RMAN, Data Pump, Label Security, Database Vault and Real Application Security operations.
Note:
* Benefits of the Unified Audit Trail
The benefits of a unified audit trail are many:
/ (B) Overall auditing performance is greatly improved. The default mode that unified audit works is Queued Write mode. In this mode, the audit records are batched in SGA queue and is persisted in a periodic way. Because the audit records are written to SGA queue, there is a significant performance improvement.
/ The unified auditing functionality is always enabled and does not depend on the initialization parameters that were used in previous releases
/ (A) The audit records, including records from the SYS audit trail, for all the audited components of your Oracle Database installation are placed in one location and in one format, rather than your having to look in different places to find audit trails in varying formats. This consolidated view enables auditors to co-relate audit information from different components. For example, if an error occurred during an INSERT statement, standard auditing can indicate the error number and the SQL that was executed. Oracle Database Vault-specific information can indicate whether this error happened because of a command rule violation or realm violation. Note that there will be two audit records with a distinct AUDIT_TYPE. With this unification in place, SYS audit records appear with AUDIT_TYPE set to Standard Audit.
/ The management and security of the audit trail is also improved by having it in single audit trail.
/ You can create named audit policies that enable you to audit the supported components listed at the beginning of this section, as well as SYS administrative users. Furthermore, you can build conditions and exclusions into your policies.
* Oracle Database 12c Unified Auditing enables selective and effective auditing inside the Oracle database using policies and conditions. The new policy based syntax simplifies management of auditing within the database and provides the ability to accelerate auditing based on conditions.
* The new architecture unifies the existing audit trails into a single audit trail, enabling simplified management and increasing the security of audit data generated by the database.

NEW QUESTION 48
What happens if a maintenance window closes before a job that collects optimizer statistics completes?

The job is terminated and the gathered statistics are not saved.

The job is terminated but the gathered statistics are not published.

The job continues to run until all statistics are gathered.

The job is terminated and statistics for the remaining objects are collected the next time the maintenance window opens.

NEW QUESTION 49
The following parameter are set for your Oracle 12c database instance:
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE
OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE
You want to manage the SQL plan evolution task manually. Examine the following steps:
1. Set the evolve task parameters.
2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function.
3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.
4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.
5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.
Identify the correct sequence of steps:

2, 4, 5

2, 1, 4, 3, 5

1, 2, 3, 4, 5

1, 2, 4, 5

NEW QUESTION 50
You execute this command:

Which two statements are true about segment space management for segments in this tablespace?

Space utilization inside segments is mapped by bitmaps.

Segments are automatically shrunk and compressed when rows are deleted.

ThePCTFREEstorage parameter has no effect on segments created in this tablespace.

ThePCTUSEDstorageparameter has no effect on segments created in this tablespace.

NEW QUESTION 51
Which three statements are true about Enterprise Manager Database Express? (Choose three.)

It can be used to perform database backup operations.

It can use the HTTP protocol.

The same port number is used for multiple Database Express configurations on the same host.

It can use the HTTPS protocol.

It is available only whenthe database is open.

NEW QUESTION 52
Which two statements are true about SQL *Loader Express Mode in an Oracle 12c database?

TheDEGREE_OF_PARALLELISMparameter is set toAUTO.

You cannot have multiple SQL *Loader data files.

If no data file is specified, it assumes the data file to be<table-name>.datin the current directory and uses it.

You can have multiple bad files created when loading in parallel.

You can selectively load rows into a table based on a filer.

NEW QUESTION 53
You Execute the Following command to create a password file in the database server:
$ orapwd file = ‘+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12’
Which two statements are true about the password file?

It records the usernames and passwords of users when granted the DBA role.

It contains the usernames and passwords of users for whom auditing is enabled.

Is used by Oracle to authenticate users for remote databaseadministration.

It records the usernames and passwords of all users when they are added to the
OSDBA or OSOPER operating system groups.

It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.

Leave a Reply Cancel reply