Limited Time Discount Offer 30% Off - Ends in 02:00:00

×

Oracle 1z0-063 Exam - Oracle Database 12c: Advanced Administration

Purchase Individually

Purchase Individually

  • Premium File

    264 Questions & Answers
    Last Update: Sep 5, 2019

    $21.41
    $14.99
  • Study Guide

    991 Pages

    $14.27
    $9.99

Download Free Oracle 1z0-063 Exam Questions

Questions & Answers for Oracle 1z0-063

Showing 1-15 of 175 Questions

Question #1

You install "Oracle Grid Infrastructure for a standalone server" on a host on which the orcl1
and orcl2 databases both have their instances running.
Which two statements are true?

A. Both orcl1 and orcl2 are automatically added to the Oracle Restart configuration.

B. All database listeners running from the database home are automatically added to the Oracle Restart configuration.

C. The srvct1 add database command must be used to add orcl1 and orcl2 to the Oracle Restartconfiguration.

D. The crsct1 start has command must be used to start software services for Oracle AutomaticStorage Management (ASM) after the "Oracle Grid Infrastructure for a standalone server" installation is complete.

E. All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added to the Oracle Restart configuration.

Explanation: https://docs.oracle.com/cd/E18283_01/server.112/e17120/restart001.htm

Question #2

Automatic Shared Memory Management (ASMm) is enabled for your database instance,
but parameters for the managed components are not defined.
You execute this command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;
Which statement is true?

A. The minimum size for the standard buffer cache is 100 MB.

B. The maximum size for the standard buffer cache is 100 MB.

C. The minimum space guaranteed in the buffer cache for any server process is 100 MB.

D. The maximum space in the buffer cache that can be released for dynamic distribution is 100 MB.

E. The minimum size for all buffer caches is 100 MB.

Question #3

Which three statements are true about unplugging a pluggable database (PDB)?

A. The PDB must be open in read only mode.

B. The PDB must be dosed.

C. The unplugged PDB becomes a non-CDB.

D. The unplugged PDB can be plugged into the same multitenant container database (CDB)

E. The unplugged PDB can be plugged into another CDB.

F. The PDB data files are automatically removed from disk.

Explanation: B, not A: The PDB must be closed before unplugging it.
D: An unplugged PDB contains data dictionary tables, and some of the columns in these
encode information in an endianness-sensitive way. There is no supported way to handle
the conversion of such columns automatically. This means,quite simply, that an unplugged
PDB cannot be moved across an endianness difference.
E (not F): To exploit the new unplug/plug paradigm for patching the Oracle version most
effectively, the source and destination CDBs should share a filesystem so that thePDBs
datafiles can remain in place.
Reference: Oracle White Paper, Oracle Multitenant

Question #4

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 databasebased on activity tracking columns, to indicate that a row is no longer considered active.

Question #5

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

Question #6

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

Question #7

Examine the commands executed in CDBS ROOT of your multitenant container database
(CDB) that has multiple pluggable databases (PDB):
SQL> CREATE ROLE c ##role1 CONTAINER-ALL;
SQL> GRANT CREATE SESSION, CREATE TABLE TO c##role1 CONTAINER'ALL;
SQL>CREATE USER c##adnin IDENTIFIED BY orcl123;
SQL>GRANT c##role1 TO c##admin CONTAINER=ALL;
SQL> GRANT SELECT ON DBA_USERS to c##rola1 CONTAINER*ALL;
Which statement is true about granting the select privilege on the DBA_users view to the
c##ROLE1role?

A. The command fails and gives an error because object privileges cannot be granted to a common user.

B. The command fails because container is not set to current.

C. The command succeeds and the common user cmadnxn can create a session and query the D3A_users view incdbssoo? and all the PDBs.

