1z0-063 무료 덤프문제 온라인 액세스

Your database instance is abnormally terminated because of a power outage. At the next startup, from which point in the redo log does the recovery start?

• A.from the beginning of the current redo log file until the instance failure
• B.from the last committed transaction
• C.from the last complete checkpoint position
• D.from the most recent incremental checkpoint
• E.from the beginning of the current redo log file to the checkpoint position

You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:

Which statement is true about the execution of the last command?

• A.It succeeds and displays all the tablespaces that belong to the root and pluggable databases.
• B.It fails and returns an error because a connection is not made by using the SYSDBA privilege.
• C.It succeeds and displays all the tablespaces that belong to the root database.
• D.It fails and returns an error because SQL commands cannot be executed at the RMAN prompt.

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.

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

A telecom company wishes to generate monthly bills to include details of customer calls, listed in order of time of call.
Which table organization allows for generating the bills with minimum degree of row sorting?

• A.an index cluster
• B.a heap table with a rowid column
• C.a sorted hash cluster
• D.a partitioned table
• E.a hash cluster

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?

• A.All data files belonging to PDB2_1 are backed up along with the archive log files.
• B.This command gives an error because archive log files can be backed up only when RMAN is connected to the root container database.
• C.All data files belonging to PDB2_1 are backed up and all archive log files are deleted.
• D.Only the data files belonging to pdb2_1 are backed up.