Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-067
100% Free Download! 100% Pass Guaranteed!

Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP

Question No: 11

A telecom company wishes to generate monthly bills to include details of customer calls, listed in order of time of call.

Which table organization allows for generating the bills with minimum degree of row sorting?

  1. a hash cluster

  2. an index cluster

  3. a partitioned table

  4. a sorted hash cluster

  5. a heap table with a rowid column

Answer: B

Question No: 12

You created a tablespace with this statement:


DATAFILE #39;/proddb/data/adtbs.dbf#39; SIZE 10G;

The tablespace is nearly full and youneed to avoid any out of space errors for the load of a 5 gig table.

Which two alter statements will achieve this?




  4. ALTER TA3LESPACE adtbs ADD DATAFILE #39;/proddb/data/adtbsl.dbf#39; SIZE 1QG;

  5. ALTER TA3LESPACE adtbs MODIFY DATAFILE #39;/proddb/data/adtbs.dbf AUTOEXTEND ON;

Answer: A,C

Explanation: http://www.techonthenet.com/oracle/tablespaces/alter_tablespace.php

Question No: 13

Which two statements are true about a common user?

  1. A common user always uses the global temporary tablespace that is defined at the CDB level as the default temporary tablespace.

  2. A common user can have a local schema in a PDB.

  3. A common user connected to a pluggable database (PDB) can exercise privileges across

    other PDBs.

  4. A common user can be granted only a common role.

  5. A common user with the create user privilege can create other common users, as well as

local users.

Answer: B,E

Question No: 14

user_data is a nonencryptedtablespace containing tables with data. You must encrypt ail data in this tablespace.

Which three methods can do this?

  1. Use Data Pump.



  4. Use alter tablespace to encrypt the tablespace after enabling row movement on all its

  5. Use altertablespace to encrypt thetablespace.

Answer: A,B,C

Question No: 15

Which three types of failures are detected by the Data Recovery Advisor (DRA)?

  1. loss of a non-critical data file

  2. loss of a control file

  3. physical data block corruption

  4. logical data block corruption

  5. loss of an archived redo log file

Answer: A,B,C Reference:http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmrepai.htm#BRAD V89728

Question No: 16

Which two statements are true about unified auditing?

  1. A unified audit trail captures audit information from unified audit policies and audit settings.

  2. Unified auditing is enabled by executing make-fins_rdbms.mk uniaud_onioracle ORACLE_HOME=SORACLE_HOME.

  3. Audit records are created for all users except sys.

  4. Audit records are created only for the DML and DDL operations performed on database objects.

  5. Unified auditing is enabled by setting the audit_trail parameter to db, extended.

  6. A unified audit trail resides in a read-only table in the audsys schema in the system tablespace.

Answer: A,B

Question No: 17

Which three statements are true about unplugging a pluggable database (PDB)?

  1. The PDB must be open in read only mode.

  2. The PDB must be dosed.

  3. The unplugged PDB becomes a non-CDB.

  4. The unplugged PDB can be plugged into the same multitenant container database (CDB)

  5. The unplugged PDB can be plugged into another CDB.

  6. The PDB data files are automatically removed from disk.

Answer: B,D,E

Explanation: B, not A: The PDB must be closed before unplugging it.

D: An unplugged PDB contains data dictionary tables, and some of the columns in these encode information in an endianness-sensitive way. There is no supported way to handle the conversion of such columns automatically. This means,quite simply, that an unplugged PDB cannot be moved across an endianness difference.

E (not F): To exploit the new unplug/plug paradigm for patching the Oracle version most effectively, the source and destination CDBs should share a filesystem so that thePDB’s datafiles can remain in place.

Reference: Oracle White Paper, Oracle Multitenant

Question No: 18

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: 19

Which four actions are possible during an Online Datafile Move operation?

  1. Performing Block Media Recovery for a data block in the datafile being moved

  2. Executing DML statements on objects stored in the datafile being moved

  3. Flashing back the database

  4. Performing file shrink of the data file being moved

  5. Creating and dropping tables in the datafile being moved

  6. Querying tables in the datafile being moved

Answer: A,B,E,F

Question No: 20

Your database is running in noarchivelog mode. One of the data files belonging to the system tablespace is corrupted. You notice that all online redo logs have been overwritten since the last backup.

Which method would you use to recover the data file?

  1. Shut downthe instance if not already shut down, restore all data files belonging to the system tablespace from the last backup, and restart the instance.

  2. Shut down the instance if not already shut down, restore the corrupted data file belonging to the system tablespace from the last backup, and restart the instance.

  3. Shut down the instance if not already shut down, restore all data files for the entire database from the last backup, and restart the instance.

  4. Mount the database, restore all data files belongingto the system tablespace from the last backup, and open the database.

Answer: C

100% Ensurepass Free Download!
Download Free Demo:1z0-067 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-067 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
Free VCE Simulator Yes No No
Instant Download Yes No No

Comments are closed.