We ensures to provide the most update 1Z0-063 new questions with the most accurate answers. We Oracle Database Application Development {keywords} are the most complete and authoritative 1Z0-063 braindumps with which one can pass the Oracle Database Application Development Newest 1Z0-063 pdf exam in an easy way. Preparing for Oracle Database Application Development Apr 24,2022 Latest 1Z0-063 pdf dumps Oracle Database 12c: Advanced Administration exam is really a tough task to accomplish. But We will simplified the process.

We Geekcert has our own expert team. They selected and published the latest 1Z0-063 preparation materials from Official Exam-Center.

The following are the 1Z0-063 free dumps. Go through and check the validity and accuracy of our 1Z0-063 dumps.We have sample questions for 1Z0-063 free dumps. You can download and check the real questions of updated 1Z0-063 dumps.

Question 1:

A complete database backup to media is taken for your database every day. Which three actions would you take to improve backup performance? (Choose three.)

A. Set the backup_tape_io_slaves parameter to true.

B. Set the dbwr_io_slaves parameter to a nonzero value if synchronous I/O is in use.

C. Configure large pool if not already done.

D. Remove the rate parameter, if specified, in the allocate channel command.

E. Always use RMAN compression for tape backups rather than the compression provided by media manager.

F. Always use synchronous I/O for the database.

Correct Answer: BCD

Reference: http://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmtunin.htm


Question 2:

You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference.

Which method or feature should you use?

A. Database Replay

B. Automatic Database Diagnostic Monitor (ADDM) Compare Period report

C. Active Session History (ASH) report

D. SQL Performance Analyzer

Correct Answer: B

Reference: http://docs.oracle.com/cd/E24628_01/server.121/e17635/tdppt_degrade.htm


Question 3:

Examine the command:

SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;

In which two scenarios is this command required? (Choose two.)

A. The current online redo log file is missing.

B. A data file belonging to a noncritical tablespace is missing.

C. All the control files are missing.

D. The control file backup is older than the database backup.

E. All the data files are missing.

Correct Answer: CD

Reference: http://searchoracle.techtarget.com/answer/Recover-database-using-backup-controlfile-until-cancel


Question 4:

Which two are prerequisites for setting up Flashback Data Archive? (Choose two.)

A. Fast Recovery Area should be defined.

B. Undo retention guarantee should be enabled.

C. Supplemental logging should be enabled.

D. Automatic Undo Management should be enabled.

E. All users using Flashback Data Archive should have unlimited quota on the Flashback Data Archive tablespace.

F. The tablespace in which the Flashback Data Archive is created should have Automatic Segment Space Management (ASSM) enabled.

Correct Answer: DF

Reference: http://www.oracle.com/technetwork/database/focus-areas/storage/total-recall-whitepaper-171749.pdf (page 8)


Question 5:

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.

NAME TYPE VALUE

audit_file_dest string /u01/app/oracle/admin/eml2rep/adump background_dump_dest string core_dump_dest string db_create_file_dest string db_recovery_file_dest string /u01/app/oracle/fast_recovery_area diagnostic_dest string

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/enl2randp/adump.

C. It is set to /u01/app/oracle.

D. It is set to /u01/app/oracle/flash_recovery_area.

Correct Answer: C

http://docs.oracle.com/cd/B28359_01/server.111/b28310/diag001.htm#ADMIN11008

The Automatic Diagnostic Repository (ADR) is a directory structure that is stored outside of the database. It is therefore available for problem diagnosis when the database is down. The ADR root directory is known as ADR base. Its location is

set by the DIAGNOSTIC_DEST initialization parameter. If this parameter is omitted or left null, the database sets DIAGNOSTIC_DEST upon startup as follows:

If environment variable ORACLE_BASE is set, DIAGNOSTIC_DEST is set to the directory designated by ORACLE_BASE.

If environment variable ORACLE_BASE is not set, DIAGNOSTIC_DEST is set to ORACLE_HOME/log.


Question 6:

You wish to create jobs to satisfy these requirements:

1.

Automatically bulk load data from a flat file.

2.

Rebuild indexes on the SALES table after completion of the bulk load.

How would you create these jobs?

A. Create both jobs by using Scheduler raised events.

B. Create both jobs using application raised events.

C. Create one job to rebuild indexes using application raised events and another job to perform bulk load using Scheduler raised events.

D. Create one job to rebuild indexes using Scheduler raised events and another job to perform bulk load by using events raised by the application.

Correct Answer: C


Question 7:

A database is running in archivelog mode. The database contains locally managed tablespaces. Examine the RMAN command:

RMAN> BACKUP AS COMPRESSED BACKUPSET SECTION SIZE 1024M DATABASE;

Which statement is true about the execution of the command?

A. The backup succeeds only if all the tablespaces are locally managed.

B. The backup succeeds only if the RMAN default device for backup is set to disk.

C. The backup fails because you cannot specify section size for a compressed backup.

D. The backup succeeds and only the used blocks are backed up with a maximum backup piece size of 1024 MB.

Correct Answer: D


Question 8:

Which two statements are true when row-archival management is enabled? (Choose two.)

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.

Correct Answer: BD


Question 9:

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 CDB1 container database (CDB):

SQL>CREATE DATABASE CDB1 DEFAULT TABLESPACE users DEFAULT TEMPORARY TABLESPACE temp UNDO TABLESPACE Undotbsl ENABLE PLUGGABLE DATABASE SEED SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED SYSAUX DATAFILES SIZE 100M;

Which three statements are true? (Choose three.)

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.

Correct Answer: ABE


Question 10:

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. Set the 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

Correct Answer: B


Question 11:

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 log files 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_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.

Correct Answer: D


Question 12:

Your database has a table CUSTOMERS that contains the columns CUST_NAME, AMT_DUE, and OLD_STATUS.

Examine the commands executed and their output:

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_FLASHBACK_RETENTION_TARGET parameter is set to a 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.

Correct Answer: B


Question 13:

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

A. Use the DBMS_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 PDB$SEED 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.

Correct Answer: DE


Question 14:

In which three scenarios is media recovery required? (Choose three.)

A. when a tablespace is accidentally dropped from a database

B. when archived redo log files are lost

C. when data files are lost

D. when one of the online redo log members is corrupted

E. when all control files are lost

Correct Answer: ACE

Reference: http://docs.oracle.com/cd/A87860_01/doc/server.817/a76993/recoscen.htm


Question 15:

Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog.

You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host.

How would you achieve this?

A. by using the RMAN SWITCH command to set the new location for the data files

B. by using the RMAN DUPLICATE command with NOFILENAMECHECK to recover the database to the new host

C. by using the RMAN DUPLICATE command with DBID and SET NEWNAME FOR TABLESPACE to recover the database to the new host

D. by creating a new database in the new host, and then using the RMAN RECOVER command

Correct Answer: B


Recommended Posts