1Z0-053 | Update Oracle 1Z0-053 exam dumps
Q71. You want to perform the following operations for the DATA ASM disk group:
-Verify the consistency of the disk.
-Cross-check all the file extent maps and allocation tables for consistency.
-Check whether the alias metadata directory and file directory are linked correctly.
-Check that ASM metadata directories do not have unreachable allocated blocks.
Which command accomplishes these tasks?
A. ALTER DISKGROUP data CHECK;
B. ALTER DISKGROUP data CHECK DISK;
C. ALTER DISKGROUP data CHECK FILE;
D. ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1;
Answer: A
Q72. Which of the following are valid program types for a lightweight job? (Choose all that apply.)
A. PLSQL_BLOCK
B. EXECUTABLE
C. JAVA_STORED_PROCEDURE
D. STORED_PROCEDURE
E. EXTERNAL
Answer: AD
Q73. Which is true concerning Database Replay in an Oracle Real Application Cluster (RAC) database?
A. Workload capture is per instance.
B. You only need to restart one instance to begin workload capture.
C. Specifically in RAC, you shut down all instances, restart them individually, and begin workload capture with the last instance started.
D. RAC does not support workload capture, but it does support workload replay.
E. None of the above.
Answer: E
Q74. Which option is best practice for creating a recovery catalog owner in the catalog database?
A. Granting UNLIMITED QUOTA on the SYSTEM tablespace to the owner
B. Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the user
C. Creating a new tablespace, allocating this as the default, and granting UNLIMITED QUOTA on this tablespace to the user
D. Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user
Answer: C
Q75. Which command is used to open the database after an incomplete recovery?
A. alter database open
B. alter database open repairlog
C. alter database open resetlogs
D. alter database open resetlog
E. alter database resetlogs open
Answer: C
Q76. Given the following steps, which would be the correct order to create a backup of an Oracle database in NOARCHIVELOG mode?
a. shutdown immediate from RMAN
b. Log into RMAN
c. startup mount from RMAN
d. backup database
e. alter database open
f. backup database plus archivelog delete input
A. b, c, a, d, e
B. b, a, c, f, e
C. a, c, e, d
D. b, a, c, e, f
E. b, a, c, d, e
Answer: E
Q77. Evaluate the following statements:
CREATE TABLE purchase_orders
(po_id NUMBER(4),
po_date TIMESTAMP,
supplier_id NUMBER(6),
po_total NUMBER(8,2),
CONSTRAINT order_pk PRIMARY KEY(po_id))
PARTITION BY RANGE(po_date)
(PARTITION Q1 VALUES LESS THAN (TO_DATE(?1-apr-2007?d-mon-yyyy?),
PARTITION Q2 VALUES LESS THAN (TO_DATE(?1-jul-2007?d-mon-yyyy?),
PARTITION Q3 VALUES LESS THAN (TO_DATE(?1-oct -2007?d-mon-yyyy?),
PARTITION Q4 VALUES LESS THAN (TO_DATE(?1-jan-2008?d-mon-yyyy?));
CREATE TABLE purchase_order_items
(po_id NUMBER(4) NOT NULL,
product_id NUMBER(6) NOT NULL,
unit_price NUMBER(8,2),
quantity NUMBER(8),
CONSTRAINT po_items_fk
FOREIGN KEY (po_id) REFERENCES purchase_orders(po_id))
PARTITION BY REFERENCE(po_items_fk);
What are the two consequences of the above statements? (Choose two.)
A. Partitions of PURCHASE_ORDER_ITEMS have system-generated names.
B. Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each.
C. Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.
D. The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.
E. Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.
Answer: BC
Q78. In your production database, you:
- Are using Recovery Manager (RMAN) with a recovery catalog to perform the backup operation at regular intervals
Set the control file autobackup to "on"
- Are maintaining image copies of the database files
You have lost the server parameter tile (SPFILE) and the control file. Which option must you consider before restoring the SPFILI: and the control file by using the control file autobackup?
A. setting DBID for the database
B. using the RMAN SWITCH command
C. using the RMAN SWITCH command
D. starting up the database Instance In the NOMOUNT state
Answer: C
Q79. Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode? (Choose all that apply.)
A. Setting the FAST_START_MTTR_TARGET to set the mean time to recover
B. Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs
C. Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area
D. Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area
Answer: CD
Q80. Which of the following calendaring syntax expressions would evaluate to the last day of every month?
A. FREQ = MONTHLY; BYMONTHDAY = 31
B. FREQ = MONTHLY; BYMONTHDAY = -1
C. FREQ = DAILY; BYDAY = -1
D. FREQ = MONTHLY; BYDAY = 31
E. FREQ = DAILY; BYMONTHDAY = LAST_DAY
Answer: B