web analytics

Update 1Z0-067 Dumps with VCE and PDF for Free (Question 91 – Question 105)

PassLeader now are offering 100% pass ensure 1Z0-067 dumps! All 1Z0-067 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-067 VCE dumps and PDF dumps: http://www.passleader.com/1z0-067.html (188 Q&As)

BTW: Download PassLeader 1Z0-067 dumps from Google Drive for free: https://drive.google.com/open?id=0B-ob6L_QjGLpUDBvX3EwWkRJRnM

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

A.    The PDB must be open in read only mode.
B.    The PDB must be dosed.
C.    The unplugged PDB becomes a non-CDB.
D.    The unplugged PDB can be plugged into the same multitenant container database (CDB).
E.    The unplugged PDB can be plugged into another CDB.
F.    The PDB data files are automatically removed from disk.

Answer: BDE
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 the PDB’s datafiles can remain in place.

QUESTION 92
You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). You are connected to cdb$root as the sys user. You execute the commands:
SQL> CREATE USER C##ADMIN IDENTIFIED BY orcll23;
SQL> CREATE ROLE C##CONNECT;
SQL> GRANT CREATE SESSION, CREATE TABLE, SELECT ANY TABLE TO C##CONNECT;
SQL> GRANT C##CONNECT to C##ADMIN CONTAINER=ALL;
Which statement is true about the c##connect role?

A.    It is created only in cdb$root and cannot be granted to the c##admin user with the container=all clause.
B.    It is granted to the c##admin user only in the CDB.
C.    It is granted to the c##admin user in all PDBs and can be granted only to a local user in a PDB.
D.    It is granted to the c##admin user in all PDBs and can be granted object and system privileges for a PDB.

Answer: D
Explanation:
https://docs.oracle.com/database/121/SQLRF/statements_6014.htm#SQLRF01311
“CONTAINER Clause. The CONTAINER clause applies when you are connected to a CDB. However, it is not necessary to specify the CONTAINER clause because its default values are the only allowed values. To create a common role, you must be connected to the root. You can optionally specify CONTAINER = ALL, which is the default when you are connected to the root. To create a local role, you must be connected to a PDB. You can optionally specify CONTAINER = CURRENT, which is the default when you are connected to a PDB.”

QUESTION 93
Examine the RMAN command:
RMAN> BACKUP VALIDATE DATABASE;
Which statement is true about the execution of the command?

A.    Block change tracking must be enabled before executing this command.
B.    The database must be running in archivelog mode for the successful execution of this command.
C.    A complete database backup must exist before executing this command.
D.    The command checks for blocks containing all zeros, an invalid checksum, or a corrupt block header.
E.    The command checks for blocks that contain a valid checksum and matching headers and footers, but that has logically inconsistent contents.

Answer: D

QUESTION 94
Which three conditions must be met before you create a Virtual Private Catalog (VPC)?

A.    A base recovery catalog should exist.
B.    The owner of VPC cannot own recovery catalog.
C.    At least one target database should be registered in the recovery catalog.
D.    The register database privilege should be granted to the virtual catalog owner.
E.    The recovery_catalog_owner role should be granted to the virtual catalog owner.

Answer: ADE
Explanation:
http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta013.htm

QUESTION 95
In your database, there are tablespaces that were read-only when the last 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 an incomplete recovery?

A.    All the read-only tablespaces should be taken offline.
B.    All the read-only tablespaces should be restored separately.
C.    All the read-only tablespaces should be renamed to have the MISSINGnnnn format.
D.    All the read-only tablespaces should be made online with logging disabled.

Answer: A
Explanation:
Take data files from read-only tablespaces offline before doing recovery with a backup control file, and then bring the files online at the end of media recovery.
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/osadvsce.htm#BRADV227

QUESTION 96
Examine the RMAN commands executed in your database:
RMAN>CONFIGUREDEFAULT DEVICE TYPE TO disk;
RMAN>CONFIGURE DEVICETYPE DISK BACKUP TYPE TO BACKUPSET;
RKAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
You issue the command:
RMAN> BACKUP DATABASE;
Which two statements are true about the command?

A.    It performs a log switch.
B.    It creates compressed backup sets by using binary compression by default.
C.    It backs up only the used blocks in data files.
D.    It backs up data files, the control file, and the server parameter file.
E.    It creates a backup of only the control file whenever the database undergoes a structural change.

Answer: CD
Explanation:
C: RMAN backup sets automatically use unused block compression.
http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta007.htm#i1015382
D: If CONFIGURE CONTROLFILE AUTOBACKUP is ON (by default it is OFF), then RMAN automatically backs up the control file and server parameter file after every backup and after database structural changes.
http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup003.htm#i1009642
Not E: spfile is also backed up.

QUESTION 97
Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)?

A.    The PDB is closed and the temp file is re-created automatically when the PDB is opened.
B.    The PDB is closed and requires media recovery at the PDB level.
C.    The PDB does not close and the temp file is re-created automatically whenever the container database (CDB) is opened.
D.    The PDB does not close and starts by using the default temporary tablespace defined for the CDB.

