1Z1-060 無料問題集「Oracle Upgrade to Oracle Database 12c」

（A）INSTR: can be used to find only the first occurrence of a character in a string

（B）TRIM: can be used to remove all the occurrences of a character from a string

（C）TRUNC: can be used with number and date values

（D）MOD: returns the quotient of a division

（E）CONCAT: can be used to combine any number of values

（F）SYSDATE: returns the database server current date and time

（A）The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.

（B）The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.

（C）RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.

（D）The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.

（E）The ASM compatibility attribute controls the format of the disk group metadata.

（A）ALTER PLUGGABLE DATABASE PDB OPEN issued from another PDB

（B）ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the root

（C）ALTER PLUGGABLE DATABASE PDB OPEN issued from the seed

（D）ALTER DATABASE OPEN issued from that PDB

（E）ALTER DATABASE PDB OPEN issued from the root

（F）ALTER PLUGGABLE DATABASE OPEN issued from that PDB

（G）ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a PDB

（A）It contains usernames and passwords of database users who are members of the OSDBA operating system group.

（B）It contains username and passwords of database users who are members of the OSOPER operating system group.

（C）It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.

（D）It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.

（E）It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.

（A）The root container can be flashed back without flashing back the pluggable databases (PDBs).

（B）The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB.

（C）A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

（D）Individual PDBs can be flashed back without flashing back the entire CDB.

（E）To enable flashback database, the CDB must be mounted.

（A）It fails because no SQL *Loader control file location is specified.

（B）It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.

（C）It fails because no SQL *Loader data file location is specified.

（D）It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.

（A）Decreased use of storage to store audit trail rows in the database.

（B）The audit trail cannot be easily modified because it is read-only.

（C）It automatically audits Recovery Manager (RMAN) events.

（D）It improves overall auditing performance.

（E）It guarantees zero-loss auditing.

（A）Tracking the most recent read time for a table segment in a user tablespace

（B）Tracking the most recent write time for a table segment in the SYSAUX tablespace

（C）Tracking insert time by row for table rows

（D）Tracking the most recent write timefor a table segmentin a usertablespace

（E）Tracking the most recent read time for a table segment in the SYSAUX tablespace

（F）Tracking the most recent write time for a table block

（A）Re-create the password file in the Oracle Database 12c format.

（B）Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.

（C）Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.

（D）Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to Yes.

（E）Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.

（A）Option E

（B）Option D

（C）Option B

（D）Option C

（E）Option A