PDF - - 1Z0-053-ENU.pdf
Wait Loading...




Like and share and download

1Z0-053-ENU.pdf

Related PDF

1Z0-060-Oracle Database 12c NF

Download Oracle 11g Upgrade Guide PDF

PDF Oracle Database 12c Oracle Rman Backup And Recoveryoracle 1z0 mclennan propertyai io oracle database 12c oracle rman backup and recoveryoracle 1z0 497 exam oracle database 12c essentials pdf PDF Database 12c Oracleloja n2midia br database 12c oracle pdf PDF Download Ocp Upgrade

1z0-060.v2015-03-01.by.EMMIE.150q

Get eBook \\ Oracle Database 12c New Features for - Ideate

PDF Actualtests 1z0 060 150q VCEplus ! vceplus 1z0 060 oracle actualtests 1z0 060 v2015 03 28 by lucile 150q pdf PDF Oracle Passit4sure 1z0 060 v2015 03 09 by Scott VCEplus !

1Z0-062_Oracle Database 12cInstallation and Administration

Oca Oracle Database 12c Installation And Administration Exam

PDF Oca Oracle Database 12c Installation And Administration Exam admin ifj oca oracle database 12c installation and administration exam guide exam 1z0 062 oracle press pdf PDF Oca Oracle Database 12c Installation And Administration Exam thelook almay oca oracle database 12c installation and

1Z0-330 Exam Training Material and Exam Dumps

oca oracle database sql certified expert exam guide exam 1z0 047

PDF Oracle 1Z0 330 Braindumps Jira – Atlassian jira atlassian secure attachment 323965 1Z0 330 pdf PDF Oracle 1Z0 330 PDF Questions | Valid Dumps 2019 Jira – Atlassian jira atlassian secure attachment 342460 1Z0 330

1Z0-434 - Oracle SOA Suite 12c Essentials.pdf

1z0 434 Oracle Soa Suite 12c Essentials Service - Book Library

PDF SOA Suite 12c Exam Study Guide PDF Oracle oracle soa suite 12c exam study guide 2398385 pdf PDF Oracle 1Z0 434 Dumps with Valid 1Z0 434 Exam Jira – Atlassian

1z0-481

1Z0-481 - CertBus

PDF Oracle 1Z0 481 Dumps with Valid 1Z0 481 Exam Questions PDF Jira jira atlassian secure 1Z0 481 Exam Dumps 2018 pdf PDF 1z0 481 Exam Questions Certleader pdf certleader 1z0 481 pdf PDF

1z0-497

1Z0-497 - Pass4Lead

PDF Oracle 1Z0 497 Dumps with Valid 1Z0 497 Exam Jira – Atlassian jira atlassian secure 1Z0 497 Exam Dumps 2018 pdf PDF 1Z0 497 Pass4Sure officialcerts pdf bycode 1Z0 497

1Z1 Scja Beta Exam Notes

Download Sun Java Certification Questions And Answers PDF

ytmfurniture sun java certification questions

bib irb hr datoteka 682263 Zbornik41 Badurina pdf LADA BADURINA VREMENSKI ODNOSI NA RAZINI SLOŽENE REČENICE I TEKSTA 77 II Vrijeme u rečenici Prikaz vremenskih odnosa na razini složene rečenice započet ćemo osvr tom na prototipni način njihova iskazivanja – vremenske zavisnosložene rečenice Odabir polazišne točke

Home back1025102610271028 10291030 Next

Description

Exam Name: Exam Type: Exam Code:

Oracle Database 11g: Administration II Oracle 1Z0-053

Total Questions:

Question: 1 You are not sure if Flashback Database is enabled

What database column and view can you query to see if the flashback logs are being created in the flash recovery area

Query the initialization parameter FLASHBACK_DATABASE in VJINSTANCE

Query the FLASHBACK_ENABLED column in VJDATABASE

Query the FLASHBACK column in VJDATABASE

Query the FLASHBACK_ON column in VJDATABASE

Answer: D'Explanation: To enable Flashback Database, you use the command ALTER DATABASE FLASHBACK ON

Your database must be in ARCHIVELOG mode, you must have the flash recovery area configured, and you must have DB_FLASHBACK_RETENTION_TARGET set to an appropriate value

A, B, and C are incorrect because they all specify columns that do not exist

Question: 2 What dynamic performance view can you query to list the supported platforms for transportable tablespaces

