Valid 1Z0-060 Dumps shared by ExamDiscuss.com for Helping Passing 1Z0-060 Exam! ExamDiscuss.com now offer the newest 1Z0-060 exam dumps, the ExamDiscuss.com 1Z0-060 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 1Z0-060 dumps with Test Engine here:
Access 1Z0-060 Dumps Premium Version
(205 Q&As Dumps, 35%OFF Special Discount Code: freecram)
<< Prev Question Next Question >>
Question 68/71
You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server.
All databases of all versions use Automatic Storage Management (ASM).
Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?
All databases of all versions use Automatic Storage Management (ASM).
Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?
Correct Answer: A,B,D
AD:The value for the disk group COMPATIBLE.ASM attribute determines the minimum software version for an Oracle ASM instance that can use the disk group.This setting also affects the format of the data structures for the Oracle ASM metadata on the disk.
B:The value for the disk group COMPATIBLE.RDBMS attribute determines the minimum COMPATIBLE database initialization parameter setting for any database instance that is allowed to use the disk group. Before advancing the COMPATIBLE.RDBMS attribute, ensure that the values for the COMPATIBLE initialization parameter for all of the databases that access the disk group are set to at least the value of the new setting for COMPATIBLE.RDBMS.
For example, if the COMPATIBLE initialization parameters of the databases are set to either 11.1 or 11.2, then COMPATIBLE.RDBMS can be set to any value between 10.1 and 11.1 inclusively.
Not E:
/The value for the disk group COMPATIBLE.ADVM attribute determines whether the disk group can contain Oracle ASM volumes. The value must be set to 11.2 or higher. Before setting this attribute, the COMPATIBLE.ASM value must be 11.2 or higher. Also, the Oracle ADVM volume drivers must be loaded in the supported environment.
/You can create an Oracle ASM Dynamic Volume Manager (Oracle ADVM) volume in a disk group. The volume device associated with the dynamic volume can then be used to host an Oracle ACFS file system.
The compatibility parameters COMPATIBLE.ASM and COMPATIBLE.ADVM must be set to 11.2 or higher for the disk group.
Note:
* The disk group attributes that determine compatibility are COMPATIBLE.ASM, COMPATIBLE.RDBMS. and COMPATIBLE.ADVM. The COMPATIBLE.ASM and COMPATIBLE.RDBMS attribute settings determine the minimum Oracle Database software version numbers that a system can use for Oracle ASM and the database instance types respectively. For example, if the Oracle ASM compatibility setting is 11.2, and RDBMS compatibility is set to 11.1, then the Oracle ASM software version must be at least 11.2, and the Oracle Database client software version must be at least 11.1. The COMPATIBLE.ADVM attribute determines whether the Oracle ASM Dynamic Volume Manager feature can create an volume in a disk group.
B:The value for the disk group COMPATIBLE.RDBMS attribute determines the minimum COMPATIBLE database initialization parameter setting for any database instance that is allowed to use the disk group. Before advancing the COMPATIBLE.RDBMS attribute, ensure that the values for the COMPATIBLE initialization parameter for all of the databases that access the disk group are set to at least the value of the new setting for COMPATIBLE.RDBMS.
For example, if the COMPATIBLE initialization parameters of the databases are set to either 11.1 or 11.2, then COMPATIBLE.RDBMS can be set to any value between 10.1 and 11.1 inclusively.
Not E:
/The value for the disk group COMPATIBLE.ADVM attribute determines whether the disk group can contain Oracle ASM volumes. The value must be set to 11.2 or higher. Before setting this attribute, the COMPATIBLE.ASM value must be 11.2 or higher. Also, the Oracle ADVM volume drivers must be loaded in the supported environment.
/You can create an Oracle ASM Dynamic Volume Manager (Oracle ADVM) volume in a disk group. The volume device associated with the dynamic volume can then be used to host an Oracle ACFS file system.
The compatibility parameters COMPATIBLE.ASM and COMPATIBLE.ADVM must be set to 11.2 or higher for the disk group.
Note:
* The disk group attributes that determine compatibility are COMPATIBLE.ASM, COMPATIBLE.RDBMS. and COMPATIBLE.ADVM. The COMPATIBLE.ASM and COMPATIBLE.RDBMS attribute settings determine the minimum Oracle Database software version numbers that a system can use for Oracle ASM and the database instance types respectively. For example, if the Oracle ASM compatibility setting is 11.2, and RDBMS compatibility is set to 11.1, then the Oracle ASM software version must be at least 11.2, and the Oracle Database client software version must be at least 11.1. The COMPATIBLE.ADVM attribute determines whether the Oracle ASM Dynamic Volume Manager feature can create an volume in a disk group.
- Question List (71q)
- Question 1: Which three activities are supported by the Data Recovery Ad...
- Question 2: Which three statements are true about Flashback Database?...
- Question 3: In your multitenant container database (CDB) containing same...
- Question 4: You are about to plug a multi-terabyte non-CDB into an exist...
- Question 5: Which statement is true regarding the default behavior of th...
- Question 6: You want to flash back a test database by five hours. You is...
- Question 7: On your Oracle 12c database, you issue the following command...
- Question 8: Identify two correct statements about multitenant architectu...
- Question 9: You have altered a non-unique index to be invisible to deter...
- Question 10: Which statement is true about Enterprise Manager (EM) expres...
- Question 11: Which two statements are true when the listener handles conn...
- Question 12: An application accesses a small lookup table frequently. You...
- Question 13: Identify three benefits of Unified Auditing....
- Question 14: Which three are amongst the categories into which column def...
- Question 15: Your multitenant container database, CDB1, is running in ARC...
- Question 16: In which two scenarios do you use SQL* Loader to load data?...
- Question 17: You create a new pluggable database, HR_PDB, from the seed d...
- Question 18: You connect to the root container of a multitenant container...
- Question 19: What are three purposes of the RMAN "FROM SERVICE" clause?...
- Question 20: Which three statements are true about adaptive SQL plan mana...
- Question 21: A redaction policy was added to the SALcolumn of the SCOTT.E...
- Question 22: You are administering a database stored in Automatic Storage...
- Question 23: Which three are true about the large pool for an Oracle data...
- Question 24: What is the effect of specifying the "ENABLE PLUGGABLE DATAB...
- Question 25: You notice a performance change in your production Oracle da...
- Question 26: Examine the following parameters for a database instance: (E...
- Question 27: Your multitenant container database (CDB) contains some plug...
- Question 28: Examine the structure of the customers table: (Exhibit) CUST...
- Question 29: Which three statements are true about SQL plan directives?...
- Question 30: Which two are prerequisites for performing a flashback trans...
- Question 31: You use the segment advisor to help determine objects for wh...
- Question 32: Which three statements are true about the use of the query r...
- Question 33: You issue the following commands: (Exhibit) The directories ...
- Question 34: Examine this command: SQL > exec DBMS_STATS.SET_TABLE_PRE...
- Question 35: Your multitenant container database (CDB) containing two plu...
- Question 36: In order to exploit some new storage tiers that have been pr...
- Question 37: You want to capture column group usage and gather extended s...
- Question 38: Which three tasks can be performed using SQL functions built...
- Question 39: Which three operations can be performed as multipartition op...
- Question 40: Which three features work together, to allow a SQL statement...
- Question 41: You enabled an audit policy by issuing the following stateme...
- Question 42: You are administering a database and you receive a requireme...
- Question 43: On your Oracle 12c database, you issue the following command...
- Question 44: Which three statements are true about Automatic Workload Rep...
- Question 45: You want to upgrade your pre-12c database to an Oracle 12c d...
- Question 46: Your database supports an online transaction processing (OLT...
- Question 47: Which three statements are true about Oracle Data Pump expor...
- Question 48: Which two are true concerning a multitenant container databa...
- Question 49: What are three purposes of the RMAN "FROM" clause?...
- Question 50: You are administering a database stored in Automatic Storage...
- Question 51: A warehouse fact table in your Oracle 12c Database is range-...
- Question 52: You run a script that completes successfully using SQL*Plus ...
- Question 53: Examine the following command; ALTER SYSTEM SET enable_ddl_l...
- Question 54: Which normal form is a table in if it has no multi-valued at...
- Question 55: On your Oracle 12c database, you Issue the following command...
- Question 56: Which two statements are true about Oracle Direct Network Fi...
- Question 57: Which four actions are possible during an Online Data file M...
- Question 58: Which two statements are true regarding the count function?...
- Question 59: In a recent Automatic Workload Repository (AWR) report for y...
- Question 60: In your multitenant container database (CDB) with two plugga...
- Question 61: Examine the following command: (Exhibit) Which three stateme...
- Question 62: You created an encrypted tablespace: (Exhibit) You then clos...
- Question 63: You notice a performance change in your production Oracle 12...
- Question 64: Your database supports a DSS workload that involves the exec...
- Question 65: Which five actions are prerequisites for using extended data...
- Question 66: You execute the following commands to audit database activit...
- Question 67: You wish to enable an audit policy for all database users, e...
- Question 68: You support Oracle Database 12c Oracle Database 11g, and Ora...
- Question 69: Examine the contents of SQL loader control file: (Exhibit) W...
- Question 70: On your Oracle Database, you issue the following commands to...
- Question 71: What is the result of executing a TRUNCATE TABLE command on ...
