최신Oracle Database 12c: Advanced Administration - 1z0-063무료샘플문제

문제1
Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)? (Choose two.)

A. Configure Label Security

B. Database Resident Connection Pooling

C. Database Vault in ORACLE_HOME

D. Non default block size tablespaces

E. Oracle Suggested Backup Strategy

정답: A,C

문제2
Examine the resources consumed by a database instance whose current Resource Manager plan is displayed.
SQL> SELECT name, active_sessions, queue_length,
consumed_cpu_time, cpu_waits, cpu_wait_time
FROM v$rsrc_consumer_group;

Which two statements are true? (Choose two.)

A. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.

B. An attempt to start a new session by a user belonging to OTHE_GROUPS fails with an error.

C. An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.

D. A user belonging to the DSS_QUERIES resource consumer group can create a new session but the session will be queued.

E. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to I/O waits and latch or enqueue contention.

정답: A,D

문제3
Examine the command:
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
In which two scenarios is this command required? (Choose two.)

A. The control file backup is older than the database backup.

B. All the control files are missing.

C. All the data files are missing.

D. A data file belonging to a noncritical tablespace is missing.

E. The current online redo log file is missing.

정답: A,B

문제4
Which two statements are true about service creation for pluggable databases (PDBs)? (Choose two.)

A. Only a common user can create additional services for a PDB.

B. The default service that is automatically created by a database at the time of PDB creation can be dropped, provided a new additional service is created.

C. A database managed by Oracle Restart can have additional services created or existing services modified by using the SRVCTL utility for each PDB.

D. When a PDB is created, a service is automatically started in the instance with the same name as the PDB.

E. When a PDB is created, a service with the same name as the PDB is created in the PDB.

정답: C,D

문제5
Users report this error message when inserting rows into the orders table:
ERROR at line1:
ORA-01654f:unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES You determine that the indexes tablespace is out of space and there is no free space on the filesystem used by the Oracle database.
Which two must you do to fix this problem without affecting currently executing queries? (Choose two.)

A. perform an on line table rebuild using dbms_redefinition

B. coalesce the order.ind index

C. rebuild the index online moving it to another tablespace that has enough free space for the index

D. drop and re-create the index

E. coalesce the indexes tablespace

정답: B,C

문제6
You want to back up a database such that only formatted blocks are backed up. Which statement is true about this backup operation?

A. The backup must be performed in MOUNT state.

B. The database must be backed up as an image copy.

C. All files must be backed up as backup sets.

D. The tablespace must be taken offline.

정답: C

문제7
Your production database is running in ARCHIVELOG mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog.
You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host.
How would you achieve this?

A. by creating a new database in the new host, and then using the RMAN RECOVER command

B. by using the RMAN SWITCH command to set the new location for the data files

C. by using the RMAN DUPLICATE command with DBID and SET NEWNAME FOR TABLESPACE to recover the database to the new host

D. by using the RMAN DUPLICATE command with NOFILENAMECHECK to recover the database to the new host

정답: D

문제8
Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)? (Choose two.)

A. If no PDB plan is enabled for a pluggable database, the PDB uses the CDB plan.

B. To enable a resource plan for a PDB, a CDB resource plan must be created and enabled.

C. If no PDB plan is enabled for a pluggable database, all sessions for that PDB are treated to an equal share of resources.

D. If a PDB plan is enabled for a pluggable database, resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

E. If a PDB plan is enabled for a pluggable database, Resource Manager uses the resource allocation at the PDB level and ignores the limits set at the CDB level.

정답: C,D

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

문제9
You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:

Which statement is true about the execution of the last command?

A. It fails and returns an error because SQL commands cannot be executed at the RMAN prompt.

B. It succeeds and displays all the tablespaces that belong to the root database.

C. It fails and returns an error because a connection is not made by using the SYSDBA privilege.

D. It succeeds and displays all the tablespaces that belong to the root and pluggable databases.

정답: D