V$TRANSPORTABLE_PLATFORM B

V$TRANSPORTABLE_TABLESPACE C

V$SUPPORTED_PLATFORMS D

V$DATABASE PLATFORM Answer: A Explanation: You use the PLATFORM_NAME and ENDIAN_FORMAT columns to determine the supported endian formats for all supported platforms

B, C, and D'are incorrect because none of these views exist

Question: 3 You issue the following command to enable block change tracking: SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING

However, you receive an error message, and the tracking file is not created

What is a possible reason for the error message

The parameter DB_RECOVERY_FILE_DEST is not set

You must use ALTER SYSTEM instead

Your database must be in the MOUNT state to create the block change tracking file

The parameter DB_CREATE_FILE_DEST is not set

Answer: D'Explanation: Unless you explicitly specify a location for the block change tracking file using the USING FILE clause, the file is created using Oracle Managed Files (OMF), which requires a destination in the parameter DB_CREATE_FILE_DEST

A is incorrect because DB_RECOVERY_FILE_DEST specifies the location of the flash recovery area

B is incorrect because the tracking file is created at the database level, not the system level

Page 1 of 61

Exam Name: Exam Type: Exam Code:

Oracle Database 11g: Administration II Oracle 1Z0-053

Total Questions:

C is incorrect because you can create the tracking file when the database is OPEN

however, to rename the tracking file, the database must be in the MOUNT state

Question: 4 You are restoring and recovering a database to a new host

What data dictionary view will you use to identify the names of the datafiles on the new database

DBA_DATAFILE B

VJTABLESPACE C

VJDATAFILE D

V$DATAFILE_COPY E

VJBACKUP DATAFILE Answer: C Explanation: V$DATAFILE lists all the datafiles for the new database, and you will use these names in the SET NEWNAME command within the RMAN RUN block

A is incorrect because no data dictionary view called DBA_DATAFILE exists, and even if it did exist, the view would not be available when the database is in the MOUNT state

B, D, and E arencorrect because these views do not contain information about datafile names on the new host

Question: 5 Your flash recovery area becomes full when you are running an RMAN backup (and has not yet reached the value specified by DB_RECOVERY_FILE_DEST)

It is the destination for archived redo log files and backups

What will happen to the database

If you have the flash recovery area set toautoextend, the backup will continue with no problem

The database will hang until you add more space to the flash recovery area

RMAN will delete obsolete backups from the flash recovery area to accommodate new backups

The RMAN backup will hang until you add more space to the flash recovery area

Answer: C Explanation: RMAN will delete files from the flash recovery area if they are obsolete according to the defined retention policy

A is incorrect because you cannot configure the flash recovery area for autoextend

B is incorrect because the RMAN backup will fail, but the database will continue to run as long as space is available in the flash recovery area for archived redo log files or it is an optional destination

D'is incorrect because the RMAN backup will attempt to clean up obsolete files, and failing that, it will terminate the backup with an error message

Question: 6 You want to ensure the recoverability of the recovery catalog itself

Which of the following steps should you implement to maximize recoverability

Configure the database for ARCHIVELOG mode

Use BACKUP DATABASE PLUS ARCHIVELOG when you back up the recovery catalog

Put the recovery catalog in the target database, and include a backup of the recovery catalog with every backup

Page 2 of 61

Exam Name: Exam Type: Exam Code:

Oracle Database 11g: Administration II Oracle 1Z0-053

Total Questions:

Use BACKUP DATABASE PLUS ARCHIVELOG when you back up the recovery catalog

Back up the recovery catalog to disk and tape after each target database backup (in other words, two separate media types)

Answer: A, B, D, E Explanation: These are all best practices for a recovery catalog that also apply to any mission-critical database

C is incorrect because you should never store the recovery catalog database in the target database

Question: 7 For which of the following scenarios would you use user-managed incomplete recovery

You have lost a data file and one or more of the archived redo log files are missing

Several widespread logical errors have occurred in the database in the last day

You want to create a test database as of a point in time in the past

You have lost a data file and you have all archived redo log files available

You have lost one of the copies of the control file

Answer: A, B, C Explanation: A is correct because you cannot perform a full recovery with missing archived redo log files

B is correct because incomplete recovery can be performed to bring the database back to a point in time before the severe logical corruptions occurred

C is correct because you can easily copy the database and recover it to a point in time in the past for regression testing

