Free Oracle 1z1-062 Exam Dumps Questions & Answers

Which four statements are true about the components of the Oracle Scheduler? (Choose four.)

• A.  A program can be used in the definition of multiple jobs.
• B.  A job is specified as part of a program specification.
• C.  A scheduler job can point to a chain instead of pointing to a single program object.
• D.  A program and job can be specified as part of a schedule definition.
• E.  A schedule can be specified to a single job only.
• F.  A program and schedule can be specified as part of a job definition.
• G.  A job may get started automatically when a window opens.

Which statement is true about profiles?

• A.  A user can exist without any profile.
• B.  A profile can be assigned only to one user.
• C.  Resource limits specified in a profile assigned to a user are always enabled.
• D.  Password management using profiles is always enabled.

After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows:

After changing the value, you notice that FULL redaction continues to redact numeric data with zero.
What must you do to activate the new default value for numeric full redaction?

• A.  Flush the shared pool.
• B.  Restart the database instance.
• C.  Re-enable redaction policies that use FULL data redaction.
• D.  Re-create redaction policies that use FULL data redaction.
• E.  Re-connect the sessions that access objects with redaction policies defined on them.

What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database?

• A.  Helps you to easily upgrade the database from a prior release.
• B.  Automatically registers the database with Oracle Restart.
• C.  Enables you to take advantage of Oracle Managed Files.
• D.  Enables the Installation of Grid Infrastructure files on block or raw devices.
• E.  Effectively implements role separation

Examine this command:
SQL > exec DBMS_STATS.SET_TABLE_PREFS ('SH', 'CUSTOMERS', 'PUBLISH', 'false'); Which three statements are true about the effect of this command? (Choose three.)

• A.  Statistics collection is not done for the CUSTOMERS table when database stats are gathered.
• B.  Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.
• C.  Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.
• D.  Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.
• E.  Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.