1z0-067 | What Free 1z0-067 vce Is?
Q51. 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: A
Q52. Which two statements are true about scheduling operations in a pluggable database (PDB)?
A. Scheduler jobs for a PDB can be defined only at the container database (CDB) level.
B. A job defined in a PDB runs only if that PDB is open.
C. Scheduler attribute setting is performed only at the CDB level.
D. Scheduler objects created by users can be exported or imported using Data Pump.
E. Scheduler jobs for a PDB can be created only by common users.
Answer: C,D
Q53. Identify three benefits of unified auditing.
A. It helps to reduce disk space used to store an audit trail in a database.
B. It guarantees zero-loss auditing.
C. It reduces overhead on a database caused by auditing, by having a single audit trail.
D. An audit trail cannot be modified because it is read-only.
E. It automatically audits Recovery Manager (RMAN) events.
Answer: C,D,E
Q54. You want to reduce fragmentation and reclaim unused space for the sales table but not its
dependent objects. During this operation, you want to ensure the following:
i.Long-running queries are not affected.
ii.No extra space is used.
iii.Data manipulation language (DML) operations on the table succeed at all times
throughout theprocess.
iv.Unused space is reclaimed both above and below the high water mark.
Which alter TABLE option would you recommend?
A. DEALLOCATE UNUSED
B. SHRINK SPACE CASCADE
C. SHRINK SPACE COMPACT
D. ROW STORE COMPRESSBASIC
Answer: A
Q55. 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: C,E
Q56. Which two are prerequisites for creating a backup-based duplicate database?
A. connecting to the target database and a recovery catalog to execute the duplicate command
B. creating a password file for an auxiliary instance
C. connecting to an auxiliary instance
D. matching the database identifier (DBID) of the source database and the duplicate database
E. creating an SPFILE for the target database
Answer: A,B
Reference:http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta020.htm#CH DEDFFH
Q57. In which three scenarios is media recovery required?
A. when a tablespace is accidentally dropped from a database
B. when archived redo log files are lost
C. when data files are lost
D. when one of the online redo log members is corrupted
E. when all control files are lost
Answer: A,D,E
Reference:http://docs.oracle.com/cd/A87860_01/doc/server.817/a76993/recoscen.htm
Q58. For your database, an incremental level 1 backup is taken every week day. On Tuesday, before the backup is performed, you add a new tablespace.
You execute the command:
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG
WEEKLY DATABASE;
Which statement is true about the execution of the command?
A. It returns an error because there is no level 0 backup available for new data files.
B. It performs an image copy backup of new data files, and a level 1 incremental backup of all other data files.
C. It performs a level-0 backup of all data files including those that belong to the new tablespace.
D. It performs an image copy backup of all data files including those that belong to the new tablespace.
E. It performs a backup as a backup set of all data files including those that belong to the new tablespace.
Answer: B,C
Reference:http://www.oracle-base.com/articles/misc/incrementally-updated-image-copy-backups.php
Q59. Examine the backup requirement for your company:
1) Every Sunday, a backup of all used data file blocks is performed.
2) Every Wednesday and Friday, a backup of all the changed blocks since last Sunday's
backup is performed.
3) On all the other days, a backup of only the changed blocks since the last day's backup is performed.
Which backup strategy satisfies the requirements?
A. level 0 backup on Sunday, cumulative incremental backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days
B. level 0 backup on Sunday, differential incremental backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days
C. full database backup on Sunday, level 0 backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days
D. full database backup on Sunday, level 0 backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days
Answer: B
Q60. You want to capture column group usage and gather extended statistics for better cardinality estimates for the customers table in theSHschema.
Examine the following steps: 1. Issue the SELECTDBMS_STATS. CREATE_EXTENDED_STATS(‘SH’,'CUSTOMERS')from dual statement.
2.Execute the dbms_stats.seed_col_usage (null,‘SH’,500) procedure.
3.Execute the required queries on the customers table.
4.Issue the select dbms_stats.reportwcol_usage(‘SH’, 'customers') from dual statement.
Identify the correct sequence of steps.
A. 3, 2, 1, 4
B. 2, 3, 4, 1
C. 4, 1, 3, 2
D. 3, 2, 4, 1
Answer: B
Explanation: Step 1 (2). Seed column usage Oracle must observe a representative workload, in order to determine the appropriate column groups. Using the new procedure DBMS_STATS.SEED_COL_USAGE, you tell Oracle how long it should observe the workload. Step 2: (3) You don't need to execute all of the queries in your work during this window. You can simply run explain plan for some of your longer running queries to ensure column group information is recorded for these queries. Step 3. (1) Create the column groups At this point you can get Oracle to automatically create the column groups for each of the tables based on the usage information captured during the monitoring window. You simply have to call the DBMS_STATS.CREATE_EXTENDED_STATS function for each table.This function requires just two arguments, the schema name and the table name. From then on, statistics will be maintained for each column group whenever statistics are gathered on the table.
Note:
* DBMS_STATS.REPORT_COL_USAGE reports column usage information and records all the SQL operations the database has processed for a given object.
* The Oracle SQL optimizer has always been ignorant of the implied relationships between data columns within the same table. While the optimizer has traditionally analyzed the distribution of values within a column, he does not collect value-based relationships between columns.
* Creating extended statistics Here are the steps to create extended statistics for related table columns
withdbms_stats.created_extended_stats:
1 - The first step is to create column histograms for the related columns.
2 – Next, we run dbms_stats.create_extended_stats to relate the columns together.
Unlike a traditional procedure that is invoked via an execute (“exec”) statement, Oracle
extended statistics are created via a select statement.