D it returns an error because scope should be set to

This preview shows page 103 - 105 out of 152 pages.

D. It returns an error because SCOPE should be set to MEMORY . Correct Answer: B Section: (none) Explanation Explanation/Reference: QUESTION 201 You want to create a database and you have the following: - Oracle Grid Infrastructure is installed and configured. - Oracle Database Vault is installed in ORACLE_HOME to be used for this database. - Oracle Enterprise Manager Cloud Control is available and an agent is deployed on the database server. Examine the requirements: 1. configuring the database instance to support shared server mode 2. using Automatic Storage Management (ASM) for storing database files. 3. configuring a naming method to help a remote user connect to a database instance 4. configuring the Fast Recovery Area 5. configuring Database Vault 6. configuring Enterprise Manager (EM) Database Express 7. registering with EM Cloud Control 8. configuring remote log archive destinations 9. enabling daily incremental backups 10. configuring a nondefault block size for nondefault block size tablespaces Which of these requirements can be met while creating a database by using the Database Configuration Assistant (DBCA)? A. 1, 2, 4, 5, 7, 8, 9 and 10 B. 1, 2, 4, 5, 6 and 7 C. 1, 2, 3, 8, 9 and 10 D. 1, 2, 3, 4, 6, 8, 9 and 10 E. 1, 2, 4, 5, 6, 7 and 8 Correct Answer: B Section: (none) Explanation Explanation/Reference: QUESTION 202 You want execution of large database operations to suspend, and then resume, in the event of space allocation failures. You set the value of the initialization parameter RESUMABLE_TIMEOUT to 3600 . Which two statements are true? (Choose two.) A. Before a statement executes in resumable mode, the ALTER SESSION ENABLE RESUMABLE statement must be issued in its session. B. Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block. C. A resumable statement can be suspended and resumed only once during execution. D. A suspended statement will report an error if no corrective action has taken place during a timeout
Image of page 103
period. E. Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction. Correct Answer: AD Section: (none) Explanation Explanation/Reference: QUESTION 203 Which two statements are true about Automatic Database Diagnostic Monitor (ADDM)? (Choose two.) A. It calls SQL advisors automatically if required. B. It provides recommendations only for poorly performing SQL statements. C. Its results are stored in AWR. D. It runs automatically after each AWR snapshot is created and requires at least two snapshots for analysis. E. It requires at least one Automatic Workload Repository (AWR) snapshot for analysis. Correct Answer: CD Section: (none) Explanation Explanation/Reference: QUESTION 204 Which statement is true about using the Database Upgrade Assistant (DBUA) to upgrade your database from Oracle Database 11g to Oracle Database 12c?
Image of page 104
Image of page 105

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