web analytics

Free PassLeader 1Z0-067 Exam Dumps with VCE and PDF Download (Question 31 – Question 45)

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 –> 242 Q&As)

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

QUESTION 31
You install “Oracle Grid Infrastructure for a standalone server” on a host on which the orcl1 and orcl2 databases both have their instances running. Which two statements are true?

A.    Both orcl1 and orcl2 are automatically added to the Oracle Restart configuration.
B.    All database listeners running from the database home are automatically added to the Oracle Restart configuration.
C.    The srvct1 add database command must be used to add orcl1 and orcl2 to the Oracle Restart configuration.
D.    The crsct1 start has command must be used to start software services for Oracle AutomaticStorage Management (ASM) after the “Oracle Grid Infrastructure for a standalone server” installation is complete.
E.    All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added to the Oracle Restart configuration.

Answer: CE
Explanation:
https://docs.oracle.com/cd/E18283_01/server.112/e17120/restart001.htm

QUESTION 32
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:
CREATEORREPLACEPROCEDUREcreate_test_v(v_emp_idNUMBER,v_enameVARCHAR2,v_S ALARYNUMBER,v_dept_idNUMBER)
BEGIN
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 from inserting values into tables on which they do not have any privileges?

A.    Create the create_test procedure with definer’s rights.
B.    Grant the execute privilege to users with grant option on the create_test procedure.
C.    Create the create_test procedure with invoker’s rights.
D.    Create the create_test procedure as part of a package and grant users the execute privilege on the package.

Answer: C
Explanation:
You can control access to privileges that are necessary to run user-created procedures by using definer’s rights, which execute with the privileges of the owner, or with invoker’s rights, which execute with the privileges of the user running the procedure.

