Which set of tablespace attributes can be specified

This preview shows page 142 - 145 out of 152 pages.

Which set of tablespace attributes can be specified for a tablespace that satisfies the requirements? A. EXTENT MANAGEMENT LOCAL STORAGE (INITIAL 5M MAXSIZE 10M) B. REUSE AUTOEXTEND ON MAXSIZE UNLIMITED C. EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT UNIFORM D. EXTENT MANAGEMENT LOCAL AUTOALLOCATE Correct Answer: D Section: (none) Explanation Explanation/Reference: QUESTION 317 The schema SALES exists in two databases, ORCL1 and ORCL2, and has the same password, SALES123. User SALES has CREATE DATABASE LINK and CREATE SESSION privileges on both databases. Examine these commands:
Image of page 142
Conn SALES/SALES123 CREATE DATABASE LINK orcl2 USING 'orcl2'; What is the outcome of executing these commands in the ORCL1 database? A. ORCL2 is created as a public database link to connect a single session to the SALES schema in the ORCL2 database. B. ORCL2 is created as a shared database link to connect multiple sessions to the SALES schema in the ORCL2 database. C. ORCL2 is created as a private database link to connect to only the SALES schema in the ORCL2 database. D. ORCL2 database link creation fails. Correct Answer: C Section: (none) Explanation Explanation/Reference: QUESTION 318 Which two services may you see on the My Service Dashboard page? (Choose two.) A. Network Cloud Service B. User Cloud Service C. Compute Cloud Service D. Database Cloud Service Correct Answer: CD Section: (none) Explanation Explanation/Reference: QUESTION 319 What is a requirement for creating a remote database scheduler job? A. The remote database job must run as a user that is valid on the target remote database. B. A private database link must be created from the originating database to the target remote database. C. The target remote database on which the job is scheduled must be Oracle Database 11g Release 2 or later. D. The target remote database must be on a different host form the originating scheduler database host. Correct Answer: A Section: (none) Explanation Explanation/Reference: QUESTION 320 The HR schema exists in two databases, BOSTON and DENVER, and has the same password, HR. You have the CREATE DATABASE LINK and CREATE SESSION privileges on both the database. BOSTON is defined as a service name in the tnsnames.ora of both the databases. You plan to use the command: CREATE DATABASE LINK hr_link CONNECT to hr IDENTIFIED BY hr USING 'denver'; What must be done to ensure only the HR user in the BOSTON database can access the HR schema in the DENVER database?
Image of page 143
A. Execute this command as HR user in the BOSTON database and SYS user in the DENVER database. B. Execute this command as SYS user in both the databases. C. Execute this command as HR user in the DENVER database. D. Execute this command as HR user in the BOSTON database. Correct Answer: D Section: (none) Explanation Explanation/Reference: QUESTION 321 Examine the command: SQL> CONNECT hr/[email protected] Which two configurations allow this command to execute successfully? (Choose two.) A. In the tnsnames.ora file, the SERVICE_NAME value of CONNECT_DATA should be explicitly suffixed with the domain name.
Image of page 144
Image of page 145

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