web analytics

Oracle Database 12c: Advanced Administration 1Z0-063 Dumps With VCE and PDF Download (Question 113 – Question 126)

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 113
Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

A.    By default, EM express is available for a database after database creation.
B.    You can use EM express to manage multiple databases running on the same server.
C.    You can perform basic administrative tasks for pluggable databases by using the EM express interface.
D.    You cannot start up or shut down a database instance by using create and configure pluggable databases by using EM express.
E.    You can create and configure pluggable databases by using EM express.

Answer: A

QUESTION 114
You create a table with the period for clause to enable the use of the Temporal Validity feature of Oracle Database 12c. Examine the table definition:
create table employees
(empno number, salary number,
deptid number, name varchar2(100),
period for employee_time);
Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

A.    The valid time columns employee_time_start and employee_time_end are automatically created.
B.    The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
C.    The valid time columns are not populated bythe Oracle Server automatically.
D.    The valid time columns are visible by default when the table is described.
E.    Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

Answer: ABE

QUESTION 115
View the SPFILE parameter settings in the Exhibit.
passleader-1z0-063-dumps-1151
You issue this command and get errors:
SQL> startup
ORA-00824:cannot setSGAJTARGET or MEMORY_TARGET due to existing internal settings, see alertlog for more information
Why did the instance fail to start?

A.    because pga_aggregate_target is not set
B.    because statistics_level is set to basic
C.    because memory_target and memory_max_target cannot be equal
D.    because sga_target and memory_target are both set

Answer: B

QUESTION 116
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.

Answer: A

QUESTION 117
Which two statements are true about tablespaces in multitenant container databases (CDBs)?

A.    Default permanent tablespaces can be shared across pluggable databases (PDBs).
B.    The current container must be set to root to create or modify the default temporary tablespace or tablespace group for a CDB.
C.    Each PDB can have its own default temporary tablespace.
D.    The default permanent tablespace for a PDB can be changed only by a local user with the required permissions.
E.    The amount of space that each PDB can usein a shared temporary tablespace must be set at the CDB level.

Answer: AB

QUESTION 118
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 all archived log files and marking them as obsolete

Answer: ACE

QUESTION 119
Which two statements are true about a multitenant architecture?

A.    Each pluggable database (PDB) has its own initialization parameter file.
B.    A PDB can have a private undo tablespace.
C.    Log switches occur only at the container database level.
D.    A PDB can have a private temporary tablespace.
E.    Each PDB has a private control file.

Answer: CD

QUESTION 120
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

Answer: B

QUESTION 121
Which two statements are true about dropping a pluggable database (PDB)?

A.    A PDB must be in mount state or it must be unplugged.
B.    The data files associated with a PDB are automatically removed from disk.
C.    A dropped and unplugged PDB can be plugged back into the same multitenant container database (CDB) or other CDBs.
D.    A PDB must be in closed state.
E.    The backups associated with a PDB are removed.
F.    A PDB must have been opened at least once after creation.

Answer: AD

QUESTION 122
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.

Answer: BDE

QUESTION 123
You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:
$ . oraenv
ORACLE-_SID = [oracle] ? cdb1
The oracle base for ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 is /u01/app/oracle $ rman target /
Recovery Manager : Release 12.1.0.0.2 – production on Fri Ju1 19 05:18:33: 2013 Copy right (c) 1982, 2013, oracle and/or its affiliates. All rights reserved.
Connected to target database:CDB1 (DBID=782249327)
RMAN>SELECT name FROM v$tablespace;
Which statement is true about the execution of the last command?

A.    It succeeds and displays all the tablespaces that belong to the root database.
B.    It fails and returns an error because a connection is not made by using the sysdba privilege.
C.    It succeeds and displays all the tablespaces that belong to the root and pluggable databases.
D.    It fails and returns an error because SQL commands cannot be executed at the RMAN prompt.

Answer: A

QUESTION 124
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 Restart configuration.
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.

Answer: CE

QUESTION 125
You created a tablespace with this statement:
CREATE BIGFILE TABLESPACE adtbs
DATAFILE ‘/proddb/data/adtbs.dbf’ SIZE 10G;
The tablespace is nearly full and youneed to avoid any out of space errors for the load of a 5 gig table. Which two alter statements will achieve this?

A.    ALTER TA3LESPACE adtbs RESI2E 20G;
B.    ALTER TA3LESPACE adtbs ADD DATAFILE;
C.    ALTER TABLESPACE adtbs AUTOEXTEND ON;
D.    ALTER TA3LESPACE adtbs ADD DATAFILE ‘/proddb/data/adtbsl.dbf’ SIZE 1QG;
E.    ALTER TA3LESPACE adtbs MODIFY DATAFILE ‘/proddb/data/adtbs.dbf AUTOEXTEND ON;

Answer: AC

QUESTION 126
Examine the output:
SQL > ARCHIVE LOGLIST
Database log mode Archive Mode
Automatic archival Enabled
Archive Destination USE_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

Answer: BCE


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