Get 100% Passing Success With True 1z0-062 Exam! [Dec-2021]
Oracle 1z0-062 PDF Questions - Exceptional Practice To Oracle Database 12c: Installation and Administration
Those candidates who are used to referring themselves to self-study and have enough time & motivation in reserve can utilize such study guides and books from the Amazon website:
- ‘OCA Oracle Database 12c Installation and Administration Exam Guide (Exam 1Z0-062)’ by John Watson is an exclusive Oracle Press manual that covers all of the associate-level objectives to prepare for 1Z0-062. Its author, John Watson, as an OCP-level database administrator, will show readers how to install and upgrade Oracle Database software, how to manage Oracle instances alongside database storage structures, and how to implement Oracle Database auditing. Furthermore, upon completion of this book, you will demonstrate expertise in automating tasks, data movement, and installing Oracle Grid infrastructure for a standalone server. What is peculiar about this manual is that each chapter of this resource includes realistic exercises, two-minute drills for every topic, and self-check tests so you can observe the results of your work. This guide is available in Kindle and Paperback versions for anyone interested. However, it should be noted that the electronic version of the book provides access to more than 185 practice exam questions, as well as a test engine so that you will not only get a valuable source of information for quality preparation for your forthcoming 1Z0-062 exam, but also a handy reference for further use in the workplace.
- For those wishing to begin efficient preparation for 1Z0-062, you should take a look at ‘OCA: Oracle Database 12c Administrator Certified Associate Study Guide: Exams 1Z0-061 and 1Z0-062 1st Edition’ written by an industry expert with hands-on Oracle database experience, Biju Thomas. With an extensive set of study tools, including flashcards, summary questions for each chapter, assessment tests, as well as practical labs, you will not only have a comprehensive resource for preparation but will also discover the world of day-to-day work as a database administrator. As a result, you will have honed the skills required for certification, such as restricting and sorting data, creating an Oracle Database, administering user security, and more. You can find this guide on Amazon in both Kindle and paperback versions, and in exchange, you get a convenient preparation source, including real-world scenarios, hands-on exercises, and access to exam prep software.
As you can see, there are more than enough ways for comprehensive and productive revision. Thus, each candidate can choose the preparation tool that suits his or her learning style.
More Info
For more info visit: Oracle 12c Official 1Z0-062 Exam Reference
NEW QUESTION 200
Which two statements are true when row archival management is enabled?
- A. The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.
- B. The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.
- C. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.
- D. The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.
- E. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
Answer: A,D
Explanation:
A: Below we see a case where we set the row archival visibility parameter to "all"
thereby allowing us to see all of the rows that have been logically deleted:
alter session set row archival visibility = all;
We can then turn-on row invisibility back on by changing row archival visibility = "active":
alter session set row archival visibility = all;
B: To use ora_archive_state as an alternative to deleting rows, you need the following settings and parameters:
1.Create the table with the row archival clause
create table mytab (col1 number, col2 char(200)) row archival;
2.Now that the table is marked as row archival, you have two methods for removing rows, a permanent solution with the standard delete DML, plus the new syntax where you set ora_archive_state to a non-zero value:
update mytab set ora_archive_state=2 where col2='FRED';
3.To make "invisible rows" visible again, you simply set the rows ora_archive_state to zero:
update mytab set ora_archive_state=0 where col2='FRED';
Note:
* Starting in Oracle 12c, Oracle provides a new feature that allow you to "logically delete" a row in a table without physically removing the row. This effectively makes deleted rows "invisible" to all SQL and DML, but they can be revealed at any time, providing a sort of "instant" rollback method.
To use ora_archive_state as an alternative to deleting rows.
NEW QUESTION 201
You execute this command:
Which two statements are true about segment space management for segments in this tablespace? (Choose two.)
- A. The PCTFREE storage parameter has no effect on segments created in this tablespace.
- B. Space utilization inside segments is mapped by bitmaps.
- C. Segments are automatically shrunk and compressed when rows are deleted.
- D. The PCTUSED storage parameter has no effect on segments created in this tablespace.
Answer: B,D
NEW QUESTION 202
Which two partitioned table maintenance operations support asynchronous Global Index Maintenance in Oracle database 12c? (Choose two.)
- A. ALTER TABLE DROP PARTITION
- B. ALTER TABLE MOVE PARTITION
- C. ALTER TABLE SPLIT PARTITION
- D. ALTER TABLE ADD PARTITION
- E. ALTER TABLE MERGE PARTITION
- F. ALTER TABLE TRUNCATE PARTITION
Answer: A,F
Explanation:
Asynchronous Global Index Maintenance for DROP and TRUNCATE PARTITION
This feature enables global index maintenance to be delayed and decoupled from a DROP and TRUNCATE partition without making a global index unusable. Enhancements include faster DROP and TRUNCATE partition operations and the ability to delay index maintenance to off-peak time.
NEW QUESTION 203
Identify two prerequisites for configuring Enterprise Manager Database Express (EM
Express).
- A. Use theDBMS_XDB_CONFIG.SETHTTPPORTprocedure to configure a portnumber for
Oracle HTTP Server. - B. Create aSYSMANuser with theSYSDBAprivilege as an administrator for EM Express.
- C. Install Oracle HTTP Server.
- D. Grant theAPEX_PUBLIC_USERrole to theSYSMANuser.
- E. Configure at least one dispatcher for the TCP/IP protocol.
Answer: B,E
NEW QUESTION 204
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 BASIC.
- 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
Explanation:
Explanation/Reference:
Explanation:
Example:
SQL> startup force
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings ORA-00848: STATISTICS_LEVEL cannot be set to BASIC with SGA_TARGET or MEMORY_TARGET
NEW QUESTION 205
Which two statements are true about the Database Configuration Assistant (DBCA)? (Choose two.)
- A. It can be usedto copy an existing Oracle database to a new host and apply any patches necessary in the new host.
- B. It can be used to add a new tablespace.
- C. It can generate SQL database creation scripts.
- D. It can be used to create a database template from an existing database.
- E. It can configure Automatic Storage Management (ASM) diskgroups.
Answer: C,D
Explanation:
References: https://docs.oracle.com/cd/E17559_01/em.111/e16599/appdx_creating_db_templates.htm#CJACEDCD
NEW QUESTION 206
Which task would you recommend before using the Database Upgrade Assistant (DBUA) to upgrade a single-instance Oracle 11g R2 database to Oracle Database 12c?
- A. copying the listener.ora file to the new ORACLE_HOME
- B. shutting down the database instance that is being upgraded
- C. executing the catctl.pl script to run the upgrade processes in parallel
- D. running the Pre-Upgrade Information Tool
Answer: D
Explanation:
References:
NEW QUESTION 207
SALES is a valid TNS entry referring to:
Hostname: HOST01
Port: 1521
Service_name: SALES_SRV
You issue this command:
$ tnsping SALES
Which two are true? (Choose two.)
- A. It validates that SALES_SRVservice is active in any database instance on HOST01.
- B. It validates that SALES_SRVservice is active in a specific database instance on HOST01.
- C. It validates that a SALES_SRVdatabase on HOST01 is open.
- D. It validates that there is a listener on HOST01 port 1521.
- E. It validates that SALESis a valid TNSNAMESentry reachable by the configured name resolution method.
Answer: C,D
Explanation:
Explanation/Reference:
NEW QUESTION 208
In your database, USERS is the default permanent tablespace.
Examine the commands and their outcome:
You plan to execute the commands:
Which two statements are true? (Choose two.)
- A. The MYTAB table is owned by the SYS user.
- B. The MYTAB table is created in the SYSTEM tablespace and rows can be inserted into the table by USER02.
- C. The CREATE TABLE statement generates an error because the SYSDBA privilege does not provide any space quota on the SYSTEM tablespace by default.
- D. The MYTAB table is created in the SYSTEM tablespace but no rows can be inserted into the table by USER02.
- E. The MYTAB table is created in the USERS tablespace but no rows can be inserted into the table by USER02.
Answer: A,B
NEW QUESTION 209
Identify three benefits of Unified Auditing. (Choose three.)
- A. Decreased use of storage to store audit trail rows in the database.
- B. The audit trail cannot be easily modified because it is read-only.
- C. It guarantees zero-loss auditing.
- D. It automatically audits Recovery Manager (RMAN) events.
- E. It improves overall auditing performance.
Answer: A,D,E
Explanation:
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 210
You have just completed a manual upgrade of an Oracle 11g Database to Oracle Database 12c.
The Post-Upgrade Status Tool reports an INVALIDstatus for some of the components after the upgrade.
What must you do first in this situation to attempt to fix this problem?
- A. Run utluiobj.sqlto filter out objects that were invalidated by the upgrade process.
- B. Run utlrp.sqlto recompile stored PL/SQL and Java code and check the DBA_REGISTRYview.
- C. Run catuppst.sqlto perform revalidation actions
- D. Run preupgrd.sqland then execute the generated "fix-up" scripts to resolve status issues.
Answer: B
NEW QUESTION 211
Examine the details of the uncompressed, non-partitioned heap table CITIES.
Examine the command:
SQL>ALTER TABLE cities SHRINK SPACE COMPACT;
What must you do before executing it?
- A. Ensure there are no pending transactions on the table.
- B. Ensure free space that is approximately equal to the space used by the table should be available.
- C. Disable all indexes on the table.
- D. Enable row movement is enabled.
Answer: D
NEW QUESTION 212
You plan to implement the distributed database system in your company. You invoke Database Configuration Assistant (DBCA) to create a database on the server. During the installation, DBCA prompts you to specify the Global Database Name.
What must this name be made up of?
- A. It must be made up of the value that you plan to assign for ORACLE_SID and SERVICE_NAMES.
- B. It must be made up of a database name and a domain name.
- C. It must be made up of the value that you plan to assign for INSTANCE_NAME and HOSTNAME.
- D. It must be made up of the value in ORACLE_SID and HOSTNAME.
Answer: B
Explanation:
Using the DBCA to Create a Database (continued)
3. Database Identification: Enter the Global Database Name in The form
database_name.domain_name, and the system identifier (SID). The SID defaults lo the database name and uniquely identifies the instance associated with the database.
4. Management Options: Use this page to set up your database so that it can be managed with Oracle Enterprise Manager. Select the default: "Configure the Database with Enterprise Manager." Optionally, this page allows you to configure alert notifications and daily disk backup area settings.
Note: Yon must configure the listener before you can configure Enterprise Manager (as shown earlier).
NEW QUESTION 213
You want to create a role that:
-is protected from unauthorized usage
-does not use a password embedded in the application source code or stored in a table
-is enabled for a user based on security policies defined in a PL/SQL package
How would you create this role?
- A. with definer's rights
- B. with external authentication
- C. as a secure application role
- D. with global authentication
Answer: C
Explanation:
References:
https://docs.oracle.com/cd/B28359_01/network.111/b28531/authorization.htm#DBSEG97973
NEW QUESTION 214
Which two statements are true? (Choose two.)
- A. A role can be granted to other roles.
- B. A role cannot be assigned external authentication.
- C. The predefined CONNECTrole is always automatically granted to all new users at the time of their creation.
- D. The predefined RESOURCErole includes the UNLIMITED TABLESPACEprivilege.
- E. All roles are owned by the SYSuser.
- F. A role can contain both system and object privileges.
Answer: A,F
NEW QUESTION 215
Identify three benefits of Unified Auditing.
- A. Decreased use of storage to store audit trail rows in the database.
- B. The audit trail cannot be easily modified because it is read-only.
- C. It guarantees zero-loss auditing.
- D. It automatically audits Recovery Manager (RMAN) events.
- E. It improves overall auditing performance.
Answer: A,D,E
Explanation:
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 216
Which two are prerequisites for performing a flashback transaction? (Choose two.)
- A. Flashback Database must be enabled.
- B. Recycle bin must be enabled for the database.
- C. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back
transaction. - D. Block change tracking must be enabled tor the database.
- E. Supplemental logging must be enabled.
- F. Undo retention guarantee for the database must be configured.
Answer: E,F
Explanation:
Explanation/Reference:
Explanation:
References: http://searchoracle.techtarget.com/tip/How-to-perform-Oracle-Flashback-Transaction-Queries
https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#ADFNS610
NEW QUESTION 217
You are managing an Oracle Database 12c database. The database is open, and you plan to perform
Recovery Manager (RMAN) backups.
Which three statements are true about these backups? (Choose three.)
- A. The backups would be inconsistent.
- B. The backups would be possible only if the database is running in ARCHIVELOGmode.
- C. The backups need to be restored and the database has to be recovered in case of a media failure.
- D. The backups would be consistent.
- E. The backups by default consist of all the data blocks within the chosen files or the full database.
Answer: A,B,C
Explanation:
Explanation/Reference:
References: https://docs.oracle.com/cd/E18283_01/server.112/e10897/backrest.htm#insertedID4
NEW QUESTION 218
Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):
Which three are prerequisites for successful execution of the command? (Choose three.)
- A. The export dump file must be created before starting the import on the target database.
- B. The import operation must be performed on the target database by a user with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user with the DATAPUMP_EXP_FULL_DATABASE role on the source database.
- C. The impdp operation must be performed by the same user that performed the expdp operation.
- D. All user-defined tablespaces must be in read-only mode on the source database.
- E. The source and target databases must be running on the same operating system (OS) with the same endianness.
Answer: B,D,E
Explanation:
In this case we have run the impdp without performing any conversion if endian format is different then we have to first perform conversion.
NEW QUESTION 219
Examine the resources consumed by a database instance whose current Resource Manager plan is displayed.
Which two statements are true? (Choose two.)
- A. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to I/O waits and latch or enqueue contention.
- B. A user belonging to the DSS__QUERIES resource consumer group can create a new session but the session will be queued.
- C. An attempt to start a new session by a user belonging to OTHER_GROUPS fails with an error.
- D. An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.
- E. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.
Answer: B,E
Explanation:
Explanation/Reference:
Explanation:
NEW QUESTION 220
......
Oracle 1z0-062 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
| Topic 9 |
|
| Topic 10 |
|
| Topic 11 |
|
1z0-062 dumps - itPass4sure - 100% Passing Guarantee: https://www.itpass4sure.com/1z0-062-practice-exam.html
