ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：2021-03-02 10:35:52
8、Examine the statements that use flashback technologies:2. SELECT * FROM customers AS OF SCN 123456;4. FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS');6. ALTER TABLE customers FLASHBACK ARCHIVE;A) 1,3,6C) 3,4,5......【阅读全文】
发布时间：2021-03-01 14:31:00
7、choose oneYou execute the following command to change the requirement:What is the outcome?B) An error is returned because the retention period cannot be reduced.D) All historical data older than two years, if any, is archived to flashback logs and the flashback archive is set to.........【阅读全文】
发布时间：2021-02-26 15:12:58
6、Which two are prerequisites for performing Flashback Transaction?B) The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.D) A supplemental log must be enabled for the primary key.......【阅读全文】
发布时间：2021-02-25 17:12:41
5、Which three are true about requirements for various FLASHBACK operations? (Choose three.)B. FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.D. FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.F. FLASHBACK version quer.........【阅读全文】
发布时间：2021-02-25 14:40:24
4、For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)B. to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDBD. to specify the list of user tablespaces to include when moving a non-CDB to a.........【阅读全文】
