1z1-062試験無料問題集「Oracle Database 12c: Installation and Administration 認定」

A. by implementing Database Resource Manager and assign it a role for the user

B. by using appropriate PASSWORD parameters set in the profile assigned to the user

C. by using appropriate KERNEL parameters set in the profile assigned to the user

D. by alerting the appropriate user attributes with an ALTER USER command

E. by implementing Database Resource Manager and assign it a profile for the user

A. Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.

B. Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.

C. Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.

D. Statistics collection is not done for the CUSTOMERS table when database stats are gathered.

E. Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.

A. Level 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since the last level 1 backup.

B. Level 0 backup on Sunday contains all the blocks that have been formatted.

C. Level 0 backup on Sunday contains all the blocks that have been changed since the last level 1 backup.

D. Level 1 backup on Monday, Wednesday, and Saturday contains all the blocks that have been changed since the last level 0 backup.

E. Level 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since the last level 0 backup.

A. BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container

B. BACKUP PLUGGABLE database PDB1 while connected to PDB2

C. BACKUP DATABASE while connected to the boot container

D. BACKUP PLUGGABLE DATABASE PDB1 while connected to the root container

E. BACKUP DATABASE while connected to the PDB1 container

A. A resumable statement can be suspended and resumed only once during execution.

B. Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.

C. Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.

D. Before a statement executes in resumable mode, the ALTER SESSION ENABLE RESUMABLE statement must be issued in its session.

E. A suspended statement will report an error if no corrective action has taken place during a timeout period.

A. They ensure that uncommitted transactions are rolled back in case of an instance failure.

B. They ensure that dirty buffers in the buffer cache are written to disk regularly.

C. They ensure that all the dirty buffers are written to disk during a normal shutdown.

D. They ensure that instance recovery starts in the event of an instance failure.

E. They reduce the time required for recovery in case of an instance failure.

A. RMAN

B. The DBMS_PDB package

C. Transportable database

D. Transportable tablespace

E. Data Pump full export/import

A. MMON

B. SMON

C. PMON

D. MMNL

E. MMAN

A. It executes successfully and creates a backup set of the database along with archived log files and then deletes the original archived log files.

B. It fails because the DELETE INPUT option can be used only with the BACKUP AS BACKUPSET command.

C. It executes successfully and creates an image copy of the database along with archive log files and then deletes the original archived log files.

D. It fails because the DELETE INPUT option can be used only with the BACKUP AS COPY command.

A. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.

B. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.

C. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.

D. Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.

E. Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.

F. Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.

A. Duplex the RMAN backup sets.

B. Configure the database to run in ARCHIVELOG mode.

C. Multiplex the online redo log files.

D. Multiplex the control files

A. The ADDM runs after each AWR snapshot is collected automatically by MMON

B. The ADDM requires at least four AWR snapshots for analysis

C. The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR)

D. The ADDM calls other advisors if required, but does not provide recommendations about the advisors

E. The ADDM analysis provides only diagnostics information but does not provide recommendations

A. Resumable space allocation does not apply when users exceed their assigned space quota in a tablespace.

B. A resumable statement can be suspended and resumed only once during a session.

C. SELECT statements that run out of temporary space for sort areas are candidates for resumable execution.

D. A database-level LOGON trigger can be used to automatically configure resumable statement settings for individual sessions.

E. Free space in a segment is automatically reclaimed when a resumable statement is suspended because of an out-of-space condition.

F. Resumable space allocation does not apply when a database instance uses asynchronous commit.