You are administering a multitenant container database (CDB) cdb1.
Examine the command and its output:
SQL>show parameterfile
NAME TYPE VALUE
db_create_file_dest string
db_file_name_convert string db_files integer 200 You verify that sufficient disk space is available and that no file currently exists in the `/u0l/app/oracle/
oradata/cdb1/salesdb' location.
You plan to create a new pluggable database (PDB) by using the command:
SQL>CREATEPLUGGABLEDATABASESALESPDB
ADMINUSER salesadm IDENTIFIED BY password;
ROLES=(dba)
DEFAULTTABLESPACE sales
DATAFILE' /u01/app/oracle/oradata/cdb1/salesdb/sales01.dbf'SIZE 250M AUTOEXTEND ON
FILE_NAME_CONVERT=(`/u01/app/oracle/oradata/cdb1/pdbseed/',
'/u01/app/oracle/oradata/cdb1/salesdb/')
STORAGE(MAXSIZE2G)
PATK_PREFIX='/u01/app/oracle/oradata/cdb1/SALESPDB';
Which statement is true?
A. SALESPDB is created and is in mount state.
B. PDB creation fails because the db_file_name_convert parameter is not set in the CDB.
C. SALESPDB is created and is in read/write mode.
D. PDB creation fails because a default temporary tablespace is not defined for SALESPDB.
You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).
The following are the possible steps to accomplish this task:
1.
Place all the user-defined tablespace in read-only mode on the source database.
2.
Upgrade the source database to a 12c version.
3.
Create a new PDB in the target container database.
4.
Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility.
5.
Copy the associated data files and export the dump file to the desired location in the target database.
6.
Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.
7.
Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.
Identify the correct order of the required steps.
A. 2, 1, 3, 4, 5, 6
B. 1, 3, 4, 5, 6, 7
C. 1, 4, 3, 5, 6, 7
D. 2, 1, 3, 4, 5, 6, 7
E. 1, 5, 6, 4, 3, 2
Your database is running in noarchivelog mode. One of the data files belonging to the system tablespace is corrupted. You notice that all online redo logs have been overwritten since the last backup.
Which method would you use to recover the data file?
A. Shut down the instance if not already shut down, restore all data files belonging to the system tablespace from the last backup, and restart the instance.
B. Shut down the instance if not already shut down, restore the corrupted data file belonging to the system tablespace from the last backup, and restart the instance.
C. Shut down the instance if not already shut down, restore all data files for the entire database from the last backup, and restart the instance.
D. Mount the database, restore all data files belonging to the system tablespace from the last backup, and open the database.
You execute the RMAN commands:
RMAN> BACKUP VALIDATE DATABASE; RMAN> RECOVER CORRUPTION LIST;
Which task is performed by these commands?
A. Corrupted blocks, if any, are repaired in the backup created.
B. Only those data files that have corrupted blocks are backed up.
C. Corrupted blocks in the data files are checked and repaired before performing the database backup.
D. The database is checked for physically corrupt blocks and any corrupted blocks are repaired.
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?
A. The PDB is closed and left in the mount state.
B. The PDB is closed and left in the unmount state.
C. The command executes only if the common user is granted the SET CONTAINER privilege for the PDB.
D. The command results in an error because the PDB can be shut down only by a local user.
Which three statements are true about the SQL*Loader utility? (Choose three.)
A. It can be used to load data from multiple external files into multiple tables.
B. It can be used to extract and reorganize data from external files, and then load it into a table.
C. It can be used to load data from external files using direct path only.
D. It can be used to create tables using data that is stored in external files.
E. It can be used to generate unique sequential values in specified columns while loading data.
While performing database backup to tape via the media manager interface, you notice that tape streaming is not happening because RMAN is not sending data blocks fast enough to the tape drive.
Which two actions would you take for tape streaming to happen during the backup? (Choose two.)
A. Configure backup optimization.
B. Configure the channel to increase maxopenfiles.
C. Configure a backup policy by using incremental backups.
D. Configure the channel to increase capacity with the rate parameter.
E. Configure the channel to adjust the tape buffer size by using the 3LKSIZE option.
F. Configure large_pool, if not done already. Alternatively, you can increase the size of large_pool.
Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2. RMAN is connected to the target database pdb2_1.
Examine the command executed to back up pdb2_1:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which statement is true about the execution of this command?
A. It fails because archive log files cannot be backed up using a connection to a PDB.
B. It succeeds but only the data files belonging to the pdb2_1 pluggable database are backed up.
C. It succeeds and all data files belonging to PD32_1 are backed up along with the archive log files.
D. It fails because the pluggable clause is missing.
View the Exhibit showing steps to create a database resource manager plan.
SQL>execute dbms_resource_manager.create_pendingarea();
PL/SQL procedure successfully completed.
SQL>exec dbms_resource_manager, create_consumergroup
(consumer_group=>'OLTP,,comment=>,onlineuser')
PL/SQL procedure successfully completed.
SQL>exec bras resource_manager.create plan(plan=>'PRIU3ER3',comment=>'dssprio');
SQL>exec
Dbms_resource_manager.create_plan_directive
(plan=>'PRIU3ER3',group_or_subplan=>'OLTP',comment=>'onlinegrp'CPU_Pl=>60);
PL/3QLproceduresuccessfullycompleted.
After executing the steps in the exhibit you execute this procedure, which results in an error:
SQL> EXECUTE dbms_resource_manager. validate_pending_area ();
What is the reason for the error?
A. The pending area is automatically submitted when creating plan directives.
B. The procedure must be executed before creating any plan directive.
C. The sys_group group is not included in the resource plan.
D. The other_groups group is not included in the resource plan.
E. Pending areas can not be validated until submitted.
One of your databases supports a data warehousing workload and is in NOARCHIVELOG mode. You perform RMAN level 0 backup on Sundays and level 1 incremental backups on other days.
One data file is corrupt and the current online redo log is missing due to media failure.
Which four actions must you take for recovery? (Choose four.)
A. Restore the missing data file.
B. Recover the database by using RECOVER DATABASE NOREDO;
C. Recover the database by using RECOVER DATABASE;
D. Restore the control file.
E. Open the database by using the RESETLOGS option.
F. Recover the corrupt file by using RECOVER DATAFILE.
G. Restore all data files.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-063 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.