A.The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.B.The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.C.The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) isrestarted.D.Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.Correct Answer: ASection: (none)ExplanationExplanation/Reference:QUESTION 145Which two are prerequisites for performing a flashback transaction? (Choose two.)A.Flashback Database must be enabled.B.Undo retention guarantee for the database must be configured.C.EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing backtransaction.D.Supplemental logging must be enabled.E.Recycle bin must be enabled for the database.F.Block change tracking must be enabled tor the database.Correct Answer: CDSection: (none)ExplanationExplanation/Reference:Explanation:References: QUESTION 146A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with
SQL:There is enough free space in the disk group for mirroring to be done.What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?A.Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1will fall.B.Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until theCONTROLLER1 for failure group is brought back online.C.The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancingis initiated.D.ASM does not mirror any data until the controller failure group is brought back online, and newlyallocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.E.Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail butqueries will succeed.Correct Answer: DSection: (none)ExplanationExplanation/Reference:QUESTION 147On your Oracle 12c database, you Issue the following commands to create indexesSQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE;SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id);Which two statements are correct? (Choose two.)A.Both the indexes are created; however, only the ORD_COSTOMER index is visible.B.The optimizer evaluates index access from both the Indexes before deciding on which index to use forquery execution plan.C.Only the ORD_CUSTOMER_IX1 index is created.D.Only the ORD_CUSTOMER_IX2 index is created.
As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.
Temple University Fox School of Business ‘17, Course Hero Intern
I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.
University of Pennsylvania ‘17, Course Hero Intern
The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.
Tulane University ‘16, Course Hero Intern
Stuck? We have tutors online 24/7 who can help you get unstuck.
Ask Expert Tutors
You can ask
You can ask
You can ask
(will expire )