Top Quality of 1Z0-052 exam engine materials and study guides for Oracle certification for IT specialist, Real Success Guaranteed with Updated 1Z0-052 pdf dumps vce Materials. 100% PASS Oracle Database 11g: Administration I exam Today!
2021 May 1Z0-052 Study Guide Questions:
Q1. Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds. You executed the following command to enable retention guarantee:
SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;
What affect would this command have on the database?
A. The extents in the undo tablespace retain data until the next full database backup
B. The extents containing committed undo in the undo tablespace are not overwritten for at least 15 minutes
C. The extents containing committed data in the undo tablespace are not overwritten until the instance is shut down
D. The extents containing committed undo in the undo tablepace are transferred to Flash Recovery Area before being overwritten
Q2. Which three statements are correct about temporary tables? (Choose three.)
A. Indexes and views can be created on temporary tables
B. Both the data and structure of temporary tables can be exported
C. Temporary tables are always created in a user's temporary tablespace
D. The data inserted into a temporary table in a session is available to other sessions
E. Data Manipulation Language (DML) locks are never acquired on the data of temporary tables
Q3. Examine the commands executed in the following sequence:
Which statement is true about the above commands?
A. The commands execute successfully.
B. Command 6 produces an error because of circular role grant.
C. Command 5 produces an error because a role cannot be granted to another role.
D. Command 3 produces an error because the MGRROLE role already contains system privileges. The table created by HR remains and HR still has the CREATE TABLE system privilege.
E. The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
Far out 1z0-052 vce:
Q4. Note the following functionalities of various background processes:
1. Record the checkpoint information in data file headers.
2. Perform recovery at instance startup.
3. Cleanup unused temporary segments.
4. Free the resources used by a user process when it fails.
5. Dynamically register database services with listeners.
6. Monitor sessions for idle session timeout.
Which option has the correct functionalities listed for a background process?
A. Archiver Process (ARCn): 1, 2, 5
B. System Monitor Process (SMON): 1, 4, 5
C. Process Monitor Process (PMON): 4, 5, 6
D. Database Writer Process (DBWn): 1, 3, 4
Q5. You notice that the performance of the database has degraded because of frequent checkpoints.
Which two actions resolve the issue? (Choose two.)
A. Disable automatic checkpoint tuning
B. Check the size of the redo log file size and increase the size if it is small
C. Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor
D. Decrease the number of redo log members if there are more than one redo log members available in each redo log group
Q6. View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hour that performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives the following error:
ORA-01555: snapshot too old What could be the reason for this error?
A. The query is unable to get a read-consistent image.
B. There is not enough space in Flash Recovery Area.
C. There is not enough free space in the flashback archive.
D. The query is unable to place data blocks in undo tablespace.
Certified 1z0-052 exam:
Q7. You are managing an Oracle Database 11g database with the following backup strategy:
1. On Sunday, an incremental level 0 tape backup is performed
2. Monday through Saturday, a cumulative incremental level 1 tape backup is performed
Which two statements are true regarding the backups performed? (Choose two.)
A. The backup performed in step 1 backs up all blocks that have ever been in use in the database
B. The backup performed in step 2 copies all the blocks changed since the most recent level 0 backup
C. The backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup
D. The backup performed in step 2 backs up all blocks that have changed since the most recent incremental backup at level 1
Q8. A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable the constraint that was disabled.
What are the two effects of this command? (Choose two.)
A. It fails if any existing row violates the constraint.
B. It does not validate the existing data in the table.
C. It enables the constraint to be enforced at the end of each transaction.
D. It prevents insert, update, and delete operations on the table while the constraint is in the process of being enabled.
Q9. You configured the Flash Recovery Area (FRA) for your database. The database instance is running in ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which two files are removed automatically if the space is required in the FRA as per the retention policy? (Choose two.)
A. Flashback log files
B. Backups that have become obsolete
C. User managed backups of the data files and control files
D. Archived redo log files that have multiple copies in a different archive location and not backed up
Q10. You executed the following command to create a password file in the database server:
$ orapwd file = orapworcl entries = 5 ignorecase=N
Which statement describes the purpose of the above password file?
A. It records usernames and passwords of users when granted the DBA role
B. It contains usernames and passwords of users for whom auditing is enabled
C. It is used by Oracle to authenticate users for remote database administrator
D. It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating groups