380 Exam Questions for 1z0-062 Updated Versions With Test Engine
Pass 1z0-062 Exam with Updated 1z0-062 Exam Dumps PDF 2022
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:
- 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.
- ‘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.
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.
Oracle 1z0-062 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
NEW QUESTION 105
You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database
12c.
Examine the table definition:
Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?
- A. Setting the session valid time using DBMS_FLASHBACK_ARCHIVENABLE_AT_VALID_TIME sets the visibility for
data manipulation language (DML), data definition language (DDL), and queries performed by the session. - B. The valid time columns employee_time_start and employee_time_end are automatically created.
- C. The valid time columns are visible by default when the table is described.
- D. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP
and PERIOD FOR clauses. - E. The valid time columns are not populated by the Oracle Server automatically.
Answer: A,B,D
Explanation:
A: To implement Temporal Validity(TV), 12c offers the option to have two date columns in that table which is having
TV enabled using the new clause Period For in the Create Table for the newly created tables or in the Alter Table for
the existing ones. The columns that are used can be defined while creating the table itself and will be used in the
Period For clause or you can skip having them in the table's definition in the case of which, the Period For clause
would be creating them internally.
E: ENABLE_AT_VALID_TIME Procedure
This procedure enables session level valid time flashback.
NEW QUESTION 106
Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.
You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:
SQL > SHUTDOWN IMMEDIATE SQL > STARTUP MOUNT SQL > FLASHBACK DATABASE to TIME "TO_DATE ('08/20/12' , 'MM/DD/YY')";
Examine following commands:
1.ALTER PLUGGABLE DATABASE ALL OPEN;
2.ALTER DATABASE OPEN;
3.ALTER DATABASE OPEN RESETLOGS;
Which command or commands should you execute next to allow updates to the flashback back schema?
- A. 3 and 1
- B. 1 and 2
- C. Only 3
- D. Only 2
- E. Only 1
Answer: C
Explanation:
Example (see step23):
Step 1:
Run the RMAN FLASHBACK DATABASE command.
You can specify the target time by using a form of the command shown in the following examples:
FLASHBACK DATABASE TO SCN 46963;
FLASHBACK DATABASE
TO RESTORE POINT BEFORE_CHANGES;
FLASHBACK DATABASE TO TIME
"TO_DATE('09/20/05','MM/DD/YY')";
When the FLASHBACK DATABASE command completes, the database is left mounted and
recovered to the specified target time.
Step 2:
Make the database available for updates by opening the database with the RESETLOGS option. If
the database is currently open read-only, then execute the following commands in SQL*Plus:
SHUTDOWN IMMEDIATE
STARTUP MOUNT
ALTER DATABASE OPEN RESETLOGS;
NEW QUESTION 107
An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges.
A multitenant container database (CDB) instant has the following parameter set:
THREADED_EXECUTION = FALSE
Which four statements are true about this administrator establishing connections to root in a CDB that has
been opened in read only mode? (Choose four.)
- A. You can connect as a local user by using the connect statement.
- B. You can connect as a local user by using the SET CONTAINER statement.
- C. You can connect by using a Net Service name.
- D. You can connect by using OS authentication.
- E. You can connect as a common user by using the connect statement.
- F. You can connect by using easy connect.
Answer: C,D,E,F
NEW QUESTION 108
A user establishes a connection to a database instance by using an Oracle Net connection. You want to ensure the following:
1. The user account must be locked after five unsuccessful login attempts.
2. Data read per session must be limited for the user.
3. The user cannot have more than three simultaneous sessions.
4. The user must have a maximum of 10 minutes session idle time before being logged off automatically.
How would you accomplish this?
- A. by granting a secure application role to the user
- B. by assigning a profile to the user
- C. by implementing Database Resource Manager
- D. by using Oracle Label Security options
Answer: B
NEW QUESTION 109
Which three factors influence the optimizer's choice of an execution plan?
- A. cardinality estimates
- B. operating system (OS) statistics
- C. object statistics in the data dictionary
- D. the optimizer_mode initialization parameter
- E. fixed baselines
Answer: A,B,D
Explanation:
Reference: http://docs.oracle.com/cd/B19306_01/server.102/b14211/optimops.htm
NEW QUESTION 110
Which four actions are possible during an Online Data file Move operation? (Choose four.)
- A. Creating and dropping tables in the data file being moved
- B. Querying tables in the data file being moved
- C. Flashing back the database
- D. Performing Block Media Recovery for a data block in the data file being moved
- E. Performing file shrink of the data file being moved
- F. Executing DML statements on objects stored in the data file being moved
Answer: A,B,C,F
Explanation:
Explanation
- You can now move On line Datafile without hove to stop Monoged Recovery and manually copy and rename Files. This can even be used to move Datafiles from or to ASM.
- New in Oracle Database 12c: FROM METAUNK. Physical Standby Database is in Active Data Guard Mode (opened READ ONLY and Managed Recovery is running):
It is now possible to online move a Datafile while Managed Recovery is running, ie. the Physical Standby Database is in Active Data Guard Mode. You con use this Command to move the Datafile
- A flashback operation does not relocate a moved data file to its previous location. If you move a data file online from one location to another and later flash back the database to a point in time before the move, then the Data file remains in the new location, but the contents of the Data file ore changed to the contents at the time specified in the flashback. Oracle0 Database Administrator's Guide 12c Release 1 (12.1)
NEW QUESTION 111
You execute the following piece of code with appropriate privileges:
User SCOTT has been granted the CREATE SESSION privilege and the MGR role.
Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table? (Choose two.)
- A. Data is never redacted for the EMP_V.SAL column.
- B. Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.
- C. Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.
- D. Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.
- E. Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.
Answer: A,E
Explanation:
Explanation
Note:
* DBMS_REDACT.FULL completely redacts the column data.
* DBMS_REDACT.NONE applies no redaction on the column data. Use this function for development testing purposes. LOB columns are not supported.
* The DBMS_REDACT package provides an interface to Oracle Data Redaction, which enables you to mask (redact) data that is returned from queries issued by low-privileged users or an application.
* If you create a view chain (that is, a view based on another view), then the Data Redaction policy also applies throughout this view chain. The policies remain in effect all of the way up through this view chain, but if another policy is created for one of these views, then for the columns affected in the subsequent views, this new policy takes precedence.
NEW QUESTION 112
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 the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.
- B. 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.
- C. 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.
- D. 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.
- 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: C
Explanation:
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
References:
NEW QUESTION 113
Which three statements are true about server-generated alerts? (Choose three.)
- A. Stateful alerts can be queried only from the DBA_ALERT_HISTORY view.
- B. When an alert is cleared, it is moved to the DBA_ALERT_HISTORY view.
- C. Alerts are not issued for locally managed read-only tablespaces.
- D. Response actions cannot be specified for server-generated alerts.
- E. Server-generated alerts notify administrators of problems that cannot be resolved automatically.
Answer: B,C,E
Explanation:
Explanation
References https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema001.htm#ADMIN10120
NEW QUESTION 114
Your database is configured in ARCHIVELOG mode.
Examine the RMAN configuration parameters:
Examine the command:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which two are true? (Choose two.)
- A. It fails because the DELETE INPUT option can be used only with the BACKUP AS COPY command
- B. It creates image copies of the database files
- C. It creates a backupset of archive log files
- D. It creates image copies of the archivelogs
- E. It fails because the DELETE INPUT option can be used only with the BACKUP AS BACKUPSET command
Answer: D,E
NEW QUESTION 115
As a user of the ORCL database, you establish a database link to the remote HQ database such that all users in the ORCL database may access tables only from the SCOTT schema in the HQ database. SCOTT's password is TIGER. The service mane "HQ" is used to connect to the remote HQ database.
Which command would you execute to create the database link?
- A. CREATE PUBLIC DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger
USING 'HQ'; - B. CREATE DATABASE LINK HQ CONNECT TO CURRENT_USER USING 'HQ';
- C. CREATE DATABASE LINK HQ USING 'HQ';
- D. CREATE DATABASE LINKHQ CONNECT TO scott IDENTIFIED BY tiger USING 'HQ';
Answer: B
NEW QUESTION 116
Which three statements are true about SQL plan directives?
- A. They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more
optimal plan. - B. They instruct the optimizer to create only column group statistics.
- C. They are used to gather only missing statistics.
- D. They are tied to a specific statement or SQL ID.
- E. Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace.
- F. They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer
are incorrect.
Answer: A,B,F
Explanation:
During SQL execution, if a cardinality misestimate occurs, then the database creates SQL plan directives. During SQL
compilation, the optimizer examines the query corresponding to the directive to determine whether missing
extensions or histograms exist (D). The optimizer records any missing extensions. Subsequent DBMS_STATS calls
collect statistics for the extensions.
The optimizer uses dynamic sampling whenever it does not have sufficient statistics corresponding to the directive. (B,
not C)
E: Currently, the optimizer monitors only column groups. The optimizer does not create an extension on expressions.
Incorrect:
Not A: SQL plan directives are not tied to a specific SQL statement or SQL ID.
Note:
* A SQL plan directive is additional information and instructions that the optimizer can use to generate a more
optimal plan. For example, a SQL plan directive can instruct the optimizer to record a missing extension.
NEW QUESTION 117
Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?
(Choose three.)
- A. A DBA can check specific tables with the DMU
- B. The release of the database to be converted can be any release since 9.2.0.8.
- C. The database to be migrated must be opened read-only.
- D. The DMU can report columns that are too long in the converted characterset.
- E. The DMU can report columns that are not represented in the converted characterset.
Answer: A,D,E
Explanation:
Explanation
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 limit
The cell data will not fit into a column after conversion.
E: Need conversion
The 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 118
The DEFERRED_SEGMENT_CREATION parameter is set to TRUE in your database instance.
You execute the following command to create a table:
Which two statements are true? (Choose two.)
- A. A segment is allocated when the first row is inserted in the table.
- B. The table is created and extents are immediately allocated as per the default storage defined for its tablespace.
- C. A segment is allocated for the table if the ALTER TABLE... ALLOCATE EXTENT command is issued.
- D. The table is created without a segment because the storage clause is missing.
- E. A segment is allocated when an index is created for any column in the table.
Answer: A,C
NEW QUESTION 119
What action must you take to ensure complete database recovery till the point of failure?
- A. Configure the database to run in ARCHIVELOG mode.
- B. Duplex the RMAN backup sets.
- C. Multiplex the control files
- D. Multiplex the online redo log files.
Answer: A
NEW QUESTION 120
Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following
command in the root container:
Which two statements are true?
- A. The schema for the common user C # # A_ADMIN can be different in each container.
- B. The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.
- C. Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.
- D. The command will create a user in the root container only because the container clause is not used.
- E. The command will, create a common user whose description is contained in the root and each PDB.
Answer: A,E
NEW QUESTION 121
Which two statements are true about the Oracle Direct Network File system (DNFS)? (Choose two.)
- A. Direct NFS can load-balance I/O traffic across multiple network adapters.
- B. Direct NFS is available only in UNIX platforms.
- C. A traditional NFS mount is not required when using Direct NFS.
- D. Oracle Disk Manager can manage NFS on its own, without using the operating kernel NFS driver.
- E. It utilizes the OS file system cache.
Answer: A,D
Explanation:
Explanation/Reference:
Explanation:
E: Performance is improved by load balancing across multiple network interfaces (if available).
Note:
* To enable Direct NFS Client, you must replace the standard Oracle Disk Manager (ODM) library with one that supports Direct NFS Client.
Incorrect:
Not A: Direct NFS Client is capable of performing concurrent direct I/O, which bypasses any operating system level caches and eliminates any operating system write-ordering locks Not B:
* To use Direct NFS Client, the NFS file systems must first be mounted and available over regular NFS mounts.
* Oracle Direct NFS (dNFS) is an optimized NFS (Network File System) client that provides faster and more scalable access to NFS storage located on NAS storage devices (accessible over TCP/IP).
Not D: Direct NFS is provided as part of the database kernel, and is thus available on all supported database platforms - even those that don't support NFS natively, like Windows.
Note:
* Oracle Direct NFS (dNFS) is an optimized NFS (Network File System) client that provides faster and more scalable access to NFS storage located on NAS storage devices (accessible over TCP/IP). Direct NFS is built directly into the database kernel - just like ASM which is mainly used when using DAS or SAN storage.
* Oracle Direct NFS (dNFS) is an internal I/O layer that provides faster access to large NFS files than traditional NFS clients.
NEW QUESTION 122
Which two statements describe the relationship between a scheduler window, a resource manager plan, and a job class?
- A. Ascheduler window together with a job class, controls resource allocation for a job using that job class in that scheduler window.
- B. A job class specifies a scheduler window that will be open when that job class becomes active.
- C. A scheduler window specifies a job class that will be activated when that scheduler window becomes active.
- D. A scheduler window can control resource allocation by itself.
- E. A scheduler window specifies a resource manager plan that will be activated when that scheduler window becomes active.
Answer: C,D
NEW QUESTION 123
In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer.
Which statement is true?
- A. The CDB must be open.
- B. The CDB must be in the nomount stage.
- C. The CDB must be in the mount stage.
- D. Alt existing PDBs must be closed.
Answer: A
Explanation:
Explanation
* Creating a PDB
Rather than constructing the data dictionary tables that define an empty PDB from scratch, and then populating its Obj$ and Dependency$ tables, the empty PDB is created when the CDB is created. (Here, we use empty to mean containing no customer-created artifacts.) It is referred to as the seed PDB and has the name PDB$Seed.
Every CDB non-negotiably contains a seed PDB; it is non-negotiably always open in read-only mode. This has no conceptual significance; rather, it is just an optimization device. The create PDB operation is implemented as a special case of the clone PDB operation. The size of the seed PDB is only about 1 gigabyte and it takes only a few seconds on a typical machine to copy it.
NEW QUESTION 124
DAILY_ORDS_LST is created in locally managed tablespace ORDERS_TBS which uses automatic segment space management.
Which two are true? (Choose two.)
- A. 20% of each data block in the table is reserved for row updates
- B. PCTFREE can help to minimize row chaining during inserts
- C. PCTFREE eliminates row chaining during inserts
- D. 80% of every data block in daily_ords_list is reserved for row inserts
- E. PCTFREE can help reduce row migration during updates
Answer: A,E
NEW QUESTION 125
Which three statements are true about space usage alerts?
- A. Alerts are issued only when the critical threshold for space available in a tablespace is breached.
- B. The sum of active extents and allocated user quotas is considered to compute space usage for an undo tablespace.
- C. Alerts are not issued for locally managed tablespaces that are offline or in read-only mode.
- D. A newly created locally managed tablespace is automatically assigned the default threshold values defined for a database.
- E. Database alerts can provide warnings about low space availability at both tablespace and segment levels.
Answer: A,C,D
Explanation:
Explanation/Reference:
References: https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema001.htm#ADMIN10120
NEW QUESTION 126
You want to capture column group usage and gather extended statistics for better cardinality estimates for the
CUSTOMERS table in the SH schema.
Examine the following steps:
1. Issue the SELECT DBMS_STATS.CREATE_EXTENDED_STATS ('SH', 'CUSTOMERS') FROM dual statement.
2. Execute the DBMS_STATS.SEED_COL_USAGE (null, 'SH', 500) procedure.
3. Execute the required queries on the CUSTOMERS table.
4. Issue the SELECT DBMS_STATS.REPORT_COL_USAGE ('SH', 'CUSTOMERS') FROM dual statement.
Identify the correct sequence of steps.
- A. 3, 2, 4, 1
- B. 2, 3, 4, 1
- C. 4, 1, 3, 2
- D. 3, 2, 1, 4
Answer: B
Explanation:
Step 1 (2). Seed column usage
Oracle must observe a representative workload, in order to determine the appropriate column groups. Using the new
procedure DBMS_STATS.SEED_COL_USAGE, you tell Oracle how long it should observe the workload.
Step 2: (3) You don't need to execute all of the queries in your work during this window. You can simply run explain
plan for some of your longer running queries to ensure column group information is recorded for these queries.
Step 3. (1) Create the column groups
At this point you can get Oracle to automatically create the column groups for each of the tables based on the usage
information captured during the monitoring window. You simply have to call the
DBMS_STATS.CREATE_EXTENDED_STATS function for each table.This function requires just two arguments, the schema
name and the table name. From then on, statistics will be maintained for each column group whenever statistics are
gathered on the table.
Note:
* DBMS_STATS.REPORT_COL_USAGE reports column usage information and records all the SQL operations the
database has processed for a given object.
* The Oracle SQL optimizer has always been ignorant of the implied relationships between data columns within the
same table. While the optimizer has traditionally analyzed the distribution of values within a column, he does not
collect value-based relationships between columns.
* Creating extended statisticsHere are the steps to create extended statistics for related table columns
withdbms_stats.created_extended_stats:
1 - The first step is to create column histograms for the related columns.2 - Next, we run
dbms_stats.create_extended_stats to relate the columns together.
Unlike a traditional procedure that is invoked via an execute ("exec") statement, Oracle extended statistics are created
via a select statement.
NEW QUESTION 127
Examine the parameters:
Users complain that their sessions for certain transactions hang. You investigate and discover that some users fail to complete their transactions, causing other transactions to wait on row-level locks.
Which two actions would you take to prevent this problem? (Choose two.)
- A. Set a limit in the profiles of blocking users to control the number of data blocks that can be accessed in a session.
- B. Increase the maximum number of ITL slots for segments on which a blocking user performs a transaction.
- C. Decrease the SESSIONS_PER_USER limit in the profiles assigned to blocking users.
- D. Decrease the IDLE_TIME resource limit in the profiles assigned to blocking users.
- E. Use Database Resource Manager to automatically kill the sessions that are idle and are blocking other sessions.
Answer: C,E
NEW QUESTION 128
......
More Info
For more info visit: Oracle 12c Official 1Z0-062 Exam Reference
1z0-062 Exam Dumps - Free Demo & 365 Day Updates: https://www.guidetorrent.com/1z0-062-pdf-free-download.html