16、请选择两项。CREATE USER finance IDENTIFIED BY pwfin; .CREATE USER fin_clerk IDENTIFIED BY pwclerk;GRANT SELECT ON scott.emp TO finance WITH GRANT OPTION;GRANT SELECT ON scott.emp TO fin_clerk;A)用户FINANCE无法向FIN_MANAGER授予对SCOTT.EMP的ALL权限。C)删除用户FINANCE将自...【阅读全文】
10、Choose three.A. performing checks to ensure minimum configuration requirements for Oracle Grid Infrastructure are metC. creating the OSDBA (dba) groupE. creating the grid OS user【阅读全文】
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...【阅读全文】
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.【阅读全文】
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...【阅读全文】