Answer: C
Explanation:
If a temp file belonging to a PDB temporary tablespace is lost or damaged, and the user issuing the statement uses it, an error during the execution of SQL statements that require that temporary space for sorting occurs.

The PDB can open with a missing temporary file. If any of the temporary files do not exist when the PDB is opened, they are automatically re-created. They are also automatically recreated at CDB startup.

QUESTION 98
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 /u01/app/oracle
$ rman target /
Recovery Manager : Release 12.1.0.0.2 – 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)
RMAN>SELECT name FROMv$tablespace;
Which statement is true about the execution of the last command?

A.    It succeeds and displays all the tablespaces that belong to the root database.
B.    It fails and returns an error because a connection is not made by using the sysdba privilege.
C.    It succeeds and displays all the tablespaces that belong to the root and pluggable databases.
D.    It fails and returns an error because SQL commands cannot be executed at the RMAN prompt.

Answer: C

QUESTION 99
Which Oracle Database component is audited by default if the Unified Auditing option is enabled?

A.    Oracle Data Pump
B.    Oracle Recovery Manager (RMAN)
C.    Oracle Label Security
D.    Oracle Database Vault
E.    Oracle Real Application Security

Answer: B
Explanation:
https://docs.oracle.com/database/121/DBSEG/audit_config.htm#CHDDHEIA
Unlike other Oracle Database components, you do not create a unified audit policy for Oracle Recovery Manager events. The UNIFIED_AUDIT_TRAIL data dictionary view has a set of fields, whose names begin with RMAN_, that automatically record Recovery Manager-related events.

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

A.    Default permanent tablespaces can be shared across pluggable databases (PDBs).
B.    The current container must be set to root to create or modify the default temporary tablespace or tablespace group for a CDB.
C.    Each PDB can have its own default temporary tablespace.
D.    The default permanent tablespace for a PDB can be changed only by a local user with the required permissions.
E.    The amount of space that each PDB can use in a shared temporary tablespace must be set at the CDB level.

Answer: BC
Explanation:
https://oracle-base.com/articles/12c/multitenant-manage-tablespaces-in-a-cdb-and-pdb-12cr1#temporary-tablespaces

QUESTION 101
When is the UNDO_RETENTION parameter value ignored by a transaction?

A.    when the data file of the undo tablespace is autoextensible
B.    when there are multiple undotablespaces available in a database
C.    when the undo tablespace is of a fixed size and retention guarantee is not enabled
D.    when Flashback Database is enabled

Answer: C
Explanation:
http://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm (undoretention, see the bullets)

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

A.    Database Resident Connection Pooling
B.    Oracle Suggested Backup Strategy
C.    Database Vault in ORACLE_HOME
D.    Nondefaultblocksizetablespaces
E.    Configure Label Security

Answer: CE

QUESTION 103
You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD. The default format of which two data types would be affected by this setting?

A.    DATE
B.    TIMESTAMP
C.    INTERVAL YEAR TO MONTH
D.    INTERVAL DAY TO SECOND
E.    TIMESTAMP WITH LOCAL TIME ZONE

Answer: BE
Explanation:
http://docs.oracle.com/database/121/NLSPG/ch3globenv.htm#i1007084

QUESTION 104
Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

A.    By default, EM express is available for a database after database creation.
B.    You can use EM express to manage multiple databases running on the same server.
C.    You can perform basic administrative tasks for pluggable databases by using the EM express interface.
D.    You cannot start up or shut down a database instance by using create and configure pluggable databases by using EM express.
E.    You can create and configure pluggable databases by using EM express.

Answer: A
Explanation:
EM Express is built inside the database.
Note:
Oracle Enterprise Manager Database Express (EM Express) is a web-based database management tool that is built inside the Oracle Database. It supports key performance management and basic database administration functions. From an architectural perspective, EM Express has no mid-tier or middleware components, ensuring that its overhead on the database server is negligible.

QUESTION 105
You issue the RMAN commands:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RKAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY;
RMAN>CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which three tasks are performed by the BACKUP DATABASE command?

A.    switching the online redo log file
B.    backing up all data files as image copies and archive log files, and deleting those archive log files
C.    backing up only the used blocks in the data files
D.    backing up all used and unused blocks in the data files
E.    backing up all archived log files and marking them as obsolete

Answer: ABD
Explanation:
https://docs.oracle.com/database/121/BRADV/rcmbckba.htm#BRADV89516


PassLeader now are offering 100% pass ensure 1Z0-067 dumps! All 1Z0-067 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-067 VCE dumps and PDF dumps: http://www.passleader.com/1z0-067.html (188 Q&As)

BTW: Download PassLeader 1Z0-067 dumps from Google Drive for free: https://drive.google.com/open?id=0B-ob6L_QjGLpUDBvX3EwWkRJRnM