（PDF)Oracle Database 1Z0-060試験と認定テストエンジン
無料提供中の1Z0-060試験問題集で（2021年最新のPDF問題集）信頼度の高い1Z0-060テストエンジン
Oracle 1Z0-060 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
| トピック 5 |
|
| トピック 6 |
|
| トピック 7 |
|
質問 18
You find this query being used in your Oracle12c database:
Which method a used by the optimizer to limit the rows being returned?
- A. A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.
- B. All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.
- C. A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows
- D. A TOP-N query is created to limit the rows to 20 percent of the total rows
正解: A
質問 19
The tnsnames.ora file has an entry for the service alias ORCL as follows:
The TNSPING command executes successfully when tested with ORCL; however, from the same OS user session, you are not able to connect to the database instance with the following command:
SQL > CONNECT scott/tiger@orcl
What could be the reason for this?
- A. The listener is running on a different port.
- B. The DEFAULT_DOMAINparameter is set to the wrong value in the sqlnet.orafile.
- C. The listener is not running on the database node.
- D. The TNS_ADMINenvironment variable is set to the wrong value.
- E. The orcl.oracle.com database service is not registered with the listener.
正解: E
解説:
Explanation/Reference:
Explanation:
Service registration enables the listener to determine whether a database service and its service handlers are available. A service handler is a dedicated server process or dispatcher that acts as a connection point to a database. During registration, the LREG process provides the listener with the instance name, database service names, and the type and addresses of service handlers. This information enables the listener to start a service handler when a client request arrives.
質問 20
Examine the query and its output executed In an RDBMS Instance:
Which three statements are true about the users (other than sys) in the output?
- A. The C # # A_ADMINuser can perform wallet operations.
- B. The C # # C_ADMINuser can perform the data guard operation with Data Guard Broker.
- C. The C # # B_ADMINuser can perform all backup and recovery operations using RMAN only.
- D. The C # # B_ADMINuser can perform all backup and recovery operations using RMAN or SQL* Plus.
- E. The C # # D_ADMINuser can perform backup and recovery operations for Automatic Storage Management (ASM).
正解: B,D,E
解説:
Explanation/Reference:
Explanation:
B: SYSDG administrative privilege has ability to perform Data Guard operations (including startup and shutdown) using Data Guard Broker or dgmgrl.
D: SYSASM
The new (introduced in 11g) SYSASM role to manage the ASM instance, variable extent sizes to reduce shared pool usage, and the ability of an instance to read from a specific disk of a diskgroup E (Not A): SYSDBA is like a role in the sense that it is granted, but SYSDBA is a special built-in privilege to allow the DBA full control over the database
Incorrect Answers:
C: SYSKM. SYSKM administrative privilege has ability to perform transparent data encryption wallet operations.
Note:
Use the V$PWFILE_USERS view to see the users who have been granted administrative privileges.
質問 21
Which two are true concerning a multitenant container database with three pluggable databases? (Choose two.)
- A. All administration tasks must be done to each pluggable database.
- B. Pluggable databases in the same container database (CDB) each have their own buffer cache
- C. Pluggable databases can make database consolidation easier
- D. Pluggable databases increase patching time.
- E. Pluggable databases are patched together
正解: C,E
質問 22
What are two of the benefits of installing Oracle Grid Infrastructure for a stand-alone server before installing and creating an Oracle database on the same server? (Choose two.)
- A. It is the only way to have "automatic restart in place" after instance failure.
- B. The Oracle database will be automatically registered as a resource in Oracle Restart.
- C. The Oracle database can be created using storage managed by ASM.
- D. The Oracle database can be created using Oracle Managed Files.
- E. The Oracle database will be easier to upgrade in the future.
正解: B,C
解説:
https://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r2/prod/install/gridinstss/gridin stss.htm
質問 23
Which three statements are true about using flashback database in a multitenant container database (CDB)?
- A. Individual PDBs can be flashed back without flashing back the entire CDB.
- B. A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.
- C. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB.
- D. The root container can be flashed back without flashing back the pluggable databases (PDBs).
- E. To enable flashback database, the CDB must be mounted.
正解: B,C,E
質問 24
Which three are amongst the categories into which column definitions are classifies by the Database Migration Assistant for Unicode (DMU)?
- A. date columns that will have invalid binary representation after converting to the chosen Unicode character set
- B. alphanumeric columns that will have invalid binary representation after converting to the chosen Unicode character set
- C. numeric columns that will have invalid binary representation after converting to the chosen Unicode character set
- D. numeric columns that will exceed the column size limit after converting to the chosen Unicode character set
- E. alphanumeric columns that need no conversion
- F. alphanumeric columns that need conversion to a different binary representation before converging to the chosen Unicode character set
正解: A,B,C
質問 25
Examine the parameters for your database instance:
Which three statements are true about the process of automatic optimization by using cardinality feedback?
(Choose three.)
- A. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.
- B. The optimizer enables monitoring for cardinality feedback after the first execution of a query.
- C. After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.
- D. The optimizer can re optimize a query only once using cardinality feedback.
- E. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.
正解: A,B,E
解説:
Explanation
C: During the first execution of a SQL statement, an execution plan is generated as usual.
D: if multi-column statistics are not present for the relevant combination of columns, the optimizer can fall back on cardinality feedback.
(not B)* Cardinality feedback. This feature, enabled by default in 11.2, is intended to improve plans for repeated executions.
optimizer_dynamic_sampling
optimizer_features_enable
* dynamic sampling or multi-column statistics allow the optimizer to more accurately estimate selectivity of conjunctive predicates.
Note:
* OPTIMIZER_DYNAMIC_SAMPLING controls the level of dynamic sampling performed by the optimizer.
Range of values. 0 to 10
* Cardinality feedback was introduced in Oracle Database 11gR2. The purpose of this feature is to automatically improve plans for queries that are executed repeatedly, for which the optimizer does not estimate cardinalities in the plan properly. The optimizer may misestimate cardinalities for a variety of reasons, such as missing or inaccurate statistics, or complex predicates. Whatever the reason for the misestimate, cardinality feedback may be able to help.
質問 26
In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLEprivilege to the common user C # # A_ADMINin root and all PDBs. You then execute this command from the root container:
SQL > REVOKE create table FROM C # # A_ADMIN;
What is the result?
- A. It executes successfully and the CREATE TABLEprivilege is revoked from C # # A_ADMINin root only.
- B. It excludes successfully and the CREATE TABLEprivilege is revoked from C # # A_ADMINin root and all PDBs.
- C. It fails and reports an error because the CONTAINER=ALLclause is not used.
- D. It fails and reports an error because the CONTAINER=CURRENTclause is not used.
- E. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMINin all PDBs.
正解: C
解説:
Explanation/Reference:
Explanation:
SQL> create user c##admin identified by stipsi container=all;
User created.
SQL> grant create table to c##admin container=all;
Grant succeeded.
SQL> revoke create table from c##admin;
revoke create table from c##admin
* ERROR at line 1:
ORA-65092: system privilege granted with a different scope to 'C##ADMIN'
質問 27
You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI)prompts you toenter the path of the Inventory directory and alsotospecify an operating system group name.
Which statement is true?
- A. The operating system group that is specified must have permission to write to the inventory directory.
- B. The operating system group that is specified should have the root user as its member.
- C. The installation is being performed by the root user.
- D. The ORACLE_BASE base parameter is not set.
正解: A
解説:
Note:
Providing a UNIX Group Name
If you are installing a product on a UNIX system, the Installer will also prompt you to
provide the name of the group which should own the base directory.
You must choose a UNIX group name which will have permissions to update, install, and
deinstall Oracle software. Members of this group must have write permissions to the base
directory chosen.
Only users who belong to this group are able to install or deinstall software on this
machine.
質問 28
You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs).
Examine the query and its output:
Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKMprivilege to the password file?
- A. Re-create the password file with SYSBACKUP, SYSDG, and SYSKMprivilege and the FORCEargument set to No.
- B. Re-create the password file with SYSBACKUP, SYSDG, and SYSKMprivilege, and FORCEarguments set to Yes.
- C. Grant SYSBACKUP, SYSDG, and SYSKMprivileges to the intended users.
- D. Re-create the password file in the Oracle Database 12c format.
- E. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.
正解: B,C
解説:
Explanation/Reference:
Explanation:
* orapwd
/You can create a database password file using the password file creation utility, ORAPWD.
The syntax of the ORAPWD command is as follows:
orapwd FILE=filename [ENTRIES=numusers] [FORCE={y|n}] [ASM={y|n}]
[DBUNIQUENAME=dbname] [FORMAT={12|legacy}] [SYSBACKUP={y|n}] [SYSDG={y|n}]
[SYSKM={y|n}] [DELETE={y|n}] [INPUT_FILE=input-fname]
force - whether to overwrite existing file (optional),
* v$PWFILE_users
/12c: V$PWFILE_USERS lists all users in the password file, and indicates whether the user has been granted the SYSDBA, SYSOPER, SYSASM, SYSBACKUP, SYSDG, and SYSKM privileges.
/10c: sts users who have been granted SYSDBA and SYSOPER privileges as derived from the password file.
ColumnDatatypeDescription
USERNAMEVARCHAR2(30)The name of the user that is contained in the password file SYSDBAVARCHAR2(5)If TRUE, the user can connect with SYSDBA privileges
SYSOPERVARCHAR2(5)If TRUE, the user can connect with SYSOPER privileges Incorrect Answers:
E: The format of the v$PWFILE_users file is already in 12c format.
質問 29
A redaction policy was added to the SALcolumn of the SCOTT.EMPtable:
All users have their default set of system privileges.
For which three situations will data not be redacted? (Choose three.)
- A. SCOTTsessions, only if the MGRrole is set in the session
- B. SCOTTsessions, only if the MGRrole is granted to SCOTT
- C. SYSTEMsessions, regardless of the roles that are set in the session
- D. SYSTEMsession, only if the MGRrole is set in the session
- E. SYSsessions, regardless of the roles that are set in the session
- F. SCOTTsessions, because he is the owner of the table
正解: B,C,E
解説:
Both users SYS and SYSTEM automatically have the EXEMPT REDACTION POLICY system privilege.
(SYSTEM has the EXP_FULL_DATABASE role, which includes the EXEMPT REDACTION POLICY system privilege.) This means that the SYS and SYSTEM users can always bypass any existing Oracle Data Redaction policies, and will always be able to view data from tables (or views) that have Data Redaction policies defined on them
質問 30
Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.
You want to Issue the following RMAN command:
RMAN > BACKUP TABLESPACE hr_pdb:userdata;
Which task should you perform before issuing the command?
- A. Take the user data tablespace offline.
- B. Place the root container in ARHCHIVELOG mode.
- C. Ensure that HR_PDB is open.
- D. Place the root container in the nomount stage.
正解: C
解説:
To back up tablespaces or data files:
Start RMAN and connect to a target database and a recovery catalog (if used).
If the database instance is not started, then either mount or open the database.
Run the BACKUP TABLESPACE command or BACKUP DATAFILE command at the RMAN
prompt.
質問 31
You execute the following PL/SQL:
Which two statements are true?
- A. FGA is enabled for all DML operations by JIMon the PRODUCTS.PRICEcolumn.
- B. FGA is enabled for the PRICEcolumn of the PRODUCTStable and the SQL statements is captured in the FGA audit trial.
- C. Fine-Grained Auditing (FGA) is enabled for the PRICEcolumn in the PRODUCTStable for SELECT statements only when a row with PRICE > 10000is accessed.
- D. FGA is enabled for the PRODUCTS.PRICEcolumn and an audit record is written whenever a row with PRICE > 10000is accessed.
正解: B,C
解説:
Explanation/Reference:
Explanation:
DBMS_FGA.ADD_POLICY(object_schema => 'hr',object_name => 'emp',policy_name =>
'chk_hr_emp',audit_condition => 'dept = "SALES" ',audit_column => 'salary'statement_types =>
'insert,update,delete,select');
Default value for statement_types is SELECT
Setting audit_trail to DBMS_FGA.DB sends the audit trail to the SYS.FGA_LOG$ table in the database
and omits SQL Text and SQL Bind.
Setting audit_trail to DBMS_FGA.DB+EXTENDED sends the audit trail to the SYS.FGA_LOG$ table in
the database and includes SQL Text and SQL Bind.
Setting audit_trail to DBMS_FGA.XML writes the audit trail in XML files sent to the operating system
and omits SQL Text and SQL Bind.
Setting audit_trail to DBMS_FGA.XML+EXTENDED writes the audit trail in XML files sent to the
operating system and includes SQL Text and SQL Bind.
Default value fo audit_trail parameter in DBMS_FGA.ADD_POLICY is DB+EXTENDED
質問 32
You use RMAN to back up a database which uses Automatic Storage Management (ASM) and you use the MD_BACKUP command to back up the ASM metadata regularly.
You lose an ASM disk group DG1 due to a hardware failure.
In which two ways can you re-create the lost disk group and restore the data? (Choose two.)
- A. Use the MD_RESTORE command to restore the disk group metadata and use RMAN to restore the data.
- B. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.
- C. Use the MKDG command to add a new disk group DG1 with the same or different specifications as those from the lost disk group and use RMAN to restore the data.
- D. Use RMAN to restore both the metadata and the data.
正解: A,C
質問 33
You database is running an ARCHIVELOG mode.
The following parameter are set in your database instance: LOG_ARCHIVE_FORMAT = arch+%t_%r.arc LOG_ARCHIVE_DEST_1 = 'LOCATION = /disk1/archive' DB_RECOVERY_FILE_DEST_SIZE = 50G DB_RECOVERY_FILE = '/u01/oradata' Which statement is true about the archived redo log files?
- A. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.
- B. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.
- C. They are created only in the Fast Recovery Area.
- D. They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.
正解: D
解説:
You can choose to archive redo logs to a single destination or to multiple destinations. Destinations can be local-within the local file system or an Oracle Automatic Storage Management (Oracle ASM) disk group-or remote (on a standby database). When you archive to multiple destinations, a copy of each filled redo log file is written to each destination. These redundant copies help ensure that archived logs are always available in the event of a failure at one of the destinations. To archive to only a single destination, specify that destination using the LOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST initialization parameters. ARCHIVE_DEST initialization parameter. To archive to multiple destinations, you can choose to archive to two or more locations using the LOG_ARCHIVE_DEST_n initialization parameters, or to archive only to a primary and secondary destination using the LOG_ ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST initialization parameters.
質問 34
Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?
- A. The DMU can report columns that are not represented in the converted characterset.
- B. The DMU can report columns that are too long in the converted characterset.
- C. The database to be migrated must be opened read-only.
- D. The release of the database to be converted can be any release since 9.2.0.8.
- E. A DBA can check specific tables with the DMU
正解: A,B,E
解説:
A: In certain situations, you may want to exclude selected columns or tables from scanning or conversion steps of the migration process.
D: Exceed column limit
The cell data will not fit into a column after conversion.
E: Need conversion
The cell data needs to be converted, because its binary representation in the
target character set is different than the representation in the current character
set, but neither length limit issues nor invalid representation issues have been
found.
* Oracle Database Migration Assistant for Unicode (DMU) is a unique next-generation migration
tool providing an end-to-end solution for migrating your databases from legacy encodings to
Unicode.
Incorrect:
Not C: The release of Oracle Database must be 10.2.0.4, 10.2.0.5, 11.1.0.7, 11.2.0.1, or later.
質問 35
An application accesses a small lookup table frequently.
You notice that the required data blocks are getting aged out of the default buffer cache.
How would you guarantee that the blocks for the table never age out?
- A. Configure the RECYCLE bufferpool and alter the table with the corresponding storage clause.
- B. Increase the database buffer cache size.
- C. Configure Automata Shared Memory Management.
- D. Configure the KEEP buffer pool and alter the table with the corresponding storage clause.
- E. Configure Automatic Memory Management-
正解: D
解説:
Schema objects are referenced with varying usage patterns; therefore, their cache behavior may be quite different. Multiple buffer pools enable you to address these differences.
You can use a KEEP buffer pool to maintain objects in the buffer cache and a RECYCLE buffer pool to prevent objects from consuming unnecessary space in the cache. When an object is allocated to a cache, all blocks from that object are placed in that cache. Oracle maintains a DEFAULT buffer pool for objects that have not been assigned to one of the buffer pools.
質問 36
Examine this command:
Which three statements are true about using an invisible column in the PRODUCTStable?
- A. Referential integrity constraint cannot be set on the invisible column.
- B. A primary key constraint can be added on the invisible column.
- C. The invisible column cannot be made visible and can only be marked as unused.
- D. The DESCRIBEcommands in SQL *Plus will not display the invisible column in the output.
- E. The %ROWTYPEattribute declarations in PL/SQLto access a row will not display the invisible column in the output.
正解: B,D,E
解説:
AB: You can make individual table columns invisible. Any generic access of a table does not show the invisible columns in the table. For example, the following operations do not display invisible columns in the output:
* SELECT * FROM statements in SQL
* DESCRIBE commands in SQL*Plus
* %ROWTYPE attribute declarations in PL/SQL
* Describes in Oracle Call Interface (OCI)
Incorrect Answers:
D: You can make invisible columns visible.
You can make a column invisible during table creation or when you add a column to a table, and you can later alter the table to make the same column visible.
質問 37
Examine the following command:
ALTER SYSTEM SET enable_ddl_logging = TRUE;
Which statement is true?
- A. All DDL commands are logged in a different log file that contains DDL statements and their execution dates.
- B. Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.
- C. All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
- D. Only DDL commands that resulted in the creation of new segments are logged.
- E. All DDL commands are logged in the alert log file.
正解: A
解説:
The log files are created only in $ADR_HOME/log
in alert log only alter system is catched.Sun Mar 30 23:30:04 2014ALTER SYSTEM SET enable_ddl_logging=TRUE SCOPE=BOTH;Sun Mar 30 23:32:41 2014ALTER SYSTEM SET enable_ddl_logging=TRUE SCOPE=BOTH;Sun Mar 30 23:39:35 2014ALTER SYSTEM SET enable_ddl_logging=FALSE SCOPE=BOTH;[oracle@ovs trace]$ only in diag/rdbms/.../../log/ two files are capturing this. The xml file is capturing full details and text file having only the commands.
[oracle@ovs log]$ pwd/oraclebase/diag/rdbms/ora12c1/ora12c1/log[oracle@ovs log]$ cat ddl/* create table testing2(a number) create table testing3( aa number)
[oracle@ovs log]$ cat ddl_ora12c1.logSun Mar 30 23:33:26 2014diag_adl:create table testing2(a number) diag_adl:create table testing3( aa number) Reference: https://docs.oracle.com/database/121/REFRN/GUID-6FBA6147-D545-4E7D-94F0- A97EC1C721AE.htm#REFRN10302
質問 38
Identify two correct statements about multitenant architecture. (Choose two.)
- A. Patches are always applied at the CDB level.
- B. Multiple non-RAC CDB instances can mount the same PDB as long as they are on the same server.
- C. Multiple CDBs share certain PDB resources.
- D. A PDB can have a private undo tablespace.
- E. Multiple pluggable databases (PDBs) share the SGA of a multitenant container database (CDB).
- F. Multitenant architecture can be deployed only in a Real Application Clusters (RAC) configuration.
正解: A,E
解説:
B: Using 12c Resource manager you will be able control CPU, Exadata I/O, sessions and parallel servers. A new 12c CDB Resource Manager Plan will use so-called "Shares" (resource allocations) to specify how CPU is distributed between PDBs. A CDB Resource Manager Plan also can use "utilization limits" to limit the CPU usage for a PDB. With a default directive, you do not need to modify the resource plan for each PDB plug and unplug.
E: New paradigms for rapid patching and upgrades.
The investment of time and effort to patch one multitenant container database results in patching all of its many pluggable databases. To patch a single pluggable database, you simply unplug/plug to a multitenant container database at a different Oracle Database software version.
Incorrect Answers:
A:
* The Oracle RAC documentation describes special considerations for a CDB in an Oracle RAC environment.
* Oracle Multitenant is a new option for Oracle Database 12c Enterprise Edition that helps customers reduce IT costs by simplifying consolidation, provisioning, upgrades, and more. It is supported by a new architecture that allows a container database to hold many pluggable databases. And it fully complements other options, including Oracle Real Application Clusters and Oracle Active Data Guard. An existing database can be simply adopted, with no change, as a pluggable database; and no changes are needed in the other tiers of the application.
D: You can unplug a PDB from one CDB and plug it into a different CDB without altering your schemas or applications. A PDB can be plugged into only one CDB at a time.
F:
* UNDO tablespace can NOT be local and stays on the CDB level.
* Redo and undo go hand in hand, and so the CDB as a whole has a single undo tablespace per RAC instance.
質問 39
Which two statements are true concerning the Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?
- A. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.
- B. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
- C. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.
- D. If a PDB plan is enabled for a pluggable database, then 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. In a PDB plan, subplans may be used with up to eight consumer groups.
正解: A,D
解説:
A: Setting a PDB resource plan is optional. If not specified, all sessions within the
PDB are treated equally.
*In a non-CDB database, workloads within a database are managed with resource plans.
In a PDB, workloads are also managed with resource plans, also called PDB resource plans.
The functionality is similar except for the following differences:
/ Non-CDB Database
Multi-level resource plans Up to 32 consumer groups Subplans / PDB Database Single-level resource plans only Up to 8 consumer groups (not B) No subplans
質問 40
Which two are true concerning a multitenant container database with three pluggable database?
- A. The pluggable databases reduce administration effort.
- B. Pluggable databases are only used for database consolidation.
- C. The pluggable databases are patched together.
- D. All administration tasks must be done to a specific pluggable database.
- E. The pluggable databases increase patching time.
正解: A,B,C
解説:
The benefits of Oracle Multitenant are brought by implementing a pure deployment choice. The following list calls out the most compelling examples.
*High consolidation density. (E)
The many pluggable databases in a single multitenant container database share its memory and
background processes, letting you operate many more pluggable databases on a particular
platform than you can single databases that use the old architecture. This is the same benefit that
schema-based consolidation brings.
*Rapid provisioning and cloning using SQL.
*New paradigms for rapid patching and upgrades. (D, not B)
The investment of time and effort to patch one multitenant container database results in patching
all of its many pluggable databases. To patch a single pluggable database, you simply unplug/plug
to a multitenant container database at a different Oracle Database software version.
*(C, not A) Manage many databases as one.
By consolidating existing databases as pluggable databases, administrators can manage many
databases as one. For example, tasks like backup and disaster recovery are performed at the
multitenant container database level.
*Dynamic between pluggable database resource management. In Oracle Database 12c,
Resource Manager is extended with specific functionality to control the competition for resources
between the pluggable databases within a multitenant container database.
Note:
*Oracle Multitenant is a new option for Oracle Database 12c Enterprise Edition that helps
customers reduce IT costs by simplifying consolidation, provisioning, upgrades, and more. It is
supported by a new architecture that allows a multitenant container database to hold many
pluggable databases. And it fully complements other options, including Oracle Real Application
Clusters and Oracle Active Data Guard. An existing database can be simply adopted, with no
change, as a pluggable database; and no changes are needed in the other tiers of the application.
Reference: 12c Oracle Multitenant
質問 41
......
1Z0-060完全版問題集には無料PDF問題で合格させる：https://jp.fast2test.com/1Z0-060-premium-file.html