C the seed will be opened readwrite d the other pdbs

This preview shows page 43 - 46 out of 152 pages.

C. The seed will be opened read/write. D. The other PDBs will be in mount state. E. The other PDBs will be opened read-only. F. The PDBs will be opened read/write. Correct Answer: BD Section: (none) Explanation Explanation/Reference: Explanation: B: The seed is always read-only. D: Pluggable databases can be started and stopped using SQL*Plus commands or the ALTER PLUGGABLE DATABASE command. QUESTION 77 You execute the following piece of code with appropriate privileges:
Image of page 43
User SCOTT has been granted the CREATE SESSION privilege and the MGR role. Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table? (Choose two.) A. Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set. B. Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set. C. Data is never redacted for the EMP_V.SAL column. D. Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set. E. Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set. Correct Answer: AC Section: (none) Explanation Explanation/Reference: Explanation: Note: * DBMS_REDACT.FULL completely redacts the column data. * DBMS_REDACT.NONE applies no redaction on the column data. Use this function for development testing purposes. LOB columns are not supported. * The DBMS_REDACT package provides an interface to Oracle Data Redaction, which enables you to mask (redact) data that is returned from queries issued by low-privileged users or an application. * If you create a view chain (that is, a view based on another view), then the Data Redaction policy also applies throughout this view chain. The policies remain in effect all of the way up through this view chain, but if another policy is created for one of these views, then for the columns affected in the subsequent views, this new policy takes precedence. QUESTION 78 Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER by issuing the following command:
Image of page 44
1snrctl > STOP What happens to the sessions that are presently connected to the database Instance? A. They are able to perform only queries. B. They are not affected and continue to function normally. C. They are terminated and the active transactions are rolled back. D. They are not allowed to perform any operations until the listener LISTENER is started. Correct Answer: B Section: (none) Explanation Explanation/Reference: 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. QUESTION 79 Which three statements are true about using flashback database in a multitenant container database (CDB)? (Choose three.) (Choose three.) A. The root container can be flashed back without flashing back the pluggable databases (PDBs).
Image of page 45
Image of page 46

You've reached the end of your free preview.

Want to read all 152 pages?

  • Fall '19
  • Oracle Database

What students are saying

  • Left Quote Icon

    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.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    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.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    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.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors