Oracle 1Z0-067 Free Practice Questions 2021

NEW QUESTION 1
Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs). In the PDB hr_pdb, the common user c##admin and the local user b_admin have only the connect privilege.
You create a common role c##role1 with the create table and select any table privileges. You then execute the commands:
SQL> GRANTc##role1 TOcMadmin CONTAINER=ALL;
SQL>CONNsys/oracle@HR_PDB assysdba
SQL> GRANTc##role1TO b_admin CONTAINER=CURRENT;
Which two statements are true?

• A. C##admin can create and select any table, and grant the c##role1 role to users only in the root container.
• B. B_admin can create and select any table in both the root container and kr_pdb.
• C. c##admin can create and select any table in the root container and all the PDBs.
• D. B_admin can create and select any table only in hr_pdb.
• E. The grant c=»role1 to b_admin command returns an error because container should be set to AL

Answer: CD

NEW QUESTION 2
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 3
You wish to create jobs to satisfy these requirements:
1. Automatically bulk load data from a flat file.
2. Rebuild indexes on the SALES table after completion of the bulk load. How would you create these jobs?

• A. Create both jobs by using Scheduler raised events.
• B. Create both jobs using application raised events.
• C. Create one job to rebuild indexes using application raised events and another job to perform bulk load using Scheduler raised events.
• D. Create one job to rebuild indexes using Scheduler raised events and another job to perform bulk load by using events raised by the application.

Answer: C

Explanation: The bulk loader would be started in response to a file watcher scheduler event and the indexes would be rebuilt in response to an application event raised by the bulk loader. https://docs.oracle.com/cd/E18283_01/server.112/e17120/scheduse005.htm#CIABIEJA Your application can raise an event to notify the Scheduler to start a job. A job started in this way is referred to as an event-based job. The job can optionally retrieve the message content of the event. https://docs.oracle.com/cd/B28359_01/server.111/b28310/scheduse008.htm#CHDIAJEB

NEW QUESTION 4
In your database, the user SCOTT wants to retrieve the dropped HR.EMPLOYEES table by using the command:
SQL> FLASHBACK TABLE HR.EMPLOYEES TO BEFORE DROP;
What are three prerequisites for this command to succeed? (Choose three.)

• A. The recycle bin should be enabled.
• B. No duplicates of the HR.EMPLOYEES table should exist in the recyclebin of the HR schema.
• C. SCOTT should have the SELECT privilege on the HR schema and its recyclebin.
• D. SCOTT should have the FLASHBACK ANY TABLE privilege.
• E. No other table with the same name should exist in the HR schema.
• F. Undo retention guarantee must be enable

Answer: ACD

NEW QUESTION 5
Your database is using a default temporary tablespace that contains the temp01.tmp temporary file. All the users on the database use the default temporary tablespace.
A user issues a query on the orders table and receives the following error: ERROR at line 1:
ORA-01565: error in identifying file '/u01/app/oracle/oradata/TEST/temp01.tmp' ORA-27037: unable to obtain file status
What would be the most efficient way to rectify this error?

• A. Add a new tempfile to the user's temporary tablespace and drop the tempfile that produced the error.
• B. Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.
• C. Allow the database to continue running, drop the temp01.tmp temporary file, and then re-create it with new tempfiles.
• D. Take the temporary tablespace offline, recover the missing tempfile by applying redo logs, and then bring the temporary tablespace online.

Answer: A

NEW QUESTION 6
Examine the RMAN command:
RMAN> SET ENCRYPTION IDENTIFIED BY <password> ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which type of encryption is used for the backup performed by using this command?

• A. password-mode encryption
• B. dual-mode encryption
• C. transparent encryption
• D. default encryption

Answer: B

Explanation: http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmbckad.htm#CEGEJABH To make dualmode encrypted backups: Start RMAN and connect to a target database and recovery catalog (if
used). Execute the SET ENCRYPTION BY PASSWORD command, making sure to omit the ONLY keyword. The following example sets the encryption password for all tablespaces (where password is
a placeholder for the actual password that you enter) in the backup and omits ONLY to indicate dualmode encryption: SET ENCRYPTION IDENTIFIED BY password ON FOR ALL TABLESPACES;

NEW QUESTION 7
Which four tablespace types can be renamed? Choose four.

• A. the default permanent tablespace
• B. the SYSTEM tablespace
• C. a temporary tablespace
• D. a read-only tablespace
• E. an offline tablespace
• F. an undo tablespace

Answer: ACDF

NEW QUESTION 8
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 9
After implementing full Oracle Data Redaction, you change the default value for the number data type as follows:
SQL> SELECT NUMBER_VALUE FROM REDACTION_VALUES_FOR_TYPE_FULL; NUMBER_VALUE
------------------------- 0S
QL> EXEC DBMS_REDACT.UPDATE_FULL_REDACTI0N_VALUES(-1)
PL/SQL procedure successfully completed.
SQL> select number_value from redaction_values_for_type_full; NUMBER VALUE
------------------------
-1
After changing the value, you notice that FULL redaction continues to redact numeric data with a zero.
What must you do to activate the new default value for numeric full redaction?

