Oracle 1z0-062 Practice Verified Answers - Pass Your Exams For Sure! [2021]
Valid Way To Pass Oracle Database's 1z0-062 Exam
NEW QUESTION 135
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 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.
- B. 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.
- C. The transaction acquires a table lock only on the DEPARTMENTStable until the transaction is complete.
- D. Only the rows that are deleted in the DEPARTMENTSand EMPLOYEEStables are locked until the transactions on the DEPARTMENTStable is complete.
Answer: A
NEW QUESTION 136
You want to schedule a job to rebuild a table’s indexes after a bulk insert, which must be scheduled as soon as a file containing data arrives on the system.
What would you do to accomplish this?
- A. Create a file watcher and an event-based job for bulk insert and then create another job to rebuild indexes on the table.
- B. Create an event-based job for the file arrival event, then create a job for bulk insert, and then create a job to rebuild indexes.
- C. Create a file watcher for the bulk inserts and then create a job to rebuild indexes.
- D. Create a job array and add a job for bulk insert and a job to rebuild indexes to the job array.
Answer: A
NEW QUESTION 137
Which three statements are true about Oracle Restart?
- A. It can be configured toautomatically attempt to restart various components after a hardware or software failure.
- B. While starting any components, it automatically attempts to start all dependencies first and in proper order.
- C. It can be configured to automatically restart a database in case of normal shutdown of the database instance.
- D. It runs periodic check operations to monitor the health of Oracle components.
- E. It can be used to only start Oracle components.
Answer: A,B,D
NEW QUESTION 138
You notice a performance change in your production Oracle database and you want to know which change has made this performance difference.
You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation.
Which three findings would you get from the report? (Choose three.)
- A. It identifies any workload change that caused a performance difference in both time periods.
- B. It detects the top wait events causing performance degradation.
- C. It shows the difference in the size of memory pools in both time periods.
- D. It detects any configuration change that caused a performance difference in both time periods.
- E. It shows the resource usage for CPU, memory, and I/O in both time periods.
- F. It gives information about statistics collection in both time periods.
Answer: A,D,E
Explanation:
Keyword: shows the difference.
* Full ADDM analysis across two AWR snapshot periods
Detects causes, measure effects, then correlates them
Causes: workload changes, configuration changes
Effects: regressed SQL, reach resource limits (CPU, I/O, memory, interconnect) Makes actionable recommendations along with quantified impact
* Identify what changed
/ Configuration changes, workload changes
* Performance degradation of the database occurs when your database was performing optimally in the past, such as 6 months ago, but has gradually degraded to a point where it becomes noticeable to the users. The Automatic Workload Repository (AWR) Compare Periods report enables you to compare database performance between two periods of time.
While an AWR report shows AWR data between two snapshots (or two points in time), the AWR Compare Periods report shows the difference (ABE) between two periods (or two AWR reports with a total of four snapshots). Using the AWR Compare Periods report helps you to identify detailed performance attributes and configuration settings that differ between two time periods.
NEW QUESTION 139
A redaction policy was added to the SAL column of the SCOTT.EMP table:
All users have their default set of system privileges.
For which three situations will data not be redacted? (Choose three.)
- A. SYS sessions, regardless of the roles that are set in the session
- B. SCOTT sessions, only if the MGR role is granted to SCOTT
- C. SYSTEM sessions, regardless of the roles that are set in the session
- D. SCOTT sessions, because he is the owner of the table
- E. SYSTEM session, only if the MGR role is set in the session
- F. SCOTT sessions, only if the MGR role is set in the session
Answer: A,B,C
NEW QUESTION 140
Your database is open and the listener LISTNENER is up. You issue the command:
LSNRCTL> RELOAD
What is the effect of reload on sessions that were originally established by listener?
- A. The sessions are not affected and continue to function normally.
- B. Only sessions based on static listener registrations are disconnected.
- C. All the sessions are terminated and active transactions are rolled back.
- D. Existing connections are not disconnected; however, they cannot perform any operations until the listener
completes the re-registration of the database instance and service handlers.
Answer: D
NEW QUESTION 141
The user SCOTT owns the CUST table that is placed in the SALES tablespace. The user SCOTT opens a session and
executes commands as follows:
SQL> INSERT INTO cust VALUES(101, 'JACK');
1 row created.
SQL> INSERT INTO cust VALUES(102, 'SMITH');
1 row created.
As a DBA, you execute the following command from another session:
ALTER TABLESPACE sales READ ONLY;
Which statement is true regarding the effect of this command on the transaction in Scott's session?
- A. The command hangs until all transactions on the objects in the tablespace commit or rollback, and then the
tablespace is placed in readonly mode. - B. The command waits and the user SCOTT can execute data manipulation language (DML) statements only as part of
the current transaction. - C. The command fails as a transaction is still pending.
- D. The transaction in Scott's session is rolled back and the tablespace becomes readonly.
Answer: B
Explanation:
You can issue the ALTER TABLESPACE...READ ONLY statement while the database is processing transactions. After the
statement is issued, the tablespace is put into a transitional read-only state. No transactions are allowed to make
further changes (using DML statements) to the tablespace. If a transaction attempts further changes, it is terminated
and rolled back. However, transactions that already made changes and that attempt no further changes are allowed
to commit or roll back.
NEW QUESTION 142
You execute this command:
Which two statements are true about segment space management for segments in this tablespace?
- A. Space utilization inside segments is mapped by bitmaps.
- B. Segments are automatically shrunk and compressed when rows are deleted.
- C. ThePCTUSEDstorageparameter has no effect on segments created in this tablespace.
- D. ThePCTFREEstorage parameter has no effect on segments created in this tablespace.
Answer: A,C
NEW QUESTION 143
Which two statements are true about the logical storage structure of an Oracle database? (Choose two.)
- A. It is possible to have tablespaces of different block sizes.
- B. Each data block always corresponds to one operating system block.
- C. An extent can span multiple segments.
- D. An extent contains data blocks that are always physically contiguous on disk.
- E. A data block is the smallest unit of I/O in data files.
Answer: A,E
Explanation:
References:
NEW QUESTION 144
In your database, USERSis 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 MYTABtable is owned by the SYSuser.
- B. The MYTABtable is created in the SYSTEMtablespace but no rows can be inserted into the table by USER02.
- C. The MYTAB table is created in the USERStablespace but no rows can be inserted into the table by USER02.
- D. The CREATE TABLE statement generates an error because the SYSDBAprivilege does not provide any space quota on the SYSTEMtablespace by default.
- E. The MYTABtable is created in the SYSTEMtablespace and rows can be inserted into the table by USER02.
Answer: A,E
NEW QUESTION 145
You execute this command:
Which two statements are true about segment space management for segments in this tablespace?
- A. Space utilization inside segments is mapped by bitmaps.
- B. Segments are automatically shrunk and compressed when rows are deleted.
- C. The PCTUSEDstorage parameter has no effect on segments created in this tablespace.
- D. The PCTFREEstorage parameter has no effect on segments created in this tablespace.
Answer: A,C
NEW QUESTION 146
Which two statements are true about Oracle Data Pump export and import operations? (Choose two.)
- 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 export job and reattach later.
- C. The master table is the last object to be exported by the data pump.
- D. Data pump uses parallel execution server processes to implement parallel import.
- E. You can detach from a data pump import job and reattach later.
Answer: B,D
Explanation:
Explanation/Reference:
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 147
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. Increase the maximum number of ITL slots for segments on which a blocking user performs a
transaction. - B. Decrease the SESSIONS_PER_USERlimit in the profiles assigned to blocking users.
- C. Set a limit in the profiles of blocking users to control the number of data blocks that can be accessed in
a session. - D. Decrease the IDLE_TIMEresource 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: B,E
NEW QUESTION 148
Examine the following query output:
You issue the following command to import tables into the hr schema:
$ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr
TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y
Which statement is true?
- A. Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.
- B. All database operations performed by the impdp command are logged.
- C. Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.
- D. None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.
Answer: A
Explanation:
Explanation
Oracle Data Pump disable redo logging when loading data into tables and when creating indexes.
The new TRANSFORM option introduced in data pumps import provides the flexibility to turn off the redo generation for the objects during the course of import. The Master Table is used to track the detailed progress information of a Data Pump job.
The Master Table is created in the schema of the current user running the Pump Dump export or import, and it keeps tracks of lots of detailed information.
NEW QUESTION 149
You have just completed a manual upgrade of an Oracle 11g Database to Oracle Database
12c.
The Post-Upgrade Status Tool reports an INVALID status for some of the components after the upgrade.
What must you do first in this situation to attempt to fix this problem?
- A. Runutlrp.sqlto recompile stored PL/SQL and Java code and check
theDBA_REGISTRYview. - B. Runpreupgrd.sqland then execute the generated "fix-up" scripts to resolve status issues.
- C. Runutluiobj.sqlto filter out objects that were invalidated by the upgrade process.
- D. Runcatuppst.sqlto perform revalidation actions
Answer: B
NEW QUESTION 150
Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:
What are three possible causes for the latch-related wait events?
- A. A large number COMMITS are being performed.
- B. There are frequent logons and logoffs.
- C. The size of the shared pool is too small.
- D. The buffers are being read into the buffer cache, but some other session is changing the buffers.
- E. Cursors are not being shared.
Answer: C,D,E
Explanation:
Explanation/Reference:
Explanation:
https://logicalread.com/oracle-latch-free-wait-dr01/#.WQygk1i6zUI
NEW QUESTION 151
Which three statements are true about Enterprise Manager Database Express? (Choose three.)
- A. The same port number is used for multiple Database Express configurations on the same host.
- B. It can use the HTTPS protocol.
- C. It can be used to perform database backup operations.
- D. It can use the HTTP protocol.
- E. It is available only when the database is open.
Answer: B,D,E
NEW QUESTION 152
Which three statements are true about Flashback Database? (Choose three.)
- A. Flashback Database can recover a data file that was dropped during the span of time of the flashback.
- B. Flashback Database can recover a database to the state that it was in before a reset logs operation.
- C. Flashback Database uses a restored control file to recover a database.
- D. The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery
Area. - E. Flashback logs are written sequentially, and are archived.
- F. Flashback logs are used to restore to the blocks before images, and then the redo data may be used to
roll forward to the desired flashback time.
Answer: B,D,F
NEW QUESTION 153
Your database instance has Automatic Memory Management enabled and supports shared server connections.
Examine the following:
1 . Parallel execution messages and control structures
2 . Local variables for a process
3 . Security and resource usage information
4 . Runtime memory values, such as rows retrieved for a SQL statement using a serial execution plan
5. SQL execution work areas
Which option indicates what is allocated from the large pool in this instance?
- A. only 1
- B. 1, 2, 3, and 5
- C. 1, 2, and 4
- D. 1, 2, and 5
Answer: C
NEW QUESTION 154
You determine that database performance is sub-optimal due to hard parsing statements.
Automatic Shared Memory Management (ASMM) is disabled for your database instance.
Which tool would you use to get advice on how to improve performance?
- A. Memory Advisor for the shared pool
- B. SQL Access Advisor
- C. SQL Tuning Advisor
- D. Memory Advisor for the PGA
Answer: A
Explanation:
References:
http://docs.oracle.com/cd/E25178_01/server.1111/e10897/montune.htm#CHDGFCFJ
NEW QUESTION 155
......
Oracle 1z0-062 Pre-Exam Practice Tests | TrainingDump: https://www.trainingdump.com/Oracle/1z0-062-practice-exam-dumps.html
1z0-062 practice test questions, answers, explanations: https://drive.google.com/open?id=1wnqblIzAc0gV9U24Qzc3hWgP6UxjG2dX