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-083

Free Oracle 1z0-083 Exam Questions (page: 5)

Page 5 of 71
PDF with 286 Questions

You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years. You execute the following command to change the requirement: SQL> ALTER FLASHBACK ARCHIVE fdal MODIFY RETENTION 2 YEAR; What is the outcome?

  1. All historical data older than two years, if any, is purged from the flashback archive FDA1.
  2. An error is returned because the retention period cannot be reduced.
  3. All the flashback data archives are purged and the subsequently created flashback archives are maintained for two years
  4. All historical data older than two years, if any, is archived to flashback logs and the flashback archive is set to new retention time.

Answer(s): A



Which three statements are true about Flashback Data Archive?

  1. To use Flashback Data Archive, users must have unlimited quota on the Flashback Data Archive tablespace.
  2. To enable Flashback Data Archive for a table, it is mandatory to have a default Flashback Data Archive for a database
  3. While enabling Flashback Data Archive for a table, if no name is provided for Flashback Data Archive, it is enabled using the default Flashback Data Archive.
  4. A table enabled for Flashback Data Archive cannot be dropped unless Flashback Data Archive is disabled or disassociated first.
  5. Flashback Data Archive prevents flashback queries from getting a snapshot-too-old error.

Answer(s): C,D,E



Examine the statements that use flashback technologies:

FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYYMM¬DD HH:MI:SS');
SELECT * FROM customers AS OF SCN 123456; FLASHBACK TABLE customers TO BEFORE DROP;
FLASHBACK DATABASE TO TIMESTAMP TO TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS');
SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999;
ALTER TABLE customers FLASHBACK ARCHIVE;

Which set of statements depends on the availability of relevant undo data in the undo tablespace?

  1. 1,3,6
  2. 1,2,5
  3. 3,4,5
  4. 2,3,5,6

Answer(s): B



You accidentally drop the CUSTOMERS table, and then recover it by using the FLASHBACK TABLE command. Which two statements are true about the dependent objects of the CUSTOMERS table?

  1. All the triggers associated with the table are flashed back but are disabled.
  2. Materialized views that use the CUSTOMERS table are flashed back.
  3. LOB segments associated with the CUSTOMERS table are flashed back.
  4. All the constraints defined on the table, except the referential integrity constraints, are flashed back.
  5. Only the primary key constraint created for the table is flashed back, whereas all other indexes must be retrieved separately.

Answer(s): C,D



Viewing page 5 of 71



Post your Comments and Discuss Oracle 1z0-083 exam prep with other Community members:

1z0-083 Exam Discussions & Posts