1Z0-063 PDF DOWNLOAD

How to use our free PDF

Our Free PDF is based on the full mock exams which is available on our Web Site. The PDF consists in an extract of questions and answers with detailed explanations that are available to be:

On-Line Users: {{voteInfo.result.viewUsers}}
Subscribed Users: {{voteInfo.result.subscribedUsers}}
Thank you for your vote {{voteInfo.result.stars}} Your vote has already been submitted ({{voteInfo.result.votingPeople}} votes)

Follow us on SlideShare to see the latest available 1Z0-063 tests pdf.

Watch us also on Vimeo: See how our 1Z0-063 tests works.

									
										
										Q1.Which two statements are true about recovering logically corrupted tables or table partitions from
an RMAN backup?
A. Tables or table partitions can be recovered by using an auxiliary instance only.
B. Tables or table partitions with a foreign key cannot be recovered.
C. Tables or table partitions can be recovered only when the database is in mount state.
D. Tables or table partitions from the system and sysauxtablespaces cannot be recovered.
E. Tables with not null constraints cannot be recovered.
Option A,D are correct.
Explanation:Explanation not provided for the free version. To know more contact: www.certificationquestions.com
Reference:http://docs.oracle.com/database/121/BRADV/rcmresind.htm#BRADV695(Limitat ions of Recovering
Tablesand Table Partitions from RMAN Backups)


Q2. 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. a hash cluster
B. an index cluster
C. a partitioned table
D. a sorted hash cluster
E. a heap table with a rowid column
Option B ic correct.
Explanation:Explanation not provided for the free version. To know more contact: www.certificationquestions.com


Q3. 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##role1role 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 andall the PDBs.
https://www.certification-questions.com/
D. It fails and reports an error because the comtainer=current clause is not used.
Option C is correct.
Explanation:For this free product demo we don't provide explanation. To know more contact:
info@certification-questions.com


Q4. Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs).
In the PDB hr_pdb, the common user c##admin and the local user b_admin have only the connect
privilege.
You create a common role c##role1 with the create table and select any table privileges.
You then execute the commands:
SQL> GRANTc##role1 TOcMadmin CONTAINER=ALL;
SQL>CONNsys/oracle@HR_PDB assysdba
SQL> GRANTc##role1TO b_admin CONTAINER=CURRENT;
Which two statements are true?
A. C##admin can create and select any table, and grant the c##role1 role to users only in the root
container.
B. B_admin can create and select any table in both the root container and kr_pdb.
C. c##admin can create and select any table in the root container and all the PDBs.
D. B_admin can create and select any table only in hr_pdb.
E. The grant c=.role1 to b_admin command returns an error because container shouldbe set to ALL.
Optiom C,D are correct.
Explanation:For this free product demo we don't provide explanation. To know more contact:
info@certification-questions.com


Q5. Examine the following set of RMAN commands:
RKAN> CONFIGURE CHANNEL del DEVICE TYPE DISK FORMAT ' /u02/backup/%U' ;
RKAN> RUN
{
ALLOCATE CHANNEL chl DEVICE TYPE DISK;
EXECUTE SCRIPT arc_backup;
}
Which statement is true about the RMAN run block execution?
A. The script is executed and both DC1 and chi channels are used for script execution.
B. The execution of the script fails because multiple channels cannot exist simultaneously.
C. The persistent configuration parameter, DC1, is overridden because a new channel is allocated in
the RMAN run block.
D. The new channel, chi, is ignored because a channel has been configured already.
Option C is correct.
Explanation:For this free product demo we don't provide explanation. To know more contact:
info@certification-questions.com


Q6. Examine the RMAN command:
RMAN> BACKUP VALIDATE DATABASE;
Which statement is true about the execution of the command?
A. Block change tracking must be enabled before executing this command.
B. The database must be running in archivelog mode for the successful execution of this command.
C. A complete database backup must exist before executing this command.
D. The command checks for blocks containing all zeros, an invalid checksum, or a corrupt block
header.
E. The command checks for blocks that contain a valid checksum and matching headers and footers, but
that has logically inconsistentcontents.
Option D is correct.
Explanation:For this free product demo we don't provide explanation. To know more contact:
info@certification-questions.com
https://www.certification-questions.com/


Q7. For your database, an incremental level 1 backup is taken every week day. On Tuesday, before the
backup is performed, you add a new tablespace.
You execute the command:
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY DATABASE;
Which statement is true about the execution of the command?
A. It returns an error because there isno level 0 backup available for new data files.
B. It performs an image copy backup of new data files, and a level 1 incremental backup of all other
data files.
C. It performs a level-0 backup of all data files including those that belong to the new tablespace.
D. It performs an image copy backup of all data files including those that belong to the new
tablespace.
E. It performs a backup as a backup set of all data files including those that belong to the new
tablespace.
Option B is correct.
Explanation:For this free product demo we don't provide explanation. To know more contact:
info@certification-questions.com
Reference:http://www.oracle-base.com/articles/misc/incrementally-updated-image-copy-backups.php
https://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup004.htm



Q8. 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
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 and all archive log files are deleted.
B. All data files belonging to pdb2_1 are backed up along with the archive log files.
C. Only the data files belonging to pdb2_ are backed up.
D. This command gives an error because archive log files can be backed up only when RMAN is connected
to the root database.
Option B is correct.
Explanation:For this free product demo we don't provide explanation. To know more contact:
info@certification-questions.com


Q9. Which two statements are true about the Automatic Diagnostic Repository (ADR)?
A. The ADR base is shared across multiple instances.
B. The ADR base keeps all diagnostic information in binary format.
C. The ADR can be used to store statspack snapshots to diagnose database performance issues.
D. The ADR can be used for problem diagnosis even when the database instance is down.
E. The ADR is used to store Automatic Workload Repository (AWR) snapshots.
Option C,D are correct.
Explanation:For this free product demo we don't provide explanation. To know more contact:
info@certification-questions.com


Q10. 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.
B. The PDB is placed in mount 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.
Option A is correct.
Explanation:For this free product demo we don't provide explanation. To know more contact:
info@certification-questions.com
https://www.certification-questions.com/
Reference:http://docs.oracle.com/database/121/ADMIN/cdb_pdb_admin.htm#ADMIN13652