web analytics

100% Pass Ensure 1Z0-063 Dumps with Free VCE and PDF (Question 29 – Question 42)

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 29
Identify three scenarios in which RMAN will use backup sets to perform active database duplication.

A.    when the duplicate … from active database command contains the section size clause
B.    when you perform active database duplication on a database with flashback disabled
C.    when you specify set encryption before the duplicate … from active database command
D.    when the number of auxiliary channels allocated is equal to or greater than the number of target channels
E.    when you perform active database duplication on a database that has read-only tablespaces

Answer: ACD

QUESTION 30
Which two statements are true when row-archival management is enabled?

A.    Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter.
B.    The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered active.
C.    The row archival visibility session parameter defaults to all rows.
D.    The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.
E.    The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer considered active.

Answer: BD

QUESTION 31
You have a production Oracle 12c database running on a host. You want toinstall and create databases across multiple new machines that do not have any Oracle database software installed. You also want the new databases to have the same directory structure and components as your existing 12c database. The steps in random order:
1. Create directory structures similar to the production database on all new machines.
2. Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database.
3. Create a database clone template for the database.
4. Run the Database Configuration Assistant (DBCA) to create the database.
5. Run OUI in graphical mode on each machine.
6. Run OUI in silent mode using the OUI response file.
Identify the required steps in the correct sequence to achieve the requirementwith minimal human intervention.

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

Answer: D

QUESTION 32
Your database has a table customers that contains the columns cust_name, amt_due, and old_status. Examine the commands executed and their output:
SQL>UPDATEcustomersSETamt_due=amt_due+amt_due*l. 1WHEREcust_name=’JAMES’; 1row updated.
SQL> ALTER TABLE customers DROP COLUMN old_status;
Table Altered
SQL> UPDATE customers SET amt_due=amt_due+amt_due*1.5 WHERE cust_r.ame=’JAMES’; 1 row updated.
SQL> COMMIT;
SQL> SELECT versions_xid AS XID, versior.s_startscr. AS START_SCN, versions_er.cscn AS END_SCN, versior.s_operatior. AS OPERATION’, amt_due
FROM customers VERSIONS BETWEEN SCN MINVALULEAND MAXVALUE WHERE custname=’JAMES’;.
XIDSTART_SCNEND_SCNOPERATIONAMT_DUE
07002f00cl03000017063371706337 U3300
Why is it that only one update is listed by the Flashback Version Query?

A.    Supplemental logging is not enabled for the database.
B.    The undo data that existed for versions of rows before the change to the table structure is invalidated.
C.    The db_flash3ACK_reteni:on_target parameter is set toa lower value and the undo data pertaining to the first transaction is flushed out.
D.    Undo retention guarantee is not enabled.
E.    Flashback Data Archive is full after the first update statement.

Answer: C

QUESTION 33
Examine the initialization parameter that is set in the PFILE:
DB_CREATE_FILE_DEST =’/u01/app/oracle/oradata/’
You execute the following command to create theCDB1. container database (CDB):
SQL>CREATEDATABASECDB1
DEFAULTTABLESPACE users
DEFAULTTEMPORARY TABLESPACEtemp
UNDO TABLESPACEundotbsl
ENABLEPLUGGA3LEDATABASE
SEED
SYSTEMDATAFILESSIZE125M AUTOEXTEND ON NEXT10M MAXSIZEUNLIMITED SYSAUXDATAFILESSIZE100M;
Which three statements are true?

A.    It creates a multitenant container database with a root and a seed pluggable database (PDB) that are opened in read-write and read-only modes, respectively.
B.    The files created for both the root and seed databases use Oracle Managed Files (OMF).
C.    It creates a multitenant container database with the root and seed databases opened and one PDB mounted.
D.    It sets the users tablespace as the default for both the root and seed databases.
E.    undotbs1 is used as the undo tablespace for both the root and seed databases.
F.    It creates a multitenant container database with the root database opened and the seed database mounted.

Answer: ABE

QUESTION 34
When is the UNDO_RETENTION parameter value ignored by a transaction?

A.    when the data file of the undo tablespace is autoextensible
B.    when there are multiple undotablespaces available in a database
C.    when the undo tablespace is of a fixed size and retention guarantee is not enabled
D.    when Flashback Database is enabled

