Create Next App

Exam contains 263 questions

Page 7 of 44

Question 37 🔥

Which two statements are true when row-archival management is enabled?

Which database solution meets these requirements?

A. Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter.

Highly voted

B. The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered active.

Highly voted

C. The row archival visibility session parameter defaults to all rows.

Highly voted

D. The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.

Highly voted

E. The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer

Highly voted

Discussion of the question

Question 38 🔥

You plan to create a new PDB by copying PDB$SEED.Which two requirements ensure a successful creation? (Choose two.)

Which database solution meets these requirements?

A. The CDB must have PDB_FILE_NAME_CONVERT configured before executing the command.

Highly voted

B. A default service for the new PDB name must already exist.

Highly voted

C. A PDB local administrative user must be granted the DBA role when creating the PDB.

Highly voted

D. A PDB local administrative user must be specified when creating the PDB.

Highly voted

E. The CDB, which will contain the PDB, must be in READ WRITE mode.

Highly voted

F. The CDB must use Oracle Managed Files.

Highly voted

Discussion of the question

Question 39 🔥

You issued these commands for one of your databases:RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE;RMAN> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USINGFILE "˜/mydir/rman_change_track.f';RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;Which two are true? (Choose two.)

Which database solution meets these requirements?

A. The cumulative incremental level 1 database backup ignores the block change tracking file.

Highly voted

B. Future cumulative incremental level 1 database backups will reference the block change tracking file.

Highly voted

C. Future incremental level 0 database backups will reference the block change tracking file.

Highly voted

D. The cumulative incremental level 1 database backup fails.

Highly voted

E. The block change tracking file will be updated automatically after creation to refer to modified blocks contained in the incremental level 0 database backup.

Highly voted

Discussion of the question

Question 40 🔥

Which two resources might be prioritized between competing pluggable databases (PDBs) when creating a multitenant container database (COB) plan usingOracle Database Resource Manager?

Which database solution meets these requirements?

A. maximum undo per consumer group

Highly voted

B. maximum idle time for a session in a PDB

Highly voted

C. parallel server limit

Highly voted

D. CPU

Highly voted

E. maximum number of sessions for a PDB

Highly voted

Discussion of the question

Question 41 🔥

Which two are true about incremental backups? (Choose two.)

Which database solution meets these requirements?

A. A backup set can be used as the baseline for an incremental backup.

Highly voted

B. Differential backups can be taken at level 0.

Highly voted

C. An image copy can be used as the baseline for an incremental backup.

Highly voted

D. A tablespace incremental level 1 backup always backs up all blocks in the backed up tablespace.

Highly voted

E. Incremental backups are not permitted when using block change tracking.

Highly voted

F. A database incremental level 0 backup always backs up all database blocks.

Highly voted

Discussion of the question

Question 42 🔥

Which two statements are true about scheduling operations in a pluggable database (PDB)?

Which database solution meets these requirements?

A. Scheduler jobs for a PDB can be defined only at the container database (CDB) level.

Highly voted

B. A job defined in a PDB runs only if that PDB is open.

Highly voted

C. Scheduler attribute setting is performed only at the CDB level.

Highly voted

D. Scheduler objects created by users can be exported or imported using Data Pump.

Highly voted

E. Scheduler jobs for a PDB can be created only by common users.

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_063

Exam contains 263 questions

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

Company

Product

Resources

Follow us