Is this exam completely free?

Examcademy offers a free preview for every exam, covering around 20% of the total questions. Full access is available with a paid upgrade.

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 mock exams are built and reviewed with the help of AI and community contributions, staying aligned with real-world exam objectives.

Free preview mode

Enjoy the free questions and consider upgrading to gain full access!

1z0-063Free trial

By oracle

Verified

25Q per page

Question 26

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 27

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.

—

Question 28

You want to move your existing recovery catalog to another database.
Examine the steps:

Export the catalog data by using the Data Pump Export utility in the source database.
Create a recovery catalog user and grant the necessary privileges in the target database.
Create a recovery catalog by using the create catalog command.
Import the catalog data into the new recovery catalog by using the Data Pump Import utility in the target database.
Import the source recovery catalog schema by using the import catalog command.
Connect to the destination database.
Connect as catalog to the destination recovery catalog schema.
Identify the option with the correct sequence for moving the recovery catalog.

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

—

Question 29

Examine the command and its output:
SQL> DROP TABLE EMPLOYEE;
SQL> SELECT object_name AS recycle_name, original_name, type FROM recyclebin;

RECYCLE_NAMEORIGINAL_NAMETYPE -
-------------------------------------------------------------------- binsgk31sj/3akk5hg3j21kl5j3d==$0EMPLOYEE TABLE
You then successfully execute the command:
SQL> FLASHBACK TABLE "BINSgk31sj/3akk5hg3j21kl5j3d==$0" TO BEFORE DROP;
Which two statements are true?

A: It flashes back the employee table and all the constraints associated with the table.
B: It automatically flashes back all the indexes on the employees table.
C: It automatically flashes back any triggers defined on the table.
D: It flashes back only the structure of the table and not the data.
E: It flashes back the data from the recycle bin and the existing data in the original table is permanently lost.

—

Question 30

You want the execution of large database operations to suspend, and then resume, in the event of space allocation failures.
You set the value of the initialization parameter resumable_timeout to 3600.
Which two statements are true?

A: A resumable statement can be suspended and resumed only once during execution.
B: Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.
C: A suspended statement will report an error if no corrective action has taken place during a timeout period.
D: Before a statement executes in resumable mode, the alter session enable resumable statement must be issued in its session.
E: Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.

—

Question 31

Your database is running in archivelog mode and Automatic Undo Management is enabled.
Which two tasks should you perform before enabling Flashback Database?

A: Enable minimal supplemental logging.
B: Ensure that the db_flashback_retention_target parameter is set to a point in time (in minutes) to which the database can be flashed back.
C: Enable the recyclebin.
D: Enable undo retention guarantee.
E: Enable Fast Recovery Area.

—

Question 32

Examine the commands executed in the root container of your multitenant container database (CDB) that has multiple pluggable databases (PDBs):
SQL> CREATE USER c##a_admin IDENTIFIED BY orcl123;
SQL> CREATE ROLE c##role1 CONTAINER=ALL;
SQL> GRANT CREATE VIEW TO C##roleI CONTAINER=ALL;
SQL> GRANT c##role1 TO c##a_admin CONTAINER=ALL;
SQL> REVOKE c##role1 FROM c##a_admin;
What is the result of the revoke command?

A: It executes successfully and the c##role1 role is revoked from the c##a_admin user only in the root container.
B: It fails and reports an error because the container=all clause is not used.
C: It executes successfully and the c##rocl1 role is revoked from the c##a_admin user in the root database and all the PDBs.
D: It fails and reports an error because the comtainer=current clause is not used.

—

Question 33

You set the following parameters in the parameter file and restart the database instance:

NEMORY_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

—

Question 34

Your database supports an OLTP workload. Examine the output of the query:
SQL> SSLECT target_mttr, estimated_mttr

FROM v$instance_recovery -

Target_mttrestimated_mttr -

To ensure faster instance recovery, you set the fast_start_mttrjtargh:t initialization parameter to 30.
What is the effect of this setting on the database?

A: Automatic checkpoint tuning is disabled.
B: The frequency of log switches is increased.
C: The overhead on database performance is increased because of frequent writes to disk.
D: The MTTR advisor is disabled.

—

Question 35

