B the impdp operation creates the view and dependent

This preview shows page 145 - 148 out of 152 pages.

B. The impdp operation creates the view and dependent objects. C. All rows from the dependent objects, along with the metadata required to create the EMP_DEPT view, are exported. D. Objects dependent on the EMP_DEPT view are exported. E. The impdp operation creates EMP_DEPT as table and populates it with the data from the export dump file. Correct Answer: ADE Section: (none) Explanation Explanation/Reference: QUESTION 326 Examine the details of the uncompressed, non-partitioned heap table CITIES.
Image of page 145
Examine the command: SQL> ALTER TABLE cities SHRINK SPACE COMPACT; What must you do before executing it? A. Ensure free space that is approximately equal to the space used by the table should be available. B. Ensure there are no pending transactions on the table. C. Enable row movement is enabled. D. Disable all indexes on the table. Correct Answer: C Section: (none) Explanation Explanation/Reference: QUESTION 327 Your database has archive logging enabled and RMAN backups are taken at regular intervals. A data file in the USERS tablespace is damaged. Which command must you execute before starting the recovery of this tablespace? A. ALTER TABLESPACE users OFFLINE B. STARTUP FORCE NOMOUNT C. STARTUP FORCE D. SWITCH DATAFILE ALL Correct Answer: A Section: (none) Explanation Explanation/Reference: QUESTION 328 Which statement is true regarding the DEFAULT profile? A. The values assigned to the resource limits and password parameters in the default profile can be altered. B. A different DEFAULT profile can be created before each user in a database. C. It can be dropped and recreated. D. it must be explicitly assigned to the user. Correct Answer: A Section: (none) Explanation Explanation/Reference: QUESTION 329 Your database is running in ARCHIVELOG mode. You want to take a consistent whole database backup.
Image of page 146
Which two statements are true in this scenario? (Choose two.) A. RMAN backups contain only data files. B. The database instance must be shut down to take a user-managed consistent backup. C. Consistent RMAN backups can be taken while the database is open. D. User-managed backups only contain formatted data blocks. E. The database must be in MOUNT state to take consistent RMAN backups. Correct Answer: BE Section: (none) Explanation Explanation/Reference: QUESTION 330 Which statement is true about the Database as a Service (DBaaS) instances and Database instances in Oracle Public Cloud A. An Oracle database instance can support only one DBaaS instance. B. A DBaaS instance can support only one Oracle database instance. C. An Oracle database instance can support multiple DBaaS instances. D. A DBaaS instance can support multiple Oracle database instances. E. A DBaaS instance runs in a pluggable database (PDB), which is contained in a multi-tenant container database (CDB). Correct Answer: D Section: (none) Explanation Explanation/Reference: QUESTION 331 Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?
Image of page 147
Image of page 148

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