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

Author: February 3, 2018

1z0-067 Latest Exam (Jan 2018)

, , , , , , , , ,

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

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

Question No: 91

You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). You are connected to cdb$root as thesys user. You execute the commands:

SQLgt; CREATE USER C##ADMIN IDENTIFIED BY orcll23; SQLgt; CREATE ROLE C##CONNECT;

SQLgt; GRANT CREATE SESSION, CREATE TABLE, SELECT ANY TABLE TO C##CONNECT;

SQLgt; GRANT C##CONNECT to C##ADMIN CONTAINER=ALL;

Which statement istrue about the c##connect role?

  1. It is created only in cdb$root and cannot be granted to the c##admin user with the container=all clause.

  2. It is granted to the c##admin user only in the CDB.

  3. It is granted to the c##admin user in all PDBs and can be granted only to a local user in a PDB.

  4. It is granted to the c##admin user in all PDBs and can be granted object and system privileges for a PDB.

Answer: C

Question No: 92

You want to create a guaranteed restore point for your database by executing the command:

SQLgt; CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;

Identify two prerequisites for the successful execution of this command.

  1. The database must be running in archivelog mode.

  2. Flashback Database must be enabled.

  3. Fast Recovery Area must be enabled.

  4. The recyclebin must be enabled for the database.

  5. Undo retention guarantee must be enabled.

  6. A database backup must be taken.

Answer: A,C

Reference:http://docs.oracle.com/cd/B19306_01/backup.102/b14192/rpfbdb002.htm

Question No: 93

Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)?

  1. Database Resident Connection Pooling

  2. Oracle Suggested Backup Strategy

  3. Database Vault in ORACLE_HOME

  4. Nondefaultblocksizetablespaces

  5. Configure Label Security

Answer: D,E

Question No: 94

Your multitenant container database (CDB) cdb1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command:

SQLgt;STARTUP

Which two statements are true about the successful execution of the command?

  1. All redo log files are opened.

  2. The root, the seed, and all the PDBs are opened in read-write mode.

  3. All the PDBs are opened in read-write mode.

  4. All the PDBs are in closed state.

  5. Only the root databaseis opened in read-write mode.

Answer: A,E

Question No: 95

You are administering a multitenant container database (CDB).

Identify two ways to access a pluggable database (PDB) that is open in read-only mode.

  1. by using the connect statement as a local user having only the set container privilege

  2. by using easy connect

  3. by using external authentication

  4. as a common user with the set container privilege

  5. by executing the alter session set container command as a local user

Answer: B,D

Question No: 96

Which two statements are true about scheduling operations in a pluggable database (PDB)?

  1. Scheduler jobs for a PDB can be defined only at the container database (CDB) level.

  2. A job defined in a PDB runs only if that PDB is open.

  3. Scheduler attribute setting is performed only at the CDB level.

  4. Scheduler objects created by users can be exported or imported using Data Pump.

  5. Scheduler jobs for a PDB can becreated only by common users.

Answer: B,D

Question No: 97

Which three conditions must be true for unused block compression to be used automatically while performing backups by using RMAN?

  1. The compatible initialization parameter is set to 10.2 or higher.

  2. There are no guaranteed restore points defined for the database.

  3. The default device for the backup must be set to disk.

  4. The tablespaces are locally managed.

  5. The fast recovery area is less than 50 percentfree.

Answer: A,B,D Reference:http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmcncpt.htm#BRAD V89481(See unused block compression)

https://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmcncpt.htm#BRADV89481

Question No: 98

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

Your database is running in archivelog mode and regular nightly backups are taken. Due to a media failure, the current online redo log group, which has one member, is lost and the instance is aborted.

Examine the steps to recover the online redo log group and move it to a new location. 1.Restore the corrupted redo log group.

2.Restore the database from the most recent database backup. 3.Perform an incomplete recovery.

4.Relocatethe member of the damaged online redo log group to a new location. 5.Open the database with the resetlogs option.

  1. Issue a checkpoint and clear the log. Identify the required steps in the correct order.

    A. 1, 3, 4, 5

    B. 6, 3, 4, 5

    C. 2, 3, 4, 5

    D. 6, 4,3, 5

    Answer: C

    Question No: 100

    You create a table with the period for clause to enable the use of the Temporal Validity feature of Oracle Database 12c.

    Examine the table definition: create table employees

    (empno number, salary number, deptid number, name varchar2(100), period for employee_time);

    Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

    1. The valid time columns employee_time_start and employee_time_end are automatically

      created.

    2. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.

    3. The valid time columns are not populated bythe Oracle Server automatically.

    4. The valid time columns are visible by default when the table is described.

    5. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

Answer: A,B,E

Explanation: A: To implement Temporal Validity(TV), 12c offers the option to have two date columns in that table which is having TV enabled using the new clause Period For in the CreateTable for the newly created tables or in the Alter Table for the existing ones. The columns that are used can be defined while creating the table itself and will be used in the Period For clause or you can skip having them in the table’s definition in thecase of which, the Period For clause would be creating them internally.

E: ENABLE_AT_VALID_TIME Procedure

This procedure enables session level valid time flashback.

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
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No