1Z0-053 | Practical Oracle 1Z0-053 vce
Q311. Which dependent object will get invalidated even if it is not affected by the table edefinition?
A. packages
B. triggers
C. synonyms
D. views
Answer: B
Q312. What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)-compliant? (Choose all that apply.)
A. ORACLE_BASE should be set explicitly.
B. An Oracle base should have only one Oracle home created in it.
C. Flash recovery area and data file location should be on separate disks.
D. Flash recovery area and data file location should be created under Oracle base in a non- Automatic Storage Management (ASM) setup.
Answer: ACD
Q313. The database is configured in ARCHIVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option? (Choose two)
A. Control files
B. Password files
C. Inactive online redo log file
D. Archived log files required to perform recovery
E. Newly created tablespace which is not backed up
Answer: AD
Q314. You have the following requirements in relation to the detection of block corruption for your database instance:
1. Check for logical self-consistency of data blocks when modified in memory.
2. Checksums are calculated before and after the block change.
3. Checks are performed for the lost writes to the physical standby database.
Which method would help you perform the above checks automatically?
A. Set the DB_SECUREFILE parameter to PERMITTED.
B. Set the DB_ULTRA_SAFE parameter to DATA_ONLY.
C. Set the DB_LOCK_CHECKSUM parameter to TYPICAL.
D. Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL.
Answer: B
Q315. View the Exhibit to examine the parameter values. You are planning to set the value for the MEMORY_TARGET parameter of your database instance. What value would you assign?
A. 1440 MB
B. 90 MB
C. 362 MB
D. 272 MB
Answer: C
Q316. You want to make sure that your database backup does not exceed 10 hours in length. What command would you issue that would meet this condition?
A. backup database plus archivelog;
B. backup database plus archivlog until time '10:00'
C. backup database plus archivelog timeout '10:00'
D. backup database plus archivelog duration 10:00;
E. backup database plus archivelog timeout 10:00;
Answer: D
Q317. A user performs an update on a table. Shortly after committing the transaction, they realize that they had an error in their WHERE clause causing the wrong rows to be updated. Which Flashback option would allow you to undo this transaction and restore the table to its previous state?
A. Flashback Drop
B. Flashback Query
C. Flashback Versions Query
D. Flashback Transaction Query
E. Flashback Table
Answer: E
Q318. Which is the correct way to connect to both the target database and the recovery catalog from the RMAN command line? Assume that the target database is called ORCL and that the recovery catalog database is called RCAT. Also assume that the recovery-catalog owner is called RCAT_OWN. Assume the environment is configured for the ORCL database. (Choose all that apply.)
A. rman target=/ catalog=/@rcat
B. rman target=/ catalog=rcat_own/rcat_own
C. rman target=/ catalog=rcat_own/rcat_own@RCAT
D. rman target=sys/robert@orcl catalog=rcat_own/rcat_own@RCAT
E. You cannot connect to the target database and the recovery catalog at the same time.
Answer: CD
Q319. Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backup and specify the KEEP clause.
Which components are backed up when this option is specified?
A. only the control file, the current SPFILE, and data files
B. only the current SPFILE and data files if autobackup is disabled
C. only the data files and the archived redo logs
D. the control file, current SPFILE file, data files, and archived redo logs
Answer: D
Q320. You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUT parameter set to a nonzero value.
Which three statements about resumable space allocation are true? (Choose three.)
A. Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.
B. A resumable statement is suspended only if an out of space error occurs.
C. When a resumable statement is suspended, the transaction that contains the statement is also suspended.
D. A resumable statement can only be suspended and resumed once during the execution of the statement.
E. You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session.
Answer: ACE