Answer: C

QUESTION 35
Which two statements are true about service creation for pluggable databases (PDBs)?

A.    When a PDB is created, a service is automatically started in the instance with the same name as the PDB.
B.    The default service that is automatically created by a database at the time of PDB creation can be dropped, provided a new additional service is created.
C.    A database managed by Oracle Restart can have additional services created or existing services modified by using the srvctl utility for each PDB.
D.    Only a common user can create additional services for a PDB.
E.    When a PDB is created, a service with the same name as the PDB is created in the PDB.

Answer: CD

QUESTION 36
You want to capture column group usage and gather extended statistics for better cardinality estimates for the customers table in the SH schema. Examine the following steps:
1. Issue the SELECTDBMS_STATS. CREATE_EXTENDED_STATS(‘SH’ ‘CUSTOMERS’)
From dual statement.
2. Execute the dbms_stats.seed_col_usage (null, ‘SH’ 500) procedure.
3. Execute the required queries on the customers table.
4. Issue the select dbms_stats.reportwcol_usage(‘SH’ ‘customers’) from dual statement.
Identify the correct sequence of steps.

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

Answer: B

QUESTION 37
Examine the steps/operations performed during the RMAN backup operation by using Oracle Secure Backup (OSB):
1. Start the RMAN client by using the RMAN target / command.
2. Start the RMANclient by using the OSB user.
3. RMAN creates the backup pieces.
4. Run the RMAN backup command with the sbt channels.
5. OSB creates a backup job and assigns a unique identifier.
6. OSB creates a backup job request through the OSB sbt library.
7. OSB stores metadata about RMAN backup pieces in the OSB catalog.
8. OSB starts the backup operation.
9. OSB updates the RMAN catalog.
Identify the required steps/operations performed in correct order.

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

Answer: C

QUESTION 38
The environmental variable oracle_Base is set to /u01/app/oracle and 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?

A.    It is set to/u01/app/oracle/product:/12.1.0/db_1/log.
B.    It is set to /u01/app/oracle/admin/enl2r&p/adump.
C.    It is set to /u01/app/oracle.
D.    It is set to/u01/app/oracle/flash_recovery_area.

Answer: A

QUESTION 39
Examine the steps to configure Oracle Secure Backup (OSB) for use with RMAN:
1. Create media families for data files and archived redo log files.
2. Configure database backup storage selectors or RMAN media management parameters.
3. Create an OSB user preauthorized for RMAN operations.
4. Configure RMAN Access to the OSB SBT.
5. Disable Non-Uniform Memory Access (NUMA) awareness by setting the ob_ignore_numa parameter to 0.
Identify the steps in the correct order.

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

Answer: C

QUESTION 40
You set the following parameters in the parameter file and restart the database instance:
NEMORY_MAX_TARGET=0
MEMORY__TARGET=500M
PGA_AGGREGATE_TARGET=90M
SGA_TARGET=270M
Which two statements are true?

A.    The memory_max_target parameter is automatically set to 500 MB.
B.    The pga_aggregate_target and sga_target parameters are automatically set to zero.
C.    The value of the memory_max_target parameter remains zero for the database instance.
D.    The lower limits of the pga_aggregate_target and sga_target parameters are set to 90 MB and 270 MB respectively.
E.    The instance does not start up because Automatic Memory Management (AMM) is enabled but pga_aggregate_target and sga_target parameters are set to nonzero values.

Answer: CE

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

A.    limiting the CPU used per database call
B.    specifying the maximum number of concurrent sessions allowed for a user
C.    specifying the amount of private space a session can allocate in the shared pool of the SGA
D.    limiting the degree of parallelism of operations performed by a user or group of users
E.    specifying an idle time limit that applies to sessions that are idle and blocking other sessions

Answer: BE

QUESTION 42
You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privileges. The statistics_level parameter isPDB modifiable. As the user sys, execute the following command on pdb2:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID=’*’ SCOPE=SPFILE;
Which statement is true about the result of this command?

A.    The statistics_level parameter is set to all when anyof the PDBs is reopened.
B.    The statistics_level parameter is set to all only for PDB2 when it is reopened.
C.    The statistics_level parameter is set to all when the root database is restarted.
D.    The statement is ignored because there is no SPFILE for a PDB.

Answer: B


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