Oracle Database 11g Administration II Version: 3.1 (Course: 1z0-053 Exam) Part-II

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

Email *

Write Down the your Full Name? *

Write Down the your Mobile Number? *

QUESTION NO: 101 View the Exhibit and examine the Data Pump architecture. Identify the numbered components. Exhibit: *

1 point

A. 1 - Oracle Loader, 2 - Oracle Data Pump, 3 - Direct Path API

B. 1 - Oracle Data Pump, 2 - Direct Path API, 3 - Oracle Loader

C. 1 - Direct Path API, 2 - Oracle Loader, 3 - Oracle Data Pump

D. 1 - Oracle Loader, 2 - Direct Path API, 3 - Oracle Data Pump

QUESTION NO: 102 The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump. Which option of Data Pump Import would you use to accomplish this? *

1 point

A. owner

B. touser

C. attach

D. remap_schema

QUESTION NO: 103 The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner? *

1 point

A. Allow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfiles

B. Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGS

C. Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfile

D. Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.

QUESTION NO: 104 To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change tracking file? (Choose two.) *

1 point

A. Multiple change tracking files can be created for a database.

B. The change tracking file must be created after the first level 0 backup.

C.RMAN does not support backup and recovery of the change tracking file.

D. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

Required

QUESTION NO: 105 Which options would you consider while configuring a flash recovery area (fast recovery area in11g Release 2) for your production database that is running in ARCHIVELOG mode? (Choose all that apply.) *

1 point

A. Setting the FAST_START_MTTR_TARGET to set the mean time to recover

B. Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs

C. Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area

D. Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area

Required

QUESTION NO: 106 What are the different logging modes available in Oracle Database 11g? (Choose two.) *

1 point

A. NOLOG mode

B. NOARCHIVELOG mode

C. LOGGING mode

D. HOTDATABASE mode

E. ARCHIVELOG mode

Required

QUESTION NO: 107 Which is the correct command to put the database in ARCHIVELOG mode? *

1 point

A. alter database archivelog

B. alter system enable archivelog mode

C. alter database enable archive

D. alter database archivelog enable

E. None of the above

QUESTION NO: 108 Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database? *

1 point

A. Yes, if the database is in ARCHIVELOG mode.

B. Yes, if the database is in NOARCHIVELOG mode.

C. No, the backup is not usable in any way.

D. Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE.

QUESTION NO: 109 Which of the following parameters defines the location where Oracle should create archived redo logs? *

1 point

A. LOG_ARCHIVE_1

B. LOG_DESTINATION_1

C.LOG_ARCHIVED_DESTINATION_1

D. LOG_ARCHIVE_DEST_1

E. LOG_ARCHIVE_SOURCE_1

QUESTION NO: 110 Archived redo logs can be copied to more than one destination by Oracle. *

1 point

A. True

B. False

Clear form

Never submit passwords through Google Forms.

This content is neither created nor endorsed by Google. Report Abuse - Terms of Service - Privacy Policy

Forms