Oracle 1Z0-067 Exam Dumps 2021

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

Answer: BD

Explanation: In general, all scheduler objects created by the user can be exported/imported into the PDB using data pump. Predefined scheduler objects will not get exported and that means that any changes made to these objects by the user will have to be made once again after the database has been imported into the pluggable database. However, this is how import/export works currently. A job defined in a PDB will run only if a PDB is open.

NEW QUESTION 2
Examine the RMAN command:
RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which prerequisite must be met before accomplishing the backup?

• A. The password for the encryption must be set up.
• B. Oracle wallet for the encryption must be set up.
• C. All the tablespaces in the database must be encrypted.
• D. Oracle Database Vault must be enabled.

Answer: B

Explanation:
Configuration encryption will used by Transparent encryption. For transparent encryption, you will need to create a wallet, and it must be open. Transparent encryption will then occur automatically
after you have issued the CONFIGURE ENCRYPTION FOR DATABASE ON or CONFIGURE ENCRYPTION FOR TABLESPACE ON command. http://docs.oracle.com/cd/E25054_01/backup.1111/e10642/rcmbckad.htm#CEGEJABH
CONFIGURE ENCRYPTION : You can use this command to persistently configure transparent encryption. You cannot persistently configure dual mode or password mode encryption. SET ENCRYPTION : You can use this command to configure dual mode or password mode encryption at the RMAN session level.

NEW QUESTION 3
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:

• A. i.Long-running queries are not affecte
• B. ii.No extra space is used.ii
• C. Data manipulation language (DML) operations on the table succeed at all times throughout the process.i
• D. Unused space is reclaimed both above and below the high water mar
• E. Which alter TABLE option would you recommend?
• F. DEALLOCATE UNUSED
• G. SHRINK SPACE CASCADE
• H. SHRINK SPACE COMPACT
• I. ROW STORE COMPRESS BASIC

Answer: C

Explanation: The COMPACT clause lets you divide the shrink segment operation into two phases. When you specify COMPACT, Oracle Database defragments the segment space and compacts the table rows but postpones the resetting of the high water mark and the deallocation of the space until a future time. This option is useful if you have long-running queries that might span the operation and attempt to read from blocks that have been reclaimed. The defragmentation and compaction results are saved
to disk, so the data movement does not have to be redone during the second phase. You can reissue the SHRINK SPACE clause without the COMPACT clause during off-peak hours to complete the second phase.
https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema003.htm

NEW QUESTION 4
Examine these parameter settings: SGA_TARGET = 700M SGA_MAX_SIZE = 1024M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M
You attempt this:
SQL> ALTER SYSTEM SER DB_8K_CACHE_SIZE=140M
Which statement is true based on the information available?

• A. It will fail because DB_8K_CACHE_SIZE cannot be changed dynamically.
• B. It succeeds only if memory is available from the autotuned components of the SGA.
• C. It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.
• D. It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.

Answer: B

NEW QUESTION 5
Which three RMAN persistent settings can be set for a database?

• A. backup retention policy
• B. default backup device type
• C. default section size for backups
• D. default destinations for backups
• E. multiple backup device types for a single backup

Answer: ABD

Explanation: http://docs.oracle.com/cd/B19306_01/backup.102/b14192/setup004.htm#i1019739 To simplify
ongoing use of RMAN, you can set several persistent configuration settings for each target database. These settings control many aspects of RMAN behavior. For example, you can configure the backup retention policy, default destinations for backups, default backup device type, and so on. You can use the SHOW and CONFIGURE commands to view and change RMAN configurations.

NEW QUESTION 6
You are administering a database that supports a data warehousing workload and is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 incremental backups on all the other days of the week.
One of the data files is corrupted and the current online redo log file is lost because of a media failure.
Which action must you take for recovery?

• A. Restore the data file, recover it by using the recover datafilenoredo command, and use the resetlogs option to open the database.
• B. Restore the control file and all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.
• C. Restore all the data files, recover them by using the recover database command, and open the database.
• D. Restore all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.

Answer: B

Explanation: https://docs.oracle.com/database/121/RCMRF/rcmsynta2001.htm#RCMRF140 See Example 3-6
Recovering a NOARCHIVELOG Database STARTUP FORCE NOMOUNT; RESTORE CONTROLFILE; #
restore control file from consistent backup ALTER DATAB ASE MOUNT; RESTORE DATABASE; # restore data files from consistent backup RECOVER DATABASE NOREDO; # specify NOREDO because online redo logs are lost ALTER DATABASE OPEN RESETLOGS;

NEW QUESTION 7
Examine the initialization parameter that is set in the PFILE: DB_CREATE_FILE_DEST ='/u01/app/oracle/oradata/'
You execute the following command to create theCDB1. container database (CDB): SQL>CREATE DATABASE CDB1
DEFAULT TABLESPACE users
DEFAULT TEMPORARY TABLESPACE temp
UNDO TABLESPACE undotbsl
ENABLE PLUGGABLE DATABASE SEED
SYSTEM DATAFILES SIZE125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED SYS AUX DATAFILES SIZE 100M;
Which three statements are true?

• A. It creates a multitenant container database with a root and a seed pluggable database (PDB) that are opened in read-write and read-only modes, respectively.
• B. The files created for both the root and seed databases use Oracle Managed Files (OMF).
• C. It creates a multitenant container database with the root and seed databases opened and one PDB mounted.
• D. It sets the users tablespace as the default for both the root and seed databases.
• E. undotbs1 is used as the undo tablespace for both the root and seed databases.
• F. It creates a multitenant container database with the root database opened and the seed database mounted.

