← Back to exam page

1z0-060 – Upgrade to Oracle Database 12c

Loading demo links...

Showing 13–15 of 15 questions

Question 13

In your multitenant container database (CDB) that contains pluggable databases (PDBs), the HR user executes the following commands to create and grant privileges on a procedure:

How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from inserting values into tables on which they do not have any privileges?

Select an option, then click Submit answer.

  • ○

    Create the CREATE_TEST procedure with definer’s rights.
  • ○

    Grant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure.
  • ○

    Create the CREATE_TEST procedure with invoker’s rights.
  • ○

    Create the CREATE_TEST procedure as part of a package and grant users the EXECUTE privilege the package.
Question 14

Examine the following query output:

You issue the following command to import tables into the hr schema:

$ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y

Which statement is true?

Select an option, then click Submit answer.

  • ○

    All database operations performed by the impdp command are logged.
  • ○

    Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.
  • ○

    Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.
  • ○

    None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.
Question 15

An Automatic Database Diagnostic Monitor (ADDM) finding in your production database reports that the shared pool is inadequately sized. You diagnose that this is due to the different kinds of workloads and this occurs only during peak hours. The following are the parameter settings for the database instance:

You want to balance the memory between the System Global Area (SGA) components depending on the workload.

Which option would solve this problem?

Select an option, then click Submit answer.

  • ○

    setting the PGA_AGGREGATE_TARGET parameter to 200M and the SGA_MAX_SIZE parameter to 400M
  • ○

    setting the MEMORY_TARGET and SGA_MAX_SIZE parameters to 400M
  • ○

    setting the SGA_TARGET parameter to 300M
  • ○

    setting the SGA_MAX_SIZE parameter to 400M