Is this exam completely free?

ExamCademy offers a free preview for every exam, covering around 20% of the total questions. Full access to all questions is available for free by signing up for an account. Optional supporters unlock AstroTutor (AI tutor) and advanced study modes.

Can I practice IT certification exams from Microsoft, AWS, or CompTIA?

Yes! ExamCademy supports a wide range of IT certification exams including Microsoft Azure, AWS Cloud Practitioner, and CompTIA A+ and Security+.

How accurate are the mock exams?

Our practice questions are community-created and moderator-reviewed to align with realistic exam objectives, style, and difficulty.

1z0-067 by Oracle - Page 1 | ExamCademy

Mode Selection

Question 1

Question 2

Question 3

You wish to create jobs to satisfy these requirements:

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.

Question 4

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 the process. 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 COMPRESS BASIC

Question 5

For which two requirements would you use the Database Resource Manager?

A limiting the CPU used per database call
B specifying the maximum number of concurrent sessions allowed for a user
C specifying the amount of private space a session can allocate in the shared pool of the SGA
D limiting the degree of parallelism of operations performed by a user or group of users
E specifying an idle time limit that applies to sessions that are idle and blocking other sessions

Question 6

Which two statements are true about the Automatic Diagnostic Repository (ADR)?

A The ADR base is shared across multiple instances.
B The ADR base keeps all diagnostic information in binary format.
C The ADR can be used to store statspack snapshots to diagnose database performance issues.
D The ADR can be used for problem diagnosis even when the database instance is down.
E The ADR is used to store Automatic Workload Repository (AWR) snapshots.

Question 7

Which two statements are true about a common user?

A A common user connected to a pluggable database (PDB) can exercise privileges across other PDBs.
B A common user with the create user privilege can create other common users, as well as local users.
C A common user can be granted only a common role.
D A common user can have a local schema in a PDB.
E A common user always uses the global temporary tablespace that is defined at the CDB level as the default temporary tablespace.

Question 8

RMAN is connected to the target database prod1 and an auxiliary instance in nomount state. Examine the command to create a duplicate database:
RMAN> DUPLICATE TARGET DATABASE TO dup1

FROM ACTIVE DATABASE -

NOFILENAMECHECK -

PASSWORD FILE -
SPFILE;
Which two statements are true about the execution of the duplicate command?

A All archive redo log files are automatically copied to the duplicate database.
B The duplicate database has the same directory structure as the source database.
C The duplicate database is created by using the backups created during the execution of
D the duplicate command.
E The password file and SPFILE for the duplicate database dup1 are created in their respective default locations.
F The duplicate database is created without using RMAN backups and prod: is allowed to remain open during duplication.

Question 9

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 tenpOi.dbf file, and then re-create the temp file.
B Add a new temp file to the temporary tablespace and drop the tempOi.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 user.

Question 10

Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and is affecting undo retention.
Which two actions would you take to solve this problem?

A Enable temporary undo for the database.
B Enable undo retention guarantee.
C Increase the size of the redo log buffer.
D Enable Automatic Memory Management (AMM).
E Increase the size of the temporary tablespace.

Question 11

Which two statements are true about service creation for pluggable databases (PDBs)?

A When a PDB is created, a service is automatically started in the instance with the same name as the PDB.
B The default service that is automatically created by a database at the time of PDB creation can be dropped, provided a new additional service is created.
C A database managed by Oracle Restart can have additional services created or existing services modified by using the srvctl utility for each PDB.
D Only a common user can create additional services for a PDB.
E When a PDB is created, a service with the same name as the PDB is created in the PDB.

That's the end of the Preview

Create a free account to unlock all questions for this exam.

Log In / Sign Up

Page 1 of 3 • Questions 1-25 of 53

1 2 3

→

Know a question that should be here? Contribute to this exam

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 definition.

Which two statements describe the relationship between a window, a resource plan, and a job class?

A A window specifies a resource plan that will be activated when that window becomes active.
B A window specifies a job class that will be activated when that window becomes active.
C A job class specifies a window that will be open when that job class becomes active.
D A window in association with a resource plan controls a job class allocation.
E A window in association with a job class controls a resource allocation.