QUESTION 33
You must unload data from the orders, order_items, and products database tables to four files using the External Tables.
CREATE TABLE orders_ext
(order_id, order_date, product_id, product_name,quantity)
ORGANIZATION EXTERNAL
(
TYPE ORACLE_DATAPUMP
DEFAULT DIRECTORY ext.dir
LOCATION (`ordersl.dmp’,’orders2.dmp’,’orders3.dmp’,’lorders4.dmp’)
)
PARALLEL
AS
SELECT o.order_id,o.order_date,p.product_id,p.product_name,i.quantity
FROM orders o,productsp,order_itemsi
WHERE o.orderjd = i.order_id and i.product_id = p.product_id;
You execute the command shown in the Exhibit, but only two files are created. Which parameter must be changed so that four files are created?

A.    TYPE
B.    LOCATION
C.    PARALLEL
D.    DEFAULT DIRECTORY
E.    ORGANIZATION EXTERNAL

Answer: C
Explanation:
https://docs.oracle.com/cd/B19306_01/server.102/b14215/et_concepts.htm#i1007483

QUESTION 34
Users report this error message when inserting rows into the orders table:
ERROR atline1:
ORA-01654f:unable to extend index USERS.ORDERS_IND by 8in tablespace INDEXES
You determine that the indexes tablespace is out of space and there is no free space on the filesystem used by the Oracle database. Which two must you do to fix this problem without affecting currently executing queries?

A.    drop and re-create the index
B.    coalesce the orders.ind index
C.    coalesce the indexes tablespace
D.    perform an on line table rebuild using dbns_redefir.ition
E.    rebuild the index online moving it to another tablespace that has enough free space for the index

Answer: BE
Explanation:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/indexes004.htm#i1006864

QUESTION 35
Evaluate these statements:
CREATE TABLE purchase_orders
(po_idNUMBER(4),
po_dateTIMESTAMP,
supplier_idNUM8ER(6),
po_totalNUMBER(8,2), CONSTRAINT order_pk PRIMARY KEY(po_id))
PARTITIONBYRANGE(po_date)
(PARTITIONQ1 VALUESLESSTHAN (TO_DATE(’01-apr-2007′,’dd-mon-yyyy’)), PARTITIONQ2VALUESLESSTHAN(TO_DATE(’01-jul-2007′,’dd-mon-yyyy’)), PARTITIONQ3VALUESLESSTHAN (TO~DATE(’01-oct-2007′,’dd-non-yyyy’)), PARTITIONQ4VALUESLESSTHAN (TO_DATE(‘Ol-jan-2008′,’dd-non-yyyy’ )));
CREATETABLEpurchase_order_items
(po_idNUM3ER(4)NOTNULL,
product_idNUMBER(6)NOTNULL,
unit_prlceNUMBER(8,2),
quantity NUMBER(8),
CONSTRAINTpo_items_f k
FOREIGNKEY(po_id)REFERENCESpurchase_orders(po_id) )
PARTITIONBYREFERENCE(po_items_fk);
Which two statements are true?

A.    Partitions of purchase_order_items are assigned unique names based on a sequence.
B.    The purchase_orders and purchase_order_items tables are created with four partition each.
C.    purchase_order_items table partitions exist in the same tablespaces as the purchase_orders table partitions.
D.    The purchase_order_:teks table inherits the partitioning key by duplicating the key columns from the parent table.
E.    Partition maintenance operations on the purchase_order_items table require disabling the foreign key constraint.

Answer: BC
Explanation:
http://docs.oracle.com/cd/B28359_01/server.111/b32024/part_admin.htm#BAJDDEEC
The following example creates a parent table orders which is range-partitioned on order_date. The reference-partitioned child table order_items is created with four partitions, Q1_2005, Q2_2005, Q3_2005, and Q4_2005, where each partition contains the order_items rows corresponding to orders in the respective parent partition. Partitions of a reference-partitioned table will collocate with the corresponding partition of the parent table, if no explicit tablespace is specified for the reference-partitioned table’s partition. The partitions of a reference-partitioned table can be named. If a partition is not explicitly named, then it will inherit its name from the corresponding partition in the parent table.

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

A.    Creating and dropping tables in the datafile being moved
B.    Performing file shrink of the data file being moved
C.    Querying tables in the datafile being moved
D.    Performing Block Media Recovery for a data block in the datafile being moved
E.    Flashing back the database
F.    Executing DML statements on objects stored in the datafile being moved

Answer: ACDF
Explanation:
The good news is that Oracle 12cR1 now offers the ability to move entire datafiles between different storage locations without ever having to take the datafiles offline. The datafiles being moved remain completely accessible to applications in almost all situations, including querying against or performing DML and DDL operations against existing objects, creating new objects, and even rebuilding indexes online. Online Move Datafile (OMD) also makes it possible to migrate a datafile between non-ASM and ASM storage (or vice-versa) while maintaining transparent application access to that datafile’s underlying database objects. OMD is completely compatible with online block media recovery, the automatic extension of a datafile, the modification of a tablespace between READ WRITE and READ ONLY mode, and it even permits backup operations to continue against any datafiles that are being moved via this feature.
http://muhammad-asif-dba.blogspot.com.br/2013/11/oracle-12c-database-online-move-datafile.html

QUESTION 37
Examine the command used to perform an incremental level-0 backup:
RMAN>BACKUPINCREMENTALLEVEL0DATABASE;
To enable block change tracking, after the incremental level 0 backup, you issue the command:
SQL>ALTERDATABASEENABLEBLOCKCHANGETRACKINGUSING
FILE’/mydir/rman_change_track.f’;
To perform an incremental level-1 cumulative backup, you issue the command:
RMAN>BACKUPINCREMENTALLEVEL1CUMULATIVEDATABASE;
Which two statements are true in the preceding situation?

A.    The block change tracking data is used only from the next incremental backup.
B.    The incremental level 1 backup fails because a block change tracking file Is created after the level 0 backup.
C.    The incremental level 1 backup does not use change tracking data for accomplishing the backup.
D.    The block change tracking file scans all blocks and creates a bitmap for the blocks backed up in the level 0 backup.
E.    The block change tracking data is used for the next incremental level 1 backup only after the next level 0 backup.

Answer: CE

QUESTION 38
You specified the warning and critical thresholds for a locally managed tablespace to be 60% and 70%, respectively. From the tablespace space usage metrics, you find that the space usage has reached the specified warning threshold value, but no alerts have been generated. What could be the reason for this?

A.    The event parameter was not set.
B.    The sql_trace parameter is set to false.
C.    Enterprise Manager was not used.
D.    The statistics_level parameter is set tobasic.
E.    The t:kid_statistics parameter is set to false.

Answer: D
Explanation:
To enable the dbms_server_alert package functionality, set the statistical_level initialization parameter to TYPICAL or ALL.
http://www.dba-oracle.com/t_dbms_server_alert.htm

QUESTION 39
You are administering a multitenant container database (CDB) cdb1 that is running in archivelog mode and contains pluggable databases (PDBs), pdb_i and pdb_2. While opening pdb_1, you get an error:
SQL> alter pluggable database pdb_1 open;
ORA-011S7:cannotidentify/lockdatafile11-seeDBWRtracefile
ORA-01110:data file 11:’/u01/app/oracle/oradata/cdb1/pcb_1/example01.dbf’
To repair the failure, you open an RMAN session for the target database CDBSROOT.
You execute the following as the first command:
RMAN>REPAIRFAILURE;
Which statement describes the consequence of the command?

A.    The command performs the recovery and closes the failure.
B.    The command produces an error because RMAN is not connected to the target database pdb_1.
C.    The command produces an error because the advise failure command was not executed before the REPAIRFAILUER command.
D.    The command executes successfully, performs recovery, and opens PDB_1.

Answer: C
Explanation:
http://docs.oracle.com/database/121/RCMRF/rcmsynta2004.htm#RCMRF199
Usage Notes
Repairs are consolidated whenever possible so that a single repair can fix multiple failures. Be advised that REPAIR FAILURE requires you to explicitly run ADVISE FAILURE in the current session to successfully repair each of the identified failures. You typically iterate through a REPAIR session with the following commands:
– REPAIR FAILURE;
– LIST FAILURE;
– ADVISE FAILURE;
– REPAIR FAILURE;

QUESTION 40
What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?

A.    statistics recommendations
B.    SQL profile recommendations
C.    SQL statement restructure recommendations
D.    creation of materialized views to improve query performance

Answer: B
Explanation:
https://docs.oracle.com/cd/B28359_01/server.111/b28274/sql_tune.htm#CHDJDFGE
Once automatic SQL tuning begins, which by default runs for at most one hour during a maintenance window, the following steps are performed:

During the tuning process, all recommendation types are considered and reported, but only SQL profiles can be implemented automatically.

QUESTION 41
You use RMAN with a recovery catalog to back up your database. The backups and the archived redo log files are backed up to media daily. Because of a media failure, the entire database along with the recovery catalog database is lost. Examine the steps required to recover the database:
1. Restore an autobackup of the server parameter file.
2. Restore the control file.
3. Start up the database instance in nomount state.
4. Mount the database.
5. Restore the data files.
6. Open the database with the resetlogs option.
7. Recover the data files.
8. Set D3ID for the database.
Identify the required steps in the correct order.

A.    1, 8, 3, 2, 4, 5, 7, 6
B.    8, 1, 3, 2, 4, 5, 7, 6
C.    1, 3, 2, 4, 8, 5, 6, 7
D.    8, 3, 2, 4, 5, 7, 6
E.    8, 1, 3, 2, 4, 5, 6

Answer: D

QUESTION 42
Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)?

A.    A PDB opened in restricted mode allows only local users to connect.
B.    When a CDB is open in restricted mode, PDBs must also be opened in restricted mode.
C.    When a CDB is in mount state, PDBs are automatically placed in mount state.
D.    All PDBs must be shut down before shutting down a CDB instance.
E.    When a CDB instance is started, PDBs can be placed in open state by using database triggers or by executing the alter pluggable database command.

Answer: BCE
Explanation:
https://oracle-base.com/articles/12c/multitenant-startup-and-shutdown-cdb-and-pdb-12cr1

QUESTION 43
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?

A.    a hash cluster
B.    an index cluster
C.    a partitioned table
D.    a sorted hash cluster
E.    a heap table with a rowid column

Answer: B
Explanation:
The table is not static, but instead is continually growing. If a table grows without limit, the space required over the life of the table (its cluster) cannot be predetermined.

QUESTION 44
You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux. You have set the db_smart_flash_file parameter:
DB_FLASH_CACHE_FILE= ` /dev/f lash_device_1`,` /dev/f lash_device_2`
How should the D3_flash_cache_size be configured to use both devices?

A.    Set DB_FLASH_CACHE_SIZE=64G.
B.    Set D3_FLASH_CACHE_SIZE=64G, 64G.
C.    Set D3_FLASK_CACKE_SI2E=128G.
D.    db_flash_cache_SI2E is automatically configured by the instance at startup.

Answer: B
Explanation:
https://oracle-base.com/articles/12c/database-smart-flash-cache-12cr1

QUESTION 45
You are required to migrate your 11.2.0.3 database to an Oracle 12c database. Examine the list of steps that might be used to accomplish this task:
1. Place all user-defined tablespaces in read-only mode on the source database.
2. Use the RMAN convert command to convert data files to the target platform’s endian format, if required.
3. Perform a full transportable export on the source database with the parameters
VERSI0N=I2, TRANSPORTABLE=ALWAYS, and FULL=Y.
4. Transport the data files for all the user-defined tablespaces.
5. Transport the export dump file to the target database.
6. Perform an import on the target database by using the full, network_link, and transportable_datafiles parameters.
7. Perform an import on the target database by using the full and transportable_datafiles parameters.
Identify the required steps in the correct order.

A.    1, 3, 5, 4, 2, and 6
B.    1, 2, 4, 6, 5, 3, and 7
C.    1, 2,4, and 7
D.    2, 4, 5, 6, and 7

Answer: A
Explanation:
http://www.oracle.com/technetwork/database/upgrade/upgrading-oracle-database-wp-12c-1896123.pdf


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 –> 242 Q&As)

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