Oracle Database 12c: Advanced Administration - 1z0-063무료 덤프문제 풀어보기
Which three statements are true about a job chain? (Choose three.)
정답: C,D,E
Because of logical corruption of data in a table, you want to recover the table from an RMAN backup to a specified point in time.
Examine the steps to recover this table from an RMAN backup:
1. Determine which backup contains the table that needs to be recovered.
2. Issue the RECOVER TABLE RMAN command with an auxiliary destination defined and the point in time specified.
3. Import the Data Pump export dump file into the auxiliary instance.
4. Create a Data Pump export dump file that contains the recovered table on a target database.
Identify the required steps in the correct order.
Examine the steps to recover this table from an RMAN backup:
1. Determine which backup contains the table that needs to be recovered.
2. Issue the RECOVER TABLE RMAN command with an auxiliary destination defined and the point in time specified.
3. Import the Data Pump export dump file into the auxiliary instance.
4. Create a Data Pump export dump file that contains the recovered table on a target database.
Identify the required steps in the correct order.
정답: B
Which three statements are true about unplugging a pluggable database (PDB)? (Choose three.)
정답: B,C,E
설명: (Fast2test 회원만 볼 수 있음)
Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:
1. Create a policy to capture the privileges used by a user for privilege analysis.
2. Generate a report with the data captured for a specified privilege capture.
3. Start analyzing the data captured by the policy.
4. Revoke the unused privileges.
5. Compare the used and unused privileges' lists.
6. Stop analyzing the data.
Identify the correct sequence of steps.
1. Create a policy to capture the privileges used by a user for privilege analysis.
2. Generate a report with the data captured for a specified privilege capture.
3. Start analyzing the data captured by the policy.
4. Revoke the unused privileges.
5. Compare the used and unused privileges' lists.
6. Stop analyzing the data.
Identify the correct sequence of steps.
정답: A
설명: (Fast2test 회원만 볼 수 있음)
You want to reduce fragmentation and reclaim unused space for the sales table but not its dependent objects.
During this operation, you want to ensure the following:
i. Long-running queries are not affected.
ii. No extra space is used.
iii. Data manipulation language (DML) operations on the table succeed at all times throughout the process.
iv. Unused space is reclaimed both above and below the high water mark.
Which alter TABLE option would you recommend?
During this operation, you want to ensure the following:
i. Long-running queries are not affected.
ii. No extra space is used.
iii. Data manipulation language (DML) operations on the table succeed at all times throughout the process.
iv. Unused space is reclaimed both above and below the high water mark.
Which alter TABLE option would you recommend?
정답: A
Which two statements are true regarding the Oracle Data Pump export and import operations? (Choose two.)
정답: C,D
One of your database runs in ARCHIVELOG mode.
Examine these initialization parameter settings:
Which statement is true based on these settings?
Examine these initialization parameter settings:
Which statement is true based on these settings?
정답: B
Which two statements are true about dropping a pluggable database (PDB)? (Choose two.)
정답: A,B
설명: (Fast2test 회원만 볼 수 있음)
You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference.
Which method or feature should you use?
Which method or feature should you use?
정답: B
You are administering a multitenant container database (CDB).
Identify two ways to access a pluggable database (PDB) that is open in read-only mode. (Choose two.)
Identify two ways to access a pluggable database (PDB) that is open in read-only mode. (Choose two.)
정답: A,B
In your database, the tbs percent used parameter is set to 60 and the tbs percent free parameter is set to 20.
Which two storage-tiering actions might be automated when using Information Lifecycle Management (ILM) to automate data movement? (Choose two.)
Which two storage-tiering actions might be automated when using Information Lifecycle Management (ILM) to automate data movement? (Choose two.)
정답: B,E
Examine the steps/operations performed during the RMAN backup operation by using Oracle Secure Backup (OSB):
1. Start the RMAN client by using the RMAN TARGET / command.
2. Start the RMAN client by using the OSB user.
3. RMAN creates the backup pieces.
4. Run the RMAN BACKUP command with the SBT channels.
5. OSB creates a backup job and assigns a unique identifier.
6. OSB creates a backup job request through the OSB SBT library.
7. OSB stores metadata about RMAN backup pieces in the OSB catalog.
8. OSB starts the backup operation.
9. OSB updates the RMAN catalog.
Identify the required steps/operations performed in correct order.
1. Start the RMAN client by using the RMAN TARGET / command.
2. Start the RMAN client by using the OSB user.
3. RMAN creates the backup pieces.
4. Run the RMAN BACKUP command with the SBT channels.
5. OSB creates a backup job and assigns a unique identifier.
6. OSB creates a backup job request through the OSB SBT library.
7. OSB stores metadata about RMAN backup pieces in the OSB catalog.
8. OSB starts the backup operation.
9. OSB updates the RMAN catalog.
Identify the required steps/operations performed in correct order.
정답: D