Oracle 1Z0-067 Free Practice Questions

NEW QUESTION 1
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?

• A. The valid time columns employee_time_start and employee_time_end are automatically created.
• B. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
• C. The valid time columns are not populated by the Oracle Server automatically.
• D. The valid time columns are visible by default when the table is described.
• E. 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 queriesperformed by the sessio

Answer: ABC

NEW QUESTION 2
Examine the steps to configure Oracle Secure Backup (OSB) for use with RMAN: 1.Create media families for data files and archived redo log files.
2.Configure database backup storage selectors or RMAN media management parameters. 3.Create an OSB user preauthorized for RMAN operations.
4. Configure RMAN Access to the OSB SBT.
5. Disable Non-Uniform Memory Access (NUMA) awareness by setting the ob_ignore_numa parameter to 0.
Identify the steps in the correct order.

• A. 1, 4, 3, 2, 5
• B. 1, 3, 4, 5, 2
• C. 4, 3, 1, 2, 5
• D. 4, 3, 5, 1, 2

Answer: C

NEW QUESTION 3
Which three statements correctly describe the relationship amongst jobs, programs, and schedules within the Oracle Job Scheduler?

• A. A job is specified as part of a program definition.
• B. A program can be used in the definition of multiple jobs.
• C. A program and job can be specified as part of a schedule definition.
• D. A program and schedule can be specified as part of a job definition.
• E. A program and window can be specified as part of a job definitio

Answer: BDE

Explanation: References: http://docs.oracle.com/database/121/ADMIN/schedover.htm#ADMIN13371

NEW QUESTION 4
View the SPFILE parameter settings in the Exhibit.

You issue this command and get errors: SQL> startup
ORA-00824:cannotsetSGAJTARGET or MEMORY_TARGET dueto existing internalsettings,seealertlog for moreinformation
Why did the instance fail to start?

• A. because pga_aggregate_target is not set
• B. because statistics_level is set to basic
• C. because memory_target and memory_max_target cannot be equal
• D. because sga_target and memory_target are both set

Answer: B

Explanation:
SQL> startup nomount ORA-01078: failure in processing system parameters ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings ORA-00848: STATISTICS_LEVEL cannot be set to BASIC with SGA_TARGET or MEMORY_TARGET SQL>

NEW QUESTION 5
Automatic Undo Management is enabled for your database. You want a user to retrieve metadata and historical data for a given transaction or for transactions in a given time interval.
Which three are prerequisites to fulfill this requirement?

• A. Minimal supplemental logging must be enabled.
• B. The database must be running in archivelog mode.
• C. Flashback Data Archive must be created and the flashback archive administer system privilege must be granted to the user.
• D. The flashback any table privilege must be granted to the user.
• E. The select any transaction privilege must be granted to the user.
• F. The recycle bin parameter must be set to o

Answer: ABE

Explanation: To configure your database for the Flashback Transaction feature, you or your database administrator must: With the database mounted but not open, enable ARCHIVELOG: ALTER DATABASE
ARCHIVELOG; Open at least one archive log: ALTER SYSTEM ARCHIVE LOG CURRENT; If not done, enable minimal and primary key supplemental logging: ALTER DATABASE ADD SUPPLEMENTAL LOG DATA; ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS; Granting
Necessary Privileges For Oracle Flashback Transaction Query Grant the SELECT ANY TRANSACTION privilege. For Oracle Flashback Query and Oracle Flashback Version Query To allow access to specific objects during queries, grant FLASHBACK and SELECT privileges on those objects. To allow queries on all tables, grant the FLASHBACK ANY TABLE privilege. http://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#ADFNS612

NEW QUESTION 6
On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the command:
S>sqlldrhr/hr@pdb table=employees
Which two statements are true about the command?

• A. It succeeds with default settings if the employees table exists in the hr schema.
• B. It fails because no SQL*Loader data file location is specified.
• C. It fails if the hr user does not have the create any directory privilege.
• D. It fails because no SQL*Loader control file location is specified.
• E. It succeeds and creates the employees table in the HR schem

Answer: AC

Explanation: sqlldr scott/tiger@pdb1 TABLE=EMP2 DATE_FORMAT=”DD-MON-YYYY HH24:MI:SS” https://oraclebase. com/articles/12c/sql-loader-enhancements-12cr1

NEW QUESTION 7
Your database is running in ARCHIVELOG mode. You backup your database regularly. If certain files are lost, an incomplete recovery is required.
In which two cases is this true?

• A. flashback logs
• B. inactive online redo log
• C. current online redo log member
• D. all control files
• E. archived log files required to perform recovery

Answer: BD

NEW QUESTION 8
While performing database backup to tape via the media manager interface, you notice that tape streaming is not happening because RMAN is not sending data blocks fast enough to the tape drive. Which two actions would you take for tape streaming to happen during the backup?

