Operating groups correct answer c section none

This preview shows page 90 - 93 out of 152 pages.

operating groups Correct Answer: C Section: (none) Explanation Explanation/Reference: QUESTION 167 Which three statements are true about space usage alerts? (Choose three.) A. Alerts are issued only when the critical threshold for space available in a tablespace is breached. B. The sum of active extents and allocated user quotas is considered to compute space usage for an undo tablespace. C. Database alerts can provide warnings about low space availability at both tablespace and segment levels. D. Alerts are not issued for locally managed tablespaces that are offline or in read-only mode. E. A newly created locally managed tablespace is automatically assigned the default threshold values defined for a database. Correct Answer: ADE Section: (none) Explanation Explanation/Reference: References: QUESTION 168 Which three statements are true about Oracle Data Pump? (Choose three.) A. IMPDP can be used to change target data file names, schemas, and tablespaces during import. B. The DBMS_DATAPUMP PL/SQL package can be used independently of Data Pump clients to perform export and import operations. C. EXPDP and IMPDP are the client components of Oracle Data Pump. D. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege. E. IMPDP always use the conventional path insert method to import data. Correct Answer: ABC Section: (none)
Image of page 90
Explanation Explanation/Reference: References: QUESTION 169 Your database instance has started using an SPFILE. Examine the RMAN configuration settings: You execute the command: RMAN> BACKUP AS COPY TABLESPACE TEST; Which three types of files are backed up by using this command? (Choose three.) A. online redo log files B. control file C. SPFILE D. archived redo log files E. data file(s) F. PFILE Correct Answer: BCE Section: (none) Explanation Explanation/Reference: References: QUESTION 170 You have the following entry in the tnsnames.ors of your hq.us.example.com host machine: You issue the following command at the command prompt: Sqlplus HR/[email protected] Which statement is true about the connection to the ORCL database instance? A. The connection succeeds, provided the NAMES.DEFAULT_DOMAIN parameter is set to us.example.com in the sqlnet.ora file on the client side. B. The connection fails because the net service name does not have the suffix us.example.com. C. The connection succeeds, provided the SERVICE_NAMES initialization parameter is set to ORCL. D. The connection succeeds, provided the ORCL.us.example.com database service is registered with a
Image of page 91
listener, the listener is up, and the database is open. Correct Answer: D Section: (none) Explanation Explanation/Reference: QUESTION 171 Which three statements are true about Oracle Restart? (Choose three.) A. It can be configured to automatically attempt to restart various components after a hardware or software failure.
Image of page 92
Image of page 93

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