web analytics

Valid 1Z0-063 Dumps with VCE and PDF for Free (Question 15 – Question 28)

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 15
Examine the RMAN command:
RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which prerequisite must be met before accomplishing the backup?

A.    The password for the encryption must be set up.
B.    Oracle wallet for the encryption must be set up.
C.    All the tablespaces in the database must be encrypted.
D.    Oracle Database Vault must be enabled.

Answer: B

QUESTION 16
Examine the RMAN commands executed in your database:
RMAN>CONFIGUREDEFAULT DEVICE TYPE TO disk;
RMAN>CONFIGURE DEVICETYPE DISK BACKUP TYPE TO BACKUPSET; RKAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
You issue the command:
RMAN> BACKUP DATABASE;
Which two statements are true about the command?

A.    It performs a log switch.
B.    It creates compressed backup sets by using binary compression by default.
C.    It backs up only the used blocks in data files.
D.    It backs up data files, the control file, and the server parameter file.
E.    It creates a backup of only the control file whenever the database undergoes a structural change.

Answer: BE

QUESTION 17
Which two statements describe the relationship between a window, a resource plan, and a job class?

A.    A window specifies a resource plan that will be activated when that window becomes active.
B.    A window specifies a job class that will be activated when that window becomes active.
C.    A job class specifies a window that will be open when that job class becomes active.
D.    A window in association with a resource plan controls a job class allocation.
E.    A window in association with a job class controls a resource allocation.

Answer: AD

QUESTION 18
In which situation can you use Flashback Database?

A.    when undoing a shrink data file operation
B.    when retrieving a dropped tablespace
C.    when returning to a point in time before the restoration or re-creation of a control file
D.    when returning to a point in time before the most recent open resetlogs operation

Answer: B

QUESTION 19
Examine the commands executed to monitor database operations:
$> conn sys/[email protected] as sysdba
SQL> VAR eid NUMBER
SQL>EXEC :eid :=
DBMS_SQL_MONITOR.BEGlN_OPERATION(‘batch_job’,FORCED_TRACKING=>’Y’);
Which two statements are true?

A.    Database operations will be monitored only when they consume a significant amount of resource.
B.    Database operations for all sessions will be monitored.
C.    Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.
D.    Only DML and DDL statements will be monitored for the session.
E.    All subsequent statements in the session will be treated as one database operation and will be monitored.

Answer: CE

QUESTION 20
Examine the command to duplicate a database:
RMAN> DUPLICATE TARGET DATABASE TO cdb
PLUGGABLE DATABASE pdb1, pdb5;
Which two statements are true about the DUPLICATE command?

A.    The SPFILE is copied along with the datafiles of the pluggable databases (PDBs). The root and the seed database in the container database (CDB) are also duplicated.
B.    A backup of pdbi and pd35 must exist before executing the command.
C.    The duplicate command first creates a backup, and then duplicates the PDBs by using the backup.
D.    An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.

Answer: CD

QUESTION 21
You create a default Flashback Data Archive FLA1and enable it for the EMPLOYEES table in the HR schema. After a few days, you want to alter the EMPLOYEES table by executing the command:
SQL> ALTER TABLE EMPLOYEES ADD PHONE NUMBER(12);
Which statement is true about the execution of the command?

A.    It gives an error because DDL statements cannot be executed on a table that is enabled for Flashback Data Archive.
B.    It executes successfully and all metadata related to the EMPLOYEES table before altering the table definition is purged from Flashback Data Archive.
C.    It executes successfully and continues to store metadata related to the EMPLOYEES table.
D.    It executes successfully but Flashback Data Archive is disabled for the EMPLOYEES table.

Answer: C

QUESTION 22
Your database is running in archivelog mode and regular nightly backups are taken. Due to a media failure, the current online redo log group, which has one member, is lost and the instance is aborted. Examine the steps to recover the online redo log group and move it to a new location.
1. Restore the corrupted redo log group.
2. Restore the database from the most recent database backup.
3. Perform an incomplete recovery.
4. Relocatethe member of the damaged online redo log group to a new location.
5. Open the database with the resetlogs option.
6. Issue a checkpoint and clear the log.
Identify the required steps in the correct order.

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

Answer: C

QUESTION 23
You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux. You have set the db_smart_flash_file parameter:
DB_FLASH_CACHE_FILE= ` /dev/f lash_device_1`,` /dev/f lash_device_2`
How should the D3_flash_cache_size be configured to use both devices?

A.    Set DB_FLASH_CACHE_SIZE=64G.
B.    Set D3_FLASH_CACHE_SIZE=64G, 64G.
C.    Set D3_FLASK_CACKE_SI2E=128G.
D.    db_flash_cache_SI2E is automatically configured by the instance at startup.

Answer: B

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

A.    The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used
B.    Setting the target tablespace to read-only after the segments are moved
C.    The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds T3Spercent used
D.    Taking the target tablespace offline after the segments are moved
E.    The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used

Answer: BC

QUESTION 25
LDAP_DIRECTORY_SYSAUTH is set to YES. Users requiring DBAs access have been granted the sysdba enterprise role in Oracle Internet Directory(OID). SSL has been configure for the database and OLD and the password file has been configured for the database. User scott with sysdba privilege tries to connect remotely using this command:
$sqlplusscott/[email protected]
As sysdba where DB01 is the net service name.
Which authentication method will be attempted first?

A.    authentication by password file
B.    authentication by using certificates over SSL
C.    authentication by using the Oracle Internet Directory
D.    authentication by using the local OS of the database server

Answer: A

QUESTION 26
Which two statements are true about Flashback Version Query?

A.    The result of a query can be used as part of a DML statement.
B.    It can be used to create views.
C.    It can be used only if Flashback Data Archive is enabled for a table.
D.    It retrieves all versions of rows that exist in a time interval, including the start time and end time.
E.    It can be used to retrieve the SQL that is required to undo a row change and the user responsible for the change.

Answer: AC

QUESTION 27
Which three requirements must be met before a tablespace can be transported across different platforms?

A.    Both the source and target databases must use the same character set.
B.    The platforms of both the source and target databases must have the same endian format.
C.    The compatible parameter value must be the same in the source and target databases.
D.    The minimum compatibility level for both the source and target databases must be 10.0.0.
E.    The tablespace to be transported must be in read-only mode.

Answer: BCD

QUESTION 28
Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?

A.    Reduced logical I/O
B.    Reduced virtual memory utilization
C.    Improved Serial Execution performance
D.    Reduced physical I/O
E.    Reduced CPU utilization

Answer: BE


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