Oracle Upgrade to Oracle Database 12c은 Oracle의 공인 역량을 입증하는 자격으로 취업과 이직 시장에서 높은 가치를 인정받습니다. Fast2test의 1Z1-060 모의고사 205문항으로 체계적으로 준비하여 자격 취득에 한 걸음 더 가까워지시기 바랍니다.

Oracle 1Z1-060 시험 개요:

Oracle 1Z1-060 시험 요강 주제:

1Z1-060 시험에 대해 궁금한 점을 모았습니다

최신 Oracle Database 1Z1-060 무료샘플문제

문제 #1

Oracle Data Redaction is active on the SCOTT.EMPtable.
You queried the table twice.
SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30;

SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30;

Which is guaranteed to be true concerning the redaction policy?

A. RANDOM redaction is active on the HIREDATE column
B. PARTIAL redaction is active of the HIREDATE column.
C. RANDOM redaction is active on the MGR column
D. FULL redaction is active on the SAL column
E. PARTIAL redaction is active on the MGR column.

문제 #2

Which two are prerequisites for performing a flashback transaction?

A. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.
B. Block change tracking must be enabled tor the database.
C. Flashback Database must be enabled.
D. Supplemental logging must be enabled.
E. Recycle bin must be enabled for the database.
F. Undo retention guarantee for the database must be configured.

문제 #3

Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.
You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:
SQL > SHUTDOWN IMMEDIATE
SQL > STARTUP MOUNT
SQL > FLASHBACK DATABASE to TIME "TO_DATE (`08/20/12' , `MM/DD/YY')";
Examine following commands:
1. ALTER PLUGGABLE DATABASE ALL OPEN;
2. ALTER DATABASE OPEN;
3. ALTER DATABASE OPEN RESETLOGS;
Which command or commands should you execute next to allow updates to the flashback back schema?

A. Only 2
B. Only 3
C. 1 and 2
D. 3 and 1
E. Only 1

문제 #4

Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service level by executing the following command:
SQL > exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE (`SRV1');
The possible outcome and actions to aggregate the trace files are as follows:
1. The command fails because a module name is not specified.
2. A trace file is created for each session that is running the SRV1
service.
3. An aggregated trace file is created for all the sessions that are
running the SRV1 service.
4. The trace files may be aggregated by using the trcess utility.
5. The trace files be aggregated by using the tkprof utility.
Identify the correct outcome and the step to aggregate by using tkprof utility?

A. 1
B. 2 and 5
C. 2 and 4
D. 3 and 5
E. 3 and 4

문제 #5

You plan to drop the column of a table that has Flashback Archiving enabled.
You want to ensure minimal service disruption.
How would you do this in your Oracle 12c Database?

A. Disable Flashback Archiving, drop the column unused, and re-enable Flashback Archiving.
B. Disassociate the Flashback Archive using the
DBMS_FLASHBACK_ARCHIVE.DISASSOCIATE_FBA procedure, drop the column, and re- associate the Flashback Archive using the procedure.
DBMS_FLASHBACK_ARCHIVE.RESASSOCIATE_FBA
C. Disable Flashback Archiving, set the column unused, and re-enable Flashback Archiving.
D. Drop the column using the ALTER TABLE statement.
E. Disassociate the Flashback Archive using the
DBMS_FLASHBACK_ARCHIVE.DISASSOCIATE_FBA procedure, set the column unused, and re-associate the Flashback Archive using the procedure.
DBMS_FLASHBACK_ARCHIVE.RESASSOCIATE_FBA

질문과 대답: