[Free] 2018(Jan) EnsurePass Dumpsleader Oracle 1z0-067 Dumps with VCE and PDF 71-80

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

In your multitenant container database (CDB) that contains pluggable databases (PDBs), the hr user executes the following commands to create and grant privileges on a procedure:



INSERT INTO hr.test VALUES (v_emp_id, v_ename, v salary, v_dept_id); END;


GRANT EXECUTE ON CREATE_TEST TO John, jim, smith, king;

How can you prevent users having the execute privilege on the create_test_v procedure frominserting values into tables on which they do not have any privileges?

  1. Create the create_test procedure with definer#39;s rights.

  2. Grant the execute privilege to users with grant option on the create_test procedure.

  3. Create the create_test procedure with invoker#39;s rights.

  4. Create the create_test procedure as part of a package and grant users the execute privilege on the package.

Answer: C

Question No: 72

You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:

$ . oraenv

ORACLE鈥SID = [oracle] ? cdb1

The oraclebasefor ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 is


$ rman target /

Recovery Manager : Release – production on Fri Ju1 19 05:18:33: 2013 Coppyright (c) 1982, 2013, oracle and/or its affiliates. All rights reserved.

Connected to target database:CDB1 (DBID=782249327) RMANgt;SELECT name FROMv$tablespace;

Which statement is true about the execution of the last command?

  1. It succeeds and displays all the tablespaces that belong to the root database.

  2. It fails and returns an error because a connection is not made by using the sysdba privilege.

  3. It succeeds and displays all the tablespaces that belong to the root and pluggable databases.

  4. It fails and returns an error because SQL commands cannot be executed at the RMAN prompt.

Answer: A

Question No: 73

The CATDB12C database contains an Oracle Database 12c catalog schema owned by the rci2c user.

The CATD3H database contains an Oracle Database Ug catalog schema owned by the rch user.

A database with dbid=H2324I is registered in the catdbII catalog. Both the recovery catalog databases are open.

In the CATD3i2c database, you execute the commands:

: r-ar.

RKANgt; CONNECT CATALOG rci2c/passI2c@catdbi2c

RKANgt; IMPORT CATALOG rcii/pwdcatUQcatdfoil DBI2=142324i; What is the outcome of the import?

  1. It fails because the target database and recovery catalog database are of different versions.

  2. It succeeds and all global scripts in the rci: catalog that have the same name as existing global scripts in the RCI2C catalog are automatically renamed.

  3. It succeeds but the database is not automatically registered in the rc:2c catalog.

  4. It fails because RMAN is not connected to the target database with r3:T=:42324:.

Answer: B

Question No: 74

You notice a performance change in your production Oracle 12c database. You want to knowwhich change caused this performance difference.

Which method or feature should you use?

  1. Compare Period ADDM report

  2. AWR Compare Period report

  3. Active Session History (ASH) report

  4. taking a new snapshot and comparing it with a preserved snapshot

Answer: A

Question No: 75

Examine the RMAN command:


Which type of encryption is used for the backup performed by using this command?

  1. password-mode encryption

  2. dual-mode encryption

  3. transparent encryption

  4. default encryption

Answer: A Reference:http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmbckad.htm#CEGE JABH(to make password -encrypted backups)

Question No: 76

Identify three scenarios in which RMAN will use backup sets to perform active database duplication.

  1. whenthe duplicate … from active database command contains the section size clause

  2. when you perform active database duplication on a database with flashback disabled

  3. when you specify set encryption before the duplicate … from active database command

  4. when the number of auxiliary channels allocated is equal to or greater than the number of target channels

  5. when you perform active database duplication on a database that has read- onlytablespaces

Answer: A,C,D


Question No: 77

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

You are administering a multitenant container database (CDB) cdb1. Examine the command and itsoutput:

SQLgt;show parameterfile



db_create_file_deststring db_file_name_convertstring db_filesinteger200

You verify that sufficient disk space is available and that nofile currently exists in the ‘/u0l/app/oracle/oradata/cdb1/salesdb#39; location.

You plan to create a new pluggable database (PDB) by using the command: SQLgt;CREATEPLUGGABLEDATABASESALESPDB

ADMINUSERsalesadmIDENTIFIED 3Y password ROLES=(dba)


DATAFILE#39; /u01/app/oracle/oradata/cdb1/salesdb/sales01 .dbf’SIZE 250M AUTOEXTEND ON

FILE_NAME_CONVERT=(‘/u01/app/oracle/oradata/cdb1/pdbseed/#39;, #39;/u01/app/oracle/oradata/cdb1/salesdb/#39;)


PATK_PREFIX=#39;/u01/app/oracle/oradata/cdb1/SALESPDB#39;; Which statement is true?

  1. SALESPDB is created and is in mount state.

  2. PDB creation fails because the D3_file_name_convert parameter is not set in the CDB.

  3. SALESPDB is created and is in read/write mode.

  4. PDB creation fails because a defaulttemporary tablespace is not defined for SALESPDB.

Answer: B

Question No: 79

Which two statements are true about Flashback Version Query?

  1. The result of a query can be used as part of a DML statement.

  2. It can be used to create views.

  3. It can be used only if Flashback Data Archive is enabled for a table.

  4. It retrieves all versions of rows that exist in a time interval, including the start time and end time.

  5. It can be used to retrieve the SQL that is required to undo a row change and the user responsible for the change.

Answer: A,C

Question No: 80

You execute the RMAN commands:


Which task is performed by these commands?

  1. Corrupted blocks, if any, are repaired in the backup created.

  2. Only those data files that have corrupted blocks are backed up.

  3. Corrupted blocks in the data files are checked and repaired before performing the database backup.

  4. The database is checked for physicallycorrupt blocks and any corrupted blocks are repaired.

Answer: D

Explanation: When you run BACKUP VALIDATE, RMAN reads the files to be backed up in their entirety, as it does during a real backup. RMAN does not, however, actually produce any backup sets or image copies.

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