Which option should you use a automatic storage

This preview shows page 111 - 114 out of 152 pages.

Which option should you use? A. Automatic Storage Management (ASM) for storage of data files B. a file system for storage of data files C. a Data Warehouse database template D. a custom database template Correct Answer: D Section: (none) Explanation Explanation/Reference: QUESTION 226 Which two statements are true about using SQL*Loader? (Choose two.) A. It can load data from external files by using the direct path only. B. It can load data into multiple tables using the same load statement. C. It can load data into only one table at a time. D. It can generate unique sequential key values in specified columns.
Image of page 111
E. It can load data from external files by using the conventional path only. Correct Answer: BD Section: (none) Explanation Explanation/Reference: QUESTION 227 The HR user owns the BONUSES table. HR grants privileges to the user TOM by using the command: SQL> GRANT SELECT ON bonuses TO tom WITH GRANT OPTION; TOM then executes this command to grant privileges to the user JIM : SQL> GRANT SELET ON hr.bonuses TO jim; Which statement is true? A. TOM cannot revoke the SELECT ON HR.BONUSES privilege from JIM . B. HR can revoke the SELECT ON HR.BONUSES privilege from JIM . C. JIM can grant the SELECT ON HR.BONUSES privilege to other users, but cannot revoke the privilege from them. D. HR can revoke the SELECT ON HR.BONUSES privilege from TOM , which will automatically revoke the SELECT ON HR.BONUSES privilege from JIM . Correct Answer: D Section: (none) Explanation Explanation/Reference: QUESTION 228 Your database is running in NOARCHIVLOG mode. Examine the following parameters: You execute the following command after performing a STARTUP MOUNT : SQL> ALTER DATABASE ARCHIVELOG; Which statement is true about the execution of the command? A. It executes successfully and sets the Fast Recovery Area as the local archive destination. B. It executes successfully and issues a warning to set LOG_ARCHIVE_DEST while opening the database. C. It fails and returns an error about LOG_ARCHIVE_DEST not being set. D. It executes successfully and sets $ORACLE_HOME/dbs as the default archive destination. Correct Answer: A Section: (none) Explanation
Image of page 112
Explanation/Reference: QUESTION 229 Which set of statements is true about data dictionary views? 1. They are stored in the SYSTEM tablespace. 2. They are based on virtual tables. 3. They are owned by the SYS user. 4. They can be queried by a normal user only if the 07_DICTIONARY_ACCESSIBILITY parameter is set to TRUE. 5. The V$FIXED_TABLE view can be queried to list the names of these views. 6. They are owned by the SYSTEM user. A. 2, 5, and 6 B. 1, 2, and 3 C. 1 and 3 D. 2, 3, 4, and 5 Correct Answer: C Section: (none) Explanation Explanation/Reference: References: QUESTION 230 What is the benefit of running the catctl.pl script during an upgrade of a pre-12c database to an Oracle 12c database?
Image of page 113
Image of page 114

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