Online Access Free 1Z1-052 Exam Questions

You executed the following command to perform a backup of the USERS tablespace:
SQL> ALTER TABLESPACE users BEGIN BACKUP;
ALTER TABLESPACE users BEGIN BACKUP
* ERROR at line 1:
ORA-01123: cannot start online backup; media recovery not enabled
What could be the reason for this error?

• A.The Flash Recovery Area is not configured.
• B.The tablespace is already in backup mode.
• C.The MTTR Advisor is disabled.
• D.The database is in NOARCHIVELOG mode.

View the Exhibit to examine the details for an incident.

Which statement is true regarding the status of the incident?

• A.The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support
• B.The incident has been newly created and is in the process of collecting diagnostic information
• C.The DBA is working on the incident and prefers that the incident be kept in the ADR
• D.The incident is now in the Done state and the ADR can select the incident to be purged

You set the following parameters in the parameter file and restarted the database:
MEMORY_MAX_TARGET=0
MEMORY_TARGET=500M
PGA_AGGREGATE_TARGET=90M
SGA_TARGET=270M
Which two statements are true about these parameters after the database instance is restarted?
(Choose two.)

• A.The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero.
• B.The value of the MEMORY_MAX_TARGET parameter remains zero until it is changed manually.
• C.The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.
• D.The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively.

In your database instance, the user sessions are connected to the database server from the remote machines. You want to achieve the following for these users:
1 . The user account must be locked after four unsuccessful login attempts.
2 . The user must be prompted to change the password at regular intervals.
3 . The user may not have more than three simultaneous sessions.
4 . The user session must automatically be logged off if more than 10 minutes elapsed time used.
How would you accomplish the above?

• A.By assigning profiles for the users
• B.By implementing the Database Resource Manager plan
• C.By implementing Fine-Grained Auditing (FGA)
• D.By granting a secure application role to the users

Which action is automatically performed as part of the Incident Packaging Service in Enterprise Manager Support Workbench?

• A.invoking the SQL Test Case Builder
• B.gathering metadata from the Automatic Diagnostic Repository (ADR)
• C.Creating a service request with My Oracle Support
• D.invoking the Data Recovery Advisor and SQL Repair Advisor