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

Which three resources might be prioritized between competing pluggable databases when creating a multitenant container database plan (CDB plan) using Oracle Database Resource Manager?

• A.Maximum Idle time
• B.Exadata I/O
• C.Local file system I/O
• D.Maximum Undo per consumer group
• E.CPU
• F.Parallel server limit

Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table's indexes, to another tablespace.
The table does not have a primary key and is used by an OLTP application.
Which technique will move the table and indexes while maintaining the highest level of availability to the application?

• A.An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.
• B.Online Table Redefinition.
• C.Edition-Based Table Redefinition.
• D.Oracle Data Pump.
• E.An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.

You created a new database using the "create database" statement without specifying the
"ENABLE PLUGGABLE" clause.
What are two effects of not using the "ENABLE PLUGGABLE database" clause?

• A.The database is treated as a PDB and must be plugged into an existing multitenant container database (CDB).
• B.The database is created as a non-CDB and can never be plugged into a CDB.
• C.The database is created as a non-CDB but will become a CDB whenever the first PDB is plugged in.
• D.The database is created as a non-CDB and can never contain a PDB.
• E.The database is created as a non-CDB but can be plugged into an existing CDB.

On your Oracle 12c database, you issue the following commands to create indexes:
SQL> CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id,
sales_rep_id);
SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which statement is correct?

• A.Both the indexes are created; however, only the ORD_CUSTOMER_IX1 index is visible.
• B.Both the indexes are created; however, only the ORD_CUSTOMER_IX2 index is visible.
• C.Only the ORD_CUSTOMER_IX1 index is created and it is visible.
• D.Both the indexes are created and both of them are visible.

You notice that the elapsed time for an important database scheduler Job is unacceptably long.
The job belongs to a scheduler job class and window.
Which two actions would reduce the job's elapsed time?

• A.Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler window
• B.Increasing the value of the JOB_QUEUE_PROCESSES parameter
• C.Increasing the job's relative priority within the Job class to which it belongs
• D.Increasing the priority of the scheduler window to which the job belongs
• E.Moving the job to an existing higher priority scheduler window with the same schedule and duration
• F.Increasing the priority of the job class to which the job belongs