Oracle Oracle Certifications 1Z0-062 Questions & Answers

• Question 91:

  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

• Question 92:

  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?

  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

• Question 93:

  Examine the command: SQL> CONNECT hr/hr@orcl

  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.

  B. The SERVICE_NAMES initialization parameter should contain the name orcl in the database host.

  C. The orcl TNS alias should be defined such that it is resolvable by a client running on the database host.

  D. The orcl TNS alias should be defined in the tnsnames.ora file on both the client and the database host.

  E. The TNS_ADMIN environment variable should be set to orcl on the client.

  Correct Answer: BC

• Question 94:

  Which users are created and can be used for database and host management of your DBaaS database servers?

  A. opc and oracle users

  B. root, oracle and cloud users

  C. root and oracle users

  D. root, opc and oracle users

  E. cloud and oracle users

  Correct Answer: A

• Question 95:

  You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log files is the FRA.

  Which two files are removed automatically if space is required in the FRA as per the retention policy? (Choose two.)

  A. Archived redo log files that have multiple copies in a different archive location

  B. user-managed backups of data files and control files

  C. RMAN backups that are obsolete

  D. flashback logs

  Correct Answer: CD

• Question 96:

  Which three database operations can be performed only at MOUNT state? (Choose three.)

  A. performing Flashback Database

  B. renaming control files

  C. enabling or disabling ARCHIVELOG mode

  D. re-creating control files E. performing full database recovery

  Correct Answer: ACE

• Question 97:

  Which statement is true about a database in ARCHIVELOG mode?

  A. All backups taken prior to switching to ARCHIVELOG mode can be used to perform complete recovery.

  B. Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.

  C. A Fast Recovery Area (FRA) must be configured for the database.

  D. Full database backups can be performed when the database is opened.

  Correct Answer: D

• Question 98:

  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 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

• Question 99:

  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/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

• Question 100:

  You create a locally managed tablespace ORDERS_TBS with automatic segment management.

  You then create the table DAILY_ORDS_LST in the ORDERS_TBS tablespace using the command.

  CREATE TABLE daily_ords_1st(ordno NUMBER, ord_date DATE) PCTFREE 20;

  How does the PCTFREE storage parameter influence data storage for this table?

  A. It allows only 80% of space to be occupied in all data blocks of this table.

  B. It minimizes row chaining during row insertion.

  C. It minimizes row migration during existing row data updation.

  D. It automatically coalesces free space of a data block when it reaches 20% of available space.

  Correct Answer: A