최신Oracle Database 12c: Advanced Administration - 1z1-063무료샘플문제
문제1
You want RMAN to make duplicate copies of data files when using the BACKUP command.
What must you set using the RMAN CONFIGURE command to achieve this?
You want RMAN to make duplicate copies of data files when using the BACKUP command.
What must you set using the RMAN CONFIGURE command to achieve this?
정답: C
문제2
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? (Choose three.)
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? (Choose three.)
정답: C,D,E
설명: (KoreaDumps 회원만 볼 수 있음)
문제3
Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?
Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?
정답: A
문제4
Examine the following set of RMAN commands:
Which statement is true about the RMAN RUN block execution?
Examine the following set of RMAN commands:
Which statement is true about the RMAN RUN block execution?
정답: C
문제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.)
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,D
문제6
You set the following parameters in the parameter file and restart the database instance:
NEMORY_MAX_TARGET=0
MEMORY__TARGET=500M
PGA_AGGREGATE_TARGET=90M
SGA_TARGET=270M
Which two statements are true? (Choose two.)
You set the following parameters in the parameter file and restart the database instance:
NEMORY_MAX_TARGET=0
MEMORY__TARGET=500M
PGA_AGGREGATE_TARGET=90M
SGA_TARGET=270M
Which two statements are true? (Choose two.)
정답: A,C
문제7
Which two can be backed up by using RMAN in a database that is in ARCHIVELOG mode? (Choose two.)
Which two can be backed up by using RMAN in a database that is in ARCHIVELOG mode? (Choose two.)
정답: B,E
문제8
You issue the command:
SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
Which statement is true about the command?
You issue the command:
SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
Which statement is true about the command?
정답: D
문제9
The following parameters are set for your Oracle 12c database instance:
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE
OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE
You want to manage the SQL plan evolution task manually. Examine the following steps:
1. Set the evolve task parameters.
2. Create the evolve task by using the DBMS_SPM.CREATE_EVOVLE_TASK function.
3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.
4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.
5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.
Identify the correct sequence of steps.
The following parameters are set for your Oracle 12c database instance:
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE
OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE
You want to manage the SQL plan evolution task manually. Examine the following steps:
1. Set the evolve task parameters.
2. Create the evolve task by using the DBMS_SPM.CREATE_EVOVLE_TASK function.
3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.
4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.
5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.
Identify the correct sequence of steps.
정답: C
문제10
You want to duplicate one of your databases when connected to the target database and to the recovery catalog.
Which three are true about this type of database duplication? (Choose three.)
You want to duplicate one of your databases when connected to the target database and to the recovery catalog.
Which three are true about this type of database duplication? (Choose three.)
정답: C,E,F
설명: (KoreaDumps 회원만 볼 수 있음)
문제11
Examine the backup requirement for your company:
1) Every Sunday, a backup of all used data file blocks is performed.
2) Every Wednesday and Friday, a backup of all the changed blocks since last Sunday's backup is performed.
3) On all the other days, a backup of only the changed blocks since the last day's backup is performed.
Which backup strategy satisfies the requirements?
Examine the backup requirement for your company:
1) Every Sunday, a backup of all used data file blocks is performed.
2) Every Wednesday and Friday, a backup of all the changed blocks since last Sunday's backup is performed.
3) On all the other days, a backup of only the changed blocks since the last day's backup is performed.
Which backup strategy satisfies the requirements?
정답: D
문제12
Which two statements are true about service for pluggable databases (PDBs)? (Choose two.)
Which two statements are true about service for pluggable databases (PDBs)? (Choose two.)
정답: C,D
문제13
You want to create a guaranteed restore point for one of your databases by executing the command:
SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;
Which two are required for the successful execution? (Choose two.)
You want to create a guaranteed restore point for one of your databases by executing the command:
SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;
Which two are required for the successful execution? (Choose two.)
정답: C,F
문제14
A database instance uses an SPFILE. Examine the parameter:
You plan to multiplex the control file to a new location, /u01/app/oracle/oradata/cdb1/disk3/control03.ctl/.
Examine the possible steps that are in random order:
1. Shut down the database instance.
2.Issue ALTER SYSTEM SET CONTROL_FILES=
'/u01/app/oracle/oradata/cdb1/disk1/control01.ctl,/u01/app/oracle/oradata/cdb1/disk2/control02.ctl,
/u01/app/oracle/oradata/cdb1/disk3/control03.ctl'
SCOPE=SPFILE;.
3. Issue ALTER SYSTEM SET CONTROL_FILES=
'/u01/app/oracle/oradata/cdb1/disk1/control01.ctl,/u01/app/oracle/oradata/cdb1/disk2/control02.ctl,
/u01/app/oracle/oradata/cdb1/disk3/control03.ctl';.
4. Copy the control file from the existing location to '/u01/app/oracle/oradata/cdb1/disk3/control03.ctl'.
5. Mount the database.
6. Open the database.
Identify the required steps in the correct order to accomplish the task.
A database instance uses an SPFILE. Examine the parameter:
You plan to multiplex the control file to a new location, /u01/app/oracle/oradata/cdb1/disk3/control03.ctl/.
Examine the possible steps that are in random order:
1. Shut down the database instance.
2.Issue ALTER SYSTEM SET CONTROL_FILES=
'/u01/app/oracle/oradata/cdb1/disk1/control01.ctl,/u01/app/oracle/oradata/cdb1/disk2/control02.ctl,
/u01/app/oracle/oradata/cdb1/disk3/control03.ctl'
SCOPE=SPFILE;.
3. Issue ALTER SYSTEM SET CONTROL_FILES=
'/u01/app/oracle/oradata/cdb1/disk1/control01.ctl,/u01/app/oracle/oradata/cdb1/disk2/control02.ctl,
/u01/app/oracle/oradata/cdb1/disk3/control03.ctl';.
4. Copy the control file from the existing location to '/u01/app/oracle/oradata/cdb1/disk3/control03.ctl'.
5. Mount the database.
6. Open the database.
Identify the required steps in the correct order to accomplish the task.
정답: E