1Z1-060 試験問題を無料オンラインアクセス

An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges.
A multitenant container database (CDB) instant has the following parameter set:
THREADED_EXECUTION = FALSE
Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode?

• A.You can connect by using a Net Service name.
• B.You can connect by using easy connect.
• C.You can connect by using OS authentication.
• D.You can connect as a local user by using the SET CONTAINER statement.
• E.You can connect as a local user by using the connect statement.
• F.You can conned as a common user by using the connect statement.

You enabled an audit policy by issuing the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;
For which database users and for which executions is the audit policy now active? (Choose two.)

• A.SCOTT, but not SYS and SYSTEM
• B.Only for successful executions
• C.SCOTT, SYS and SYSTEM
• D.SYS and SYSTEM, but not SCOTT
• E.Both successful and failed executions
• F.Only for failed executions

Which two partitioned table maintenance operations support asynchronous Global Index Maintenance in Oracle database 12c?

• A.ALTER TABLE TRUNCATE PARTITION
• B.ALTER TABLE SPLIT PARTITION
• C.ALTER TABLE MOVE PARTITION
• D.ALTER TABLE MERGE PARTITION
• E.ALTER TABLE DROP PARTITION
• F.ALTER TABLE ADD PARTITION

You plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.
Which three storage options support the use of HCC?

• A.ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array
• B.ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files
• C.ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays
• D.Database files stored in ZFS and accessed using conventional NFS mounts.
• E.Database files stored in ZFS and accessed using the Oracle Direct NFS feature
• F.Database files stored in any file system and accessed using the Oracle Direct NFS feature
• G.ASM disk groups with ASM disks consisting of Exadata Grid Disks.

Which normal form is a table in if it has no multi-valued attributes and no partial dependencies?

• A.Third normal form
• B.Fourth normal form
• C.First normal form
• D.Second normal form