The sh user receives the following error while

This preview shows page 119 - 122 out of 152 pages.

The SH user receives the following error while inserting data into the sales table: Which three actions can be taken to enable the user to insert data? (Choose three.) A. altering the data file associated with the SMD tablespace to grow automatically B. adding a data file to the SMD tablespace, provided the tablespace has not reached its maximum number of file C. changing segment space management for the SMD tablespace to automatic D. resizing the data file associated with the SMD tablespace to make it larger, provided all data files have not yet reached their maximum size E. increasing the space quota on the SMD tablespace for the SH user, provided the files have not yet reached their maximum size Correct Answer: ABD Section: (none) Explanation Explanation/Reference: QUESTION 248 In your database instance, the UNDO_RETENTION parameter is set to 1000 and undo retention is not guaranteed for the fixed size undo tablespace. Which statement is true about undo retention?
Image of page 119
A. Undo is retained in the UNDO tablespace for 1000 seconds, and then moved to the SYSTEM tablespace to provide read consistency. B. Inactive undo is retained for at least 1000 seconds if free undo space is available. C. Inactive undo is retained for 1000 seconds even if new transactions fall due to lack of space in the undo tablespace. D. Undo becomes expired obsolete after 1000 seconds. Correct Answer: B Section: (none) Explanation Explanation/Reference: QUESTION 249 Which two files must you copy from the Oracle home of the database that is being upgraded to the new Oracle home for Oracle Database 12c? (Choose three.) A. the tnsnames.ora file B. the sqlnet.ora file C. the initialization parameter file D. the password file E. the listener.ora file Correct Answer: CD Section: (none) Explanation Explanation/Reference: References QUESTION 250 In your Oracle 12c database, you invoke SQL *Loader Express Mode command to load data: $> sqlldr hr/hr table=employees Which two statements are true about this command? (Choose two.) A. It succeeds and creates the EMPLOYEES table in the HR schema if the table does not exist. B. It fails because the SQL *Loader control file location is not specified. C. It fails because the SQL *Loader data file location is not specified. D. It succeeds with default settings if the EMPLOYEES table belonging to the HR schema is already defined in the database. E. It succeeds even if the HR user does not have the CREATE DIRECTORY privilege. Correct Answer: DE Section: (none) Explanation Explanation/Reference: QUESTION 251 Backup requirements for a database: * Level 0 backup on Sunday * Cumulative incremental level 1 backup on Monday, Wednesday, and Saturday * Differential incremental level 1 backup on Tuesday, Thursday, and Friday Which three statements are true about the strategy? (Choose three.)
Image of page 120
A. Level 0 backup on Sunday contains all the blocks that have been formatted.
Image of page 121
Image of page 122

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