1Z0-053 | Up to date Oracle 1Z0-053 braindumps
Q131. Which command creates an image copy?
A. backup as copy
B. backup copy
C. copy as backup
D. copy back
Answer: A
Q132. True or false: RMAN offers the equivalent of the SQL command alter database backup controlfile to trace.
A. True
B. False
Answer: B
Q133. Which command will result in a trace file being created with the create controlfile command contained in it?
A. alter database backup controlfile;
B. alter database backup controlfile to trace;
C. alter database controlfile backup;
D. alter database controlfile backup to '/ora01/oracle/ctrl_backup.ctl'
E. alter database begin controlfile backup;
Answer: B
Q134. A schedule defined entirely within the confines of a Scheduler job object is known as a (n) ________________.
A. Fixed schedule
B. Inline schedule
C. Stored schedule
D. Hard-coded schedule
E. None of the above
Answer: B
Q135. View the Exhibit to examine the details for an incident. Which statement is true regarding the status of the incident?
A. The incident has been newly created and is in the process of collecting diagnostic information.
B. The incident is now in the Done state and the ADR can select the incident to be purged.
C. The DBA is working on the incident and prefers that the incident be kept in the ADR.
D. The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support.
Answer: D
Q136. Which of the following RMAN structures can data from a datafile span?
A. RMAN backup-set pieces spanning backup sets
B. RMAN backup-set pieces within a given backup set
C. RMAN backups
D. RMAN channels
E. None of the above
Answer: B
Q137. ASM supports all but which of the following file types? (Choose all that apply.)
A. Database files
B. Spfiles
C. Redo-log files
D. Archived log files
E. RMAN backup sets
F. Password files
G. init.ora files
Answer: FG
Q138. Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP;
While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true?
A. The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.
B. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.
C. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.
D. If you restart the database, the database will not be opened.
Answer: D
Q139. Examine the following RMAN command:
BACKUP DATABASE
TAG TESTDB
KEEP UNTIL 'SYSDATE+1'
RESTORE POINT TESTDB06;
Which two statements are true regarding the backup taken by using the above RMAN command? (Choose two.)
A. Only data files and the control file are backed up.
B. Archived redo logs are backed up only if the database is open during the backup.
C. The backup is deleted after one day, regardless of the default retention policy settings.
D. The backup becomes obsolete after one day, regardless of the default retention policy settings.
Answer: BD
Q140. In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.
Which method must you use to recover the lost data?
A. Complete Recovery with online redo log
B. Complete Recovery with archived redo log
C. Tablespace Point-in-Time Recovery (TSPITR)
D. Incomplete Recovery with system change number (SCN)
Answer: C