1Z0_062 questions • Exam prepare

Exam contains 381 questions

Page 19 of 64

Question 109 🔥

You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c.Examine the table definition:Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table? (Choose three.)

Which database solution meets these requirements?

A. The valid time columns employee_time_start and employee_time_end are automatically created.

Highly voted

B. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.

Highly voted

C. The valid time columns are not populated by the Oracle Server automatically.

D. The valid time columns are visible by default when the table is described.

E. Setting the session valid time using DBMS_FLASHBACK_ARCHIVENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data

Highly voted

Discussion of the question

Question 110 🔥

Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)? (Choose three.)

Which database solution meets these requirements?

A. A DBA can check specific tables with the DMU

B. The database to be migrated must be opened read-only.

C. The release of the database to be converted can be any release since 9.2.0.8.

D. The DMU can report columns that are too long in the converted characterset.

E. The DMU can report columns that are not represented in the converted characterset.

Discussion of the question

Question 111 🔥

Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart.Examine the following command and its output:$ crsctl config hasCRS-4622: Oracle High Availability Services auto start is enabled.What does this imply?

Which database solution meets these requirements?

A. When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.

B. When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.

C. When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.

D. When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.

Discussion of the question

Question 112 🔥

Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container:Which two statements are true? (Choose two.)

Which database solution meets these requirements?

A. Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.

B. The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.

C. The command will, create a common user whose description is contained in the root and each PDB.

D. The schema for the common user C # # A_ADMIN can be different in each container.

E. The command will create a user in the root container only because the container clause is not used.

Discussion of the question

Question 113 🔥

You performed an incremental level 0 backup of a database:RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE;To enable block change tracking after the incremental level 0 backup, you issued this command:SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE/mydir/rman_change_track.f;To perform an incremental level 1 cumulative backup, you issued this command:RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;Which three statements are true? (Choose three.)

Which database solution meets these requirements?

A. Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.

Highly voted

B. The change tracking file must always be backed up when you perform a full database backup.

Highly voted

C. Block change tracking will always reduce I/O performed during cumulative incremental backups.

Highly voted

D. More than one database block may be read by an incremental backup for a change made to a single block.

E. The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed

Discussion of the question

Question 114 🔥

Examine the parameters for your database instance:You execute the following command:SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE;Which statement is true in this scenario?

Which database solution meets these requirements?

A. Undo data is written to flashback logs after 1200 seconds.

B. Inactive undo data is retained for 1200 seconds even if subsequent transactions fail due to lack of space in the undo tablespace.

C. You can perform a Flashback Database operation only within the duration of 1200 seconds.

D. An attempt is made to keep inactive undo for 1200 seconds but transactions may overwrite the undo before that time has elapsed.

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_062

Exam contains 381 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us