1z0-062 — Free Practice Questions
10 free sample questions from a bank of 455, with the correct answers and explanations. No signup required — start practising right now.
1Examine the parameters for your database instance: You execute the following command:
SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE;
Which statement is true in this scenario?
- Undo data is written to flashback logs after 1200 seconds.
- Inactive undo data is retained for 1200 seconds even if subsequent transactions fail due to lack of space in the undo tablespace.
- You can perform a Flashback Database operation only within the duration of 1200 seconds.
- An attempt is made to keep inactive undo for 1200 seconds but transactions may overwrite the undo before that time has elapsed.
Answer: D
2Which two tasks can be performed on an external table? (Choose two.)
- partitioning the table
- creating an invisible index
- updating the table by using an update statement
- creating a public synonym
- creating a view
Answer:
3Examine the parameters for your database instance: Which three statements are true about the process of automatic optimization by using cardinality feedback? (Choose three.)
- The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.
- The optimizer can re optimize a query only once using cardinality feedback.
- The optimizer enables monitoring for cardinality feedback after the first execution of a query.
- The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.
- After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.
Answer:
4Which three statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled In
UNIX? (Choose three.)
- Thread creation must be routed through a dispatcher process
- The local listener may spawn a now process and have that new process create a thread
- Each Oracle process runs an SCMN thread.
- Each multithreaded Oracle process has an SCMN thread.
- The local listener may pass the request to an existing process which in turn will create a thread.
Answer:
5You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privileges and execute the following sequence statements: What is the result of the last SET CONTAINER statement and why is it so?
- It succeeds because the PDB_ADMIN user has the required privileges.
- It fails because common users are unable to use the SET CONTAINER statement.
- It fails because local users are unable to use the SET CONTAINER statement.
- If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).
Answer: C
6Examine 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?
- The size of the shared pool is too small.
- Cursors are not being shared.
- A large number COMMITS are being performed.
- There are frequent logons and logoffs.
- The buffers are being read into the buffer cache, but some other session is changing the buffers.
Answer:
7You enabled an audit policy by issuing the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;
For which database users and for which executions is the audit policy now active? Select two.
- SYS, SYSTEM
- SCOTT
- Only for successful executions
- Only for failed executions
- Both successful and failed executions
Answer:
8A 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.)
- SYS sessions, regardless of the roles that are set in the session
- SYSTEM sessions, regardless of the roles that are set in the session
- SCOTT sessions, only if the MGR role is set in the session
- SCOTT sessions, only if the MGR role is granted to SCOTT
- SCOTT sessions, because he is the owner of the table
- SYSTEM session, only if the MGR role is set in the session
Answer:
9What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archiving enabled?
- It fails with the ORA-665610 Invalid DDL statement on history-tracked message
- The rows in the table are truncated without being archived.
- The rows in the table are archived, and then truncated.
- The rows in both the table and the archive are truncated.
Answer: C
10Which three statements are true about a job chain? (Choose three.)
- It can contain a nested chain of jobs.
- It can be used to implement dependency-based scheduling.
- It cannot invoke the same program or nested chain in multiple steps in the chain.
- It cannot have more than one dependency.
- It can be executed using event-based or time-based schedules.
Answer:
Want the full bank of 455 questions for 1z0-062? See all practice exams.