web analytics

Premium PassLeader 1Z0-063 Dumps with VCE and PDF Download (Question 99 – Question 112)

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 99
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?

A.    It fails because archive log files cannot be backed up using a connection to a PDB.
B.    It succeeds but only the data files belonging to the pdb2_i pluggable database are backed up.
C.    It succeeds and all data files belonging to PD32_i are backed up along with the archive log files.
D.    It fails because the pluggable clause is missing.

Answer: C

QUESTION 100
Which two methods can be used to add an Oracle 11g database to a multitenant container database (CDB) as a pluggable database (PDB)?

A.    Use the d3MS_pdb package to plug the Oracle 11g database into the existing CDB as a PDB.
B.    Use the create database … enable pluggable database statement to create a PDB by copying data files from pd3Sseed and use data pump to load data from the Oracle 11g database into the newly created PDB.
C.    Pre-create a PDB in CDB and use data pump to load data from the complete database export of the Oracle 11g database into the newly created PDB.
D.    Pre-create a PDB in CDB and use the network_link and parallel parameters with data pump import to import data from the Oracle 11g database to the newly created PDB.
E.    Upgrade the Oracle 11g database to a 12c non-CDB and use the dbms_pdb.describe procedure to plug the database as a new PDB into the CDB.

Answer: BE

QUESTION 101
On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the command:
S>sqlldrhr/[email protected] table=employees
Which two statements are true about the command?

A.    It succeeds with default settings if the employees table exists in the hr schema.
B.    It fails because no SQL*Loader data file location is specified.
C.    It fails if the hr user does not have the create any directory privilege.
D.    It fails because no SQL*Loader control file location is specified.
E.    It succeeds and creates the employees table in the HR schema.

Answer: BD

QUESTION 102
Which two statements are true about scheduling operations in a pluggable database (PDB)?

A.    Scheduler jobs for a PDB can be defined only at the container database (CDB) level.
B.    A job defined in a PDB runs only if that PDB is open.
C.    Scheduler attribute setting is performed only at the CDB level.
D.    Scheduler objects created by users can be exported or imported using Data Pump.
E.    Scheduler jobs for a PDB can be created only by common users.

Answer: BD

QUESTION 103
What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?

A.    statistics recommendations
B.    SQL profile recommendations
C.    SQL statement restructure recommendations
D.    creation of materialized views to improve query performance

Answer: C

QUESTION 104
You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD. The default format of which two data types would be affected by this setting?

A.    DATE
B.    TIMESTAMP
C.    INTERVAL YEAR TO MONTH
D.    INTERVAL DAY TO SECOND
E.    TIMESTAMP WITH LOCAL TIME ZONE

Answer: BE

QUESTION 105
In your multitenant container database (CDB) that contains pluggable databases (PDBs), the hr user executes the following commands to create and grant privileges on a procedure:
CREATEORREPLACEPROCEDUREcreate_test_v(v_emp_idNUMBER,v_enameVARCHA R2,v_SALARYNUMBER,v_dept_idNUMBER)
BEGIN
INSERT INTO hr.test VALUES (v_emp_id, v_ename, v salary, v_dept_id); END;
/
GRANT EXECUTE ON CREATE_TEST TO John, jim, smith, king;
How can you prevent users having the execute privilege on the create_test_v procedure frominserting values into tables on which they do not have any privileges?

A.    Create the create_test procedure with definer’s rights.
B.    Grant the execute privilege to users with grant option on the create_test procedure.
C.    Create the create_test procedure with invoker’s rights.
D.    Create the create_test procedure as part of a package and grant users the execute privilege on the package.

Answer: C

QUESTION 106
The following parameters are set for your Oracle 12c database instance:
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE
OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE
You want to manage the SQL plan evolution task manually. Examine the following steps:
1. Setthe evolve task parameters.
2. Create the evolve task by using the DBMS_SPM.CREATE_EVOVLE_TASK function.
3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.
4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.
5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.
Identify the correct sequence of steps.

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

Answer: B

QUESTION 107
In the SPFILE, UNDOJTABLESPACEis Set to UNDOTBS. You rename the undotbs undo tablespace:
ALTER TABLESPACE undotbs RENAME TO undotbs_old;
Which statement is true?

A.    The tablespace will be renamed but the data file headers will not be updated.
B.    The statement will fail because you cannot rename an undo tablespace.
C.    The tablespace will be renamed and all the changes will be logged in the alert log.
D.    The tablespace will be renamed and a message written to the alert log indicating that you should change the corresponding initialization parameter.
E.    You must set the undo_tablespace parameter to some other tablespace name before renaming undotbs.

Answer: C

QUESTION 108
You are administering a database that supports a data warehousing workload and is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 incremental backups on all the other days of the week. One of the data files is corrupted and the current online redo log file is lost because of a media failure. Which action must you take for recovery?

A.    Restore the data file, recover it by using the recover datafile noredo command, and use the resetlogs option to open the database.
B.    Restore the control file and all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.
C.    Restore all the data files, recover them by using the recover database command, and open the database.
D.    Restore all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.

Answer: B

QUESTION 109
Your database is running in archivelog mode. You are taking a backup of your database by using RMAN with a recovery catalog. Because of a media failure, one of the data files and all the control files are lost. Examine the steps to recover the database:
1. Restore the control filesby using the RMAN restore controlfile command.
2. Mount the database.
3. Restore the data files by using the RMAN restore database command.
4. Open the database with the resetlogs option.
5. Recover the data files by using the RMAN recover using backup controlfile command.
6. Start the database instance in nomount state.
7. Connect to the target database by using a recovery catalog.
8. Open the database.
9. Restore the data file.
10. Recover the data file.
Identify the required steps in the correct order.

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

Answer: D

QUESTION 110
You want RMAN to make duplicate copies of data files when using the backup command. What must you set using the RMAN configure command to achieve this?

A.    MAXSETSIZE TO 2;
B.    DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
C.    CHANNEL DEVICE TYPE DISK FORMAT ‘/disk1/%U’ , ‘/disk2/%U’;
D.    DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;

Answer: D

QUESTION 111
Your database is running in archivelog mode. Examine the parameters for your database instance:
LOG_ARCHIVE_DEST_l =’LOCATION=/disk1/arch MANDATORY’
LOG_ARCHIVE_DEST_2 =’LOCATION=/disk2/arch’
LOG_ARCHIVE_DEST_3 =’LOCATIO=/disk3/arch’
LOG_ARCHIVE_DEST _4 =’LOCATIONs/disk4/arch’
LOG_ARCHIVE _MIN_SUCCEED_DEST = 2
While the database is open, you notice that the destination set by the log_archive_dest_1 parameter is not available. All redo log groups have been used. What happens at the next log switch?

A.    The database instance hangs and the redo logfiles are not overwritten.
B.    The archived redo log files are written to the fast recovery area until the mandatory destination is made available.
C.    The database instance is shutdown immediately.
D.    The destination set by the log_archive_dest parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.

Answer: D

QUESTION 112
Users report this error message when inserting rows into the orders table:
ERROR atline1:
ORA-01654f:unable to extend index USERS.ORDERS_IND by 8in tablespace INDEXES
You determine that the indexes tablespace is out of space and there is no free space on the filesystem used by the Oracle database. Which two must you do to fix this problem without affecting currently executing queries?

A.    drop and re-create the index
B.    coalesce the orders.ind index
C.    coalesce the indexes tablespace
D.    perform an on line table rebuild using dbns_redefir.ition
E.    rebuild the index online moving it to another tablespace that has enough free space for the index

Answer: AC


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