Answer: ABE

Explanation: The seed actually doesn’t use anything since it’s read-only, but any PDB created from the seed will use the undotbs1 undo tablespace. Each PDB can have its own default tablespace, but cannot change the undo tablespace.

NEW QUESTION 8
A user issues a query on the sales table and receives the following error: ERROR at line 1:
ORA-01565: error in identifying file '/u0l/app/oracle/oradata/ORCL/temp01.dbf' ORA-27037: unable to obtain file status
Which two actions would you take to recover the temporary tablespace?

• A. Drop the tenp01.dbf file, and then re-create the temp file.
• B. Add a new temp file to the temporary tablespace and drop the temp01.dbf file.
• C. Shut down the database instance, start up the database instance in mount state, create a new temporary tablespace, and then open the database.
• D. Take the temporary tablespace offline, recover the missing temp file, and then bring the temporary tablespace online.
• E. Create a new temporary tablespace and assign it as the default to the use

Answer: BE

NEW QUESTION 9
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 10
Your database is running in ARCHIVELOG mode. You observe that the fast recovery area does not have enough free space and there is no scope to add more space to it.
Identify two events that can occur at the time of a log switch. (Choose two.)

• A. All active transactions are rolled back and the database instance shuts down.
• B. The database instance status is automatically changed to RESTRICTED mode and file creation in the fast recovery area is prevented.
• C. The Oracle Database server deletes a file that is on the obsolete file list to create free space in the fast recovery area.
• D. An entry is written in the alert log and the database instance is automatically placed in MOUNTstate.
• E. The log switch hangs until free space is available in the fast recovery are

Answer: CE

NEW QUESTION 11
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 12
You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance.
How can you detect the cause of the degraded performance?

• A. Enable Memory Access Mode, which reads performance data from SGA.
• B. Use emergency monitoring to fetch data directly from SGA for analysis.
• C. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.
• D. Use Active Session History (ASH) data and hang analysis in regular performance monitoring,
• E. Run ADDM in diagnostic mod

Answer: B

NEW QUESTION 13
You want to capture column group usage and gather extended statistics for better cardinality estimates for the customers table in the SH schema.
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.

NEW QUESTION 14
Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, the database is running with peak workload. You want to analyze some of the most resource-intensive statements cached in the library cache.
What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance?

• A. SQL Performance Analyzer
• B. SQL Access Advisor
• C. SQL Tuning Advisor
• D. Automatic Workload Repository (AWR) report
• E. Automatic Database Diagnostic Monitor (ADDM)

Answer: B

Explanation: References:
http://docs.oracle.com/cd/B28359_01/server.111/b28275/tdppt_sqltune.htm#TDPPT160

NEW QUESTION 15
You set the following parameters in the parameter file and restart the database instance: MEMORY_MAX_TARGET=0
MEMORY TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M
Which two statements are true?

• A. The memory_max_target parameter is automatically set to 500 MB.
• B. The pga_aggregate_target and sga_target parameters are automatically set to zero.
• C. The value of the memory_max_target parameter remains zero for the database instance.
• D. The lower limits of the pga_aggregate_target and sga_target parameters are set to 90 MB and 270 MB respectively.
• E. The instance does not start up because Automatic Memory Management (AMM) is enabled but pga_aggregate_target and sga_target parameters are set to nonzero values.

Answer: AD

NEW QUESTION 16
Examine the output:
SQL > ARCHIVE LOGLIST
Database log mode Archive Mode Automatic archival Enabled
Archive Destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 376
Next log sequence to archive 378 Current log sequence 378
Which three types of files are automatically placed in the fast recovery area?

• A. Flashback data archives (FDA)
• B. Archived redo log files
• C. Control file autobackups
• D. Server parameter file (SPFILE)
• E. Recovery Manager (RMAN) backup pieces

Answer: BCE

Explanation: References: http://docs.oracle.com/cd/E11882_01/backup.112/e10642/glossary.htm#BRADV526

NEW QUESTION 17
You install Oracle Grid Infrastructure for a standalone server and issue this command:
crsctl start has
Which two components get automatically added to the Oracle Restart configuration the first time this command is issued?
Choose two.

• A. A database that already exists prior to the Grid Infrastructure installation
• B. Oracle Notification services
• C. Oracle Healthcheck services
• D. An Oracle Net Listener that already exists prior to the Grid Infrastructure installation
• E. Oracle CSSD services

Answer: CE

NEW QUESTION 18
Examine the command to back up the ASM metadata: ASMCMD>md_backup /backup/ASM_backup
In which three situations can you use the backup?

• A. when one or more disks in an ASM disk group are lost
• B. when the data file on an ASM disk group gets corrupted
• C. when one of the disks in a disk group is accidentally unplugged
• D. when one or more file directory paths are accidentally deleted from an ASM disk group
• E. when all the ASM disk groups for the ASM instance are lost

Answer: ADE

Explanation: http://www.hhutzler.de/blog/asm-backup-and-restore-dg-metadata/
The md_backup command creates a backup file containing metadata for one or more disk groups. i By default all the mounted disk groups are included in the backup file which is saved in the current working directory. http://docs.oracle.com/cd/E11882_01/server.112/e18951/asm_util004.htm#OSTMG94578
The md_backup command creates a backup file containing metadata for one or more disk groups.

NEW QUESTION 19
Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?

• A. Reduced logical I/O
• B. Reduced virtual memory utilization
• C. Improved Serial Execution performance
• D. Reduced physical I/O
• E. Reduced CPU utilization

Answer: BE