Which method would you use a use dbca to create a

This preview shows page 130 - 132 out of 152 pages.

Which method would you use? A. Use DBCA to create a template from the existing database to contain the database structure and then manually copy the data by using Oracle Data Pump. B. Use Database Configuration Assistant (DBCA) to create a template from the existing database to contain the database structure. C. Create the database by using the CREATE DATABASE. . . command and manually import data by using Data Pump. D. Use DBCA to create a template from the existing database to contain the database structure with data files and then use the same template to create the database in the new location. Correct Answer: C Section: (none) Explanation Explanation/Reference: QUESTION 279 You want to load data from a large file into your database without causing an overhead on the SGA. Which tool would you use. A. external table B. Oracle data Pump C. SQL*Loader with a direct data path D. SQL*Loader with a conventional data path E. Enterprise Manager Database Express Correct Answer: C Section: (none) Explanation Explanation/Reference: References QUESTION 280 You are using RMAN to back up your database. All the data files are in read/write mode. Examine the RMAN configuration parameters:
Image of page 130
Which two statements are true about a whole consistent backup of a database running in ARCHIVELOG mode? (Choose two.) A. The backup can be used as an incremental level 0 backup. B. The database instance must be shut down to take the backup. C. The database must be in MOUNT state to take the backup. D. The backup consists of blocks that have been formatted. E. The system Change Number (SCN) is the same for all the data files in the backup. Correct Answer: CE Section: (none) Explanation Explanation/Reference: QUESTION 281 As part of a manual upgrade of your database to Oracle Database 12c, you plan to issue the command: SQL> STARTUP UPGRADE Which three statements are true about the upgrade process? (Choose three.) A. All system triggers are disabled during the upgrade process. B. Only queries on fixed views execute without errors until you run the catctl.pl script. C. The COMPATIBLE parameter must be set to at least 12.1.0 before issuing the command. D. All job queues remain active during the upgrade process. E. Only connections AS SYSDBA are allowed during the upgrade process. Correct Answer: ABE Section: (none) Explanation Explanation/Reference: QUESTION 282 Which statement is true about using the Export/Import method for migrating data when upgrading to Oracle Database 12c? A. It automatically restarts a Data Pump Export or Import job after a failure is connected and the job continues from the point of failure. B. It can be used to migrate a database only if the source and target databases are hosted on the same endian format.
Image of page 131
Image of page 132

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