D'is incorrect because you can perform complete recovery if you have lost a datafile and have all archived redo log files since the last backup of the datafile

E is incorrect because you do not need to perform recovery if only one copy of the control file is missing

Question: 8 You want to leverage resource consumer groups when using the Scheduler

Which Scheduler object uses resource plans directly

A lightweight job B

Ajob class C

Ajob chain D

A program Answer: B Explanation: You create a job class with CREATE_JOB_CLASS and specify a resource consumer group with the RESOURCE_CONSUMER_GROUP parameter

You can also specify a resource plan with CREATE_WINDOW

A is incorrect because you cannot directly link a lightweight job with a consumer group

C is incorrect because job chains only specify conditional execution and sequencing among a set of related jobs

D'is incorrect because you cannot directly associate a program with a resource plan or resource consumer group

Page 3 of 61

Exam Name: Exam Type: Exam Code:

Oracle Database 11g: Administration II Oracle 1Z0-053

Total Questions:

Question: 9 You need to recover the database after a disk is lost but you are missing two archived redo log files

You need to run the RMAN RECOVER DATABASE UNTIL command

In what database state can you perform this recovery

MOUNT C

RESTRICTED D

NOMOUNT Answer: B Explanation: You must have the control file open but cannot open the datafiles during recovery

A is incorrect because the database cannot be open during a full database recovery

C is incorrect because RESTRICTED mode is the same as OPEN, except restricted to users with SYSDBA privileges

D'is incorrect because NOMOUNT does not open the control file, and you need to control file contents to perform recovery

Question: 10 Which of the following methods can you use to enable duplexed RMAN backups

Use the initialization parameter RMAN_BACKUP_COPIES

Use the BACKUP COPIES option in the RMAN CONFIGURE command

Use the BACKUP COPIES option in the ALLOCATE CHANNEL command

Use the COPIES option in the RMAN BACKUP command

Answer: B,D Explanation: You configure backup copies either in the CONFIGURE command for the device type or during the backup itself in the BACKUP command

A is incorrect because no such initialization parameter controls RMAN backup copies

C is incorrect because you cannot control the number of backup copies in the ALLOCATE command

Question: 11 Which of the following tablespaces can be recovered while the database is online

USERS B

SYSAUX D

SYSTEM 3 E

EXAMPLE Answer: A,C,E Explanation: The USERS, SYSAUX, and EXAMPLE tablespaces are not considered critical tablespaces , so the database can be OPEN when these tablespaces are recovered

Page 4 of 61

Exam Name: Exam Type: Exam Code:

Oracle Database 11g: Administration II Oracle 1Z0-053

Total Questions:

B and D'are incorrect because the database will not open without the SYSTEM or UNDO tablespaces

Question: 12 Which of the following methods can you use to run a job chain

Create and schedule a job with CREATEJOB of type CHAIN

Create and schedule a chain using the CREATE_CHAIN procedure

Create and schedule a chain using the CREATE_JOB_CHAIN procedure

Use the START_CHAIN procedure

Use the RUN_CHAIN procedure

Answer: A,E Explanation: You can initiate a job chain by creating and scheduling a job with CREATE_JOB of type CHAIN, or you can use the RUN_CHAIN procedure

B is incorrect because CREATE_CHAIN creates only the chain container and not any of the steps

C and D'are incorrect because there are no such procedures as CREATE_JOB_CHAIN or START_CHAIN Question: 13 Which of the following commands successfully allocates a channel

ALLOCATE CHANNEL T2 TYPE TAPE

ALLOCATE CHANNEL T2 TYPE SBT

ALLOCATE CHANNEL DB2 TYPE DISK PARMS='SBT_LIBRARY=mmv

ALLOCATE CHANNEL T1 TYPE DISK

Answer: B,D Explanation: Only two valid media types exist for ALLOCATE CHANNEL: DISK and TAPE

Each type allows only certain parameters such as FORMAT and PARMS

A is incorrect because there is no such type TAPE

C is incorrect because you cannot specify media manager library settings for a backup to disk

Question: 14 To enable remote connections to the database using the password file, what values should REMOTE_LOGIN_PASSWORDFILE have

SHARED C

EXCLUSIVE D

REMOTE Answer: B,C Explanation: The value of REMOTE_LOGIN_PASSWORDFILE can be either SHARED or EXCLUSIVE to allow both SYS and non-SYS users to connect to the database remotely (instead of using operating system authentication)

Page 5 of 61