New questions 1z0-063  

  RSS

Active Member
Joined:6 years  ago
Posts: 5
29/11/2017 6:16 am  

I did the exam a month ago. These questions were in the exam and I didn't see on your web.

Questions:

You want to backup a database such that only formatted blocks are backed up. Which statement is true about this backup operation?
A. The backup must be performed in mount state.
B. The tablespace must be taken offline.
C. All files must be backed up as backup sets.
D.The database must be backed up as an image copy.

Answer: C

A database is running in archive log mode. The database contains locally managed tablespaces. Examine the RMAN command:
RMAN> BACKUP AS COMPRESSED BACKUPSET SECTION SIZE 1024M DATABASE;
Which statement is true about the execution of the command?
A. The backup succeeds only if all the tablespaces are locally managed.
B. The backup succeeds only if the RMAN default device for backup is set to disk.
C. The backup fails because you cannot specify section size for a compressed backup.
D. The backup succeeds and only the used blocks are backed up with a maximum backup piece size of 1024 MB.

Answer: D

Your database is running in ARCHIVELOG mode and flashback is enabled.
In which scenario must you use RMAN backups for recovering tables and table partitions?
A. When recovering a table to a point in time
B. When recovering a table that has been logically corrupted
C. When recovering dropped tables that are present in the recyclebin
D. When recovering the data of a table to the desired point in time, which is more recent than the oldest available undo
E. When recovering data that was lost after a DDL operation modified the structure of a table

Answer: A

Which three statements are true about Flashback Data Archive?
A. Flashback Data Archive prevents flashback queries from getting a snapshot-too-old error
B. A table enabled for Flashback Data Archive cannot be dropped unless Flashback Data Archive is disabled or disassociated first
C. To enable Flashback Data Archive for a table, it is mandatory to have a default Flashback Data Archive for a database
D. While enabling Flashback Data Archive for a table, if no name is provided for Flashback Data Archive, it is enabled using the default Flashback Data Archive
E. To use Flashback Data Archive, users must have unlimited quota on the Flashback Data Archive tablespace

Answer: A, B, E

1. FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP (‘2013-02-04 09:30:00’, ‘YYYY-MM-DD HH:MI:SS’);
2. SELECT * FROM customers AS OF SCN 123456;
3. FLASHBACK TABLE customers TO BEOFRE DROP;
4. FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP (‘2013-02-04 09:30:00’, ‘YYYY-MM-DD HH:MI:SS’);
5. SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999;
6. ALTER TABLE customers FLASHBACK ARCHIVE.
Which set of statements depends on the availability of relevant undo data in the undo tablespace?
A. 1, 2, 5
B. 1, 3, 6
C. 2, 3, 5, 6
D. 3, 4, 5

Answer: A

In your database, the user SCOTT wants to retrieve the dropped HR.EMPLOYEES table by using the command:
SQL> FLASHBACK TABLE HR.EMPLOYEES TO BEFORE DROP;
What are thre prerequisites for this command to succeed?
A. Undo retention guarantee must be enabled
B. No other table with the same name should exist in the HR schema
C. SCOTT should have the FLASHBACK ANY TABLE privilege
D. SCOTT should have the SELECT privilege on the HR schema and its recyclebin
E. No duplicates of the HR.EMPLOYEES table should exist in the recyclebin of the HR schema
F. The recycle bin should be enabled

Answer: A, C, F

Examine the RMAN commands:
RMAN> CONNECT TARGET “sbu@prod AS SYSBACKUP”;
RMAN> CONNECT AUXILIARY “sbu@prod AS SYSBACKUP”;
RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M;
Which statement is true about the DUPLICATE command?
A. It fails because there is no connection to a recovery catalog
B. It fails because no parallel channels are allocated for the auxiliary database
C. It succeeds only if the target database is in mount state
D. It succeeds and creates multisection backup sets that are used for active database duplication

Answer: D

You execute the RMAN commands:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2;
RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT ‘/disk1/%u’;
RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT ‘/disk2/%u’;
Which statement is true about the backup set created by the BACKUP command?
A. The default channel is allocated and the backup set is created in only one destination
B. Two channels are allocated and backup pieces for the backup set are created in both the specified destinations
C. Two channels are allocated and two copies of the backup set are taken in parallel in both locations
D. Two channels are allocated and a copy of the backup set is taken in the location specified by CHANNEL 2

Answer: B

You issue the RMAN command:
RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;
Which statement is true about the execution of the command?
A. The resulting backupset has backup pieces that cannot exceed 300 MB
B. RMAN uses multiplexing to perform the backup
C. RMAN always performs this type of backup in parallel
D. The backup succeeds only if the USERS tablespace is locally managed
E. The backup set size is limited to 300 MB

Answer: A


ReplyQuote
PrepAway - Latest Free Exam Questions & Answers
  
Working

Please Login or Register