1Z0-053 | A Review Of Practical 1Z0-053 examcollection
Q171. Which method could be utilized to identify both DML operations and the SQL statements needed to undo those operations for a specific schema owner? (Choose all that apply.)
A. Query DBA_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL.
Limit rows by START_SCN and TABLE_OWNER.
B. Query FLASHBACK_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL. Limit rows by START_SCN and TABLE_OWNER.
C. Query FLASHBACK_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL. Limit rows by START_TIMESTAMP and TABLE_OWNER.
D. Query DBA_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL.
Limit rows by START_SCN and TABLE_OWNER.
Answer: BC
Q172. View the Exhibit.
You are creating a database by using Database Configuration Assistant (DBCA). You have chosen the File System option as the storage mechanism. What would be the result of choosing this option?
Exhibit:
A. Disk mirroring and striping would be done automatically
B. The database files would be managed by the operating system's file system
C. DBCA would not save the database files by using Optimal File Architecture (OFA)
D. The data files are automatically spread across all available storage devices to optimize performance and resource utilization
Answer: B
Q173. Automatic data conversion will occur if which of the following happens?
A. The client and server have different NLS_LANGUAGE settings.
B. The client and server character sets are not the same, and the database character set is not a strict superset of the client character set.
C. The client and server are in different time zones.
D. The client requests automatic data conversion.
E. The AUTO_CONVERT initialization parameter is set to TRUE.
Answer: B
Q174. Which type of backup backs up only data blocks modified since the most recent backup at the same level or lower?
A. Differential incremental backup
B. Different incremental backup
C. Cumulative backup
D. Cumulative incremental backup
Answer: A
Q175. What is an obsolete backup set?
A. A backup set that is missing one or more backup set pieces
B. A backup that has exceeded the retention criteria and is no longer needed
C. A backup set that does not include archived redo logs
D. A backup set that can not be recovered due to corruption
E. A backup set superceded by a datafile copy
Answer: B
Q176. 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 or remove the trace files to the package.
B. You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.
C. You can add SQL test cases to the incident package.
D. You cannot create an incremental incident package when the physical files are purged rom the ADR.
Answer: ABC
Q177. View the Exhibit and note the contents of V$DIAG_INFO. Which statement is true about the ADR?
Exhibit:
A. The text alert log file will be available in Diag Trace
B. A copy alert log file will be kept in Diag Incident for every incident.
C. The XML version of the alert log file will be available in Diag Trace.
D. An Automatic Database Diagnostic Management (ADDM) report is generated and stored in the Health Monitor whenever an incident occurs.
Answer: A
Q178. What is the advantage of setting the ASM-preferred mirror read for the Stretch cluster configuration?
A. It improves resync operations.
B. This feature enables much faster file opens.
C. It improves performance as fewer extent pointers are needed in the shared pool.
D. It improves performance by reading from a copy of an extent closest to the node.
Answer: D
Q179. The BOOKINGS table contains online booking information. When a booking is confirmed, the details are transferred to an archival table BOOKINGS_HIST and deleted from the BOOKINGS table. There is no fixed time interval between each online booking and its confirmation. Because sufficient space is not always available from the delete operations the high-water mark (HWM) is moved up and many rows are inserted below the HWM of the table. The BOOKINGS table has Automatic Segment Space Management (ASSM) and row movement enabled. The table is accessible in 24x7 mode.
What is the most efficient method to reclaim the space released by the delete operations in the BOOKINGS table
A. Perform EXPORT, DROP, and IMPORT operations on the BOOKINGS table sequentially
B. Shrink the BOOKINGS table by using the ALTER TABLE... SHRINK SPACE command
C. Move the BOOKINGS table to a different location by using the ALTER TABLE... MOVE command
D. Deallocate the space in the BOOKINGS table by using the ALTER TABLE ... DEALLOCATE UNUSED command
Answer: B
Q180. What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode?
A. MMON
B. LGWR
C. ARCH
D. ARWR
E. COPY
Answer: C