Pass 1z0-063 Exam Latest Practice Questions Updated on Sep 12, 2022 [Q52-Q69]

admin 1z0-063 Oracle September 12, 2022

4/5 - (1 vote)

Pass 1z0-063 Exam Latest Practice Questions Updated on Sep 12, 2022

Oracle 1z0-063 Study Guide Archives

Q52. Examine the command used to perform an incremental level-0 backup:
RMAN> BACKUP INCREMENTAL LEVEL0 DATABASE;
To enable block change tracking, after the incremental level 0 backup, you issue the command:
SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING
FILE’/mydir/rman_change_track.f’;
To perform an incremental level-1 cumulative backup, you issue the command:
RMAN> BACKUP INCREMENTAL LEVEL1 CUMULATIVE DATABASE;
Which two statements are true in the preceding situation? (Choose two.)

The block change tracking data is used only from the next incremental backup.

The incremental level 1 backup fails because a block change tracking file Is created after the level 0 backup.

The incremental level 1 backup does not use change tracking data for accomplishing the backup.

The block change tracking file scans all blocks and creates a bitmap for the blocks backed up in the level 0 backup.

The block change tracking data is used for the next incremental level 1 backup only after the next level 0 backup.

Q53. 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? (Choose two.)

It succeeds with default settings if the employees table exists in the hr schema.

It fails because no SQL*Loader data file location is specified.

It fails if the hr user does not have the create any directory privilege.

It fails because no SQL*Loader control file location is specified.

It succeeds and creates the employees table in the HR schema.

Q54. You are administering a multitenant container database (CDB) CDB1 that has multiple pluggable databases (PDBs). As the SYS user on CDB$ROOT, you execute the commands:
SQL> CREATE USER C##ADMIN IDENTIFIED BY orcl123;
SQL> GRANT CREATE SESSION to C##ADMIN CONTAINER=ALL;
SQL> GRANT CREATE USER TO C##ADMIN CONTAINER=ALL;
Which two statements are true about the c##ADMIN user that is created in all PDBs? (Choose two.)

It can create only local users in all the PDBs.

It has a common schema for all the PDBs.

It can create common users only when it is logged in to the CDB.

It can create only local users in the CDB.

It can be granted only common roles in the PDBs.

Q55. You have a production Oracle 12c database running on a host.
You want to install and create databases across multiple new machines that do not have any Oracle database software installed. You also want the new databases to have the same directory structure and components as your existing 12c database.
The steps in random order:
1.Create directory structures similar to the production database on all new machines.
2.Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database.
3.Create a database clone template for the database.
4.Run the Database Configuration Assistant (DBCA) to create the database.
5.Run OUI in graphical mode on each machine.
6.Run OUI in silent mode using the OUI response file.
Identify the required steps in the correct sequence to achieve the requirement with minimal human intervention.

2, 1, 6, and 4

2, 3, and 6

3, 1, 5, and 6

2, 3, 1, and 6

1, 5, and 4

Q56. Your multitenant container database (CDB) CDB1 that is running in ARCHIVELOG mode contains two pluggable databases (PDBs), PDB2_1 and PDB2_2, both of which are open. RMAN is connected to the target pluggable database PDB2_1.
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which statement is true about the execution of this command to back up the database?

All data files belonging to PDB2_1 are backed up and all archive log files are deleted.

All data files belonging to PDB2_1 are backed up along with the archive log files.

Only the data files belonging to pdb2_1 are backed up.

This command gives an error because archive log files can be backed up only when RMAN is connected to the root container database.

Q57. You create a new database by using the CREATE DATABASEcommand in SQL *Plus, with the ENABLE
PLUGGABLE DATABASEclause specified.
Which statement is true about the database that is created?

It is created as a container database (CDB) with CDB$ROOT, PDB$SEED, and a pluggable database
(PDB).

It is created as a non-CDB that becomes a CDB after the first PDB is plugged in.

It is created as a PDB that must be plugged into an existing CDB.

It is created as a CDB with the CDB$ROOTand PDB$SEEDdatabases.

Q58. Which two statements are true about dropping a pluggable database (PDB)? (Choose two.)

A PDB must be in MOUNTstate or it must be unplugged.

The data files associated with a PDB are automatically removed from disk.

A dropped and unplugged PDB can be plugged back into the same multitenant container database (CDB) or other CDBs.

A PDB must be in closed state.

The backups associated with a PDB are removed.

A PDB must have been opened at least once after creation.

Q59. You plan to create a new PDB by copying PDB$SEED.
Which two requirements ensure a successful creation? (Choose two.)

The CDB must have PDB_FILE_NAME_CONVERT configured before executing the command.

A default service for the new PDB name must already exist.

A PDB local administrative user must be granted the DBA role when creating the PDB.

A PDB local administrative user must be specified when creating the PDB.

The CDB, which will contain the PDB, must be in READ WRITE mode.

The CDB must use Oracle Managed Files.

Q60. One of your container databases (CDBs) has five pluggable databases (PDBs).
COMMON_USER_PREFIXis C##.
These commands executed successfully while connected as SYSto CDB$ROOT:
SQL> CREATE USER c##dba_admin IDENTIFIED BY orcl123;
SQL> CREATE ROLE c##role1 CONTAINER=ALL;
SQL> GRANT CREATE VIEW TO c##role1 CONTAINER=ALL;
SQL> GRANT c##role1 TO c##dba_admin CONTAINER=ALL;
SQL> GRANT c##role1 to system CONTAINER=ALL;
Which three are true? (Choose three.)

