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

문제1

You execute the following piece of code with appropriate privileges:
User SCOTT has been granted the CREATE SESSION privilege and the MGR role.
Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table?

A. Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.

B. Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.

C. Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.

D. Data is never redacted for the EMP_V.SAL column.

E. Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.

정답: A,D

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

문제2

Which three actions are mandatory post database upgrade?

A. Updating client scripts with the new Oracle home.

B. Setting threshold values for tablespace alerts.

C. Run OPatch commands from the new Oracle home.

D. Migration to unified auditing.

E. Resetting passwords to enforce case-sensitivity.

F. Upgrading user tables that depend on Oracle-maintained abstract data types.

정답: A,C,F

문제3

Examine this configuration:
1. CDB1 is a container database.
2. APP1_ROOT is an application container contained in CDB1.
3. APP1_ROOT$SEED is the application seed contained in APP1_ROOT and synchronized with APP1_ROOT.
4. APP1_PDB1 and APP1_PDB2 are application PDBs contained in APP1_ROOT.
5. APP1_USER_APP is an application installed in APP1_ROOT at version 1.0.
6. USER1 is a common user in APP1_ROOT and all its application PDBs, created when version
1.0 of APP1_USER_APP was installed.
You execute these commands:
$ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba
SQL> ALTER SESSION SET CONTAINER=app1_root;
Session altered.
SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app
BEGIN UPGRADE '1.0' TO '2.0'; pluggable database altered.
SQL> GRANT CREATE SESSION TO USER1; Grant succeeded.
SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app
END UPGRADE TO '2.0'; Pluggable database altered
SQL> ALTER SESSION SET CONTAINER=app1_pdb1;
Session altered.
SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app SYNC;
Pluggable database altered.
Which two are true?

A. USER1 can connect only to APP1_ROOT.

B. USER1 is defined in APP1_PDB2. E) USER1 can connect only to APP1_PDB1.

C. USER1 can connect to APP1_ROOT, APP1_ROOT$SEED, and APP1_PDB1.

D. USER1 can connect to CDB1.

E. USER1 can connect to APP1_ROOT and APP1_PDB1.

정답: B,E

문제4

Your container database, CDB1, has an application container, HR_ROOT, with an application PDB, HR_PDB1.
You have the required privilege to clone HR_PDB1to container database CDB2, which does not contain HR_ROOT.
Which two are always true? (Choose two.)

A. Cloning HR_ROOT automatically clones HR_PDB1.

B. All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.

C. A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.

D. The HR_PDB1 clone created in CDB2 will be in mount state when cloning ends.

E. CDB1 and CDB2 must be in shared undo mode.

정답: C,D

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

문제5

HR_ROOT is an application container with the HR_APP application installed.
No application PDBs and no application seed have yet been created in HR_ROOT.
An application PDB, PDB1, must be created so that the HR_APP application's common objects are accessible to it.
Which two methods can be used? (Choose two.)

A. Create an application seed, and install HR_APP in it.

B. Create the PBD1 application PDB and synchronize it with HR_ROOT.

C. Create an application seed, synchronize it with HR_ROOT, and then create the PDB1 application PDB.

D. Create the PBD1 application PDB and synchronize it with PDB$SEED.

E. Create the PDB1 application PDB and install HR_APP in it.

정답: B,C

문제6

Which three are true about Optimizer Statistics Advisor? (Choose three.)

A. It can recommend changes to improve the statistics gathering process.

B. It can be run only manually.

C. It is part of the DBMS_ADVISOR package.

D. It always analyzes all schemas in the database.

E. It is part of the DBMS_STATS package.

F. It runs automatically every night by default.

정답: A,E,F

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

문제7

Which three are true about Audit policies In container databases (CDBs)?

A. A common unified audit policy can be created at the CDB level.

B. Application-common unified audit policies defined In an application root must be manually synchronized by each application PDB contained in the application root.

C. Fine-grained auditing policies defined in an application root must be manually synchronized by each application PDB contained in the application root.

D. A common unified audit policy can be created at the application root level.

E. All audit records are written to the audit trail in CDB$ROOT

F. An application PDB cannot have a local audit policy.

정답: A,B,D

문제8

You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database instance because it hangs.
How can you detect the cause of the degraded performance?

A. by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis

B. by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots

C. by running ADDM in diagnostic mode

D. by using Active Session History (ASH) data and performing hang analysis

정답: A

문제9

You issued this command:
RMAN> BACKUP RECOVERY AREA FORCE;
Which three are true? (Choose three.)

A. All Oracle recovery files normally written to the FRA and which have not yet been backed up, are backed up.

B. All files in the current FRA that have been backed up already, are backed up.

C. All files in any previous FRA that have been backed up already, are backed up.

D. All files in any previous FRA that have not yet been backed up, are backed up.

E. All files in the current fast recovery area (FRA) that have not yet been backed up, are backed up.

F. All Oracle recovery files normally written to the FRA and which have been backed up already to in any previous FRA, are backed up.

G. All Oracle recovery files normally written to the FRA and which have been backed up already to the current FRA, are backed up.

정답: A,F,G

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

문제10

