D no redo is generated for the undo records belonging

This preview shows page 98 - 101 out of 152 pages.

D. No redo is generated for the undo records belonging to temporary tables. E. No redo and undo records are generated for temporary tables. Correct Answer: AD Section: (none) Explanation Explanation/Reference: QUESTION 188 You set the following parameters in the parameter file and restart the database instance: Which two statements are true? (Choose two.) A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB. B. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero. C. The value of the MEMORY_MAX_TARGET parameter remains zero for the database instance. D. The lower limits of the PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB respectively. E. The instance does not start up because Automatic Memory Management (AMM) is enabled but PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to nonzero values. Correct Answer: AD Section: (none) Explanation Explanation/Reference: QUESTION 189 Which three statements are true about the purpose of checkpoints? (Choose three.) A. They ensure that uncommitted transactions are rolled back in case of an instance failure. B. They ensure that all the dirty buffers are written to disk during a normal shutdown. C. They ensure that instance recovery starts in the event of an instance failure. D. They ensure that dirty buffers in the buffer cache are written to disk regularly. E. They reduce the time required for recovery in case of an instance failure. Correct Answer: BDE Section: (none)
Image of page 98
Explanation Explanation/Reference: References: QUESTION 190 Your database is configured in ARCHIVELOG mode. Examine the RMAN configuration parameters: Examine the command: RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT; What is the outcome? A. It fails because the DELETE INPUT option can be used only with the BACKUP AS BACKUPSET command. B. It executes successfully and creates a backup set of the database along with archived log files and then deletes the original archived log files. C. It executes successfully and creates an image copy of the database along with archive log files and then deletes the original archived log files. D. It fails because the DELETE INPUT option can be used only with the BACKUP AS COPY command. Correct Answer: B Section: (none) Explanation Explanation/Reference: References: QUESTION 191 Your production database uses file system storage. You want to move storage to Oracle Automatic Storage Management (ASM). How would you achieve this? A. by using a transportable database B. by using the Database Upgrade Assistant (DBUA) C. by using Data Pump D. by using RMAN Correct Answer: D Section: (none) Explanation Explanation/Reference: References: (p.184) QUESTION 192 The HR user executes the following query on the EMPLOYEES table but does not issue COMMIT, ROLLBACK , or any data definition language (DDL) command after that:
Image of page 99
HR then opens a second session.
Image of page 100
Image of page 101

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