• A. Configure backup optimization.
• B. Configure the channel to increase maxopenfiles.
• C. Configure a backup policy by using incremental backups.
• D. Configure the channel to increase capacity with the rate parameter.
• E. Configure the channel to adjust the tape buffer size by using the 3LKSIZE option.
• F. Configure large_pool, if not done alread
• G. Alternatively, you can increase the size of
• H. LARGE_POOL.

Answer: BE

Explanation: Allocation of Tape Buffers If you back up to or restore from an SBT device, then by default the database allocates four buffers for each channel for the tape writers. The size of the tape I/O buffers is platform-dependent. You can change this value with the PARMS and BLKSIZE parameters of the
ALLOCATE CHANNEL or CONFIGURE CHANNEL command. You can improve backup performance by adjusting the level of multiplexing, which is number of input files simultaneously read and then
written into the same RMAN backup piece. The level of multiplexing is the minimum of the MAXOPENFILES setting on the channel and the number of input files placed in each backup set. The following table makes recommendations for adjusting the level of multiplexing.

NEW QUESTION 9
You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:
$ . oraenv
ORACLE_SID = [oracle] ? cdb1
The oracle base for 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 promp

Answer: C

NEW QUESTION 10
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: 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.
References: https://docs.oracle.com/cd/B28359_01/server.111/b28274/sql_tune.htm#CHDJDFGE

NEW QUESTION 11
Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:
1. Create a policy to capture the privileges used by a user for privilege analysis.
2. Generate a report with the data captured for a specified privilege capture.
3. Start analyzing the data captured by the policy.
4. Revoke the unused privileges.
5. Compare the used and unused privileges' lists.
6. Stop analyzing the data.
Identify the correct sequence of steps.

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

Answer: B

Explanation: 1. Create a policy to capture the privilege used by a user for privilege analysis.
3. Start analyzing the data captured by the policy.
6. Stop analyzing the data.
2. Generate a report with the data captured for a specified privilege capture.
5. Compare the used and unused privileges’ lists.
4. Revoke the unused privileges.

NEW QUESTION 12
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 owne

Answer: ADE

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

NEW QUESTION 13
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 to basic.
• E. The t:kid_statistics parameter is set to fals

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

NEW QUESTION 14
RMAN is connected to a target database instance and an auxiliary instance. You execute the command:
RMAN> DUPLICATE TARGET DATABASE
TO dupdb
FROM ACTIVE DATABASE SECTION SIZE 1G;
What is the outcome?

• A. RMAN uses the push method to transfer image copies.
• B. RMAN uses the push method to transfer backup sets.
• C. RMAN uses the pull method to restore files using backup sets.
• D. RMAN uses the pull method to restore files using image copie

Answer: C

NEW QUESTION 15
Which statements are true regarding system-partitioned tables? (Choose all that apply.)

• A. Only a single partitioning key column can be specified.
• B. All DML statements must use partition-extended syntax.
• C. The same physical attributes must be specified for each partition.
• D. Unique local indexes cannot be created on a system-partitioned table.
• E. Traditional partition pruning and partitionwise joins are not supported on these table

Answer: DE

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

• A. when the duplicate ... from active database command contains the section size clause
• B. when you perform active database duplication on a database with flashback disabled
• C. when you specify set encryption before the duplicate ... from active database command
• D. when the number of auxiliary channels allocated is equal to or greater than the number of target channels
• E. when you perform active database duplication on a database that has read-only tablespaces

Answer: ACD

Explanation: Starting with Oracle Database 12c Release 1 (12.1), RMAN can use backup sets to transfer the source database files that need to be duplicated. The backup sets are transferred over the network to the auxiliary database. Backup sets can be encrypted for additional security. Specify the encryption
algorithm by using the SET ENCRYPTION ALGORITHM command before the DUPLICATE command. RMAN uses backup sets to perform active database duplication when the connection to the target database is established using a net service name and any one of the following conditions is satisfied:
The DUPLICATE ... FROM ACTIVE DATABASE command contains either the USING BACKUPSET, USING
COMPRESSED BACKUPSET, or SECTION SIZE clause. The number of auxiliary channels allocated is equal to or greater than the number of target channels allocated. http://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV298

NEW QUESTION 17
You are connected to a recovery catalog and target database. You execute the command: RMAN> CATALOG START WITH ‘/disk1/backups’;
Which statement is true?

• A. It lists and catalogs all valid data file copies, backup pieces, and archived logs that exist in all directory paths with the prefix /disk1/backups and their subdirectories.
• B. It lists all the data file copies, backup pieces, and archived logs cataloged in the recovery catalog in the /disk1/backups directory and its subdirectories.
• C. Only valid data file copies, existing in the /disk1/backups directory, are cataloged.
• D. Only valid backup pieces and archived logs, existing in the /disk1/backups directory, are cataloge

Answer: A