최신 1Z0-083 무료덤프 - Oracle Database Administration II

문제1

Which two statements are true about indexes and their administration in an Oracle database?

A. An index is always created by scanning the key columns from the underlying table.

B. A non-unique index can be converted to a unique index using a Data Definition Language (DDL) command.

C. A descending index is a type of bitmapped index.

D. An invisible index is maintained when a Data Manipulation Language (DML) command is per- formed on its underlying table.

E. An index can be scanned to satisfy a query without the indexed table being accessed.

정답: D,E

문제2

Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES_APP application.
Examine these steps:
1. Install the SALES_APP application, including the common tables, in the application root.
2. Install the SALES_APP application in the application root and the common tables in both the CDB root and the application root.
3. Create an application seed.
4. Install the SALES_APP application in the application seed.
5. Create the SALES_APP1 and SALES_APP2 application PDBs.
6. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root.
7. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed.
8. Sync the application seed with the application root.
Which are the minimum required steps in the correct sequence?

A. 1,3,5,6,7

B. 3,4,1,6,8

C. 2,5,6

D. 1,3,5,7

E. 1,5,6

정답: E

문제3

Which two are benefits of unified auditing in full mode?

A. The audit trail uses less space.

B. All audit data is written to both the traditional locations and to the unified location.

C. Pre 12c audit data is written to the traditional locations and new 12c audit data is written to the unified location.

D. The audit trail is in a single format.

E. The audit trail is read-only.

정답: C,D

문제4

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 are visible by default when the table is described.

B. The valid time columns employee_time_start and employee_time_end are automatically created.

C. 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.

D. Thesamestatementmayfilteronbothtransactiontimeandvalidtemporaltimebyusingthe AS OF TIMESTAMP and PERIOD FOR clauses.

E. The valid time columns are not populated by the Oracle Server automatically.

정답: B,D,E

문제5

Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)

A. All metrics are instance related.

B. STATISTICS_LEVEL must be set to ALL to generate alerts.

C. They are generated by SMON when a tablespace is 97% full.

D. Metrics are statistical counts for a specific unit.

E. Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.

F. A space usage management alert is automatically cleared after the underlying problem is resolved.

정답: D,E,F

설명: (DumpTOP 회원만 볼 수 있음)

문제6

Examine the RMAN commands:
RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP";
RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP";
RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE
PASSWORD FILE SECTION SIZE 400M;
Which statement is true about the DUPLICATE command?

A. It succeeds and creates multisection backup sets that are used for active database duplication.

B. It succeeds only if the target database is in MOUNT state.

C. It fails because no parallel channels are allocated for the auxiliary database.

D. It fails because there is no connection to a recovery catalog.

정답: A

문제7

Automatic Shared Memory Management is disabled for one of your database instances.
Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance.
What would be your next step?

A. Run the SQL Access Advisor.

B. Run the SQL Tunning Advisor.

C. Run the Memory Advisor for the Program Global Area.

D. Run the Memory Advisor for the shared pool.

E. Run the Memory Advisor for the System Global Area.

정답: D

설명: (DumpTOP 회원만 볼 수 있음)

문제8

Which three are true about creating container databases (CDBs) and pluggable databases (PDBs) in Oracle 19c and later releases? (Choose three.)

A. A snapshot copy PDB can be a full copy of a source PDB.

B. A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode with no configuration required before starting the duplication.

C. A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.

D. A PDB snapshot depends on an existing storage snapshot of the source PDB.

E. A PDB snapshot can be a full copy of a source PDB.

F. A CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before starting the duplication.

G. A PDB snapshot can be a sparse copy of a source PDB.

정답: B,E,G

설명: (DumpTOP 회원만 볼 수 있음)

문제9

Which three are true about post-upgrade activities when upgrading an Oracle database using Database Upgrade Assistant?

A. The Oracle Application Express configuration should be updated after upgrading Oracle Database.

B. The new extended data type capability must be enabled by running the utlrp.sql script

C. Time zone files must be upgraded manually using the DBMS_DST PL/SQL package.

D. After a manual upgrade, TNSNAMES.ORA entries must be updated to reflect the new ORACLE_HOME.

E. Any Recovery Manager (RMAN) recovery catalog must be upgraded manually.

정답: A,B,E

문제10

Which two are true about Oracle Database Configuration Assistant (DBCA) templates? (Choose two.)

A. Oracle DBCA templates can be used to create new databases and duplicate existing databases.

B. The Data Warehouse template is most suitable when transaction response time is the key criterion.

C. Oracle DBCA templates can store only logical structure and not database files.

D. New templates can only be created by modifying an existing user-created template.

E. The General Purpose of Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.

정답: A,E

설명: (DumpTOP 회원만 볼 수 있음)

문제11

How do you configure a CDB for local undo mode?

A. Open the CDB instance in upgrade mode.
In cdb$root, execute alter database local undo on, and then restart the CDB instance.

B. Open the CDB instance in restricted mode.
In cdb$root, execute alter database local undo on.
create an undo tablespace in each PDB, and hen restart the CDB instance

C. Open the CDB in read-only mode.
In cdb$root, ex cute alter database local undo on, and then change the CDB to read/write mode.

D. Open the CDB instance in restricted mode.
In cdb$root, drop the undo tablespace.
Execute alter database local undo on in each PDB and then restart the CDB instance.

E. Open the CDB instance in upgrade mode.
In each PDB, execute alter database local undo on, create an undo tablespace, and hen restart the CDB instance.

정답: A

설명: (DumpTOP 회원만 볼 수 있음)

문제12

Which three RMAN persistent settings can be set for a database?

A. default backup device type

B. default section size for backups

C. multiple backup device types for a single backup

D. backup retention policy

E. default destinations for backups

정답: A,D,E

문제13

Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges. You execute the command:
SQL>CREATE AUDIT POLICY table_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLES hr_admin,oe_admin; Which statement is true?

A. It fails because the command does notspecify when the unified audit policy should be enforced.

B. It fails because system privileges cannot be granted with roles in the same audit policy.

C. It succeeds and starts capturing only successful SQL statements for all users who have either the specified privileges or roles granted to them.

D. It succeeds and needs to be enabled to capture all SQL statements that require either the specified privileges or any privilege granted to the HR_ADMIN or OE_ADMIN role.

정답: D

문제14

You want to install Oracle Grid Infrastructure for a Standalone Server using Oracle Universal Installer (OUI). There is no existing Oracle installation on the server.
Which two are prerequisites? (Choose two.)

A. the installation of Oracle ASMLIB

B. a group called dba

C. an operating system user to own this installation

D. an operating system account called grid

E. the Oracle Inventory group to install

정답: C,E

최신 1Z0-083 무료덤프 - Oracle Database Administration II

우리와 연락하기

유용한 링크

최신 업데이트