This page was exported from Braindump2go Free Exam Dumps with PDF and VCE Collection [ https://www.mcitpdump.com ] Export date:Fri Nov 22 7:34:30 2024 / +0000 GMT ___________________________________________________ Title: [2016-Jun-NEW]Newest Microsoft 1Z0-053 Practice Tests Free Updated By Braindump2go for Downloading[NQ81-NQ90] --------------------------------------------------- 2016 June Oracle Official - 1Z0-053: Oracle Database 11g: Administration II Exam Questions New Updated Today in Braindump2go.com. 100% 1Z0-053 Exam Pass Guaranteed!NEW QUESTION 81 - NEW QUESTION 90: QUESTION 81Your database has a backup that was taken yesterday (Tuesday) between 13:00 and 15:00 hours. This is the only backup you have. You have lost all the archived redo logs generated since the previous Monday, but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss. To which point can you restore your database? A.    13:00 on Tuesday.B.    15:00 on Tuesday.C.    Up until the last available archived redo log on Sunday.D.    To any point; all the redo should still be available in the online redo logs.E.    The database is not recoverable. Answer: E QUESTION 82Which of the following files cannot be backed up by RMAN? (Choose all that apply.) A.    Database datafilesB.    Control filesC.    Online redo logsD.    Database pfilesE.    Archived redo logs Answer: CD QUESTION 83Which of the following RMAN structures can data from a datafile span? A.    RMAN backup-set pieces spanning backup setsB.    RMAN backup-set pieces within a given backup setC.    RMAN backupsD.    RMAN channelsE.    None of the above Answer: B QUESTION 84Which RMAN backup command is used to create the block-change tracking file? A.    alter database create block change tracking fileB.    alter database enable block change fileC.    alter database enable block change tracking using file ,,/ora01/opt/ block_change_tracking.filD.    alter system enable block change tracking using file '/ora01/opt/block_ change_tracking.fil'E.    alter system block change tracking on Answer: CExplanation:http://docs.oracle.com/cd/E16655_01/backup.121/e17630/rcmbckba.htm#BRADV8125  QUESTION 85A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger, which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression? A.    backup database allB.    backup compressed databaseC.    backup as compressed backupset database;D.    backup as compressed backup database plus archivelog all;E.    backup as compressed backupset database plus compress archivelog all; Answer: CExplanation:http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmbckba.htm#BRADV8138 QUESTION 86What is the purpose of the RMAN recovery catalog? (Choose all that apply.) A.    Make backups fasterB.    Store RMAN metadataC.    Store RMAN scriptsD.    Provide the ability to do centralized backup reporting.E.    Make recovery faster Answer: BCDExplanation:A recovery catalog is a database schema used by RMAN to store metadata about one or more Oracle databases. Typically, you store the catalog in a dedicated database. A recovery catalog provides the following benefits:A recovery catalog creates redundancy for the RMAN repository stored in the control file of each target database. The recovery catalog serves as a secondary metadata repository. If the target control file and all backups are lost, then the RMAN metadata still exists in the recovery catalog.A recovery catalog centralizes metadata for all your target databases. Storing the metadata in a single place makes reporting and administration tasks easier to perform.A recovery catalog can store metadata history much longer than the control file. This capability is useful if you must do a recovery that goes further back in time than the history in the control file. The added complexity of managing a recovery catalog database can be offset by the convenience of having the extended backup history available.Some RMAN features function only when you use a recovery catalog. For example, you can store RMAN scripts in a recovery catalog. The chief advantage of a stored script is that it is available to any RMAN client that can connect to the target database and recovery catalog. Command files are only available if the RMAN client has access to the file system on which they are stored.A recovery catalog is required when you use RMAN in a Data Guard environment. By storing backup metadata for all primary and standby databases, the catalog enables you to offload backup tasks to one standby database while enabling you to restore backups on other databases in the environment. QUESTION 87RMAN provides more granular catalog security through which feature? A.    Virtual private databaseB.    Virtual private catalogC.    RMAN virtual databaseD.    RMAN secure catalogE.    Oracle Database Vault Answer: BExplanation:About Virtual Private CatalogsBy default, all of the users of an RMAN recovery catalog have full privileges to insert, update, and delete any metadata in the catalog. For example, if the administrators of two unrelated databases share the same recovery catalog, each administrator could, whether inadvertently or maliciously, destroy catalog data for the other's database. In many enterprises, this situation is tolerated because the same people manage many different databases and also manage the recovery catalog. But in other enterprises where clear separation of duty exists between administrators of various databases, and between the DBA and the administrator of the recovery catalog, you may desire to restrict each database administrator to modify only backup metadata belonging to those databases that they are responsible for, while still keeping the benefits of a single, centrallymanaged, RMAN recovery catalog. This goal can be achieved by implementing virtual private catalogs. QUESTION 88You can back up the RMAN recovery catalog with RMAN. A.    TrueB.    False Answer: AExplanation:When backing up the recovery catalog database, you can use RMAN to make the backups.Refer to here. QUESTION 89What RMAN command must you use before you can back up a database using the recovery catalog? A.    create catalogB.    install databaseC.    catalog databaseD.    merge Catalog with databaseE.    register database Answer: E QUESTION 90You have control-file autobackups enabled. When starting your database from SQL*Plus, you receive the following error message:SQL> startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file ,,C:ORACLEPRODUCT11.1.0DB_1DATABASEINITORCL.ORA Using RMAN,how would you respond to this error? A.    Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.B.    Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.C.    Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.D.    Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.E.    Issue the restore spfile from autobackup command from the RMAN prompt. Answer: C 2016 Valid Oracle 1Z0-053 Study Materials:   1.| Latest 1Z0-053 Exam PDF and VCE Dumps 676q from Braindump2go: http://www.braindump2go.com/1z0-053.html [100% Exam Pass Guaranteed!]   2.| New 1Z0-053  Exam Questions and Answers - Google Drive: https://drive.google.com/folderview?id=0B75b5xYLjSSNOGJaLVVucEZfS28&usp=sharing     MORE Practice is the Most Important IF You want to PASS Oracle 1Z0-053 Exam 100%!————— Braindump2go.com————— Pass All IT Exams at the first Try! --------------------------------------------------- Images: --------------------------------------------------- --------------------------------------------------- Post date: 2016-06-22 06:26:02 Post date GMT: 2016-06-22 06:26:02 Post modified date: 2016-06-22 06:26:02 Post modified date GMT: 2016-06-22 06:26:02 ____________________________________________________________________________________________ Export of Post and Page as text file has been powered by [ Universal Post Manager ] plugin from www.gconverters.com