This page was exported from IT certification exam materials [ http://blog.dumpleader.com ] Export date:Sat Jan 18 12:06:01 2025 / +0000 GMT ___________________________________________________ Title: [Oct 26, 2022] Updates Up to 365 days On Valid 1z0-062 Braindumps [Q36-Q53] --------------------------------------------------- [Oct 26, 2022] Updates Up to 365 days On Valid 1z0-062 Braindumps Best Quality1z0-062 Exam Questions Oracle Test To Gain Brilliante Result NEW QUESTION 36Your 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 37You 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. * Oracle Database provides a mechanism to make table structure modifications without significantly affecting the availability of the table. The mechanism is called online table redefinition. Redefining tables online provides a substantial increase in availability compared to traditional methods of redefining tables.* To redefine a table online:Choose the redefinition method: by key or by rowid* By key-Select a primary key or pseudo-primary key to use for the redefinition. Pseudo- primary keys are unique keys with all component columns having NOT NULL constraints.For this method, the versions of the tables before and after redefinition should have thesame primary key columns. This is the preferred and default method of redefinition.* By rowid-Use this method if no key is available. In this method, a hidden column namedM_ROW$$ is added to the post-redefined version of the table. It is recommended that this column be dropped or marked as unused after the redefinition is complete. IfCOMPATIBLE is set to 10.2.0 or higher, the final phase of redefinition automatically sets this column unused. You can then use the ALTER TABLE … DROP UNUSED COLUMNS statement to drop it.You cannot use this method on index-organized tables.Note:* When you rebuild an index, you use an existing index as the data source. Creating an index in this manner enables you to change storage characteristics or move to a newtablespace. Rebuilding an index based on an existing data source removes intra-block fragmentation. Compared to dropping the index and using the CREATE INDEX statement, re-creating an existing index offers better performance.Incorrect:Not E: Edition-based redefinition enables you to upgrade the database component of an application while it is in use, thereby minimizing or eliminating down time.NEW QUESTION 38Your 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. * Oracle Database provides a mechanism to make table structure modifications without significantly affecting the availability of the table. The mechanism is called online table redefinition. Redefining tables online provides a substantial increase in availability compared to traditional methods of redefining tables.*To redefine a table online:Choose the redefinition method: by key or by rowid*By key-Select a primary key or pseudo-primary key to use for the redefinition. Pseudo-primary keys are unique keys with all component columns having NOT NULL constraints. For this method, the versions of the tables before and after redefinition should have the same primary key columns. This is the preferred and default method of redefinition.*By rowid-Use this method if no key is available. In this method, a hidden column named M_ROW$$ is added to the post-redefined version of the table. It is recommended that this column be dropped or marked as unused after the redefinition is complete. If COMPATIBLE is set to10.2.0 or higher, the final phase of redefinition automatically sets this column unused. You can then use the ALTER TABLE … DROP UNUSED COLUMNS statement to drop it.You cannot use this method on index-organized tables.Note:* When you rebuild an index, you use an existing index as the data source. Creating an index in this manner enables you to change storage characteristics or move to a new tablespace. Rebuilding an index based on an existing data source removes intra-block fragmentation. Compared to dropping the index and using the CREATE INDEX statement, re-creating an existing index offers better performance.Incorrect:Not E: Edition-based redefinition enables you to upgrade the database component of an application while it is in use, thereby minimizing or eliminating down time.NEW QUESTION 39Examine 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. Explanation/Reference:Explanation:NEW QUESTION 40Which 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. A: In certain situations, you may want to exclude selected columns or tables from scanning or conversion steps of the migration process.D: Exceed column limitThe cell data will not fit into a column after conversion.E: Need conversionThe cell data needs to be converted, because its binary representation in the target character set is different than the representation in the current character set, but neither length limit issues nor invalid representation issues have been found.* Oracle Database Migration Assistant for Unicode (DMU) is a unique next-generation migration tool providing an end-to-end solution for migrating your databases from legacy encodings to Unicode.Incorrect:Not C: The release of Oracle Database must be 10.2.0.4, 10.2.0.5, 11.1.0.7, 11.2.0.1, or later.NEW QUESTION 41What 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. Explanation/Reference:References: https://docs.oracle.com/database/121/UPGRD/upgrade.htm#UPGRD52860NEW QUESTION 42You 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 References:https://docs.oracle.com/database/121/LADBI/oraclerestart.htm#LADBI999NEW QUESTION 43Which 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. Referenceshttps://docs.oracle.com/cd/E11882_01/server.112/e25494/tasks.htm#ADMIN12331NEW QUESTION 44You created a new database using the “create database” statement without specifying the “ENABLEPLUGGABLE” 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. Explanation/Reference:Explanation:A (not B,not E): The CREATE DATABASE … ENABLE PLUGGABLE DATABASE SQL statement createsa new CDB. If you do not specify the ENABLE PLUGGABLE DATABASE clause, then the newly createddatabase is a non-CDB and can never contain PDBs.D: You can create a PDB by plugging in a Non-CDB as a PDB.The following graphic depicts the options for creating a PDB:Incorrect:Not E: For the duration of its existence, a database is either a CDB or a non-CDB. You cannot transform anon-CDB into a CDB or vice versa. You must define a database as a CDB at creation, and then createPDBs within this CDB.NEW QUESTION 45Which 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 46Automatic Shared Memory Management (ASMM) is enabled for your database instance. You execute the followingcommand: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 nextinstance startup. NEW QUESTION 47Identify 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 TrailThe 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 48What 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 49The following parameter are set for your Oracle 12c database instance:OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSEOPTIMIZER_USE_SQL_PLAN_BASELINES=TRUEYou 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 Explanation/Reference:Explanation:* Evolving SQL Plan Baselines* 2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function.This function creates an advisor task to prepare the plan evolution of one or more plans for a specified SQL statement. The input parameters can be a SQL handle, plan name or a list of plan names, time limit, task name, and description.1. Set the evolve task parameters.SET_EVOLVE_TASK_PARAMETERThis function updates the value of an evolve task parameter. In this release, the only valid parameter is TIME_LIMIT.4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.This function executes an evolution task. The input parameters can be the task name, execution name, and execution description. If not specified, the advisor generates the name, which is returned by the function.3: IMPLEMENT_EVOLVE_TASKThis function implements all recommendations for an evolve task. Essentially, this function is equivalent to using ACCEPT_SQL_PLAN_BASELINE for all recommended plans. Input parameters include task name, plan name, owner name, and execution name.5. Report the task outcome by using the DBMS_SPM_EVOLVE_TASK function.This function displays the results of an evolve task as a CLOB. Input parameters include the task name and section of the report to include.References:NEW QUESTION 50You 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 51Which 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 52Which 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. References:https://docs.oracle.com/database/121/SUTIL/GUID-0F35B551-861B-450D-8 BF3-2312893A67D7.htm#SUTIL3951NEW QUESTION 53You 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 theOSDBA or OSOPER operating system groups.  It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.  Loading … Focus on 1z0-062 All-in-One Exam Guide For Quick Preparation: https://www.dumpleader.com/1z0-062_exam.html --------------------------------------------------- Images: https://blog.dumpleader.com/wp-content/plugins/watu/loading.gif https://blog.dumpleader.com/wp-content/plugins/watu/loading.gif --------------------------------------------------- --------------------------------------------------- Post date: 2022-10-26 09:08:10 Post date GMT: 2022-10-26 09:08:10 Post modified date: 2022-10-26 09:08:10 Post modified date GMT: 2022-10-26 09:08:10