Category «1Z0-062»

What is the outcome of executing these commands in the ORCL1 database?

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:Conn SALES/SALES123CREATE 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 …

Which set of tablespace attributes can be specified for a tablespace that satifies the requirements?

You want to create a locally managed tablespace called NEWTBS to store segments with different extent sizes.Which set of tablespace attributes can be specified for a tablespace that satifies the requirements? A. EXTENT MANAGEMENT LOCAL STORAGE (INITIAL 5M MAXSIZE 10M) B. REUSE AUTOEXTEND ON MAXSIZE UNLIMITED C. EXTENT MNAGMENT LOCAL SEGMENT SPACE MANAGEMENT UNIFORM D. …