문제10
Examine this query:
SELECT cust_name, amt_due
FROM customers
AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE)
WHERE cust_no = 'AYR2011';
Which two requirements guarantee that the query will execute successfully? (Choose two.)

A. Undo retention guarantee must be enabled.

B. The database must be in ARCHIVELOG mode.

C. Row movement must be enabled for CUSTOMERS.

D. Supplemental logging must be enabled.

E. Automatic Undo Management must be configured.

F. FLASHBACK must be ON for the database.

정답: E,F

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

문제11
Examine the RMAN command:
RMAN> SET ENCRYPTION IDENTIFIED BY <password> ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which type of encryption is used for the backup performed by using this command?

A. dual-mode encryption

B. transparent encryption

C. password-mode encryption

D. default encryption

정답: C

문제12
A database is running in ARCHIVELOG mode. You want to back up a 10 TB data file belonging to the users tablespace. The backup of the data file is too slow.
What type of backup do you recommend to improve the performance of the backup?

A. multisection parallel backup by using RMAN

B. cold backup after placing the tablespace in backup mode

C. image copy backup by using RMAN

D. cold backup after taking the tablespace offline

E. multisection image copy backup by using RMAN

정답: A

문제13
Your database instance is abnormally terminated because of a power outage. At the next startup, from which point in the redo log does the recovery start?

A. from the beginning of the current redo log file until the instance failure

B. from the last committed transaction

C. from the last complete checkpoint position

D. from the beginning of the current redo log file to the checkpoint position

E. from the most recent incremental checkpoint

정답: E

문제14
The CATDB12C database contains an Oracle Database 12c catalog schema owned by the RC12C user.
The CATDB11 database contains an Oracle Database l1g catalog schema owned by the RC11 user.
A database with DBID=1423241 is registered in the CATDB11 catalog. Both the recovery catalog databases are open.
In the CATDB12c database, you execute the commands:

What is the outcome of the import?

A. It succeeds and all global scripts in the RC11 catalog that have the same name as existing global scripts in the RC12C catalog are automatically renamed.

B. It fails because the target database and recovery catalog database are of different versions.

C. It succeeds but the database is not automatically registered in the RC12c catalog.

D. It fails because RMAN is not connected to the target database with DBID=1423241.

정답: B

자격증의 중요성:

ITDumpsKR 경쟁율이 심한 IT시대에 인증시험을 패스함으로 IT업계 관련 직종에 종사하고자 하는 분들에게는 아주 큰 가산점이 될수 있고 자신만의 위치를 보장할수 있으며 더욱이는 한층 업된 삶을 누릴수 있을수도 있습니다.

ITDumpsKR 제품의 가치:

ITDumpsKR에는 IT인증시험의 최신 학습가이드가 있습니다. ITDumpsKR의 IT전문가들이 자신만의 경험과 끊임없는 노력으로 최고의 학습자료를 작성해 여러분들이 시험에서 패스하도록 도와드립니다.

무료샘플 받아보기:

관심있는 인증시험과목 덤프의 무료샘플을 원하신다면 덤프구매사이트의 PDF Version Demo 버튼을 클릭하고 메일주소를 입력하시면 바로 다운받아 덤프의 일부분 문제를 체험해 보실수 있습니다.

완벽한 서비스 제공:

ITDumpsKR는 한국어로 온라인상담과 메일상담을 받습니다. 덤프구매후 일년동안 무료 업데이트 서비스를 제공해드리며 구매일로 부터 60일내에 시험에서 떨어지는 경우 덤프비용 전액을 환불해드려 고객님의 부담을 덜어드립니다.

인터넷에는IT인증시험대비자료가 헤아릴수 없을 정도로 많습니다.이렇게 많은 덤프자료중 대부분 분들께서 저희ITDumpsKR를 선택하는 이유는 덤프 업데이트가 다른 사이트보다 빠르다는 것이 제일 큰 이유가 아닐가 싶습니다.

유용한 링크

우리와 연락하기

근무시간: ( UTC+9 ) 9:00-24:00

월요일~토요일

서포트: 바로 연락하기