다운로드 Oracle : 1Z1-060 질문 & 답 PDF & Test Software

바쁜 직장인에게 Oracle Upgrade to Oracle Database 12c 시험 준비는 결코 쉽지 않은 일입니다. PassTIP의 1Z1-060 연습문제는 출퇴근 시간에도 활용하실 수 있도록 세 가지 버전으로 제공됩니다.

Oracle 1Z1-060 시험 개요:

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

Oracle Upgrade to Oracle Database 12c 관련 궁금증을 해결해 드립니다

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

문제 #1

A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1with SQL:

There is enough free space in the disk group for mirroring to be done.
What happens if the CONTROLLER1failure group becomes unavailable due to error or for maintenance?

A. Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.
B. ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.
C. Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.
D. The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.
E. Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.

문제 #2

In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs.
You execute the following command from the root container:
SQL > REVOKE create table FROM C # # A_ADMIN;
What is the result?

A. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.
B. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.
C. It fails and reports an error because the CONTAINER=CURRENT clause is not used.
D. It fails and reports an error because the CONTAINER=ALL clause is not used.
E. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.

문제 #3

You notice a performance change in your production Oracle database and you want to know which change has made this performance difference.
You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation.
Which three findings would you get from the report?

A. It detects any configuration change that caused a performance difference in both time periods.
B. It shows the resource usage for CPU, memory, and I/O in both time periods.
C. It detects the top wait events causing performance degradation.
D. It identifies any workload change that caused a performance difference in both time periods.
E. It shows the difference in the size of memory pools in both time periods.
F. It gives information about statistics collection in both time periods.

문제 #4

Which four actions are possible during an Online Data file Move operation?

A. Querying tables in the data file being moved
B. Performing file shrink of the data file being moved
C. Executing DML statements on objects stored in the data file being moved
D. Creating and dropping tables in the data file being moved
E. Performing Block Media Recovery for a data block in the data file being moved
F. Flashing back the database

문제 #5

Which three statements are true about Flashback Database?

A. Flashback Database can recover a database to the state that it was in before a reset logs operation.
B. The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.
C. Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.
D. Flashback Database can recover a data file that was dropped during the span of time of the flashback.
E. Flashback logs are written sequentially, and are archived.
F. Flashback Database uses a restored control file to recover a database.

질문과 대답: