Online Comptia Certification Exam Braindumps–Pass4side

Information from: www.pass4side.com

11. Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to
use Recovery Manager (RMAN) to perform backups.
Which two backups would you be able to perform when the database is being accessed by users? (Choose two.)
Pass4Side Orcal 1Z0-043
Pass4Side Help you pass any IT Exams! Page 6 of 9
A. backup of offline tablespaces
B. backup of read-only tablespaces
C. backup of system-critical tablespaces
D. backup of online, locally managed tablespaces
E. backup of read/write dictionary-managed tablespaces
Answer:AB

12. Which two statements regarding compressed backups in Recovery Manager (RMAN) are true? (Choose two.)
A. Backup compression is disabled by default.
B. Backup compression applies to only backup sets.
C. Backup compression applies to only image copies.
D. Backup compression cannot be enabled using the CONFIGURE command.
E. Backup compression can be used with both backup sets and image copies.
F. Backup compression works only if the COMPATIBILITY parameter is set to 9.0.0.0 or higher.
Answer:AB

13. What purpose would you achieve by enabling the block change tracking feature?
A. eliminate the necessity for backups
B. perform optimized image copy backups
C. perform optimized incremental backups
D. enable checkpoint (CKPT) to perform checkpointing at every block change
E. enable database writer (DBWn) to write changed blocks to data files faster
Answer:C

14. You are managing a database for which incremental backups can be very time consuming. In order to perform
optimized incremental backups you enable the block change tracking feature.
How would you instruct RMAN to use the block change tracking feature when performing incremental backups?
A. You need to mention it with every BACKUP command.
B. You need to configure it using the CONFIGURE command.
C. The block change tracking feature is used automatically by RMAN.
Pass4Side Orcal 1Z0-043
Pass4Side Help you pass any IT Exams! Page 7 of 9
D. You need to set the necessary initialization parameters to direct RMAN to use the feature.
Answer:C

15. You executed the following command in Recovery Manager (RMAN) against your Oracle 10g database:
RMAN> REPORT NEED BACKUP days 3;
What would be the output of this command?
A. a list of files that require a backup within three days
B. a list of files that have not been backed up for three days
C. a list of files that RMAN recommends be backed up only once in every three days, based on low volatility
D. a list of files for which a backup has already been performed and may need a backup after three days
Answer:B
16. The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following
command in Recovery Manager (RMAN) against your database:
RMAN> REPORT OBSOLETE;
What would you see in the output?
A. a list of all the expired backups and copies
B. a list of all those files that have been deleted in the last two days
C. a list of all those files that have been recovered within the last two days
D. a list of backups and copies that are outside the range covered by the current retention policy
Answer:D

17. Last night, a media failure caused the loss of a temporary file that belongs to your database. Which two things
may happen this morning when you try to open your database? (Choose two.)
A. The database opens normally.
B. The database prompts for a database recovery.
C. The database writer writes to a trace file, indicating that the temporary file is not found.
D. The database gets mounted and throws an error indicating that the temporary file requires recovery.
Answer:AC
18. A user executes a query on the EMP table, which contains thousands of rows, to get details about employees in
one of the departments. The user receives the following error:
SQL> SELECT ename FROM emp WHERE deptno=10 ORDER BY sal;
SELECT ename FROM emp WHERE deptno=10 ORDER BY sal
ERROR at line 1:
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: ‘/u01/app/oracle/oradata/orcl/temp01.dbf’
What is a possible reason?
A. The tempfile belonging to the default temporary tablespace is missing.
B. The database is opened in restricted mode, so queries are not allowed.
C. The default temporary tablespace required to execute the query is offline.
D. The default temporary tablespace required to execute the query is dropped.
E. The default temporary tablespace required to execute the query is read-only.
Answer:A

19.You are working on a database, where you have three redo log groups. When the database is down for a backup,
an operating system (OS) user deletes all the redo log files in a group. What will happen when you open your
database?
A. The instance starts and the database opens because two redo log groups still exist.
B. Before the instance starts, you receive an error about the missing redo log files of a group.
C. The instance starts and the database opens with an error message written to the alert log file.
D. The instance starts and the database opens, but every attempt to write to redo log files fails with an error.
E. The instance starts, the database is mounted, but efforts to open the database fail, and an error about the missing
redo log group is displayed.
Answer:E

20.A media failure has occurred. This has resulted in all the members of the next log group being rendered
inaccessible to the log writer process (LGWR) at a log switch. How does this failure affect the operational
Pass4Side Orcal 1Z0-043
Pass4Side Help you pass any IT Exams! Page 9 of 9
database?
A. The database re-creates the missing redo log files automatically.
B. The database continues to function normally with the existing files.
C. The database allows only queries; no other statements are allowed.
D. The database returns an error and the database instance shuts down.
E. The user sessions that generate redo logs are terminated automatically.
Answer:D

Powered by MightyAdsense