Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
All Vendors
  2. Home
  3. Exams
  4. Oracle
  5. 1Z0-062

Free Oracle 1Z0-062 Exam Questions (page: 9)

Page 9 of 87
PDF with 419 Questions

Examine the parameters for your database instance:

You execute the following command:
SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE;
Which statement is true in this scenario?

  1. Undo data is written to flashback logs after 1200 seconds.
  2. Inactive undo data is retained for 1200 seconds even if subsequent transactions fail due to lack of space in the undo tablespace.
  3. You can perform a Flashback Database operation only within the duration of 1200 seconds.
  4. An attempt is made to keep inactive undo for 1200 seconds but transactions may overwrite the undo before that time has elapsed.

Answer(s): D



Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER by issuing the following command:
1snrctl > STOP
What happens to the sessions that are presently connected to the database Instance?

  1. They are able to perform only queries.
  2. They are not affected and continue to function normally.
  3. They are terminated and the active transactions are rolled back.
  4. They are not allowed to perform any operations until the listener LISTENER is started.

Answer(s): B

Explanation:

The listener is used when the connection is established. The immediate impact of stopping the listener will be that no new session can be established from a remote host. Existing sessions are not compromised.



Your database is open and the listener LISTENER is up. You issue the command:
LSNRCTL> RELOAD
What is the effect of RELOAD on sessions that were originally established by LISTENER?

  1. Only sessions based on static listener registrations are disconnected.
  2. 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.
  3. The sessions are not affected and continue to function normally.
  4. All the sessions are terminated and active transactions are rolled back.

Answer(s): C



Examine the structure of the SALES table, which is stored in a locally managed tablespace with Automatic Segment Space Management (ASSM) enabled.

You want to perform online segment shrink to reclaim fragmented free space below the high water mark.
What should you ensure before the start of the operation?

  1. Row movement is enabled.
  2. Referential integrity constraints for the table are disabled.
  3. No queries are running on this table.
  4. Extra disk space equivalent to the size of the segment is available in the tablespace.
  5. No pending transaction exists on the table.

Answer(s): A



Viewing page 9 of 87



Post your Comments and Discuss Oracle 1Z0-062 exam prep with other Community members:

1Z0-062 Exam Discussions & Posts