Which three are performed by Oracle Automatic Storage Management (ASM) instances?
(Choose three.)

A. acting as an I/O server to write data file blocks to ASM disks on behalf of Database Writer processes (DBWn)

B. mounting disk groups

C. managing extent allocation for Oracle database segments

D. managing Allocation Units (AUs) for disk group content

E. managing space allocation for Oracle ASM files

F. acting as an I/O server to read data file blocks from ASM disks on behalf of database server processes

정답: B,D,E

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

문제11

While backing up to an SBT channel, you determine that the read phase of your compressed Recovery Manager (RMAN) incremental level 0 backup is a bottleneck.
FORCE LOGGINGis enabled for the database.
Which two could improve read performance? (Choose two.)

A. Increase the size of tape I/O buffers.

B. Disable FORCE LOGGING for the database.

C. Increase the level of RMAN multiplexing.

D. Increase the size of the database buffer cache.

E. Enable asynchronous disk I/O.

정답: C,E

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

문제12

For which two tasks can you use the DBMS_PDB.DESCRIBE procedure?

A. to generate an XML metadata file that describes a non-CDB Oracle 12c database so that it can be plugged in as a PDB

B. to determine whether an XML file describes a PDB that can be plugged into the CDB in which you run the procedure

C. to generate an XML metadata file that describes the current plugged-in PDB

D. to generate a . pdb archive file for any PDB in the current CDB

E. to generate an XML metadata file from any unplugged PDB

정답: A,C

문제13

Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and later releases? (Choose two.)

A. Space is only reclaimed when there is space pressure in the Fast Recovery Area. (FRA)

B. Space is always reclaimed automatically when the retention period for Flashback logs is lowered.

C. Space is always reclaimed proactively before space pressure occurs.

D. Space might be reclaimed automatically when the retention period for Flashback logs is lowered.

E. Space might be reclaimed proactively before space pressure occurs.

정답: B,C

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

문제14

Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?

A. Tables with not null constraints cannot be recovered.

B. Tables or table partitions can be recovered by using an auxiliary instance only.

C. Tables or table partitions from the system and sysaux tablespaces cannot be recovered.

D. Tables or table partitions with a foreign key cannot be recovered.

E. Tables or table partitions can be recovered only when the database is in mount state.

정답: B,C

문제15

You plan to perform cross-platform PDB transport using XTTS. Which two are true?

A. A backup of the PDB must exist, taken using the BACKUP command with the To PLATFORM clause.

B. The source PDB can be in MOUNT or OPEN state.

C. Automatic conversion of endianess occurs.

D. The source PDB must be in MOUNT state.

E. The source and target platforms must have the same endianess.

F. The source PDB must not be an application root.

정답: B,E

문제16

Examine the statements that use flashback technologies:
1. FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP (2013-02-04 09:30:00, YYYY-MM-DD HH:MI:SS);
2. SELECT * FROM customers AS OF SCN 123456;
3. FLASHBACK TABLE customers TO BEFORE DROP;
4. FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP (2013-02-04 09:30:00, YYYY- MM-DD HH:MI:SS);
5. SELECT * FROM customers VERSIONS BETWEEM SCN 123456 AND 123999;
6. ALTER TABLE customer FLASHBACK ARCHIVE;
Which set of statements depends on the availability of relevant undo data in the undo tablespace?

A. 1,2,5

B. 3,4,5

C. 1,3,6

D. 2,3,5,6

정답: A

문제17

Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)?

A. Tracking the most recent write time for a table block

B. Tracking the most recent write time for a table segment in the SYSAUX tablespace Correct

C. Tracking insert time by row for table rows

D. Tracking the most recent read time for a table segment in a user tablespace

E. Tracking the most recent write time for a table segment in a user tablespace

F. Tracking the most recent read time for a table segment in the SYSTEM tablespace

정답: C,D,E

문제18

Which three are true about RMAN archival backups with the RESTORE POINT clause? (Choose three.)

A. All archive logs are retained after an archival backup is taken, until the next archival backup is taken of the same database.

B. They are never considered obsolete by RMAN.

C. The ARCHIVAL attribute for a backup overrides the RMAN retention policy.

D. They can optionally be written to a fast recovery area (FRA).

E. Archive logs are retained if they are necessary to allow the database to be recovered to a consistent state when an archival backup is restored.

F. Use of a recovery catalog is always required to support the creation and use of archival backups.

G. The SPFILE is included in the archival backup.

정답: C,E,G

문제19

Which three are true about RMAN persistent configuration settings, administration, and their effects? (Choose three.)

A. A DBA must specify either a redundancy retention policy or a recovery window retention policy.

B. Backups written to the fast recovery area (FRA) that are oboslete based on the redundancy retention policy can be deleted automatically to free space.

C. A target database's persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.

D. The V$RMAN_CONFIGURATION view displays only settings with values that have been modified.

E. The RMAN SHOW ALL command displays only settings with nondefault values.

F. Backup older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.

G. A target database's persistent RMAN configuration settings are always stored in the target's control file

정답: B,D,G

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

우리와 연락하기

유용한 링크

최신 업데이트