Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-053
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-053.html
Oracle Database 11g: Administration II
Question No: 61 – (Topic 1)
You are managing an Oracle Database 11g instance with ASM storage. You lost an ASM disk group DATA. You have RMAN backup of data as well as ASM metadata backup. You want to re-create the missing disk group by using the ASMCMD md_restore command.
Which of these methods would you use to achieve this? (Choose all that apply.)
-
Restore the disk group with the exact configuration as the backed-up disk group, using
the same disk group name, same set of disks, failure group configurations, and data on the disk group.
-
Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, and failure group configurations.
-
Restore the disk group with changed disk group specification, failure group specification, disk group name, and other disk attributes.
-
Restore metadata in an existing disk group by passing the existing disk group name as an input parameter.
Answer: B,C,D Explanation: Purpose
The md_restore command restores disk groups from a metadata backup file.
Syntax and Description
md_restore backup_file [-silent]
[-full|-nodg|-newdg -o #39;old_diskgroup:new_diskgroup [,…]#39;] [-S sql_script_file] [-G #39;diskgroup [,diskgroup…]#39;]
backup_file
Reads the metadata information from backup_file.
-silent
Ignore errors. Typically, if md_restore encounters an error, it stops. Specifying this flag ignores any errors.
-full
Specifies to create a disk group and restore metadata.
-nodg
Specifies to restore metadata only.
-newdg -o old_diskgroup:new_diskgroup]
Specifies to create a disk group with a different name when restoring metadata. The -o option is required with
-newdg.
-S sql_script_file
Write SQL commands to the specified SQL script file instead of executing the commands.
-G diskgroup
Select the disk groups to be restored. If no disk groups are defined, then all disk groups are restored.
Question No: 62 – (Topic 1)
View the Exhibit and examine the disk groups created at the time of migrating the database storage to Automatic Storage Management (ASM).
Why does the FRA disk group initially have more free space even though both DATA and FRA disk groups are provided with the same size?
-
Because the FRA disk group will not support dynamic rebalancing
-
Because the FRA disk group is not configured to support mirroring
-
Because disks in the FRA disk group are not formatted at this stage
-
Because the FRA disk group will support only a single size of allocation unit
Answer: B
Question No: 63 – (Topic 1)
You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statement regarding the ASM disk group compatibility attributes are true in this scenario? (Choose all that apply.)
-
The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances.
-
RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group.
-
The RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.
-
ASM compatibility controls which features for the ASM will be enabled.
Answer: A,B,D
Question No: 64 – (Topic 1)
The INV_HISTORY table is created using the command:
The following data has been inserted into the INV_HISTORY table:
You would like to store the data belonging to the year 2006 in a single partition and issue
the command:
SQLgt; ALTER TABLE inv_history MERGE PARTITIONS
FOR(TO_DATE(#39;15-feb-2006#39;,#39;dd-mon-yyyy#39;)), FOR(TO_DATE(#39;15-apr-2006#39;))
INTO PARTITION sys_py;
What would be the outcome of this command?
-
It executes successfully, and the transition point is set to #39;1-apr-2006#39;.
-
It executes successfully, and the transition point is set to #39;15-apr-2006#39;.
-
It produces an error because the partitions specified for merging are not adjacent.
-
It produces an error because the date values specified in the merge do not match the date values stored in the table.
Answer: C
Question No: 65 – (Topic 1)
In your database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory (OID). SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command:
$ SQLPLUS scott/tiger@DB01 AS SYSDBA Which DB01 is the net service name.
Which authentication method would be used first?
-
authentication by password file
-
authentication by using certificates over SSL
-
authentication by using the Oracle Internet Directory
-
authentication by using the local OS of the database server
Answer: A
Topic 2, Configuring for Recoverability
Question No: 66 – (Topic 2)
Which of the following does the recover command not do?
-
Restore archived redo logs.
-
Apply archived redo logs.
-
Restore incremental backups.
-
Apply incremental backups.
-
Restore datafile images.
Answer: A
Question No: 67 – (Topic 2)
What is the purpose of the list expired backup command?
-
Lists all backups impacted by a resetlogs command
-
Lists all backups that are subject to retention criteria
-
Lists all backups that are missing associated physical backup set pieces
-
Lists the status of datafile backup failures due to the use of the duration command
-
Lists backups that cannot be used by the restore command because they have been marked as disabled
Answer: C
Question No: 68 – (Topic 2)
Your 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?
-
13:00 on Tuesday.
-
15:00 on Tuesday.
-
Up until the last available archived redo log on Sunday.
-
To any point; all the redo should still be available in the online redo logs.
-
The database is not recoverable.
Answer: E
Question No: 69 – (Topic 2)
Which of the following parameters defines the location where Oracle should create archived redo logs?
-
LOG_ARCHIVE_1
-
LOG_DESTINATION_1
-
LOG_ARCHIVED_DESTINATION_1
-
LOG_ARCHIVE_DEST_1
-
LOG_ARCHIVE_SOURCE_1
Answer: D
Question No: 70 – (Topic 2)
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?
-
owner
-
touser
-
attach
-
remap_schema
Answer: D
100% Ensurepass Free Download!
–Download Free Demo:1z0-053 Demo PDF
100% Ensurepass Free Guaranteed!
–1z0-053 Dumps
EnsurePass | ExamCollection | Testking | |
---|---|---|---|
Lowest Price Guarantee | Yes | No | No |
Up-to-Dated | Yes | No | No |
Real Questions | Yes | No | No |
Explanation | Yes | No | No |
PDF VCE | Yes | No | No |
Free VCE Simulator | Yes | No | No |
Instant Download | Yes | No | No |
100-105 Dumps VCE PDF
200-105 Dumps VCE PDF
300-101 Dumps VCE PDF
300-115 Dumps VCE PDF
300-135 Dumps VCE PDF
300-320 Dumps VCE PDF
400-101 Dumps VCE PDF
640-911 Dumps VCE PDF
640-916 Dumps VCE PDF
70-410 Dumps VCE PDF
70-411 Dumps VCE PDF
70-412 Dumps VCE PDF
70-413 Dumps VCE PDF
70-414 Dumps VCE PDF
70-417 Dumps VCE PDF
70-461 Dumps VCE PDF
70-462 Dumps VCE PDF
70-463 Dumps VCE PDF
70-464 Dumps VCE PDF
70-465 Dumps VCE PDF
70-480 Dumps VCE PDF
70-483 Dumps VCE PDF
70-486 Dumps VCE PDF
70-487 Dumps VCE PDF
220-901 Dumps VCE PDF
220-902 Dumps VCE PDF
N10-006 Dumps VCE PDF
SY0-401 Dumps VCE PDF