• A. Re-enable redaction policies that use FULL data redaction.
• B. Re-create redaction policies that use FULL data redaction.
• C. Re-connect the sessions that access objects with redaction policies defined on them.
• D. Flush the shared pool.
• E. Restart the database instanc

Answer: E

Explanation: About Altering the Default Full Data Redaction Value
You can alter the default displayed values for full Data Redaction polices. By default, 0 is the redacted value when Oracle Database performs full redaction (DBMS_REDACT.FULL) on a column of the NUMBER data type. If you want to change it to another value (for example, 7), then you can run the
DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES procedure to modify this value. The modification applies to all of the Data Redaction policies in the current database instance. After you modify a
value, you must restart the database for it to take effect.

NEW QUESTION 10
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

NEW QUESTION 11
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 12
You are administering a multitenant container database (CDB) CDB1 with two pluggable databases (PDBs), PDB1 and PDB2. You execute the following commands on CBD$ROOT as the SYS user: SQL> CREATE USER c##scott IDENTIFIED BY scottorcl1;
SQL> GRANT CREATE SESSION TO c##scott;
Which statement is true about the C##SCOTT user? Choose the best answer.

• A. It is created in all the PDBs with CREATE SESSION privilege.
• B. It is created in all the PDBs but has CREATE SESSION privilege only in CDB$ROOT.
• C. It is created and has the CREATE SESSION privilege only in a PDB that is open.
• D. It is created only in CDB$ROOT and has the CREATE SESSION privileg

Answer: D

NEW QUESTION 13
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 14
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 15
The environmental variable oracle_Base is set to /u01/app/oracle and oracle_home is set to
/u01/app/oracle/product/12.1.0/db 1.
You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR). Examine the initialization parameters set in your database.
NAME TYPE VALUE
-------------------------------------------- ------------------- ------------------------------------------------
audit_file_deststring/u01/app/oracle/admin/eml2rep/adump
background_dump_deststring
core_dump_deststring
db_create_file_deststring
db_recovery_file_deststring/u01/app/oracle/fast_recovery_area
diagnostic_deststring
What is the location of the ADR base?

• A. It is set to/u01/app/oracle/product:/12.1.0/db_1/log.
• B. It is set to /u01/app/oracle/admin/en12.1.0/adump.
• C. It is set to /u01/app/oracle.
• D. It is set to /u01/app/oracle/flash_recovery_are

Answer: C

Explanation: http://docs.oracle.com/cd/B28359_01/server.111/b28310/diag001.htm#ADMIN11008
The Automatic Diagnostic Repository (ADR) is a directory structure that is stored outside of the database. It is therefore available for problem diagnosis when the database is down.
The ADR root directory is known as ADR base. Its location is set by the DIAGNOSTIC_DEST initialization parameter. If this parameter is omitted or left null, the database sets DIAGNOSTIC_DEST upon startup as follows:
If environment variable ORACLE_BASE is set, DIAGNOSTIC_DEST is set to the directory designated by ORACLE_BASE.
If environment variable ORACLE_BASE is not set, DIAGNOSTIC_DEST is set to ORACLE_HOME/log.

NEW QUESTION 16
Examine the probable steps involved in the basic backup process of RMAN and Oracle Secure Backup (OSB):
1. RMAN initiates backup and passes the database backup storage selector to OSB.
2. RMAN creates the backup job.
3. OSB creates the backup job with an OSB user.
4. RMAN updates its repository.
5. RMAN executes the job and transfers data from a client to media.
6. OSB executes the job and transfers data from a client to media.
7. OSB updates its repository.
Identify the required steps in the correct order.

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

Answer: C

NEW QUESTION 17
Which three statements are true about Consolidated Database Replay?

• A. The workload capture and replay systems must have the same operating system (OS).
• B. Multiple workload captures from multiple databases can be replayed simultaneously on all pluggable databases (PDBs) in a multitenant container database (CDB).
• C. A subset of the captured workload can be replayed.
• D. The number of captured workloads must be the same as the number of PDBs in a multitenant CDB.
• E. Multiple replay schedules can be defined for a consolidated replay and during replay initialization, you can select from any of the existing replay schedules.

Answer: BCE

Explanation: https://docs.oracle.com/database/121/RATUG/GUID-36DE5567-5A64-493B-A154- 6581C678FC8A.htm#RATUG105
These capture files are platform independent and can be transported to another system. https://docs.oracle.com/database/121/RATUG/GUID-42958859-005D-4B93-9DD3- 79807968EA9E.htm#RATUG4199
You can use Consolidated Database Replay to combine the captured workloads from the three applications and replay them concurrently on PDBs. https://docs.oracle.com/database/121/RATUG/GUID-C4DC0795-74B2-456D-AA0AB4F7F45C81F8. htm
https://docs.oracle.com/database/121/RATUG/GUID-B1AEA82F-60E5-43CE-BB12- C6D72232886A.htm

NEW QUESTION 18
Which two statements are true when row-archival management is enabled?

• A. Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter.
• B. The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered active.
• C. The row archival visibility session parameter defaults to all rows.
• D. The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.
• E. The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer considered active.

Answer: BD