최신Oracle Database 12c: Installation and Administration - 1z1-062무료샘플문제
문제1
Which three resources might be prioritized between competing pluggable databases when creating a multitenant container database plan (CDB plan) using Oracle Database Resource Manager? (Choose three.)
Which three resources might be prioritized between competing pluggable databases when creating a multitenant container database plan (CDB plan) using Oracle Database Resource Manager? (Choose three.)
정답: B,C,D
문제2
Your database is running in ARCHIVELOG mode. You want to take a consistent whole database backup.
Which two statements are true in this scenario? (Choose two.)
Your database is running in ARCHIVELOG mode. You want to take a consistent whole database backup.
Which two statements are true in this scenario? (Choose two.)
정답: C,D
문제3
Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN. (Choose all that apply.)
Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN. (Choose all that apply.)
정답: A,B,E
설명: (ITDumpsKR 회원만 볼 수 있음)
문제4
Which three factors influence the optimizer's choice of an execution plan? (Choose three.)
Which three factors influence the optimizer's choice of an execution plan? (Choose three.)
정답: A,C,E
문제5
You configure your database Instance to support shared server connections.
Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?
(Choose two.)
You configure your database Instance to support shared server connections.
Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?
(Choose two.)
정답: A,C
설명: (ITDumpsKR 회원만 볼 수 있음)
문제6
Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:
Which two statements are true about redefining the table? (Choose two.)
Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:
Which two statements are true about redefining the table? (Choose two.)
정답: B,D
설명: (ITDumpsKR 회원만 볼 수 있음)
문제7
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?
정답: D
설명: (ITDumpsKR 회원만 볼 수 있음)
문제8
Your database is in ARCHIVELOG mode and you want to automate the backup scheduling for your database.
Which two tools or utilities would you use to achieve this? (Choose two.)
Your database is in ARCHIVELOG mode and you want to automate the backup scheduling for your database.
Which two tools or utilities would you use to achieve this? (Choose two.)
정답: B,D
문제9
You executed the following query:
SELECT oldest_flashback_scn, oldest_flashback_time
FROM V$FLASHBACK_DATABASE_LOG;
Considering that all the redo logs are available, what information can you derive from the output of the preceding query?
You executed the following query:
SELECT oldest_flashback_scn, oldest_flashback_time
FROM V$FLASHBACK_DATABASE_LOG;
Considering that all the redo logs are available, what information can you derive from the output of the preceding query?
정답: A
문제10
Which two statements are true about the Oracle Direct Network File system (DNFS)? (Choose two.)
Which two statements are true about the Oracle Direct Network File system (DNFS)? (Choose two.)
정답: C,D
설명: (ITDumpsKR 회원만 볼 수 있음)
문제11
Which three statements are true about the purpose of checkpoints? (Choose three.)
Which three statements are true about the purpose of checkpoints? (Choose three.)
정답: A,D,E
문제12
The HR schema exists in databases, BOSTON and DENVER, with the same password, HR.
You have CREATE DATABASE LINK and CREATE SESSION privileges in both databases.
DENVER is defined as a service name in the tnsnames.ora of both databases.
You plan to use this command:
CREATE DATABASE LNK hr_link CONNECT TO hr IDENTIFIED BY hr USING 'DENVER'; What must be done to ensure that all users in BOSTON can access the HR schema in DENVER?
The HR schema exists in databases, BOSTON and DENVER, with the same password, HR.
You have CREATE DATABASE LINK and CREATE SESSION privileges in both databases.
DENVER is defined as a service name in the tnsnames.ora of both databases.
You plan to use this command:
CREATE DATABASE LNK hr_link CONNECT TO hr IDENTIFIED BY hr USING 'DENVER'; What must be done to ensure that all users in BOSTON can access the HR schema in DENVER?
정답: A
문제13
Backup requirements for a database:
* Level 0 backup on Sunday
* Cumulative incremental level 1 backup on Monday, Wednesday, and Saturday
* Differential incremental level 1 backup on Tuesday, Thursday, and Friday Which three statements are true about the strategy? (Choose three.)
Backup requirements for a database:
* Level 0 backup on Sunday
* Cumulative incremental level 1 backup on Monday, Wednesday, and Saturday
* Differential incremental level 1 backup on Tuesday, Thursday, and Friday Which three statements are true about the strategy? (Choose three.)
정답: A,C,E
문제14
Which statement is true about redo log files during instance recovery?
Which statement is true about redo log files during instance recovery?
정답: B
설명: (ITDumpsKR 회원만 볼 수 있음)
문제15
You plan to create a database by using the Database Configuration Assistant (DBCA), with the following specifications:
- Applications will connect to the database via a middle tier.
- The number of concurrent user connections will be high.
- The database will have mixed workload, with the execution of complex BI queries scheduled at night.
Which DBCA option must you choose to create the database?
You plan to create a database by using the Database Configuration Assistant (DBCA), with the following specifications:
- Applications will connect to the database via a middle tier.
- The number of concurrent user connections will be high.
- The database will have mixed workload, with the execution of complex BI queries scheduled at night.
Which DBCA option must you choose to create the database?
정답: A
설명: (ITDumpsKR 회원만 볼 수 있음)