The C##DBA_ADMIN user is able to create views in any PDB as a result of being granted the C##ROLE1 role.

The C##DBA_ADMINuser is a local user in CDB$ROOTand PDB$SEED.

The c##role1role will always have the same privileges in all current and future PDBs.

The C##DBA_ADMINuser is a local user in CDB$ROOT.

SYSTEMis able to create views in any PDB as a result of being a DBA user.

SYSTEMis able to create views in any PDB as a result of being granted the C##ROLE1role.

Q61. Which two statements are true about tablespaces in multitenant container databases (CDBs)?

Default permanent tablespaces can be shared across pluggable databases (PDBs).

The current container must be set to root to create or modify the default temporary tablespace or tablespace group for a CDB.

Each PDB can have its own default temporary tablespace.

The default permanent tablespace for a PDB can be changed only by a local user with the required permissions.

The amount of space that each PDB can use in a shared temporary tablespace must be set at the CDB level.

Q62. You are connected to a pluggable database (PDB) as a common user with the SYSDBA privilege. The PDB is open and you issue the SHUTDOWN IMMEDIATE command.
What is the outcome?

The PDB is closed and left in the mount state.

The PDB is closed and left in the unmount state.

The command executes only if the common user is granted the SET CONTAINER privilege for the PDB.

The command results in an error because the PDB can be shut down only by a local user.

Q63. Which three statements are true about the database instance startup after an instance failure? (Choose three.)

The RECO process recovers the uncommitted transactions at the next instance startup.

Online redo log files and archived redo log files are required to complete the rollback stage of instance recovery.

Uncommitted changes are rolled back to ensure transactional consistency.

The SMON process coordinates the database recovery.

Media recovery is required to complete the database recovery.

Changes committed before the failure, which were not written to the data files, are re-applied.

Q64. You need to perform a block media recovery on the tools01.dbf data file in your database by using Recovery Manager (RMAN).
Which two are prerequisites for performing this operation? (Choose two.)

You must configure a block change tracking file.

You must use an incremental level-1 backup to restore blocks.

You must ensure that the database is mounted or open.

You must have full or level-0 backups to restore blocks.

You must take the tools01.dbf data file offline.

Q65. You want to create a duplicate database DUP_DB from your production database PROD on the same host.
The PROD database uses Automatic Storage Management (ASM) for storage. Regular backups are taken using RMAN connected to a recovery catalog.
You create an auxiliary instance and want to execute the command:

What is a prerequisite for the successful execution of this command?

The target database must be in MOUNT state.

RMAN must be connected to the target database instance and the auxiliary instance.

A most recent backup set of the PROD database must exist.

Flashback must be enabled for the PROD database.

Q66. Which four are true about Consolidated Database Replay? (Choose four.)

The workload capture and replay servers must run the same operating system (OS).

Multiple workload captures from multiple databases can be replayed simultaneously.

A subset of the captured workload can be replayed.

The number of captured workloads must be the same as the number of PDBs in a multitenant CDB.

Multiple replay schedules can be defined for a consolidated replay.

A single replay schedule can be defined for a consolidated replay.

A superset of the captured workload can be replayed.

Q67. You want to consolidate databases for the CRM, ERP, and SCM applications by migrating them to pluggable databases (PDBs).
You have already created a test system to support the consolidation of databases in a multitenant container database (CDB) that has multiple PDBs.
What is the easiest way to perform capacity planning for consolidation?

capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Performance Analyzer on the test system

capturing the workload on the production system and replaying the workload for one PDB at a time on the test system

capturing the workload on the production system and using Consolidated Database Replay to replay the workload of all production systems simultaneously for all PDBs

capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Tuning Advisor on the test system

Q68. 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?

Create both jobs by using Scheduler raised events.

Create both jobs using application raised events.

Create one job to rebuild indexes using application raised events and another job to perform bulk load using Scheduler raised events.

Create one job to rebuild indexes using Scheduler raised events and another job to perform bulk load by using events raised by the application.

Q69. Examine the statements that use flashback technologies:
1. FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP(‘2013-02-04 09:30:00’,
‘YYYY-MM-DD HH:MI:SS’);
2. SELECT * FROM customers AS OF SCN 123456;
3. FLASHBACK TABLE customers TO BEFORE DROP;
4. FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP(‘2013-02-04 09:30:00’,
‘YYYY-MM-DD HH:MI:SS’);
5. SELECT * FROM customers VERSIONS BETWEEM SCN 123456 AND 123999;
6. ALTER TABLE customers FLASHBACK ARCHIVE;
Which set of statements depends on the availability of relevant undo data in the undo tablespace?

1, 2, 5

1, 3, 6

2, 3, 5, 6

3, 4, 5

Oracle 1Z0-063 Dumps

Oracle 12c Dumps are tests created to demonstrate all the features of our Oracle 12c Questions Web Simulator. You will be able to access to many questions and will have the ability to test your knowledge on-line.

There are several components you can interact with when you take our practice exams:

Navigate the Oracle 12c Questions using the “Previous” and “Next” buttons.
Once the test is submitted, the result section will expand. Here, you will be able to review all the questions of the test. From here, you can also navigate directly to each question.
Start now our 1Z0-063 exam dumps on-line Simulator.
Keep an eye on the countdown. This will tell you how much time is left. When the countdown expires, the test will be automatically submitted.

1z0-063 Questions Prepare with Learning Information: https://www.validexam.com/1z0-063-latest-dumps.html