C an spfile must reside in the oraclehomedbs

This preview shows page 125 - 127 out of 152 pages.

C. An SPFILE must reside in the ORACLE_HOME/dbs directory. D. An SPFILE can be created only before a database instance is started. E. An SPFILE contains only those dynamic parameters that can be changed without having to restart the database instance. Correct Answer: AB Section: (none) Explanation Explanation/Reference: QUESTION 266 Your database is configured in ARCHIVELOG mode, and a daily full database backup is taken by using RMAN. Control file autobackup is configured. Loss of which three database files can lead to an incomplete recovery? (Choose three.) A. inactive online redo log file group B. a data file belonging to the default temporary tablespace C. a data file belonging to the SYSAUX tablespace D. server parameter file (SPFILE) E. active online redo log file group F. all the control flies Correct Answer: AEF Section: (none) Explanation
Image of page 125
Explanation/Reference: QUESTION 267 Which two statements are true about resumable space allocation? (Choose two.) A. A database-level LOGON trigger can be used to automatically configure resumable statement settings for individual sessions. B. SELECT statements that run out of temporary space for sort areas are candidates for resumable execution. C. A resumable statement can be suspended and resumed only once during a session. D. Resumable space allocation does not apply when a database instance uses asynchronous commit. E. Resumable space allocation does not apply when users exceed their assigned space quota in a tablespace. F. Free space in a segment is automatically reclaimed when a resumable statement is suspended because of an out-of-space condition. Correct Answer: AB Section: (none) Explanation Explanation/Reference: QUESTION 268 Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and generates lots of redo. Which two actions would you take to solve this problem? (Choose two.) A. Increase the size of the temporary tablespace. B. Enable Automatic Memory Management (AMM). C. Enable undo retention guarantee. D. Enable temporary undo for the database. E. Increase the size of the redo log buffer. Correct Answer: AD Section: (none) Explanation Explanation/Reference: QUESTION 269 You want to create a file watcher and an event-based job for detecting the arrival of files on the local server from various locations. To achieve this, you enable the raising of file arrival events from remote systems. Which two conditions must be satisfied to receive file arrival events from a remote system? (Choose two.) A. The remote system must have a running Oracle Database instance and a scheduler agent installed. B. The initialization parameter REMOTE_OS_AUTHENT must be set to TRUE on your database.
Image of page 126
Image of page 127

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