2021 Updated Oracle 1z0-067 Dumps PDF - Want To Pass 1z0-067 Fast
1z0-067 Practice Exam Dumps - 99% Marks In Oracle Exam
NEW QUESTION 62
Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)?
- A. When a CDB is open in restricted mode, PDBs must also be opened in restricted mode.
- B. When a CDB is in mount state, PDBs are automatically placed in mount state.
- C. 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.
- D. All PDBs must be shut down before shutting down a CDB instance.
- E. A PDB opened in restricted mode allows only local users to connect.
Answer: A,B,C
NEW QUESTION 63
In which three situations must your use a recovery catalog?
- A. when you want to restrict the amount of space used by backups
- B. when you want to maintain backup metadata longer than the period specified by the CONTROL_FILE_RECORD_KEEP_TIME parameter
- C. when you want to list data files that were in a target database at a given time by using the AT clause with the REPORT SCHEMA command
- D. when you want to store RMAN global scripts that can be used across multiple databases
- E. when you want to perform incremental backups by using a block change tracking file
Answer: B,C,D
NEW QUESTION 64
Examine the commands executed to monitor database operations:
$> conn sys/oracle@prod as sysdba
SQL> VAR eid NUMBER
SQL>EXEC :eid := DBMS_SQL_MONITOR.BEGlN_OPERATION('batch_job',FORCED_TRACKING=>'Y'); Which two statements are true?
- A. Only DML and DDL statements will be monitored for the session.
- B. Database operations will be monitored only when they consume a significant amount of resource.
- C. All subsequent statements in the session will be treated as one database operation and will be monitored.
- D. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.
- E. Database operations for all sessions will be monitored.
Answer: C,D
Explanation:
C: Setting the CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter to DIAGNOSTIC
+TUNING (default) enables monitoring of database operations. Real-Time SQL Monitoring is a feature of the Oracle Database Tuning Pack.
Note:
* The DBMS_SQL_MONITOR package provides information about Real-time SQL Monitoring and Real-time Database Operation Monitoring.
*(not B) BEGIN_OPERATION Function starts a composite database operation in the current session.
/ (E) FORCE_TRACKING - forces the composite database operation to be tracked when the operation starts.
You can also use the string variable 'Y'.
/ (not A) NO_FORCE_TRACKING - the operation will be tracked only when it has consumed at least 5 seconds of CPU or I/O time. You can also use the string variable 'N'.
NEW QUESTION 65
user_data is a nonencryptedtablespace containing tables with data.
You must encrypt ail data in this tablespace.
Which three methods can do this?
- A. Use CREATE TABLE AS SELECT
- B. Use ALTERTABLE. . .MOVE
- C. Use altertablespace to encrypt the tablespace.
- D. Use Data Pump.
- E. Use alter tablespace to encrypt the tablespace after enabling row movement on all its
Answer: A,B,D
NEW QUESTION 66
Which three statements are true about Oracle Restart?
- A. It runs periodic check operations to monitor the health of Oracle components.
- B. While starting any components, it automatically attempts to start all dependencies first and in proper order.
- C. It can be configured to automatically attempt to restart various components after a hardware or software failure.
- D. It can be configured to automatically restart a database in case of normal shutdown of the database instance.
- E. It can be used to only start Oracle components.
Answer: A,B,C
Explanation:
Explanation
A is correct: Oracle Restart improves the availability of your Oracle database. When you install Oracle Restart, various Oracle components can be automatically restarted after a hardware or software failure or whenever your database host computer restarts E is correct: Oracle Restart runs periodic check operations to monitor the health of these components. If a check operation fails for a component, the component is shut down and restarted. B is also true About Startup Dependencies Oracle Restart ensures that Oracle components are started in the proper order, in accordance with component dependencies. For example, if database files are stored in Oracle ASM disk groups, then before starting the database instance, Oracle Restart ensures that the Oracle ASM instance is started and the required disk groups are mounted. Likewise, if a component must be shut down, Oracle Restart ensures that dependent components are cleanly shut down first. Oracle Restart also manages the weak dependency between database instances and the Oracle Net listener (the listener): When a database instance is started, Oracle Restart attempts to start the listener. If the listener startup fails, then the database is still started. If the listener later fails, Oracle Restart does not shut down and restart any database instances.
References:
http://docs.oracle.com/cd/E18283_01/server.112/e17120/restart001.htm
NEW QUESTION 67
You issue the RMAN commands:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RMAN> 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 archived log files and marking them as obsolete
- C. backing up all data files as image copies and archive log files, and deleting those archive log files
- D. backing up only the used blocks in the data files
- E. backing up all used and unused blocks in the data files
Answer: A,C,E
NEW QUESTION 68
Which three statements are true about compression of backup sets?
- A. Binary compression creates performance overhead during a backup operation.
- B. Compressed backups can only be written to media.
- C. Unused blocks below the high-water mark are not backed up.
- D. Compressed backups cannot have section size defined during a backup operation
- E. It works only for locally managed tablespaces.
Answer: A,C,E
Explanation:
Explanation/Reference:
Explanation:
"RMAN also skips other datafile blocks that do not currently contain data, if all of the following conditions
apply: The COMPATIBLE initialization parameter is set to 10.2 There are currently no guaranteed restore
points defined for the database The datafile is locally managed The datafile is being backed up to a
backup set as part of a full backup or a level 0 incremental backup The backup set is being created on
disk.
References:https://docs.oracle.com/cd/B19306_01/backup.102/b14194/rcmsynta009.htm#i1015382
NEW QUESTION 69
What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?
- A. SQL profile recommendations
- B. SQL statement restructure recommendations
- C. creation of materialized views to improve query performance
- D. statistics recommendations
Answer: A
Explanation:
Explanation/Reference:
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 70
You want to create a guaranteed restore point for your database by executing the command:
SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;
Identify two prerequisites for the successful execution of this command.
- A. Flashback Database must be enabled.
- B. A database backup must be taken.
- C. The database must be running in archivelog mode.
- D. Undo retention guarantee must be enabled.
- E. Fast Recovery Area must be enabled.
- F. The recyclebin must be enabled for the database.
Answer: C,E
Explanation:
Explanation/Reference:
Explanation:
SQL> select flashback_on from v$database;
FLASHBACK_ON
------
NO
SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;
Restore point created.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 113
Next log sequence to archive 115
Current log sequence 115
SQL>
http://docs.oracle.com/cd/B19306_01/backup.102/b14192/rpfbdb002.htm
NEW QUESTION 71
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. INTERVAL DAY TO SECOND
- B. DATE
- C. INTERVAL YEAR TO MONTH
- D. TIMESTAMP
- E. TIMESTAMP WITH LOCAL TIME ZONE
Answer: D,E
NEW QUESTION 72
You issue the RMAN commands:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RMAN> 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 archived log files and marking them as obsolete
- C. backing up all data files as image copies and archive log files, and deleting those archive log files
- D. backing up only the used blocks in the data files
- E. backing up all used and unused blocks in the data files
Answer: A,C,E
Explanation:
Explanation/Reference:
https://docs.oracle.com/database/121/BRADV/rcmbckba.htm#BRADV89516
NEW QUESTION 73
Examine the command:
$expdp SYSTEM FULL=YES DUMPFILE=dpump_dir1:fulll%U.dmp, dpump_dir2:full2% U.dmp, dpump_dir3:full3%U.dmp FILESIZE=400M PARALLEL=3 JOB_NAME=expfull Which statement is true about the execution of the command?
- A. It succeeds and exports the full database, simultaneously creating three dump files at three different locations, but the total number of dump files can exceed three.
- B. It fails because the log file parameter is not specified.
- C. It succeeds and exports the full database, simultaneously creating three copies of dump files at three different locations.
- D. It fails because no absolute path is specified for the log file and dump file.
Answer: A
Explanation:
Explanation/Reference:
Explanation:
It can create more than 3 files because you say that each file has a maximum of 400 MB. For example in my export that had 1,2 gb it created 4 files. %u makes 01, 02, 03 and so on.
NEW QUESTION 74
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 command checks for blocks that contain a valid checksum and matching headers and footers, but that has logically inconsistent contents.
- C. The command checks for blocks containing all zeros, an invalid checksum, or a corrupt block header.
- D. The database must be running in archivelog mode for the successful execution of this command.
- E. A complete database backup must exist before executing this command.
Answer: C
NEW QUESTION 75
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.Relocate the member of the damaged online redo log group to a new location.
5.Open the database with the resetlogs option.
6. Issue a checkpoint and clear the log.
Identify the required steps in the correct order.
- A. 6, 3, 4, 5
- B. 2, 3, 4, 5
- C. 6, 4, 3, 5
- D. 1, 3, 4, 5
Answer: B
Explanation:
Explanation/Reference:
Explanation:
NEW QUESTION 76
Your database is running in archivelog mode. Examine the initialization parameters you plan to set for your database instance.
LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch'
LOG_ARCHIVE_DEST_2 = 'L0CATI0N=/disk2/3rch'
LOG_ARCHIVE_DEST_3 = 'LOCATION=/disk3/arch'
L0G_ARCHIVE_DEST_4 = 'L0CATI0N=/disk4/3rch MANDATORY'
Identify the statement that correctly describes these settings.
- A. Optional destinations cannot use the fast recovery area.
- B. An online redo log file is not allowed to be overwritten if the archived log file cannot be created in the location specified for log_archive_dest_4.
- C. An online redo log file is not allowed to be overwritten if the archived log file cannot be created in any of the log_archive_dest_.n destinations.
- D. These settings work only if log__archive_min_succeed_dest is set to a value of 4.
Answer: C
Explanation:
Explanation/Reference:
Explanation:
NEW QUESTION 77
Your multitenant container database (CDB) cdb1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command:
SQL>STARTUP
Which two statements are true about the successful execution of the command?
- A. Only the root database is opened in read-write mode.
- B. The root, the seed, and all the PDBs are opened in read-write mode.
- C. All redo log files are opened.
- D. All the PDBs are in closed state.
- E. All the PDBs are opened in read-write mode.
Answer: A,C
Explanation:
Explanation
The 12.1.0.2 patchset has introduced the ability to preserve the startup state of PDBs, so you probably shouldn't be implementing a trigger in the manner discussed in this section. Prior to 12.1.0.2, when the CDB is started, all PDBs remain in mounted mode. There is no default mechanism to automatically start them when the CDB is started. The way to achieve this is to use a system trigger on the CDB to start some or all of the PDBs.
NEW QUESTION 78
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 partitioned table
- B. an index cluster
- C. a hash cluster
- D. a heap table with a rowid column
- E. a sorted hash cluster
Answer: E
Explanation:
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.
NEW QUESTION 79
Which three statements are true about Scheduler Windows? (Choose three.)
- A. Consumer groups are associated with windows.
- B. The Resource Manager can automatically start windowed jobs or change resource allocation among windowed jobs.
- C. A database service name must be provided during window creation.
- D. Windows work with job classes to control resource allocation.
- E. Only one window can be open at one time.
Answer: C,D,E
NEW QUESTION 80
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. ROW STORE COMPRESS BASIC
- D. SHRINK SPACE COMPACT
Answer: A
NEW QUESTION 81
Which Oracle Database component is audited by default if the Unified Auditing option is enabled?
- A. Oracle Recovery Manager (RMAN)
- B. Oracle Label Security
- C. Oracle Database Vault
- D. Oracle Data Pump
- E. Oracle Real Application Security
Answer: A
Explanation:
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.
References:
https://docs.oracle.com/database/121/DBSEG/audit_config.htm#CHDDHEIA
NEW QUESTION 82
......
Preparation Resources
As you can see, the list of topics covered for the 1Z0-067 exam is very extensive. Thereby Oracle offers specially designed courses on how to work with the Database Oracle 12c. You can gain in-depth knowledge as well as skills in Oracle Database 12c Administration, backup and recovery, security and management, as well as get the latest information from expert Oracle instructors through live virtual classes. Each of these courses is recommended, but not required, as it aims to cover only one of the exam areas.
However, for comprehensive training for the OCP certification, the official vendor offers 2 programs that cover all the 1Z0-067 exam objectives.
- In a similar vein, Oracle Database 12c: Backup and Recovery Workshop designed to transfer the skill of using Oracle Enterprise Manager Cloud Control 12c to database administrators who already have key knowledge of SQL and PL/SQL as well as Oracle Database 12c. Furthermore, candidates will work out appropriate strategies for backup, recovery, and restoration procedures for the real-world scenarios provided. All this will help them learn how to diagnose and repair data failures, as well as secure the availability of your organization's database. Then, in hands-on training sessions, you can practice your skills on numerous failure scenarios thanks to the realistic technology environment. Overall, all this can keep you confident on the official exam day and get the Oracle Database 12c Administrator Certified Professional certification you want.
- Oracle Database 12c R1: New Features for Administrators a course that introduces you to the enhanced features and options of Oracle Database 12c, and lets you understand how it can help improve the security, performance, and manageability of your organization's data center. Moreover, students will be familiarized with Oracle Database Cloud Service and other tools such as Oracle Enterprise Manager Database Express SQL Developer, useful for monitoring and administration. All this thanks to the qualitatively elaborated program of more than 20 sections, each of which includes demonstration and theory classes, as well as practical exercises in order to train on living proofs to develop skills in the administration of the new features of Oracle Database 12c.
Updated Verified 1z0-067 Q&As - Pass Guarantee: https://www.testkingpass.com/1z0-067-testking-dumps.html