Which three statements are true about persistent lightweight jobs?

A: A user cannot set privileges on them.
B: They generate large amounts of metadata.
C: They may be created as fully self-contained jobs.
D: They must reference an existing Scheduler Program.
E: They are useful when users need to create a large number of jobs quickly.

—

Question 36

You restore and recover your database to a new host by using an existing RMAN open database backup.
Which step must you perform next?

A: Execute catproc.sql to recompile invalid PL/SQL modules.
B: Open the database with the resetlogs option.
C: Set a new database identifier (DBID) for the newly restored database.
D: Use the RMAN set newname and switch commands to switch to new files.

—

Question 37

Which two statements are true about unified auditing?

A: A unified audit trail captures audit information from unified audit policies and audit settings.
B: Unified auditing is enabled by executing make-fins_rdbms.mk uniaud_onioracle ORACLE_HOME=SORACLE_HOME.
C: Audit records are created for all users except sys.
D: Audit records are created only for the DML and DDL operations performed on database objects.
E: Unified auditing is enabled by setting the audit_trail parameter to db, extended.
F: A unified audit trail resides in a read-only table in the audsys schema in the system tablespace.

—

Question 38

Your database is running in archivelog mode. You are taking a backup of your database by using RMAN with a recovery catalog. Because of a media failure, one of the data files and all the control files are lost.
Examine the steps to recover the database:
1.Restore the control files by using the RMAN restore controlfile command.
2.Mount the database.
3.Restore the data files by using the RMAN restore database command.
4.Open the database with the resetlogs option.
5.Recover the data files by using the RMAN recover using backup controlfile command.
6.Start the database instance in nomount state.
7.Connect to the target database by using a recovery catalog.
8.Open the database.
9.Restore the data file.
10.Recover the data file.
Identify the required steps in the correct order.

A: 7, 6, 1, 2, 3, 5, 4
B: 7, 2, 1, 3, 5, 8
C: 7, 6, 1, 2, 9, 10, 8
D: 7, 6, 1, 2, 9, 10, 4

—

Question 39

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.
Which method or feature should you use?

A: Compare Period ADDM report
B: AWR Compare Period report
C: Active Session History (ASH) report
D: Taking a new snapshot and comparing it with a preserved snapshot

—

Question 40

Which two statements are true about Flashback Version Query?

A: The result of a query can be used as part of a DML statement.
B: It can be used to create views.
C: It can be used only if Flashback Data Archive is enabled for a table.
D: It retrieves all versions of rows that exist in a time interval, including the start time and end time.
E: It can be used to retrieve the SQL that is required to undo a row change and the user responsible for the change.

—

Question 41

You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). You are connected to cdb$root as the sys user.
You execute the commands:
SQL> CREATE USER C##ADMIN IDENTIFIED BY orcll23;
SQL> CREATE ROLE C##CONNECT;
SQL> GRANT CREATE SESSION, CREATE TABLE, SELECT ANY TABLE TO C##CONNECT;
SQL> GRANT C##CONNECT to C##ADMIN CONTAINER=ALL;
Which statement is true about the c##connect role?

A: It is created only in cdb$root and cannot be granted to the c##admin user with the container=all clause.
B: It is granted to the c##admin user only in the CDB.
C: It is granted to the c##admin user in all PDBs and can be granted only to a local user in a PDB.
D: It is granted to the c##admin user in all PDBs and can be granted object and system privileges for a PDB.

—

Question 42

Which three conditions must be met before you create a Virtual Private Catalog (VPC)?

A: A base recovery catalog should exist.
B: The owner of VPC cannot own recovery catalog.
C: At least one target database should be registered in the recovery catalog.
D: The register database privilege should be granted to the virtual catalog owner.
E: The recovery_catalog_owner role should be granted to the virtual catalog owner.

—

Question 43

Which three statements are true about compression of backup sets?

A: Compressed backups can only be written to media.
B: Binary compression creates performance overhead during a backup operation.
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.

—

That’s the end of your free questions

You’ve reached the preview limit for 1z0-063

Consider upgrading to gain full access!

Page 2 of 9 • Questions 26-50 of 212

←

1 2 3 4 5

→

Free preview mode

Enjoy the free questions and consider upgrading to gain full access!