D. The command succeeds and the common user ct (admin can create a session in cdbSroot and all the PDBs, but can only query the dba_users view in ct3S?cdt.

E. The command succeeds and the common user c#(admin can create a session and query the D3A users view only in cdbsrooi.

Question #8

Which two statements are true regarding the Oracle Data Pump export and import
operations?

A. You cannot export data from a remote database.

B. You can rename tables during import.

C. You can overwrite existing dump files during export.

D. You can compress data but not metadata during export.

Reference:http://docs.oracle.com/cd/B28359_01/server.111/b28319/dp_import.htm#BEHF
FDCD

Question #9

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 sysauxtablespaces cannot be recovered.

E. Tables with not null constraints cannot be recovered.

Reference:http://docs.oracle.com/database/121/BRADV/rcmresind.htm#BRADV695(Limitat
ions of Recovering Tablesand Table Partitions from RMAN Backups)

Question #10

For which three pieces of information can you use the RMAN list command?

A. stored scripts in the recovery catalog

B. available archived redo log files

C. backup sets and image copies that are obsolete

D. backups of tablespaces

E. backups that are marked obsolete according to the current retention policy

Reference:http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup007.htm
http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmreprt.htm#BRADV89585
The primary purpose of the LIST command is to list backup andcopies. For example, you
can list:
Backups and proxy copies of a database, tablespace, datafile, archived redo log, or
control file
Backups that have expired
Backups restricted by time, path name, device type, tag, or recoverability
Archived redolog files and disk copies

Question #11

Which two statements are true regarding Oracle Data Pump?

A. EXPDP and IMPDP are the clientcomponents of Oracle Data Pump.

B. DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.

C. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.

D. Oracle Data Pump imports can bedone from the export files generated in the Original Export Utility.

E. EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.

Reference:http://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_overview.htm

Question #12

Which two statements are true about unified auditing?

A. A unified audit trail captures audit information from unified audit policies and audit settings.

B. Unified auditing is enabled by executing make-fins_rdbms.mk uniaud_onioracle ORACLE_HOME=SORACLE_HOME.

C. Audit records are created for all users except sys.

D. Audit records are created only for the DML and DDL operations performed on database objects.

E. Unified auditing is enabled by setting the audit_trail parameter to db, extended.

F. A unified audit trail resides in a read-only table in the audsys schema in the system tablespace.

Question #13

The environmental variable oracle_Base is set to /u01/app/oracleand 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.

Explanation:
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 #14

You issue the RMAN commands:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RKAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY;
RMAN>CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which three tasks are performed by the BACKUP DATABASE command?

A. switching the online redo log file

B. backing up all data files as image copies and archive log files, and deleting those archive log files

C. backing up only the used blocks in the data files

D. backing up all used and unused blocks in the data files

E. backing up allarchived log files and marking them as obsolete

Question #15

Examine the output:
SQL > ARCHIVE LOGLIST
Database log modeArchive Mode
Automatic archivalEnabled
Archive DestinationUSE_DB_RECOVERY_FILE_DEST
Oldest online log sequence376
Next log sequence to archive378
Current log sequence378
Which three types of files are automatically placed in the fast recovery area?

A. Flashback data archives (FDA)

B. Archived redo log files

C. Control file autobackups

D. Server parameter file (SPFILE)

E. Recovery Manager (RMAN) backup pieces

Reference:http://docs.oracle.com/cd/E11882_01/backup.112/e10642/glossary.htm#BRADV
526

  • Premium File

    264 Questions & Answers
    Last Update: Sep 5, 2019

    $21.41
    $14.99
  • Study Guide

    991 Pages

    $14.27
    $9.99

You Need Avanset VCE Player in Order to Open VCE Files

Try Our Special 30% Discount Offer for
Premium 1z0-063 VCE File

  • Verified by experts

1z0-063 Premium File

  • Real Questions
  • Last Update: Sep 5, 2019
  • 100% Accurate Answers
  • Fast Exam Update

$14.99

$21.41

AUTUMN SALE: 30% DISCOUNT
This is ONE TIME OFFER

You save
30%

Enter Your Email Address to Receive Your 30% Discount Code

AUTUMN SALE: 30% DISCOUNT

You save
30%

Use Discount Code:

A confirmation link was sent to your e-mail.

Please check your mailbox for a message from [email protected] and follow the directions.