The examinees that study the Pass4sure Oracle 1Z0-052 puts are usually success of highly certified instructors, living an excellent existence. Pass4sure may be dedicated to build your potential secure and begin your own Oracle 1Z0-052 Oracle Database 11g: Administration I examination preparations through the latest updated Pass4sure checks 1Z0-052 test engine. Your goals can come true by commence your own 1Z0-052 vce with regard to Oracle Database 11g: Administration I examination by means of Pass4sure Oracle research manuals only. You will not able to excel your talent inside the initial try of 1Z0-052 test if you use any additional path than Oracle. Oracle Oracle 1Z0-052 pdf will provide you with brilliance thus making you sufficient positive about your entire existence.
2021 Jan 1Z0-052 free practice exam
Q101. You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add a new column to the EMPLOYEE table to achieve this.
Which data types would you use for the new column?
A. CLOB
B. BLOB
C. BFILE
D. LONG RAW
Answer: C
Q102. Note the functionalities of various background processes:
1: Perform recovery at instance startup.
2: Free the resources used by a user process when it fails.
3: Cleanup the database buffer cache when a process fails.
4: Dynamically register database services with listeners.
5: Monitor sessions for idle session timeout.
6: Cleanup unused temporary segments.
7: Record the checkpoint information in control file.
Which option has the correct functionalities listed for a background process?
A. Checkpoint (CKPT): 1, 2, 5
B. System Monitor (SMON): 1, 6
C. Process Monitor (PMON): 4, 6, 7
D. Database Writer (DBWR): 1, 3, 4
Answer: B
Q103. 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
Answer: B
Q104. The database instance has the following parameter setting:
OS_AUTHENT_PREFIX = OPS$
OS_ROLES = FALSE
REMOTE_OS_AUTHENT = FALSE
REMOTE_OS_ROLES = FALSE
TIMED_OS_STATISTICS = 0
You have a local operating system user SKD. You create a database user OPS$SKD, and then assign external authentication. The user OPS$SKD has the CREATE SESSION privilege.
What would you achieve by the above process?
A. The database user OPS$SKD will be able to administer the database.
B. The authentication detail for the database user OPS$SKD is recorded in the password file.
C. The local operating system user SKD will be able to access the database instance without specifying the username and password.
D. The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.
Answer: C
Q105. Which three operations require undo data? (Choose three.)
A. Committing a transaction
B. Flashing back a transaction
C. Recovering a failed transaction
D. Running a read-consistent query
E. Changing a tablespace status from READ ONLY to READ WRITE
Answer: BCD
Replace 1Z0-052 exam question:
Q106. Which statements are true regarding the creation of an incident package file by using the EM Workbench Support? (Choose all that apply.)
A. You can add SQL test cases to the incident package.
B. You can add or remove the trace files to the package.
C. You cannot create an incremental incident package when the physical files are purged from the ADR.
D. You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.
Answer: ABD
Q107. Identify the memory component from which memory may be allocated for:
Session memory for the shared serverBuffers for I/O slavesOracle Database Recovery Manager (RMAN) backup and restore operations
A. Large Pool
B. Redo Log Buffer
C. Database Buffer Cache
D. Program Global Area (PGA)
Answer: A
Q108. Your database instance is started using the server parameter file (SPFILE). You executed a
command to change the value of the LOG_BUFFER initialization parameter:
ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH;
What would be the outcome of this command?
A. The command succeeds only if Automatic Memory Management is not enabled.
B. The command succeeds, but you need to restart the database for changes to take effect.
C. The command returns an error because the size of the redo log buffer cannot be changed dynamically.
D. The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area (SGA).
Answer: C
Q109. See the Exhibit to observe the roles assigned to the SL_REP user.
Which statement is true about the assignment of the SELECT_CATALOG_ROLE role to the SL_REP user?
A. The user must enable the role explicitly
B. The user can grant the role to other users
C. The user cannot user the role until the DBA enables it explicitly
D. The user can start using the role immediately without any changes
Answer: A
Q110. Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)
A. The ADDM requires at least four AWR snapshots for analysis
B. The ADDM runs after each AWR snapshot is collected automatically by MMON
C. The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR)
D. The ADDM analysis provides only diagnostics information but does not provide recommendations
E. The ADDM calls other advisors if required, but does not provide recommendations about the advisors
Answer: BC