100% Free 1z0-063 Files For passing the exam Quickly UPDATED Aug 15, 2022 [Q128-Q152]

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

NEW QUESTION 129
The environmental variable oracle_Base is set to /u01/app/oracleand oracle_home is set to /u01/app/oracle/product/12.1.0/db 1.
You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR). Examine the initialization parameters set in your database.
NAMETYPEVALUE
audit_file_deststring/u01/app/oracle/admin/eml2rep/adump
background_dump_deststring
core_dump_deststring
db_create_file_deststring
db_recovery_file_deststring/u01/app/oracle/fast_recovery_area
diagnostic_deststring
What is the location of the ADR base?

NEW QUESTION 130
In your database, the tbs percent used parameter is set to 60 and the tbs percent free parameter is set to 20.
Which two storage-tiering actions might be automated when using Information Lifecycle Management (ILM) to automate data movement?

NEW QUESTION 131
Which three RMAN persistent settings can be set for a database?

NEW QUESTION 132
You create a table with the period for clause to enable the use of the Temporal Validity feature of Oracle
Database 12c.
Examine the table definition:
create table employees
( empno number, salary number,
deptid number, name varchar2(100),
period for employee_time);
Which three statements are true concerning the use of the Valid Time Temporal feature for the
EMPLOYEES table? (Choose three.)

NEW QUESTION 133
In your database, there are tablespaces that were read-only when thelast backup was taken. These tablespaces have not been made read/write since then. You want to perform an incomplete recovery on the database by using a backup control file.
What precaution must you take for the read-only tablespaces before performing anincomplete recovery?

NEW QUESTION 134
RMAN is connected to the target database prod1 and an auxiliary instance in nomount state. Examine the command to create a duplicate database:

Which two statements are true about the execution of the duplicate command? (Choose two.)

NEW QUESTION 135
You accidentally drop the CUSTOMERStable, and then recover it by using the FLASHBACK TABLE command.
Which two statements are true about the dependent objects of the CUSTOMERS table? (Choose two.)

NEW QUESTION 136
Which statement is true about the ALTER SESSION SET CONTAINER command to switch between containers?

NEW QUESTION 137
Which two operations are NOT performed by the DUPLICATE command in RMAN while duplicating a database that is open? (Choose two.)

NEW QUESTION 138
You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference.
Which method or feature should you use?

NEW QUESTION 139
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?

NEW QUESTION 140
Your database is running on the host OUSERVER. You back up your database regularly using RMAN and the backups are cataloged in a recovery catalog. For testing purposes, you want to replicate your database to another host, OUSERVER1, with the same directory structure. So, you copy the backups to the new host.
What must you do to make the database operational in OUSERVER1?

NEW QUESTION 141
For which two requirements would you use the Database Resource Manager?

NEW QUESTION 142
Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?

NEW QUESTION 143
Which two statements are true about encrypted backups performed by using RMAN?

NEW QUESTION 144
You create a table with the period for clause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition:
create table employees
( empno number, salary number,
deptid number, name varchar2(100),
period for employee_time);
Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

NEW QUESTION 145
Examine the command:

Which statement is true about the execution of the command?

NEW QUESTION 146
Which three statements are true about Oracle Restart?

NEW QUESTION 147
You regularly take backups of your database using RMAN with a recovery catalog. Your database is currently open and the temp01.dbftemp file belonging to the TEMPtablespace is corrupted.
Identify two methods to recover the temp file with the least disruption to database availability. (Choose two.)

NEW QUESTION 148
Which three statements are true about the SQL*Loader utility?

NEW QUESTION 149
Which two statements are true regarding SecureFile lobs? (Choose two.)

NEW QUESTION 150
You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:
$ . oraenv ORACLE_SID = [oracle] ? cdb1 The oraclebasefor ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 is
/u01/app/oracle $ rman target / Recovery Manager : Release 12.1.0.0.2 – production on Fri Ju1 19 05:18:33: 2013
Coppyright (c) 1982, 2013, oracle and/or its affiliates. All rights reserved.
Connected to target database:CDB1 (DBID=782249327)
RMAN>SELECT name FROMv$tablespace;
Which statement is true about the execution of the last command?

NEW QUESTION 151
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?

NEW QUESTION 152
You plan to duplicate the multitenant container database (CDB) cdb1that contains the pluggable
database (PDB) SALES:

Which two statements are true? (Choose two.)