1z0-067
Free trial
Verified
Question 1
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.
Question 2
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.
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 your free questions
You’ve reached the preview limit for 1z0-067Consider upgrading to gain full access!
Free preview mode
Enjoy the free questions and consider upgrading to gain full access!