F the destination can be changed by setting the

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: tialization parameter. Answer: C,E QUESTION 118: You created a new user in your database but missed assigning a default tablespace to that user. The user created a table without specifying the tablespace name. In which tablespace would the table be stored? A. the INDEX tablespace B. the USERS tablespace C. the SYSAUX tablespace D. the SYSTEM tablespace Actualtests.com - The Power of Knowing 1Z0-042 E. the default undo tablespace F. the default temporary tablespace G. the default permanent tablespace Answer: G QUESTION 119: Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning, media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday. What would you do in this situation? A. recover using Oracle Flashback Database technology B. restore the data files from backup and perform a complete recovery C. restore only the corrupted data file and perform tablespace recovery D. restore the data files from backup and perform cancel-based recovery E. restore the entire database from the most recent backup and start the instance and open the database Answer: E QUESTION 120: You want the size of the tablespace to increase when it is full. Which option would you use? A. use automatic extent allocation B. disable threshold for the tablespace C. use freelists to manage the free space D. use automatic segment space management E. create the tablespace as a bigfile tablespace F. use the RESIZE clause while creating the tablespace G. enable AUTOEXTEND for at least one of the data files in the tablespace Answer: G QUESTION 121: Your database performance has degraded due to frequent checkpointing. What would you do in this scenario? A. make redo log files smaller B. increase the size of the checkpoint file C. make the changes as per the advice given by MTTR Advisor D. make the changes as per the advice given by Checkpoint Advisor Actualtests.com - The Power of Knowing 1Z0-042 Answer: C QUESTION 122: Exhibit: View...
View Full Document

Ask a homework question - tutors are online