web analytics

Update 1Z0-063 Dumps with VCE and PDF for Free (Question 43 – Question 56)

PassLeader now are offering 100% pass ensure 1Z0-063 dumps! All 1Z0-063 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-063 VCE dumps and PDF dumps: http://www.passleader.com/1z0-063.html (180 Q&As –> 236 Q&As)

BTW: Download PassLeader 1Z0-063 dumps from Google Drive for free: https://drive.google.com/open?id=0B-ob6L_QjGLpUjhWdDA4ZmNlLTg

QUESTION 43
Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)?

A.    Database Resident Connection Pooling
B.    Oracle Suggested Backup Strategy
C.    Database Vault in ORACLE_HOME
D.    Non default block size tablespaces
E.    Configure Label Security

Answer: DE

QUESTION 44
Which three statements are true about Consolidated Database Replay?

A.    The workload capture and replay systems must have the same operating system (OS).
B.    Multiple workload captures from multiple databases can be replayed simultaneously on all pluggable databases (PDBs) in a multitenant container database (CDB).
C.    A subset of the captured workload can be replayed.
D.    The number of captured workloads must be the same as the number of PDBs in a multitenant CDB.
E.    Multiple replay schedules can be defined for a consolidated replay and during replay initialization, you can select from any of the existing replay schedules.

Answer: BCE

QUESTION 45
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?

A.    Configure backup optimization.
B.    Configure the channel to increase max openfiles.
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.

Answer: BE

QUESTION 46
Which three statements are true about the keystore storage framework for transparent data encryption?

A.    It facilitates and helps to enforce keystore backup requirements.
B.    It handles encrypted data without modifying applications.
C.    It enables a keystore to be stored only in a file on a file system.
D.    It enables separation of duties between the database administrator and the security administrator.
E.    It transparently decrypts data for the database users and applications that access this data.
F.    It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations.

Answer: ADF

QUESTION 47
Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)?

A.    The PDB is closed and the temp file is re-created automatically when the PDB is opened.
B.    The PDB is closed and requires media recovery at the PDB level.
C.    The PDB does not close and the temp file is re-created automatically whenever the container database (CDB) is opened.
D.    The PDB does not close and starts by using the default temporary tablespace defined for the CDB.

Answer: A

QUESTION 48
Which three types of failures are detected by the Data Recovery Advisor (DRA)?

A.    loss of a non-critical data file
B.    loss of a control file
C.    physical data block corruption
D.    logical data block corruption
E.    loss of an archived redo log file

Answer: ABC

QUESTION 49
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 orc1123;
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?

A.    It can create only local users in all the PDBs.
B.    It has a common schema for all the PDBs.
C.    It can create common users only when it is logged in to the CDB.
D.    It can create only local users in the CDB.
E.    It can be granted only common roles in the PDBs.

Answer: AB

QUESTION 50
Which two statements are true about a common user?

A.    A common user connected to a pluggable database (PDB) can exercise privileges across other PDBs.
B.    A common user with the create user privilege can create other common users, as well as local users.
C.    A common user can be granted only a common role.
D.    A common user can have a local schema in a PDB.
E.    A common user always uses the global temporary tablespace that is defined at the CDB level as the default temporary tablespace.

Answer: CD

QUESTION 51
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 sysaux tablespaces cannot be recovered.
E.    Tables with not null constraints cannot be recovered.

Answer: AD

QUESTION 52
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

Answer: B

QUESTION 53
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 and all the PDBs.
D.    It fails and reports an error because the comtainer=current clause is not used.

Answer: C

QUESTION 54
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/[email protected]_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 should be set to ALL.

Answer: CD

QUESTION 55
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.

Answer: C

QUESTION 56
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 inconsistent contents.

Answer: D


PassLeader now are offering 100% pass ensure 1Z0-063 dumps! All 1Z0-063 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-063 VCE dumps and PDF dumps: http://www.passleader.com/1z0-063.html (180 Q&As –> 236 Q&As)

BTW: Download PassLeader 1Z0-063 dumps from Google Drive for free: https://drive.google.com/open?id=0B-ob6L_QjGLpUjhWdDA4ZmNlLTg