[Free] 2018(Jan) EnsurePass Passguide Oracle 1z0-063 Dumps with VCE and PDF 61-70

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-063
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-063.html

Oracle Database 12c: Advanced Administration

Question No: 61

Which three statements are true about the SQL*Loader utility?

  1. It can be used to load data from multiple external files into multiple tables.

  2. It can be used to extract and reorganize data from external files, and then load it into a table.

  3. It can be used to load data from external files using direct path only.

  4. It can be used to create tables using data that is stored in external files.

  5. It can be used to generate unique sequential values in specified columns while loading data.

Answer: A,D,E

Question No: 62

Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2, both of which are open. RMAN is connected to the target database pdb2_1.

RMANgt; BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

Which statement is true about the execution of this command to back up the database?

  1. All data files belonging to pdb2_1 are backed up and all archive log files are deleted.

  2. All data files belonging to pdb2_1 are backed up along with the archive log files.

  3. Only the data files belonging to pdb2_ are backed up.

  4. This command gives an error because archive log files can be backed up only when

RMAN is connected to the root database.

Answer: B

Question No: 63

Examine the steps/operations performed during the RMAN backup operation by using Oracle Secure Backup (OSB):

1.Start the RMAN client by using the RMAN target / command. 2.Start the RMANclient by using the OSB user.

  1. RMAN creates the backup pieces.

  2. Run the RMAN backup command with the sbt channels. 5.OSB creates a backup job and assigns a unique identifier. 6.OSB creates a backup job request through the OSB sbt library.

7.OSB stores metadata about RMAN backup pieces in the OSB catalog. 8.OSB starts the backup operation.

  1. OSB updates the RMAN catalog.

    Identify the required steps/operations performed in correct order.

    A. 1, 4, 6, 5, 8, 3, 9

    B. 1, 6, 4, 5, 8, 3, 9

    C. 2, 4, 6, 5, 8, 3, 7

    D. 2, 4, 5, 8, 3, 7, 9

    Answer: C

    Question No: 64

    For which two requirements would you use the Database Resource Manager?

    1. limiting the CPU used per database call

    2. specifying the maximum number of concurrent sessions allowed for a user

    3. specifying the amount of private space a session can allocate in the shared pool of the SGA

    4. limiting the degree of parallelism of operations performed by a user or group of users

    5. specifying an idle time limit that applies to sessions that are idle and blocking other sessions

Answer: B,E

Question No: 65

You want to reduce fragmentation and reclaim unused space for the sales table but not its dependent objects. During this operation, you want toensure the following:

i.Long-running queries are not affected. ii.No extra space is used.

  1. Data manipulation language (DML) operations on the table succeed at all times throughout theprocess.

  2. Unused space is reclaimed both above and below the high water mark. Which alter TABLE option would you recommend?

  1. DEALLOCATE UNUSED

  2. SHRINK SPACE CASCADE

  3. SHRINK SPACE COMPACT

  4. ROW STORE COMPRESS BASIC

Answer: A

Question No: 66

A user issues a query on thesales table and receives the following error:

ERROR at line 1:

ORA-01565: error in identifying file #39;/u0l/app/oracle/oradata/ORCL/temp01.dbf#39; ORA-27037: unable to obtain file status

Which two actions would you take to recover the temporary tablespace?

  1. Drop the tenpOi.dbf file, and then re-create the temp file.

  2. Add a new temp file to the temporary tablespace and drop the tempOi.dbf file.

  3. Shut down the database instance, start up the database instance in mount state, create a new temporary tablespace, and then open the database.

  4. Take the temporary tablespace offline, recover the missing temp file, and then bring the temporary tablespace online.

  5. Create a new temporary tablespace and assign it as the default to the user.

Answer: D,E

Question No: 67

Which two statements are true about tablespaces in multitenant container databases (CDBs)?

  1. Default permanent tablespaces can be shared across pluggable databases (PDBs).

  2. The current container must be set to root to create or modify the default temporary tablespace or tablespace group for a CDB.

  3. Each PDB can have its own default temporary tablespace.

  4. The default permanent tablespace for a PDB can be changed only by a local user with the required permissions.

  5. The amount of space that each PDB can usein a shared temporary tablespace must be set at the CDB level.

Answer: A,B

Question No: 68

In your database, there are tablespaces that were read-only when thelast backup was taken. These tablespaces have not been made read/write since then. You want to perform an incomplete recovery on the database by using a backup control file.

What precaution must you take for the read-only tablespaces before performing anincomplete recovery?

  1. All the read-only tablespaces should be taken offline.

  2. All the read-only tablespaces should be restored separately.

  3. All the read-only tablespaces should be renamed to have the MISSINGnnnn format.

  4. All the read-only tablespacesshould be made online with logging disabled.

Answer: B

Question No: 69

You want to consolidate backup information and centrally manage backup and recovery scripts for multiple databases running in your organization.

Which two backup solutions can be used?

  1. RMAN recovery catalog

  2. RMAN Media Management Library

  3. Enterprise Manager Cloud Control

  4. Enterprise Manager Database Express

  5. Oracle Secure Backup

Answer: A,C

Question No: 70

Which three statements are true about the database instance startup after an instance failure?

  1. The RECO process recovers the uncommitted transactions at the next instance startup.

  2. Online redo log files and archived redo log files are required to complete the rollback stage of instance recovery.

  3. Uncommitted changes are rolled back to ensure transactional consistency.

  4. The SMON process automatically performs the database recovery.

  5. Media recovery is required to complete the database recovery.

  6. Changes committed before the failure, which were not written to the data files, are re- applied.

Answer: A,C,D

100% Ensurepass Free Download!
Download Free Demo:1z0-063 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-063 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

Leave a Reply

Your email address will not be published. Required fields are marked *