B the database instance aborts and media recovery is

This preview shows page 107 - 109 out of 152 pages.

B. The database instance aborts, and media recovery is required after restoration of the control file to open the database. C. The database instance remains open and the control file can be restored without shutting down the database. D. The database instance aborts and a control file restore operation does not require media recovery. Correct Answer: D Section: (none) Explanation Explanation/Reference: QUESTION 214 Examine the parameter settings in your local ORCL database: Examine the parameter settings for the remote SALES database: As the SYS user, you issue the following command on ORCL : CREATE PUBLIC DATABASE LINK sales.us.example.com USING ‘sales1’; The sales1 tnsnames entry points to the sales database instance. Which two are requirements to ensure that you can successfully connect by using this database link? (Choose two.) A. The GLOBAL_NAMES initialization parameter should be set to FALSE in the ORCL database. B. The SALES1 net service name should be known to both the local and remote databases. C. Local database users who use this database link should have accounts and the required privileges in the remote database. D. The REMOTE_OS_AUTHENT initialization parameter should be set to FALSE in the remote database.
Image of page 107
E. Only the user creating the database link must have an account and the required privileges in the remote database. Correct Answer: AC Section: (none) Explanation Explanation/Reference: QUESTION 215 Which three are activities performed by SMON? (Choose three.) A. cleaning up the database buffer cache and freeing resources that a client process was using B. applying online redo during instance recovery C. cleaning up temporary segments that are no longer needed D. performing database services registration with the default listener E. restarting a server or a dispatcher process that terminated abnormally F. recovering failed transactions that were skipped during instance recovery because of file-read or tablespace offline errors Correct Answer: BCF Section: (none) Explanation Explanation/Reference: QUESTION 216 You are administering a database that supports an OLTP workload. The default UNDO tablespace is a fixed size tablespace with the RETENTION NOGUARATNEE clause and undo retention set to 12 minutes. The user SCOTT queries a large table during peak activity. The query runs for more than 15 minutes and then SCOTT receives the following error: ORA-01555: snapshot too old Which is possible reason for this? A. The Oracle server is unable to generate a read-consistent image for a block containing updates.committed after the query began. B. The query is unable to place data blocks in the UNDO tablespace. C. The flashback data archive is not enabled for the table on which the query is issued. D. There is not enough space in Fast Recovery Area.
Image of page 108
Image of page 109

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