[Sep 03, 2022] Valid 1z0-062 Test Answers Full-length Practice Certification Exams
Accurate & Verified 2022 New 1z0-062 Answers As Experienced in the Actual Test!
Preparation Resources
Now that you can grasp how to get certified, you should review all the 1Z0-062 exam topics in detail on the official Oracle webpage. As you understand, there is a lot of work to be performed, so don't neglect to prepare thoroughly and diligently since your result depends on it. Before registering for the Oracle Database 12c Administration 1Z0-062, assess your strengths and set aside enough time to be fully prepared on the day of the official test. When it comes to preparation materials, there are numerous study tools available to candidates, including free Oracle training, special preparatory courses, and study guides that can be ordered online.
Just for comprehensive preparation for 1Z0-062 exam, the official vendor offers Oracle Database 12c: Administration Workshop. Not only will you significantly reduce your preparation time and save yourself the trouble of finding the relevant information, but you'll also learn everything about Oracle Database architecture. What's more, this program, aimed mostly at database administrators, will help you brilliantly demonstrate your skills in managing the Oracle Database instance, setting up Oracle Network Environment, and maintaining databases.
For candidates aiming not to stop at the Oracle Database 12c Administration 1Z0-062 test, and further down the path to the Oracle certification, an annual Oracle Database Learning Subscription is offered by Oracle experts. In return, you get unlimited access to digital courses to keep pace with evolving Oracle products, hands-on lab sessions to hone your skills in a simulated learning environment, and instructor-coaching sessions, where you can ask remaining questions to lead Oracle experts.
The Oracle 1Z0-062 is one of the two certification exams that you need to pass in order to get the Oracle Database 12c Administrator Certified Associate certificate. The second test is 1Z0-071. The target audience for this exam is those individuals who want to prove their skills in fundamental database terminologies and concepts to guide vital functions for businesses, processes, and systems.
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.
NEW QUESTION 54
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?
- A. It succeedsand the minimum size for the DEFAULT buffer pool is set to 100M.
- B. It succeeds and the value is changed in the SPFILE immediately, but the change takes effect only at the next instance startup.
- C. It fails because ASMM is enabled and individual SGA components cannot be sized.
- D. It fails becauseDB_CACHE_SIZEis a static initialization parameter.
Answer: A
NEW QUESTION 55
Which two statements are true? (Choose two.)
- A. The predefined CONNECTrole is always automatically granted to all new users at the time of their creation.
- B. A role cannot be assigned external authentication.
- C. A role can be granted to other roles.
- D. A role can contain both system and object privileges.
- E. All roles are owned by the SYSuser.
- F. The predefined RESOURCErole includes the UNLIMITED TABLESPACEprivilege.
Answer: C,D
NEW QUESTION 56
The HR.DEPARTMENTS table is the parent of the HR.EMPLOYEES table. The EMPLOYEES.DEPARTMENT_ID column has a foreign key constraint with the ON DELETE CASCADEoption that refers to the DEPARTMENTS.DEPARTMENT_ID column. An index exists on the DEPARTMENTS.DEPARTMENT_ID column.
A transaction deletes a primary key in the DEPARTMENTStable, which has child rows in the EMPLOYEEStable.
Which statement is true?
- A. The transaction acquires a table lock only on the DEPARTMENTStable until the transaction is complete.
- B. Only the rows that are deleted in the DEPARTMENTSand EMPLOYEEStables are locked until the transaction on the DEPARTMENTStable is complete.
- C. The transaction acquires a table lock on the EMPLOYEES table. This lock enables other sessions to query but not update the EMPLOYEEStable until the transaction on the DEPARTMENTS table is complete.
- D. The transaction acquires a table lock on the DEPARTMENTS table. This lock enables other sessions to query but not update the DEPARTMENTStable until the transaction on the DEPARTMENTS table is complete.
Answer: C
NEW QUESTION 57
For which three requirements would you use the Database Resource Manager? (Choose three.)
- A. specifying the maximum number of concurrent sessions allowed for a user
- B. limiting the degree of parallelism of operations performed by user sessions in a consumer group
- C. specifying an idle time limit that applies to sessions that are idle and blocking other sessions
- D. specifying the amount of private space a session can allocate in the shared pool of the SGA.
- E. limiting the CPU used per database call
Answer: A,B,C
Explanation:
References: http://docs.oracle.com/cd/B19306_01/server.102/b14231/dbrm.htm
NEW QUESTION 58
You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name.
Which statement is true?
- A. The ORACLE_BASE base parameter is not set.
- B. The operating system group that is specified should have the root user as its member.
- C. The installation is being performed by the root user.
- D. The operating system group that is specified must have permission to write to the inventory directory.
Answer: D
Explanation:
Note:
Providing a UNIX Group Name
If you are installing a product on a UNIX system, the Installer will also prompt you to provide the name of the group which should own the base directory.
You must choose a UNIX group name which will have permissions to update, install, and deinstall Oracle software. Members of this group must have write permissions to the base directory chosen.
Only users who belong to this group are able to install or deinstall software on this machine.
NEW QUESTION 59
What is the effect of setting the STATISTICS_LEVEL initialization parameter to BASIC?
- A. The Oracle server dynamically generates the necessary object-level statistics on tables as part of query optimization.
- B. Only timed operating system (OS) statistics and plan execution statistics are collected.
- C. Optimizer statistics are collected automatically.
- D. Automatic Workload Repository (AWR) snapshots are not generated automatically.
Answer: D
Explanation:
Explanation/Reference:
References: https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams240.htm#REFRN10214
NEW QUESTION 60
Examine the command:
SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE;
Which two statements are true in this scenario? (Choose two.)
- A. All DDL commands are logged in to a trace file in ADR home.
- B. A subset of executed DDL statements is written into an XML file in ADR home.
- C. All DDL commands are logged in to a text file in Automatic Diagnostic Repository (ADR) home.
- D. A subset of executed DDL statements is written to the DDL log in ADR home.
- E. All data definition language (DDL) commands ae logged in to the alert log file.
Answer: B,D
NEW QUESTION 61
You created an encrypted tablespace:
You then closed the encryption wallet because you were advised that this is secure.
Later in the day, you attempt to create the EMPLOYEES table in the SECURESPACE tablespace with the SALT option on the EMPLOYEE column.
Which is true about the result?
- A. It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.
- B. It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation.
- C. It generates an error when creating the table because the wallet is closed.
- D. It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because the wallet must be opened to encrypt columns with SALT.
Answer: C
NEW QUESTION 62
Which two statements are true about SQL *Loader Express Mode in an Oracle 12c database?
- A. The DEGREE_OF_PARALLELISM parameter is set to AUTO.
- B. You cannot have multiple SQL *Loader data files.
- C. You can selectively load rows into a table based on a filer.
- D. If no data file is specified, it assumes the data file to be <table-name>.dat in the current directory and uses it.
- E. You can have multiple bad files created when loading in parallel.
Answer: A,E
NEW QUESTION 63
Which three factors influence the optimizer's choice of an execution plan? (Choose three.)
- A. object statistics in the data dictionary
- B. cardinality estimates
- C. operating system (OS) statistics
- D. fixed baselines
- E. the optimizer_mode initialization parameter
Answer: A,B,E
NEW QUESTION 64
Which three statements are true about Oracle Data Pump export and import operations?
- A. Data pump import requires the import file to be in a directory owned by the oracle owner.
- B. You can detach from a data pump import job and reattach later.
- C. You can detach from a data pump export job and reattach later.
- D. The master table is the last object to be exported by the data pump.
- E. Data pump uses parallel execution server processes to implement parallel import.
Answer: C,D,E
Explanation:
B: Data Pump can employ multiple worker processes, running in parallel, to increase job performance.
D: For export jobs, the master table records the location of database objects within a dump file set. / Export builds and maintains the master table for the duration of the job. At the end of an export
job, the content of the master table is written to a file in the dump file set.
/ For import jobs, the master table is loaded from the dump file set and is used to control the
sequence of operations for locating objects that need to be imported into the target database.
NEW QUESTION 65
What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database? (Choose two.)
- A. Automatically registers the database with Oracle Restart.
- B. Effectively implements role separation
- C. Helps you to easily upgrade the database from a prior release.
- D. Enables you to take advantage of Oracle Managed Files.
- E. Enables the Installation of Grid Infrastructure files on block or raw devices.
Answer: A,B
Explanation:
C: To use Oracle ASM or Oracle Restart, you must first install Oracle Grid Infrastructure for a standalone server before you install and create the database. Otherwise, you must manually register the database with Oracle Restart.
Desupport of Block and Raw Devices
With the release of Oracle Database 11g release 2 (11.2) and Oracle RAC 11g release 2 (11.2), using Database Configuration Assistant or the installer to store Oracle Clusterware or Oracle Database files directly on block or raw devices is not supported.
If you intend to upgrade an existing Oracle RAC database, or an Oracle RAC database with Oracle ASM instances, then you can use an existing raw or block device partition, and perform a rolling upgrade of your existing installation. Performing a new installation using block or raw devices is not allowed.
NEW QUESTION 66
Which three statements are true about the purpose of checkpoints?
- A. They ensure that instance recovery starts in the event of an instance failure.
- B. They reduce the time required for recovery in case of an instance failure.
- C. They ensure that uncommitted transactions are rolledback in case of an instance failure.
- D. They ensure that all the dirty buffers are written to disk during a normal shutdown.
- E. They ensure that dirty buffers in the buffer cache are written to disk regularly.
Answer: A,B,E
Explanation:
References:http://docs.oracle.com/cd/E36909_01/server.1111/e25789/startup.htm#BABGD
ACG
NEW QUESTION 67
Your database is configured for ARCHIVELOGmode, and a daily full database backup is taken. RMAN is
configured to perform control file autobackup.
In which three scenarios do you need media recovery? (Choose three.)
- A. logical corruption of data that is caused by a wrong transaction
- B. loss of a data file that belongs to the active undo tablespace
- C. abnormal termination of the database instance
- D. loss of all the copies of the control file
- E. loss of all the inactive online redo log group members
- F. loss of data files that belong to the SYSTEMtablespace
Answer: B,D,F
NEW QUESTION 68
Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?
- A. creation of a fine-grained audit policy
- B. execution of SQL statements by users connected with the SYSDBAprivilege
- C. usage of the AUDITstatement
- D. configuration of unified auditing mode
Answer: B
Explanation:
Explanation/Reference:
References https://docs.oracle.com/cd/B28359_01/network.111/b28531/auditing.htm#DBSEG0622
NEW QUESTION 69
A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL:
There is enough free space in the disk group for mirroring to be done.
What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?
- A. ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.
- B. Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.
- C. Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.
- D. Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.
- E. The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.
Answer: A
NEW QUESTION 70
Examine this command executed on a client that is remote from the database server.
SQL> CONNECT hr/hr@orcl
Which two are required for this command to connect the SQLPLUS client to a database instance? (Choose two.)
- A. An orclTNS entry must be defined in the client-side and server-side tnsnames.orafiles
- B. An orclTNS entry must be defined in the client-side tnsnames.orafile
- C. A service name must be defined to the listener that matches the service name in the orclTNS entry
- D. The service name orclmust be defined to the listener
- E. An orclTNS entry must be defined in the server-side tnsnames.orafile
Answer: D,E
NEW QUESTION 71
Which three statements are true about the working of system privileges in a multitenant control database (CDB) that has pluggable databases (PDBs)? (Choose three.)
- A. Local users cannot use local system privileges on the schema of a common user.
- B. The granter of system privileges must possess the set container privilege.
- C. System privileges apply only to the PDB in which they are used.
- D. System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.
- E. Common users connected to a PDB can exercise privileges across other PDBs.
Answer: B,C,D
Explanation:
Explanation/Reference:
Explanation:
A, Not D: In a CDB, PUBLIC is a common role. In a PDB, privileges granted locally to PUBLIC enable all local and common users to exercise these privileges in this PDB only.
C: A user can only perform common operations on a common role, for example, granting privileges commonly to the role, when the following criteria are met:
The user is a common user whose current container is root.
The user has the SET CONTAINER privilege granted commonly, which means that the privilege applies in all containers.
The user has privilege controlling the ability to perform the specified operation, and this privilege has been granted commonly Incorrect:
Note:
* Every privilege and role granted to Oracle-supplied users and roles is granted commonly except for system privileges granted to PUBLIC, which are granted locally.
NEW QUESTION 72
You want to create a database and you have the following:
- Oracle Grid Infrastructure is installed and configured.
- Oracle Database Vault is installed in ORACLE_HOME to be used for this database.
- Oracle Enterprise Manager Cloud Control is available and an agent is deployed on the database server.
Examine the requirements:
1. configuring the database instance to support shared server mode
2. using Automatic Storage Management (ASM) for storing database files.
3. configuring a naming method to help a remote user connect to a database instance
4. configuring the Fast Recovery Area
5. configuring Database Vault
6. configuring Enterprise Manager (EM) Database Express
7. registering with EM Cloud Control
8. configuring remote log archive destinations
9. enabling daily incremental backups
10. configuring a nondefault block size for nondefault block size tablespaces
Which of these requirements can be met while creating a database by using the Database Configuration Assistant (DBCA)?
- A. 1, 2, 3, 8, 9 and 10
- B. 1, 2, 4, 5, 6 and 7
- C. 1, 2, 4, 5, 6, 7 and 8
- D. 1, 2, 4, 5, 7, 8, 9 and 10
- E. 1, 2, 3, 4, 6, 8, 9 and 10
Answer: E
NEW QUESTION 73
You install "Oracle Grid Infrastructure for a standalone server" on a host on which the ORCL1 and ORCL2 databases
both have their instances running.
Which two statements are true?
- A. The crsctl start has command must be used to start software services for Oracle Automatic Storage Management
(ASM) after the "Oracle Grid Infrastructure for a standalone server" installation is complete. - B. The srvctl add database command must be used to add ORCL1 and ORCL2 to the ORACLE Restart configuration.
- C. Both ORCL1 and ORCL2 are automatically added to the Oracle Restart configuration.
- D. All database listeners running from the database home are automatically added to the Oracle Restart configuration.
- E. All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added
to the Oracle Restart configuration.
Answer: B,D
NEW QUESTION 74
Identify three benefits of Unified Auditing.
- A. It guarantees zero-loss auditing.
- B. Decreased use of storage to store audit trail rows in the database.
- C. It automatically audits Recovery Manager (RMAN) events.
- D. The audit trail cannot be easily modified because it is read-only.
- E. It improves overall auditing performance.
Answer: B,C,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 75
Which three operations can be performed as multipartition operations in Oracle?
- A. Coalesce partitions of a hash-partitioned global index.
- B. Merge partitions of a reference partitioned index
- C. Move partitions of a range-partitioned table
- D. Rename partitions of a range partitioned table
- E. Drop partitions of a list partitioned table
- F. Merge partitions of a list partitioned table
Answer: B,E,F
Explanation:
Multipartition maintenance enables adding, dropping, truncate, merge, split operations on multiple partitions.
A: Merge Multiple Partitions:
The new "ALTER TABLE ... MERGE PARTITIONS " help merge multiple partitions or subpartitions with a single
statement. When merging multiple partitions, local and global index operations and semantics for inheritance of
unspecified physical attributes are the same for merging two partitions.
B: Drop Multiple Partitions:
The new "ALTER TABLE ... DROP PARTITIONS " help drop multiple partitions or subpartitions with a single statement.
Example:
view plaincopy to clipboardprint?
SQL> ALTER TABLE Tab_tst1 DROP PARTITIONS
Tab_tst1_PART5, Tab_tst1_PART6, Tab_tst1_PART7;
Table altered
SQL>
Restrictions :
-You can't drop all partitions of the table.
-If the table has a single partition, you will get the error: ORA-14083: cannot drop the only partition of a partitioned.
NEW QUESTION 76
You execute the following commands to audit database activities:
SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE;
SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER
SUCCESSFUL;
Which statement is true about the audit record that generated when auditing after instance restarts?
- A. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE
command on a table, and contains the SQL text for the SQL Statements. - B. One audit record is created for the whole session if JOHN successfully executes a select command,
and contains the SQL text and bind variables used. - C. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or
DELETE command, and contains the execution plan for the SQL statements. - D. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE
command, and contains the execution plan for the SQL statements. - E. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or
DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.
Answer: A
Explanation:
Explanation/Reference:
Explanation:
Note:
* BY SESSION
In earlier releases, BY SESSION caused the database to write a single record for all SQL statements or
operations of the same type executed on the same schema objects in the same session. Beginning with
this release (11g) of Oracle Database, both BY SESSION and BY ACCESS cause Oracle Database to
write one audit record for each audited statement and operation.
* BY ACCESS
Specify BY ACCESS if you want Oracle Database to write one record for each audited statement and
operation.
Note:
If you specify either a SQL statement shortcut or a system privilege that audits a data definition language
(DDL) statement, then the database always audits by access. In all other cases, the database honors the
BY SESSION or BY ACCESS specification.
* For each audited operation, Oracle Database produces an audit record containing this
information:
/The user performing the operation
/The type of operation
/The object involved in the operation
/The date and time of the operation
NEW QUESTION 77
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?
- A. It executes successfully and sets $ORACLE_HOME/dbs as the default archive destination.
- B. It executes successfully and issues a warning to set LOG_ARCHIVE_DEST while opening the database.
- C. It fails and returns an error about LOG_ARCHIVE_DEST not being set.
- D. It executes successfully and sets the Fast Recovery Area as the local archive destination.
Answer: D
NEW QUESTION 78
......
Certification Topics of 1z0-062 Exam PDF Recently Updated Questions: https://examtorrent.actualcollection.com/1z0-062-exam-questions.html